High Level Design
Overview
Many airlines operate over 11 million flight departures per year. Because of the many departures, monitoring each airline's performance is necessary for an optimal customer experience.Goals
Monitor daily Airline Performance
Objectives
- Track Performance KPIs:
- Number of Cancelled Flights
- D0% (percentage of flights with a Departure time of zero or less than zero)
- D15% (percentage of flights with a Departure time of 15 minutes or less)
- A0% (percentage of flights with an Arrival time of zero or less than zero)
- Number of Scheduled Flights
KPIs Architecture
Objective | KPI’s | Measures | Data source |
Track Performance KPIs
|
# of Cancelled Flights | Count(Flights) where CANCELLED = 1 | Fact_Airline |
D0 | (Count(Flights) where DepTime <= 0) / Count(Flights) | Fact_Airline | |
D15 | (Count(Flights) where DepTime <= 15) / Count(Flights) | Fact_Airline | |
A0 | (Count(Flights) where ArrTime <= 0) / Count(Flights) | Fact_Airline | |
# of Scheduled Flights | Count(Flights) | Fact_Airline |