Dimensional Modelling Public Training Course

Join us for our virtual training course Tue 16th – Wed 17th March, 2021
9:00 am – 5:00 pm AEDT

 

Book Your Spot Now

 

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.

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.

 

Course Content

• Dimensions
• Facts
• Granularity
• Star Schema
• Subject Areas
• Surrogate Keys
• Conformed Dimensions
• Bus Matrix
• Snowflake Schema
• 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
• 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.

Dimensional Modelling Training

 

Who Should Attend?

This class is designed for data warehouse architects, data modelers, 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 modeling.

 

Pricing & Logistics

• $800/day per person ex GST.
• Training delivered remotely via Microsoft Teams.
• Capped at 40 attendees.

Book Your Spot Now

If you have any issues purchasing tickets above, you can click below to be taken direct to our event page:

Go to event page