DATA 336 - Dimensional Modeling

5 CR

Previously ISIT 336.
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(s): DATA 330 or ISIT 330 with a C or better.

Course Outcomes

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.

Find out when this course is offered