#### In-Class Exercises

# In-Class Exercise 13.2: Simple Predictive Analytics

*For this one you’ll need a Windows PC. The Mac version of Tableau is slightly different and can’t do the “self-join” operation used in the exercise.*

*If you get a “missing driver” error message, download this update.*

Here is the exercise.

And here is the spreadsheet you’ll need to do the exercise [In-Class Exercise 13.2 – VandelayOrdersAll.xlsx]

# In-Class Exercise 13.1: Predicting Future Enrollment

Here is the exercise.

# In-Class Exercise 12.2: Sentiment Analysis Using Excel

Here is the exercise.

And here is the spreadsheet you’ll need to do the exercise [In-Class Exercise 12.2 – Sentiment Analysis Tools.xlsx].

# In-Class Exercise 12.1: Manually Determining the Sentiment of Text Data

Here is the exercise.

# In-Class Exercise 11.2: Working with ‘Pivot Tables’ in Tableau

Here is the exercise.

And here is the spreadsheet you’ll need for this exercise [In-Class Exercise 11.2 – NCAA 2013-2014 Player Stats.xlsx].

And here is the answer key.

# In-Class Exercise 11.1: Creating a Database

Here is the exercise.

And here is the solution [In-Class Exercise 11.1 – Playlist DB.xlsx].

# 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.2: Visualizing KPIs

Here is the exercise.

And here is the workbook you’ll need [In-Class Exercise 8.2 – OnTime Airline Stats [Jan 2014].xlsx].

# In-Class Exercise 8.1: Identifying Key Performance Indicators

Here is the exercise.