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])