Airline Performance

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

 Entities Relationship Diagram

Airline KPI Dashboard

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation