Joonik developed a responsive, web-based dashboard for leading U.S. airlines. The dashboard provides real-time operational data and performance metrics, enhancing efficiency and scalability
Industry Association
Web Services
A group of leading airlines in the United States, represented by their operational data management teams, sought a more efficient and scalable system to manage and interpret their vast and diverse operational data, including real-time location, flight details, publicly available airport and competitor statistics, and weather conditions.
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.
Construct a more efficient and scalable system to manage and interpret the vast and diverse operational data of leading U.S. airlines.
Normalize data from various sources with different formats and structures, and develop formulas and algorithms to calculate performance indicators.
Create a design-driven, responsive, web-based dashboard that provides real-time updates and visualizes complex metrics in a user-friendly manner.
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.
