Dimensional Data Deck Posted
Here’s the link to the deck for Dimensional Data Modeling – Decks
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
ETL Slide Deck Posted
Hi – the slides for tomorrow’s ETL discussion can be found here: http://community.mis.temple.edu/mis2502sec001s16/slide-decks/
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.
Class Capture – 2/24/16
Here’s the link for the Class Capure from 2/24 Class Capture
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
Class Capture – 2/17/16
Here’s the class capture for today: Class Capture
Recent Comments