Recent Comments

In Class Exercises

« Older Entries

ER-D Exercise

February 5, 2013 | Author

Hi all,

Please find the ER-D exercise (Feb 6, 2013) here.

Posted in In Class Exercises | Comments Closed

June 20: In class Exercise – Decision Trees and Clustering

June 19, 2012 | Author

Hi all,

Please see the instructions for the lab session below.

Decision Tree.

Clustering.

Posted in Announcements, In Class Exercises | Comments Closed

June 19: Clustering and Segmentation

June 18, 2012 | Author

Hi all,

Please see lecture notes for tomorrow’s class here.

Posted in In Class Exercises | Comments Closed

June 13: In class exercise: Decision Trees

June 13, 2012 | Author

Hello all,

Please see the in class exercise file here. If we have time we will go over it.

Posted in In Class Exercises | Comments Closed

June 12: Intro to Data Analytics

June 11, 2012 | Author

Please find the slides here:

Instruction to familiarizing yourself with SAS is here.

Posted in In Class Exercises, Lecture Material | Comments Closed

ETL question: joining two names with a space

June 11, 2012 | Author

Please try using this code for joining two names (first name last name) into one cell:

=CONCATENATE(‘Source 2′!B2, ” “, ‘Source 2′!C2)

Posted in In Class Exercises | Comments Closed

In Class Exercise 4: ETL

June 11, 2012 | Author

Hi all,

Please see in class exercise 4 here.

The dataset is here.

Posted in In Class Exercises | Comments Closed

Assignment 2 MySQL “out” Answer Keys

June 10, 2012 | Author

Hi all,

Please find answer keys for the MySQL in Assignment here. By the way, grades for this assignment were uploaded.

Please drop by my office if you still have ANY problems with writing MySQL queries to get out data/info. I am available for you guys most of the time even after office hours.

MySQL is very important and useful so I want to make sure all of you understand the basic principles.

Posted in Announcements, Assignments, In Class Exercises | Comments Closed

In Class Group Discussion

June 7, 2012 | Author

Today we will be discussion extraction, transformation and loading of data from operational database to a data mart and then to a data cube,

after the lecture we will spend about 30 minutes on a group discussion on ETL: finding factors that have an effect on Amazon book sales.

The group discussion file is here.

Posted in In Class Exercises | Comments Closed

In Class Exercise: Pivot Tables

June 6, 2012 | Author

Please see the exercise here.

The data cube (spreadsheet format) can be downloaded here.

Posted in In Class Exercises | Comments Closed
« Older Entries