The Flights_data.twbx Tableau file contains information on all U.S. airline flights from 2010 and 2011. Create a Tableau workbook to answer each of the following questions:
A quick viz of flights over time shows a drop of more than 300,000 flights from 2010 to 2011:
- From your experience, you know that flight activity did not drop so significantly between 2010 and 2011. Why does this viz seem to indicate otherwise? Investigate the flights over time in more detail to determine why these yearly numbers show such a large drop. Something does not add up, see if you can find it.
- Now let’s identify days that are particularly light in terms of travel each year. Are there particular holidays that seem to experience substantially lower numbers of flights? Find a chart to show this.
- Next, you want to know who operates the most flights. Is there one airline that operated more flights than any other single airline for each week in this dataset? Use a chart to show the trend over time for all airlines.
- You would also like to know which states tend to experience the longest departure delays. Create a map that visualizes the departure delay that you can expect in each origin state. Allow the user to filter by the airline. Colors should range from dark blue for states with short departure delays to dark red for states with long departure delays.