#### In Class Exercises

# In-Class Exercise 8.1: Identifying Key Performance Indicators

Here is the exercise.

# In-Class Exercise 7.2: Finding Bad Data in Excel

Here is the exercise.

And here is the dataset you’ll need [Vandelay Orders by Zipcode.xlsx].

# In-Class Exercise 7.1: How Data Gets Dirty

Here is the exercise.

# In-Class Exercise 5.2: Creating Infographics

Here is the exercise.

And here is the graphic file you’ll need: Philadelphia Area Obesity Rates.png.

**Right-click on the file and save it to your computer.**

# In-Class Exercise 5.1: Telling a Story Through Visualization

Here is the exercise.

Before you start, save this Tableau file and the studentloans2013 Excel workbook to your computer. Remember, to save the file right-click on the link and choose “Save As…” (don’t just left-click on the link).

# In-Class Exercise 4.2: Getting Familiar with Tableau

Here is the exercise.

And here is the spreadsheet you’ll need to complete the exercise [In-Class Exercise 4.2 – FoodAtlas.xlsx].

**Make sure you right-click on the Excel file link and select “Save [Link] As…” to save it to your computer before starting the exercise.**

Here is the final version of the Tableau exercise.

# In-Class Exercise 4.1: Finding Good and Bad Visualizations

Here is the exercise.

Here are the links in case you cannot click from the document.

Remember to leave a comment on this post with the link to your graphic for our discussion.

# In-Class Exercise 3.1: Trusting Data

Here is the exercise.

# In-Class Exercise 2.2: Finding Sources of Data

Here is the exercise.

As discussed in class today, please comment on this post with the following:

- What dataset did you find
- Where did you find it
- Why did you think it was interesting
- What did you learn from the data
- How could you use the data or what decisions could you make based on it

Comments are due by 7:59am Wednesday, September 14, 2016.

# In-Class Exercise 2.1: Creating a Data Dictionary

Here is the exercise.

And here is the spreadsheet you’ll need [In-Class Exercise 2.1 – 2015 Car Fuel Econ [Start]].

And here is the completed data dictionary for your reference In-Class Exercise 2.1 – 2015 Car Fuel Econ [Complete]