Sunil Wattal

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

Click here for instructions on the SAS inclass exercise on decision trees.

Click here for a copy of the assignment. This is due on Wednesday – November 7, 2012. Please submit a printout of the completed answers on page 2 of the assignment (no screen shots and diagrams are […]

Here are some options you can follow if SAS is not working correctly.

1. If you have problems with Java, make sure that the correct version of Java is installed. Follow the instructions on pages 22-24 to check […]

Here is an excellent book chapter to read for decision trees. This is not part of the exam, and is for your reference only (click here).

We’re starting to get into analytics this week and next. This set of PPT slides covers Decision Trees.

In this lecture, we’ll discuss the use of decision trees for data mining. The topics covered include […]

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.