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]