Laurel Miller

Here are the instructions for the in-class exercise, to familiarize you with SAS On Demand Enterprise Miner.

Here is the study guide for your next exam, which will take place on Friday, November 9th. This exam will cover SQL In, Dimensional Modeling, Pivot Tables and ETL (data cleaning).

This assignment builds on the ETL In-Class Assignment using the Excel workbook “ETL Exercise.xlsx.” If you haven’t finished that yet, you’ll need to do that before starting this The link is <a […]

Click here for a copy of the presentation slides. We’ll cover this in week 9.

In this lecture, we’ll provide overview of data mining, and also introduce some key concepts in the area.

Here is how IBM defines Big Data (IBM)

Think for about 100 seconds what you learnt in class during week 7 (ETL) and summarize your thought here.

Here is how the city of New York is using data analytics to save live and tax dollars (O’Reilly Media)

Here is an interesting article on careers in Big Data (USA Today)

Here is a tip for troubleshooting SAS:

Account names must be entered only in lower case when the person logs in to SAS software. So if you registered as :

Bobsmith, password “HeLLo”

You should log in as […]

We will be working with SAS Enterprise Miner tool for the Data Analytics part (the last third of the class). To take part in this, you must create an account with SAS. The instructions are provided here: (click […]

This one is simple. Just setup your SAS OnDemand account and report your username as a comment on this post by 3pm on October 25th, and receive a bonus of 0.25% toward your final grade.

Hi All,

We’ll have office hours tomorrow from 2:30 – 3:30pm in Alter Hall 603 (laptop lab). The TA will go over your queries regarding the Pivot Table assignment.

Best

Here are some slides with some useful Excel functions (slides).  Also attached is the example Excel spreadsheet that demonstrates the use of each function.

Click here for inclass exercise on ETL. Also, click here for the data.

Click here for a copy of the presentation slides. We’ll cover this in week 8.

In this lecture, we’ll discuss the key issues involved with converting a transactional database into an analytical database.

Click here for a copy of the assignment. The Excel spreadsheet can be accessed here

This is due on Wednesday – October 24, 2012. Please submit a printout with all the answers at the beginning of the class.

Click here for class captures by date:

October 8, 2012

October 10, 2012

October 12, 2012

Hi All,

A couple of announcements about test 1:

1. The first test will be held on Monday, October 15. The study guide for the same has been posted on the blog.

2. The test will be 50 mins duration and […]

Click here for a study guide for test 1.