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.
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
Data Modeling, Data Warehousing Fundamentals
Data Warehouse Bus Architecture and matrix for integration
Dimensional Modeling characteristics
Fact table types
Hierarchies and snowflaking
Mapping Source-Target Data
Slowly changing dimensions
Modeling the Calendar
Develop an ETL high-level map
Data Warehouse Optimization
Refreshing Warehouse Data
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.