To Do
Assignment 5 – Due March 18th
In Class Exercise – Pivot Tables
Here’s the document: In-Class Exercise #8 – Pivot Tables
Here’s the Salesperson Cube Data: In Class Exercise Salesperson Cube
Assignment 4 – ETL – Due March 11
Here’s the information you need to complete Assignment #4. This assignment will walk you through the process of ETL in Excel. You will learn some basic Excel formulas that will be helpful for the future as well! Simply work through the instructions in the Word document and as always, let me know if you have questions!
Follow the instructions for submission as well – just email me your completed Excel workbook by the morning of 3/11.
Word Doc: Assignment #4 – ETL
Excel Workbook: ETL Workbook
Weekly Question
Hi – here’s your weekly question – it’s due the Monday we return from Spring Break, but please feel free to get it done before you go off and do something fabulous for the week!
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!If you sign in using your AccessNet ID and password you won’t have to fill in the name, email and captcha fields when you leave your comment.
Here is the question:
Consider the best practices for data visualizations we discussed in class. Take a look at two infographic sites: The Daily Infographic and Cool Infographics. Find a graphic that does a nice job of telling a story. Post a link to the graphic and explain why you think it’s an example of a good data visualization.
Files for ICE
In Class Exercise # 7
Here’s the doc: In-Class Exercise #7 – Creating Infographics (DataViz)
And here are the additional files you will need:
Protected: In Class Exercise #6 Key
Assignment 3
Here’s the document for Assignment 3 – Assignment #3 – SQL #2
Additional Office Hours
I will be holding extra office hours for your questions as you study for Exam 1.
The office hours will be Friday, February 12: 10:00-11:00, please stop by if you have questions!
Exam 1 Study Guide
Here’s a guide to help you as you prepare for Exam #1 – Exam 1 Study Guide