The leading airlines in the United States needed a better system to manage their operational data. Data sources included real-time location, flight details, publicly available airport and competitor statistics, and weather conditions. Each source had its own format and data structure; all feeding into a centralized database and interpreted by data analysts through SQL queries. There were many teams of analysts, each using different models that were neither scalable nor efficient.
The airline controllers can now log in to the dashboard to obtain an overview of their operations. Diverted flights appear in a different color, airports with delays are ranked by severity, delayed flights are accentuated to reflect the impact on connecting routes; and a notification center alerts users on issues with significant operational impact. In addition, real-time statistics are continuously benchmarked against industry metrics to improve the carriers’ performance.