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.
After completing this class, students should be able to:
- Analyze the organizational goals of a data warehouse
- Analyze the importance of dimensional modeling for a data warehouse
- Analyze the basic structure of a dimensional model
- Analyze the differences between dimensional modeling and other design techniques
- Analyze the key facets of good fact table design
- 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 key facets of good dimension table design
- 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
- Apply appropriate dimensional modeling techniques to new scenarios