Lab Practice

Part I: In this part you will work with USDA dataset.

• Design Straight Table with Linear Guages for Sum(Sugar) and Sum(Cholesterol)
• Values for Gauge Settings Max:

  =Max(Aggr(sum(Sugar), Description))

  =Max(Aggr(Sum(Cholesterol), Description))

Part II DataSet: Airline Operations

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

• Open TemplateChapter2AirlineOperations QilkView File and save it with your Initials at the end of the file name.

  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.

• Create the following List Boxes: Year, Month, Carrier Name, Origin City, Origin Country, Origin State, Destination City, Destination Country, and Destination State

• Answer the following questions. Create a textbox to document your answers:
  • Which carriers have logged flights departing from Accra, Ghana?
  • In which cities and states are those flights arriving?

• Create a new Sheet; Dashboard.
• Create a Bar chart to display the number of departed flights per Year and Month by creating a Cyclic Dimension Group: Year/Month.
  • Expression: Sum ([# Departures Performed])
  • Sort in Descending Order
  • Choose Integer for Number Format

• Answer the following questions. Create a textbox to document your answers.
  • Find the busiest year and busiest month
  • Name one Country which didn't have any departures in 2010
  • Name ony City which didn't have any departures in July

• Create a new Sheet: MoreCharts
• Create Straight Table, call it Top 10 Routes, that displays the top routes in terms of number of flights, enplaned passengers, transported freight, and transported mail.
  • Dimensions: From - To City
  • Expressions and their corresponding labels:
    • Sum ([# Departures Performed]), Label: Flights
    • Sum ([# Transported Passengers]), Label: Passengers
    • Sum ([# Transported Freight]), Label: Freight
    • Sum ([# Transported Mail]), Label: Mail
  • Select No Totals for all four of them.
  • On Presentation Tab, enable the Max Number (1 - 100) checkbox and set it to 10.
  • Format all expressions to the Integer format.
• Name the route with max number of flights, enplaned passengers, transported freight, and transported mail - you might have different routes for each category. Hint: Sort each column to find a maximum in each category.

• In this part you will analyze the relationship between the number of passengers, number of transported mail, and the number of performed departures at the carrier level. To visualize this create a scatter chart.
  • Dimension: Carrier Name
  • Expression X: # Transported Mail, Expression Y: # Transported Passengers.
    Select the Bubble Chart and enter the following in the Bubble Size Expression input field: Sum([# Departures Performed])
  • Number format: Integer.
• Analyze the chart