Data Warehouse (OLAP) Design Techniques

Start Date: January 01, 1970 – 12:00 AM (Pacific Time)

End Date: January 01, 1970 – 12:00 AM (Pacific Time)


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

Hours

25