#### In Class Exercises

# In-Class Exercise 9.2: Creating Interactive Dashboards

Here is the exercise.

And here is the Excel workbook you’ll need [Pew Story Data (Jan – May 2012).xlsx]

# In-Class Exercise 9.1: Connecting Diverse Data

Here is the exercise.

And here are the workbooks [2012 Presidential Election Results by District.xlsx and Portrait 113th Congress.xlsx]

# In-Class Exercise 8.1: Identifying Key Performance Indicators

Here is the exercise.

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