Ready to Learn More

DATA WAREHOUSING: DESIGN

COURSE DESCRIPTION
What you will learn:

This 18-hour instructor-led course is designed to walk-through into real-world examples in-class exercises the architecture, and various features of data warehouses, dimensional model and data extraction tools. You gain hands-on experience in building a Data Warehouse through a formal process from the conceptual, logical, and physical phases using leading market tools.

COURSE OBJECTIVES

    At the end of this course, you should be able to:
  • Mapping source data to subject area
  • Define the dimensional model and its components
  • Select the data extraction tools
  • Review the standard industry benchmarks
    WHO SHOULD ATTEND?
  • Data Warehouse Administrators
  • DBAs
  • Business Analyst
  • Project Managers
    REQUIRED PREREQUISITES
  • Data Modeling, Data Warehousing Fundamentals
COURSE CONTENTS
    MODULE ONE
  • Data Warehouse Bus Architecture and matrix for integration
  • Dimensional Modeling characteristics
  • Fact table types
  • Hierarchies and snowflaking
    MODULE TWO
  • Mapping Source-Target Data
  • Slowly changing dimensions
  • Conformed dimensions
  • Modeling the Calendar
    MODULE THREE
  • Develop an ETL high-level map
  • ETL workflow
  • Data Warehouse Optimization
  • Refreshing Warehouse Data
Note:

Enrollment is limited to 20 attendees.

The program course contents are delivered either only evening time or at the weekends or in combination of both.