Lab Practice Airline Operations

These labs are based on Garcia, M., Harmsen, B. (2012). QlikView 11 for Developers

• In this lab you will work with real publicly available data. The original data files have been downloaded from The Bureau of Transportation Statistics of the United States website (http://transtats.bts.gov), and have been pre-processed.
• You should have already these List Boxes: Year, Quarter, Month, Carrier's Operating Region, Carrier Group, Aircraft Group, and Flight Type.
• Modify the List Box for Year to display all 3 years in one row
• Modify the List Box for Month, to display a table of 2 rows and 6 columns
• Modify the List Box for for Quarter to display a table of 2 rows and 2 columns
• Modiy the BAR Chart to Create a Cyclic Expression Group. Add the following Expressions:
  • Sum ([# Transported Passengers]). Set the label for this expression as # of Enplaned Passengers.
  • Sum ([# Transported Freight]). Set the label for this expression as Transported Freight.
  • Sum ([# Transported Mail]). Set the label for this expression as Transported Mail.
  • Format ALL expressions as Integers
• Find the busiest month/year for each category (expression).
• Clone this chart and convert it to Line Chart
• Make the following modifications: Clear Sort Option
• Add TrendLine AVERAGE for each expression
• Analyze the Chart

  Friday Sept 27 Short in Class Demo

• Create the Current Selestions Box
• Create a Bookmark Object

Lab 4

• Write answers to Analysis questions in Word file and submit on Canvas
• Show me QV file at the end of the class

• Create a New Sheet - Lab4
• Add Carrier Name List Box
• Add Expression into Carrier Name List Box:
  sum([# Departures Performed]).
  Change the name of the List Box to: Carrier Name (#Departures)

• Create a Multi Box
  • Title: Flight Information.
  • Choose the following Fields: From - To City, Origin City, Origin Country, Destination City, Destination Country, and Distance Interval.
  • On the Sort tab, Distance Interval, in the Sort by section, uncheck the Text option, and mark the Load Order checkbox.

  Analysis: Find Destination Cities and Countries, Origin Cities and Countries and Carrier Names that fly Distance Interval 9500-9999

• Create a bar Chart to display number of passengers and number of available seats by flight type.
  • Title: #passengers/#available seats by flight type
  • Dimension: Flight Type
  • Expressions: Sum ([# Transported Passengers]), Sum([# Available Seats]). Label them: [# Transported Passengers and # Available Seats
  • For each Expression: Select Values on Data Points checkbox
  • On Axes Tab: Select Show Grid for BOTH Axes
  • On Numbers Tab: Select Fixed to 1 Decimals, and Million for Million Symbol

• Analyze the Chart

• Create Pie Chart to display Market Share.
  • Dimension: Carrier Name,
  • Expression: Sum([# Transported Passengers]). Select Relative and Show Values on Data Points. Click finish. The chart looks too crowded.
  • Open chart properties and go to the Dimension Limits tab.
  • Mark the Restrict which values are displayed using the first expression checkbox.
  • Select the Show only values that accumulate to radio button and set the corresponding value to 50% relative to the total. Enable the Include Boundary Values checkbox as well.

  • Analyze the Chart