#### In Class Exercises

# In-Class Exercise 8.2: Visualizing KPIs

Here is the exercise.

And here is the spreadsheet to complete the exercise [In-Class Exercise 8.2 – OnTime Airline Stats [Jan 2014].xlsx].

# 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.**

# 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.

# 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]]