Question

Step by step, explain how to do this in-class exercise: introduction to maps. The file needed for this exercise is an Excel file provided by your client, a food critic who has visited fine restaurants all over the world. The file includes the exact location (latitude/longitude) of each restaurant visited last year, along with other useful information such as the type of cuisine and Michelin star information. Use Tableau to create the following visualizations of this dataset (without the annotations): Visualization 1: [Insert description of visualization 1] Visualization 2: [Insert description of visualization 2]. After successfully creating the two maps above, use the Tableau skills you have learned so far in this course to create at least 2 other interesting visualizations of this data. Be ready to share these with your classmates and explain why you chose the visualization techniques that you used?

Answer 1

To visualize the food critic's Excel data in Tableau, connect to the file, create map views with latitude and longitude, and enhance with additional information. Further visualizations can include bar charts or scatter plots to analyze the data by different factors.

Step-by-step explanation:

To create visualizations in Tableau using the Excel file provided by your client, follow these steps:

1. 
   
3. Open Tableau and connect to the Excel file. Ensure that the file is correctly read by Tableau, with appropriate data type assignments for latitude and longitude values.
4. 
   
6. Drag and drop the latitude and longitude fields into the columns and rows shelves respectively to create a map view.
7. 
   
9. Add additional data to the map by dragging fields such as type of cuisine and Michelin star information onto the appropriate 'Marks' card slots (color, size, label, etc.) to differentiate the points.
10. 
    
12. Refine your visualizations by adjusting the map style, zoom levels, and any filters or legends you would like to add.
13. 
    
15. For your additional visualizations, you might create a bar chart to show the number of restaurants by cuisine type or a scatter plot showing Michelin star rating by geographic location.
16. 
    
18. Review and save your visualizations, prepping them to be shared with your classmates.

These maps and charts will help in understanding geographical distributions and patterns associated with the food critic's restaurant visits.