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 Tableau workbook with the answer in form of completed dashboards.
And here are the answers to the questions posed in the exercise.
Weekly Question #8: Complete by November 9, 2016
Leave your response as a comment on this post by the beginning of class on November 9, 2016. 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:
Once again, find another online article dated within last two weeks from a credible source that has something to do with data and is interesting and relevant to you. Copy and paste the URL directly into your response followed by a few sentences that explain what is interesting about it.
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]
Here is the finished Tableau Workbook for this exercise.
Study Guide for Exam 2
Here is the study guide for the second exam, which will be on Friday, November 4, 8:00am.
Format for review is same as for the first exam:
- Unstructured, for my part. I do not have an agenda for topics to cover. I will field questions as you ask them, but only if you ask them.
- I won’t answer questions like “what’s going to be on the exam”.
- Conceptually, the following are subject for valid questions:
- Anything on the study guide
- Anything from the readings
- Anything from the slides and in-class activities
- Anything from the Assignments
- Anything from the quizzes and weekly questions
- When the questions stop or we reach 50 minutes, class will end.
- On the matter of questions:
- There are no dumb questions.
- Don’t self-censor. Ask your question, and leave it to me to determine if it’s one I’m inclined to answer, discuss, or if it’s too close to the “what’s on the exam” slant to respond to.
- Remember if you have the question, likelihood is someone else does too, and they’ll probably thank you for asking it.
- And lastly, do come to class with questions in hand.
Suggested study approach:
- Review the Study Guide first, then:
- Start with the slides
- Look at the major concepts
- Where a slide is associated with a reading, review the reading that covers the major concept
- Understand how the reading is associated with the slide, and the reading’s key concepts
- Then look at the quizzes
- Review the questions and answers to the quizzes
- Understand where all the answers came from, review those readings
- Then review the In-Class Exercises
- If we did it in an exercise, it’s probably important.
- Focus on topics we emphasized in the Exercises.
- Then, review your Assignments.
- Lastly, re-read any readings you didn’t review in the prior study steps.
What will be on the exam, in order of likelihood, are:
- Things we talked about explicitly in class
- Slides, and readings directly associated with them
- Things I quizzed you on
- Things we worked on in class through the exercises
- Things you used while completing Assignments
- Other things from readings that may not have otherwise been emphasized in class discussion or readings
Reading Quiz #8: Complete by November 7, 2016
Some quick instructions:
- You must complete the quiz by the start of class on November 7, 2016.
- 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’s the finished workbook in Tableau [Visualizing KPIs.twb]
Weekly Question #7: Complete by October 26, 2016
Leave your response as a comment on this post by the beginning of class on October 26, 2016. 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.1: Identifying Key Performance Indicators
Here is the exercise.
Reading Quiz #7: Complete by October 24, 2016
Some quick instructions:
- You must complete the quiz by the start of class on October 24, 2016.
- 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 7.2: Finding Bad Data in Excel
Here is the exercise.
And here is the dataset you’ll need [Vandelay Orders by Zipcode.xlsx].