Welcome to your Specialist Hands-on questions for Exploring & Analyzing Data
Links to data sets used in the hands-on questions:
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.
6. Using the Southern Region sheet of the South Superstore data, which state bordering Mississippi had the highest Sales?
Yay! I feel like I’m getting better every time I do a test!