Xue Guo
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].
Tableau Tutorials and Extra Credit Opportunities
Dear All,
There are some excellent resources about tableau for you to learn as a beginner.
Lynda.com (free for temple students, log in through TUportal) offers two useful courses related to the materials we taught in the class.
The first one is called Tableau Essential Training with Curt Frye. This video covers some basic steps of using Tableau which can help you understand the materials in class. If you finish this course (send me the course certificate), you can earn 10 extra points to your assignment 1.
Another course is called Creating Pivot Tables. Pivot Tables of Excel are the foundations of Tableau. Tableau just integrates different types of charts based on the text tables. This may help you understand the logic of Tableau.
Assignment 3: Final (Group) Project
Here are the assignment instructions and the updated final groups.
The assignment is due Dec 3, 2018 before class. We’ll do the presentations on Monday (Dec 3) and (if needed) Wednesday (Dec 5).
This is a GROUP project so you may not do this assignment on your own.
Reading Quiz #7: Complete by October 22
Some quick instructions:
- You must complete the quiz by the start of class on October 22.
- You can only do the quiz once.
- 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.1: Identifying Key Performance Indicators
Here is the exercise.
Assignment 2: Cleaning a Data Set–DUE OCTOBER 26
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. Please turn in both the answer sheet and your clean spreadsheet before class via Canvas on October 26.
And here is the data file you’ll need: VandelayOrders(Jan).xlsx.
In-Class Exercise 7.2: Finding Bad Data in Excel
Extra Credit Alert!! Temple Analytics Challenge
Participant in the Temple NBCUniversal Analytics Challenge and receive extra credit! It is due by midnight on October 31. Start early!
You don’t need to do anything more except submit it to the competition and you could win up to $2,500!
Reading Quiz #6: Complete by October 15
Some quick instructions:
- You must complete the quiz by the start of class on October 15.
- You can only do the quiz once.
- This is “open book” – you can use the articles to answer the questions – but do not get help from anyone else.
Please access the quiz6 through Canvas.com
In-Class Exercise 7.1: How Data Gets Dirty
Here is the exercise.