Lawrence Dignan
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]
Reading Quiz #7: Complete by Oct. 29, 2018
Some quick instructions:
- You must complete the quiz by the start of class on Oct. 29, 2018.
- When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign in. It will then take you to the quiz.
If it says you don’t have access, make sure you’re signed out of your regular Gmail (non-TUMail) account! - You can only do the quiz once. If you submit multiple times, I’ll only use the first (oldest) one.
- This is “open book” – you can use the articles to answer the questions – but do not get help from anyone else.
Ready? Take the quiz by clicking this link.
Your reading for the week (data integration)
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 8.1: Identifying Key Performance Indicators
Here is the exercise.
Reading Quiz #6: Complete by Oct. 22, 2018
Some quick instructions:
- You must complete the quiz by the start of class on Oct. 22, 2018.
- When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign in. It will then take you to the quiz.
If it says you don’t have access, make sure you’re signed out of your regular Gmail (non-TUMail) account! - You can only do the quiz once. If you submit multiple times, I’ll only use the first (oldest) one.
- This is “open book” – you can use the articles to answer the questions – but do not get help from anyone else.
Ready? Take the quiz by clicking this link.
Your reading list for KPIs
A few reports worth checking out
Here are a few reports worth checking out. The first one is the UN’s 2018 report on global warming. You probably saw a headline or two about it last week. It’s worth seeing the whole report and the executive summary (which is 34 pages). In any case, you’ll see the data, the hundreds of authors and contributors and a few visualizations.
The other report is one on data literacy by a company called Qlik, which is a Tableau competitor. It captures business perceptions of analytics and data (and fits in with what we’re talking about the next two classes).
Separately, there’s a Reddit thread called Data is Beautiful and has some interesting visualizations and approaches.
For instance, I came across this story on someone on Reddit visualizing his Tinder experience only to find another person did their 500-day OKCupid outcomes.
Both of the data sets (along worth a bunch of others) are on the Data is Beautiful Reddit. The thread highlights the democratization of visualizing data. Worth checking out for giggles.
Assignment 2: Cleaning a Data Set, Due Oct. 19 at 3 p.m.
Here are the instructions (in Word) (and as a PDF). Make sure you read them carefully! This is an assignment that should be done individually.
And here is the data file you’ll need: VandelayOrders(Jan).xlsx.