Lab 4 - Graded Lab

• In this lab you will continues to work with AirlineOperations application.
• Create New Sheet- Lab 4
• Create a Pie Chart - Load Factor to analyze # of Passengers / Available Seat by Flight Type and by Carrier Name for Top 10 Companies.
  • Create Cyclic Dimension Group - Lab4 - include Flight Type and Carrier Name
  • Expression: sum([# Transported Passengers])/sum([# Available Seats])
  • Select Show Values on Data Point
  • Number Format: Fixed to 1 decimal and Select Show in Percent
  • Restrict Dimension Limits to show 10 largest and don't show Others
• Analyze the chart. Write your analysis is the textbox.

• Create a Combo Chart to Analyze Performed vs Scheduled Departures ratio
  • Use the same Dimension Group, Lab4, you created earlier
  • Expressions:
  • Sum([# Departures Performed]), Label: Performed, in Display Options: select Bar Chart for this one
  • Sum([# Departures Scheduled]), Label: Scheduled, in Display Options:select Bar Chart for this one
  • Sum([# Departures Performed])/Sum([# Departures Scheduled]), Label: Ratio, in Display Options: CLEAR all choices
  • Number Formating: Performed and Scheduled - are integers, Ratio - Fixed to 1 decimal and Select Show in Percent
  • Style: Grouped, Horizontal
• Analyze the Chart

• Create Straight Table to Display KPI (Key Performance Indicators) for Load Factor % and Air time %. We will use Cyclic Dimension Group Airline_Origin_Destination to see these KPIs by Airline, Origin Country, and Destination Country (This Dimension Group is already created for you and listed in the Dimension List)
  • Dimension: Airline_Origin_Destination Group
  • Expressions:
    Sum([# Transported Passengers])/Sum([# Available Seats]), Label: Load Factor, Number Format: Fixed to 1 decimal, Show in Percent
    Sum ([# Air Time]) / Sum ([# Ramp-To-Ramp Time]), Label: Air Time%,
• Analyze the chart and try to add visual clues based on your observations. For example, load factor below certain % highlight in RED
• Create container to include all 3 charts

• Create Statistics Box:
  • On the General tab, select Distance from the Field drop-down menu.
  • REMOVE Total count option from the Displayed Functions lis
  • Number Format: Select Override Default Settings and Integer
• Select Year 2011, Country: Israel, Carrier: US Airways. Find total distance, Min and Max and also find Destination City and Origin City (Look on the list boxes you created on the main sheet)

• Create a Button:
  • Enter Clear Selections in the Text input field.
  • On the Action Tab: Click the Add button, select the Clear All option from the Action list on the right, and click on OK
  • Make a few selections and then click the Button you created above and observe the Action

• Bonus: Create a Gauge Chart to display the percentage of occupied seats compared to those that were available on each flight. Title the chart: Load Factor %.
  • Expression: Sum ([# Transported Passengers]) / Sum ([# Available Seats])
  • Label: Load Factor %
  • At Presentation Tab: Min and Max values will be 0.5 and 1 respectively
  • Add 2 more segments
  • Segment 1:Lower Bound: 0.5, Color: Red
  • Segment 2:Lower Bound: 0.625 Color: Orange
  • Segment 3:Lower Bound: 0.75, Color: Yellow
  • Segment 4:Lower Bound: 0.85, Color: Green
  • On the Presentation tab, select: Show Scale, Show Labels on Every Major Unit, Hide Segment Boundaries, and Hide Gauge Outlines.
  • Set the value of Show Scale to 6 Major Units, set the value of Show Labels on Every to 1 Major Unit
  • Number Format: Integer and Show in Percent (%).
• Make selection and compare results on the Gauge and other charts that display Load Factor