Creating the new Dashboard sheet
Now that we have finished the first iteration of our analysis sheet, it is time to start creating the new Dashboard sheet. As was defined before, we will need to visualize the following KPIs and metrics:
Load Factor %: This gives the number of enplaned passengers versus the number of available seats
Performed versus scheduled flights: This gives the number of flights that were performed versus those that were scheduled
Air time %: This gives the time spent flying versus total ramp-to-ramp time
Enplaned passengers (in millions): This gives the number of transported passengers, in millions
Departures performed (in thousands): This gives the number of flights performed, in thousands
Revenue Passenger Miles (millions): This gives the total number of miles that all passengers were transported, in millions
Available Seat Miles (millions): This gives the total number of miles that all seats (including unoccupied seats) were transported, in millions
Market Share...
