Data Warehousing
Fall
2007
General
Please be sure that I have a resume from you.
SQL Resources
SAS Resources
For a student copy of SAS, contact Lane Reiser (1536)
References
**1************
Introduction
Monday, 08/20/07
Wednesday, 08/22/07
**2************
Monday, 08/27/06
Resume due.
Wednesday, 08/29/06
Homework: Due 9/07/06 Write SQL code to
* Extract the data from the Sales database into a new table
* Generate surrogate keys
* Add the surrogate keys into a new analysis table
****** Dimensional Modeling: Designing the data warehouse *****
**3************
Monday, 09/03/07
LABOR DAY HOLIDAY
Wednesday, 09/05/07
**4************
Monday, 09/10/07
Wednesday, 09/12/07
**5************
Monday, 09/17/07
Wednesday, 09/19/07
**6************
Monday, 09/24/07
Wednesday, 09/27/07
****** The ETL Process: Loading the data warehouse *****
**7************
Monday, 10/01/07
Wednesday, 10/03/07
class
**8************
Monday, 10/08/07
Wednesday, 10/10/07
**9************
Tuesday, 10/15/07
Wednesday, 10/17/07
<<<<<<<<<<<<<<<<<<<<< Quiz 1 >>>>>>>>>>>>>>>>>>>>>>>