Description

Overview

In this brief assignment, you'll have an opportunity to use your Tableau skills to explore  US Department of Transportation data about airline flights at the Gainesville Regional Airport (GNV).

You have been asked to analyze flight departures from Gainesville and provide two visualizations that investigate late departures in particular.  Details below.

Setup the Tableau Workbook

Download   EC3-FlightData-GNV-Jan2020.xlsx
Create a new Tableau workbook and connect to the EC3 Excel data file.

Understanding the Data

[Origin] is the airport where the flight begins.  The flight then ends at [Destination].  Both of those fields are 3-letter airport codes.  The airport codes used in this file are GNV=Gainesville, CLT=Charlotte, ATL=Atlanta, DFW=Dallas, MIA=Miami.

Task #1 -- Create calculated fields

Create the following new calculated fields that are needed for the analysis:

·         Flight Type -- this field should contain the value "Departure" if the flight is leaving from Gainesville.   For all other flights, the field should contain the value "Arrival".

·         Departure Status -- if the flight departed late (late departure minutes is greater than zero) then this field should contain the value "Late Departure"; for all other flights, this field should be "On-Time Departure".

Task #2 -- Departure Summary

Create a crosstab viz.  The rows should display the airlines.  The columns should display the Departure Status.

The data contains both arrivals and departures.  Setup a filter so that your crosstab only displays the departures.

Build the three analyses in the body of the crosstab:

1.    Percentage of Delayed Flights -- First, configure your crosstab to display the number of flights.  Now use a table calc to change that into the percentage of flights for each airline that were delayed or on-time.  (Results check -- on-time departures for AA is 75.53%).

2.    Number of Flights.  (Results check -- there were 167 on-time departures for Delta).

3.    Average number of minutes the flight departed late.   (Results check -- the average was 38.7 minutes for late AA flights).

Now make it look nice for your users -- they aren't Tableau data analysis wizards like you are.  Format the body of the table to match the example below ... zero decimal places, friendly wording for row text, and sequence of data items.

To edit the row text, you right-click on the current row text, then choose "Edit Alias":

Here is the desired outcome ... with the results check data from above.

Task #3 -- Heat Map

Now, you will create a heat map to visually depict flight departure delays out of Gainesville in January 2020.

·         Please create a symbol map that shows a dot for each destination airport (hint: you will need to change the Geographic Role of the dimension).