BUSIT 202 - Dimensional Modeling

5 CR

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(s): BUSIT 105 with a C- or better.

Course Outcomes

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

Find out when this course is offered