Data Warehouse (OLAP) Design Techniques

Student financing options are available.

Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.

Looking for group training? Contact Us
SKU: 9 Category:

Download PDF of Course Details

Course Description

Students will learn basic concepts, such as the purpose of Data Warehouses and how it is different from an OLTP database. The course will provide a thorough understanding of data warehousing concepts such as different types of dimensions, facts, and methodologies to design Data Warehouses or Data Marts. Student will be able to design DWHs using schemas such as STAR, SNOW FLAKE, and GALAXY. Students will be able to design multiple Slowly Changing, Degenerate, and Inferred Dimensions. In the concluding section, student will learn about ETL processes and options available to handle multiple data loads.

Learning Objectives

  • Develop and implement data warehouse designs
  • Perform requirements gathering
  • Analyze requirements
  • Identify star, snowflake, and galaxy schema
  • Manage dimensions and facts






Shopping Cart