This accelerated class will go beyond the fundamental questions and tackle some of the most commonly asked questions and addresses the most common mistakes that people make. This course is based on real world experience in dealing with large data volumes and very complex models. The goal of this course is to equip you with the tool and knowledge to address your complex modeling challenges and to meet your demanding business needs.
All data modelers and database administrators who have been developing or supporting data warehouses should attend this course. This course is intended to expand their knowledge of modeling techniques beyond the basic concepts. This course is also appropriate for other team members including project manager, staging system developers and end user application designers, including BI developers and data scientists.
Setting The Stage
Handling Dimension Challenges
Designing for Special Types of Facts
Gathering Business Requirements
Fact Table Design Challenges
Advanced Dimension Table Challenges
Advanced Fact Table Challenges
Design Approach For Complex Data Marts
Real World Dimensional Modeling
Aggregation
Join our public courses in our Canada facilities. Private class trainings will be organized at the location of your preference, according to your schedule.