Data+Warehousing

=Data Warehousing 1= Tuesday, March 25

**Topic overview:**
Effective Business Intelligence requires data. Lots of it. In this class we will look at fundamental models and techniques used by BI specialists to design, construct, load, and manage Data Warehouses. These processes can be thought of as the 'diet and exercise ' portion of a corporate Business Intelligence program. They 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:
 * Data warehouses and data marts
 * Data warehousing architectures
 * Dimensional modeling

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


 * Slides**: [[file:BITT S08 Lecture 3 - Data Warehousing I.ppt]]


 * In-class exercise:** [[file:BITT S08 Lecture 3 in class exercise.doc]]

Please edit only below this line [Bob Monroe]

**Supplementary resources:**
Sen and Sinha provide a quick overview of some popular data warehousing methodlogies in their 2005 CACM paper:
 * [SS05] Sen, Arun and Sinha, Atish P., "A Comparison of Data Warehousing Methodologies"., Communications of the ACM, March 2005, pp 79-84.