Graded Lab - Lab 6 - this Lab will be graded as Practice Lab

• Open the file AirlineOperationsYourInitials.qvw we worked with this week.
• Create a new sheet Lab6Part1
• Create a Straight Table.
  • Dimension: Aircraft Name
  • Expressions:
    1. $(eLoadFactor) (Make sure that variable is still exist in your application, and if not, add it, with the following value:
       (Sum ([# Transported Passengers]) / Sum ([# Available Seats]))
       Number formating: fixed to 2 decimal, show percent
    2. $(eLoadFactor) - Linear Gauge with 2-3 segments (your choice).
    3. $(eAirTime)
       Number formating: fixed to 2 decimal, show percent
    4. $(eEnplanedPassengers)
    5. $(eEnplanedPassengers) with Representation as Mini Chart. Use Mini Chart Dimension: Period
       Create a separate Line Chart for the same expression and Dimension Period and compare charts for one of the Aircraft names of your choice

  • Create new sheet Lab6PartII
  • Create Bar Chart to compare # Transported Passengers in PHL - Philadelphia International Airport (as origin City) in two consecutive years: Max(Year) which is 2011 in our case and Max(Year)-1 which is 2010.
    • Dimension: Carrier Name
    • Use the following for Expressions:

      Sum({$<[Origin Airport Code] = {'PHL'},Year = {$(=Max(Year))}>} [# Transported Passengers])

      Sum({$<[Origin Airport Code] = {'PHL'},Year = {$(=Max(Year)-1)}>} [# Transported Passengers])

    • Format the chart to display data in decreasing order for 10 largest carriers.
    • Analyze the chart.
    • Perform analysis by adding additional restrictions to Carrier's Operating Region, Carrier Group and Flight Type (use List Boxes to make selections). Document your results in the Text Object.

  Lab 6 Part III - Challenge (Only 11 Points)

  • In Straight Table you created in Part I observe the values for the eAirTime and eLoadFactor columns and add Visual Cues to eAirTime and eLoadFactor using variables. Create slider to change variable values. You have to decide on colors and upper/low bounds values.
  • Linear Gauge with 2-3 segments (your choice). Create variables for the lower bounds and slider object to change variable values (you can use variables we already created for similar cases)
  • For Bar Chart you created in Part II display data for any specific number of carriers. To implement this part: create a variable and use it on Dimension Limits Tab and create a slider to change the value. Try the following range: 5 - 15 ( to display between 5 and 15 largest values).

  Lab 6 Part 4 - Optional

  • For Straight Table you created in Part I build Heat Chart using if statements and Color Wizard for eAirTime Column. Decide on the upper/lower bounds and use variables and slider (input box) to change the values of the upper/low bounds
  • Complete the Set Analysis Lab (we didn't try all expressions)
  • For Set Analysis Lab try to create your own Set Analysis expressions to find for example number of transported passengers departed from specific City and compare two different cities
  • Design scenarion of your own that will require use of Set Analysis Documnet your scenario in the Text Object