The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Jul 2017 |
| Last Sign in: | 304 Weeks Ago, 6 Days Ago |
| Questions Answered: | 15833 |
| Tutorials Posted: | 15827 |
MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002
Manager Planning
WalMart
Mar-2001 - Feb-2009
This is a Tableau Assignment. Don't take it if you don't know how to operate the Tableau Software. Check the word document for instruction.
Download and save the BirdStrikes dataset. You may want to first look at it in Excel, note the data has 99,404 records. This data describes bird strikes with aircraft in the U.S. from 2000-2011. Close the Excel file prior to opening it in Tableau. Use the PPT slides and your worksheets to complete the assignment.
Create four worksheets for each of the following scenarios. Each worksheet and title must be named appropriately.
a.      Bar Chart: Number of flights (Count the flight number) by Phase of Flight. Filter for only precipitation conditions of None and type of aircraft to airplane. Always show the number (show label) of bird strikes for Descent.
b.     Side by Side Vertical Bars: Total cost by sky conditions and time of day. Group Some Cloud and Some Clouds together and then No Cloud and No Clouds together. Filter out the UNKNOWN time of day. Bring the time of day to color in Marks section.
c.      Line Chart: The total number of people who get injured from a bird strike incident and the year reported (use the record date). Show all of the data points.
d.     Highlight Table: The total cost by state and airport name. Only include those values where total costs are at least $15,000,000.
Create a dashboard and include the four worksheets.Â
Create a story including the 4 worksheets and the dashboard.Â
Â
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly