# Introduction to Tableau

Download the following 2 datasets to your computer:

1\. [Global Superstore.xlsx](https://docs.google.com/spreadsheets/d/1Do1D7bRO0lRho0WcQK3irGgSw0JYmVNM/edit?usp=sharing\&ouid=110148203766108747805\&rtpof=true\&sd=true)

2\. [Data Prep - Flights.xlsx  ](https://docs.google.com/spreadsheets/d/1fh_c8hleEhPbiWzkybTnsSbo_Rt5p2D5/edit?usp=sharing\&ouid=110148203766108747805\&rtpof=true\&sd=true)

{% embed url="https://docs.google.com/presentation/d/1T5SRTmY1nvAkY_jbUViV7dWSdCsF0xAfN6HxvaHipxk/edit?usp=sharing" %}

**Hands on exercise:**

For this exercise, you will work with the [2019 Massachusetts crime data by city](https://docs.google.com/spreadsheets/d/1VTYO2cnjJBs5O1l3htW5cfG0IZW83YyZ/edit?usp=sharing\&ouid=110148203766108747805\&rtpof=true\&sd=true). The spreadsheet includes one table and some extra formatting. &#x20;

1\. Connect the excel file to Tableau.&#x20;

2\. Drag over the “Crime 2019” table to the area that says “Drag sheets here”. Look at your data table. Does it look right to you? Consider the table format, header, footer, and variable type.

3\. Use the data interpreter function in Tableau, review Data Interpreter results in the preview area.&#x20;

4\. Check out the data table. How does it look now? Consider the table format, header, footer, and variable type.&#x20;

5\. Change the variable names to better reflect what they are. E.g., crime total 1 to Violent crime, crime total 2 to Property crime. (provide a screenshot)

6\. What potential data visualization questions can you ask from this data set? \
