Attendees of this two-day course will learn the tried and tested Kimball techniques for designing robust dimensional models to support enterprise decision making. Students will gain an in-depth understanding of dimensional modelling that they can apply directly to their workplace projects.

What is Dimensional Modelling?

Excellence in dimensional modelling remains the keystone of a well-designed data warehouse/business intelligence system, regardless of your architecture.

The word “Kimball” is synonymous with dimensional modelling. The Data Warehouse Toolkit (Kimball/Ross, 2013) established an extensive portfolio of dimensional techniques and vocabulary, including conformed dimensions, slowly changing dimensions, junk dimensions, mini-dimensions, bridge tables, periodic and accumulating snapshot fact tables, and the list goes on.

Course Outline

What Is Dimensional Modelling And Why Do We Do It?
Dimensional Modelling Introduction
- Dimensions
- Facts
- Granularity
- Star Schema
- Subject Areas
- Surrogate Keys
- Conformed Dimensions
- Bus Matrix
- Snowflake Schema
Kimball’s 4 Steps To Dimensional Modelling
Dimensional Modelling Advanced
- Types of Fact Tables: Transactional, Accumulating Snapshot, Periodic Snapshot, Factless
- Bridge Tables
- Types of Dimensions: Slowly Changing Dimensions Types 0, 1, 2, 3, 4, 5, 6, 7), Date Dimensions, Time Dimension, Degenerate Dimension, Junk Dimension, Role Playing Dimension, Outrigger Dimension, Mini Dimension
- Supertype and Subtype Schemas
Case Study Review
- Walkthrough the business requirements as a team.
- Work in small teams to develop dimensional model(s) to satisfy the business requirements.
- Come together to critique the dimensional models as a team.

Who Should Attend?

This class is designed for data warehouse architects, data modellers, database administrators, business analysts, and ETL or BI application developers and designers. It’s appropriate for anyone interested in A-to-Z coverage of dimensional modelling.

Pricing & Logistics

• $900/day per person ex GST.
• Training delivered remotely via Zoom.
• Capped at 40 attendees.

Visit our website to find out more.