[ Login ]

Classes

ISIT 336 Dimensional Modeling • 5 Cr.

Description:

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.

Outcomes:

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
v3.4.2.0

Footer Navigation

Contact info

Bellevue College
3000 Landerholm Circle SE Bellevue, WA 98007-6484 U.S.A.
Work: (425) 564-1000