Description:

Dimensional modeling has been broadly accepted as the principle technique for data warehouse design. Students use a sequenced series of case studies and hands-on exercises to learn effective design principles for data warehouse development. Prerequisite: BUSIT 105 with a C- or better.

Details:

Prerequisite: BUSIT 105 with a C- or better; class uses SQL Server 2008 and Analysis Services.

Outcomes:

After completing this class, students should be able to:

• Describe the goals of a data warehouse
• Describe the components of a data warehouse
• Explain the importance of dimensional modeling for a data warehouse
• Design Fact and Dimension tables
• Using a series of Case Studies, identify the probable set of dimensional modeling problems that occur in organizations
• Develop design principles based on the problems identified in the case studies
• Apply design principles to new situations