Attendees of this one-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?

Dimensional Modelling is an approach to make it easier and faster to store, read, summarize and analyse information in a data warehouse. The concept of Dimensional Modelling was developed by Ralph Kimball and made famous in the book ‘The Data Warehouse Toolkit' (Kimball/Ross, 2013) that established a whole new vocabulary including “facts” and “dimensions”.

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

• Course runs 9am - 5pm AEST
• $900 per person ex GST.
• Training delivered remotely.
• Capped to small numbers to allow for interactive workshops

Interested in Data Visualisation Training? Check out our Data Visualisation public training course here.

Visit our website to find out more.