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]
Here is the final version of the Tableau file (right-click and download to save file first), and final version of the Word document, to check your work.
Weekly Question #7: Complete by Oct. 26, 2017
Leave your response as a comment on this post by the beginning of class on October 26, 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.)
Reading Quiz #7: Complete by Oct. 26, 2017
Some quick instructions:
- You must complete the quiz by the start of class on October 26, 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.
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].
Here is the final version of the exercise, to check your work. (Remember to right-click and download the file first. Dropbox cannot display Tableau files.)
In-Class Exercise 8.1: Identifying Key Performance Indicators
Here is the exercise.
Video Solution for Assignment #2
In the interests of time, I have posted a video on our Class Capture page of how the charts were to be created and analysis conducted for Assignment #2. We will not be reviewing this in class, so please take the time to view independently.
Let me know if you have questions after watching the video.
Thanks,
Professor Pote
Weekly Question #6: Complete by Oct. 19, 2017
Leave your response as a comment on this post by the beginning of class on October 19, 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 Oct. 19, 2017
Some quick instructions:
- You must complete the quiz by the start of class on October 19, 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.
Assignment 3: Cleaning a Data Set
Assignment 3 is due before class (5:30pm) on Thursday, October 26, 2017. 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.
When your assignment is complete, you’re going to email both files (answer sheet in .docx or .pdf format, and cleaned .xls file) to me at MIS0855.h6xo7208v2mgk0g6@u.box.com from your Temple email account. If your upload is successful, you’ll receive a confirmation receipt via email from the Temple OwlBox system. SAVE THIS RECEIPT! It is your proof that your submission was submitted, the name of the document, and the time/date of submission.
If you don’t receive a confirmation email, it likely means your submission was not successful. Try again, and contact me if you’re having recurrent issues.
In-Class Exercise 7.1: How Data Gets Dirty
Here is the exercise.