ISIT 336 Dimensional Modeling • 5 Cr.
Dimensional modeling has been broadly accepted as one of the principle techniques 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: ISIT 330 with a C or better.
After completing this class, students should be able to:
- Analyze the organizational goals of a data warehouse.
- Analyze the importance and basic structure of dimensional modeling for a data warehouse.
- Analyze the differences between dimensional modeling and other design techniques then apply appropriate techniques to new scenarios.
- Analyze the different types of fact tables and when it is appropriate to use each.
- Create designs for fact tables using solid dimensional modeling techniques.
- Analyze the different ways in which change is handled in dimension tables.
- Create designs for dimension tables based upon solid dimensional modeling principles.
- Create appropriate dimensional models/designs for a variety of organizational data warehouses/data marts.