[ Login ]

Classes

BUSIT 202 Dimensional Modeling • 5 Cr.

Description:

Dimensional modeling has been broadly accepted as the principle technique 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: BUSIT 105 with a C- or better.

Details:

Prerequisite: BUSIT 105 with a C- or better; class uses SQL Server 2008 and Analysis Services.

Outcomes:

After completing this class, students should be able to:

  • Describe the goals of a data warehouse
  • Describe the components of a data warehouse
  • Explain the importance of dimensional modeling for a data warehouse
  • Design Fact and Dimension tables
  • Using a series of Case Studies, identify the probable set of dimensional modeling problems that occur in organizations
  • Develop design principles based on the problems identified in the case studies
  • Apply design principles to new situations

Offered:

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