please answer each question using Tableau providing details and screenshots of how you
arrived at the answer. Use the files attached. As a guidance, treat this like your case studies, where I look for steps/details
rather than an “answer”. This is not to be done in Excel , rather it should be done in Tableau. Use resources available on the
internet or any of these
1. Open the Flights worksheet of the tds_sample_data_all workbook. Create a bar chart showing the average of Minutes of Delay
per Flight broken down by Airport, and filtered by date to show only the last September, October, and November 2013. Which
airport had the lowest average minutes of delay per flight between September and November?
2. Open the Flights worksheet of the tds_sample_data_all workbook. Create a crosstab showing the sum of Flights broken out by
ontime category and airport, then add grand totals to the view. Use a filter to exclude flights that were ontime. For Dallas/Fort
Worth, what number of flights were not ontime, and what number were Delayed by Security?
3. Open the Flights worksheet of the tds_sample_data_all workbook. Create a line chart showing the average minutes of delay
per flight by month. Create a filter for carrier name of US Airways. Which month saw the biggest decrease in average minutes of
delay per flight compared with the previous month?
4. Using the Southern Region sheet of the South Superstore data, find the total sales value of items shipped in January and
February 2014.
5. Using the Southern Region sheet of the South Superstore data, find the customer name with the largest number of unique
order ids.
