Michelin star information

Introduction to Maps

The file needed for this exercise is Restaurants-Map.xlsx
Your client is a food critic who has been visiting fine restaurants all over the world. She has provided you with an Excel file that includes the exact location of each restaurant (latitude/longitude) that she visited last year, along with other useful information such as the type of cuisine, Michelin star information, etc. Use Tableau to create the following visualizations of this dataset (without the Annotations. See Annotation for more information):
Visualization 1: (Name worksheet as” Vis1”)
Hint: Use the number of records and Michelin stars in the marks. Also, drag Longitude(generated) to Column and latitude(generated) to row.

Visualization 2: (Name worksheet as” Vis2”)
Hint: Create another dimension by creating a calculated field. Name it as “TwoPlusStars”.
Use the following equation to create “TwoPlusStars” dimenstion. (See Annotation for more information)
IF [Michelin Stars]>1 then "yes" ELSE "no" END
Also, drag longitude to Column and latitude to row.

Save your tableau file as “Assignment_Map”.

Charts and Dashboard

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

1. 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. (Name your worksheet as ”FlightDrop”)

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? (Name your worksheet as ”Flightholiday”)
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? (Name your worksheet as ”Flightairline”)
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. (Name your worksheet as ”Flightdelay”)
5. Create a dashboard using the visualizations you created in the 1 through 4. Organize those worksheets into the dashboard like the picture below. (Name your dashboard as ”Flightdashboard”)
6. Save your Tableau file as “Assignment_Charts and Dashboard”