Data Analytics – Section 1

To Do

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.

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!