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.