Applying the DAR principle to Airline Operations

Now that we've gone through the theoretical part of QlikView use cases and user types, it's time to get practical again. To continue, open the Airline Operations.qvw file we've been working on. We will build our exercises upon the previously created data model and frontend.

When we look at the document we have built so far, we will notice that this does not yet cover the Dashboard, Analysis, and Report use cases. That's why, in this section, we will expand on the various charts that are available in QlikView, while also applying the DAR principles.

Applying the DAR principle to Airline Operations

First, though, we need to take a better look at the business requirements set by HighCloud Airlines.

Document requirements

After requirement workshops and interviews with the HighCloud Airlines' executive team, Sara has distilled the following KPIs:

  • 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 actually 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 (in millions): This gives the total number of miles that all passengers were transported, in millions
  • Available Seat Miles (in millions): This gives the total number of miles that all seats (including unoccupied seats) were transported, in millions
  • Market Share: This is based on transported passengers

Besides these requirements, there is a need to further analyze the data. While the workshop and interviews weren't conclusive about the exact analytics requirements (they rarely are), there was consensus that at least the following areas should be investigated:

  • Trend analysis of the number of flights, transported passengers, freight, and mail through time
  • Top 10 routes based on the number of flights, enplaned passengers, freight, and mail
  • The number of passengers versus available seats (Load Factor %) across flight types
  • The relationship between transported passengers, mail, and the number of flights

In addition, the current metrics currently shown on the Dashboard sheet should be moved to the new analysis section.

It was also decided that the following two reports should be available:

  • Aggregated flights per month
  • KPIs per carrier
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset