Data+Warehousing+2

=Data Warehousing 2= Thursday, March 27

**Topic overview:**
Today's class extends the 'diet and exercise' discussion on the previous class. The emphasis today will be the processes, tools, and techniques required to Extract, Transform, and Load data from transactional data stores to analytical data stores. This process is ofter referred to as ETL. A key aspect of any good ETL program is evaluating, improving, and insuring a high level of data quality. This is often referred to as data cleansing. These process require hard work and discipline, are not particularly glamorous, but are necessary if you want to subsequently make effective use of BI analytics, visualization, and reporting tools.

Specific topics that we will cover include:
 * ETL processes
 * Data cleansing
 * Introduction to dimensional modeling

**Preparation for class:**
Please complete the following reading prior to class on 1/22.
 * [Los03] Loshin, David, Business Intelligence: The Savvy Manager’s Guide, Morgan Kaufmann Publishers, 2003, ISBN: 1-55860-916-4 (course textbook)
 * Required: Chapters 8, 9, 10

In-class exercises: [[file:BITT S08 Lecture 4 - in class exercise.doc]]
Please edit only below this line [Bob Monroe]