Lawrence Dignan
Your reading for the week
Foursquare analytics dashboard for brick-mortar retailers
An interesting read on how Foursquare is building its dashboards and analytics out for retail. Worth checking out.
In-Class Exercise 8.1: Identifying Key Performance Indicators
Here is the exercise.
Weekly Question #7: Complete by March 27, 2017
Leave your response as a comment on this post by the beginning of class on March 27, 2017. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your opinions, not so much particular “facts” from the class!
Here is the question:
Give an example of a KPI – some sort of metric for performance – that you use on a regular basis? Briefly discuss how it conforms to the SMART criteria.
(For example, my car tells me its average gas mileage. This is specific and measurable – gas mileage is a precise measure. It is achievable – I can alter my driving to try to get better mileage. It’s relevant – gas mileage has an impact on my costs! And it’s time-variant, I can look at gas mileage over a week, or a day, or a month.)
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].
Weekly Question #6: Complete by March 20, 2017
Leave your response as a comment on this post by the beginning of class on March 9, 2017. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your opinions, not so much particular “facts” from the class!
Answer one of these:
We spent a little time in class discussing the article Stupid Data Corruption Tricks.
- Have you ever made one of the mistakes listed in the article? Describe what happened.
- If you haven’t made one of those mistakes, which one of them do you think is the most important to avoid?
Reading Quiz #6: Complete by March 20, 2017
Some quick instructions:
- You must complete the quiz by the start of class on March 20, 2017.
- 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 3/20
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].
Reading Quiz #5: Complete by March 6, 2017
Some quick instructions:
- You must complete the quiz by the start of class on February 28, 2017.
- 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.