Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment: Flights Data This Tableau file contains information on all U . S . airline flights from 2 0 1 0 and 2 0 1

Assignment: Flights Data
This Tableau file contains information on all U.S. airline flights from 2010 and 2011. Create a Tableau worksheet to answer each of the following questions:
FILE to use: Flights_data.twbx from the Public Files on your Moodle site.
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 flights over time in more detail to determine why these yearly numbers show such a large drop.
2. You are interested in identifying days that are particularly light in terms of travel each year. Are there particular holidays that seem to experience substantially lower numbers of flights?
3. 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?
4. 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 airline, Colors should range from dark blue for states with short departure delays to dark red for states with long departure delays.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

10th Edition

0137916787, 978-0137916788

More Books

Students also viewed these Databases questions

Question

7. Explain why retirees may be valuable as part-time employees.

Answered: 1 week ago

Question

3. Provide advice on how to help a plateaued employee.

Answered: 1 week ago