DW 304 – Advanced Dimensional Modeling

Advanced Dimensional Modeling is an in-depth, technical course that teaches the advanced concepts for designing a dimensional Business Intelligence (BI) model for high-performance reporting and analytics solutions such as Business Performance Management (BPM), Customer Analytics, Supply Chain Analytics, etc.

This course will review data warehouse architecture and basic dimensional modeling concepts, but the primary focus will be on advanced dimensional modeling techniques and helping participants learn when to use which techniques. With hands-on workshops, attendees will transform end users’ reporting and analytics requirements into Dimensional Models (using a phased modeling approach) that are understandable to the business and will perform well in the face of unpredictable query patterns.

By learning the best way to design dimensional models for Business Intelligence or Business Performance systems, your designers and analysts will better capture business requirements and relate them to the supporting data structures. Hands-on workshops throughout the course will reinforce the learning experience and provide the attendees with concrete results that can be utilized in their organizations.