Dimensional Modelling Public Training Course

Join us for our virtual training course Wed 23rd – Thu 24th June, 2021
9:00 am – 5:00 pm AEDT

 

Book Your Spot Now


Interested in more data & analytics training? To find out more about our Data Visualisation Public Training Course click here.

 

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”.

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 Zoom.
• Small Group training, spaces are limited!

Book Your Spot Now

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

Go to event page