Two-day training on developing powerful and understandable data models that deliver direct value to BI environments. Focus on facts, dimensions and hierarchies as fundamental components.
In the two-day Dimensional Modelling training, you learn how to develop powerful and understandable data models that add direct value to your Business Intelligence environment. You work with facts, dimensions and hierarchies, the building blocks of every successful analytical solution. This standard method is essential for structuring data warehouses and supporting reliable reports and dashboards.
What can you expect?
You get a solid foundation in the principles of dimensional modelling, combined with many practice-oriented exercises. In realistic cases you learn how to translate business questions into an effective data model. You work actively in groups and receive personal feedback from experienced trainers who come from practice themselves.
What will you learn?
After this training you can:
Translate business questions into an effective dimensional model;
Design and structure fact and dimension tables;
Deal with historical data and changing dimensions (SCDs);
Integrate dimensional models within modern data warehouses;
Apply advanced modelling techniques such as snowflaking and Data Vault links;
Apply theory directly in realistic group assignments.
Training setup
The training is practice-oriented and interactive. You learn by doing, through examples, assignments and feedback. We work with recognisable scenarios from different sectors.
Why take part?
Without a good data model, no reliable insights. With dimensional modelling you learn to structure data so that it is understandable, fast and reliable to use in any BI system.
Want to design data models that really work and make direct impact in your organisation?
Sign up today and become a specialist in dimensional modelling.
Programme overview, Dimensional Modelling
Day 1: Fundamentals
Introduction: facts, dimensions and the importance of "grain"
Translating business processes into star schemas
Star schemas and OLAP cubes
Dealing with changing data (SCD Type 1, 2, 3)
Practical group assignments
Day 2, Deepening and Integration
Advanced fact tables (snapshots, factless, aggregations)
Dimensional tables (SCD, junk, snowflaked)
Linking to Data Vault and the data warehouse bus architecture
Group assignments with complex cases
After completing this training, you receive a Professional Development certificate as proof of the knowledge and skills you have gained.
No specific prior knowledge required; basic experience with data analysis, SQL or BI tools is useful but optional.
