More dates

Dimensional Modelling Public Training with Altis Consulting - June 2024

Price $1800 AUD + BF + GST Get tickets

Event description

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

β€’ Course runs 9am - 5pm AEST
β€’ $900 per person ex GST.
β€’ Training delivered remotelyΒ via Zoom.
β€’ Capped to small numbers to allow for interactive workshops.

Visit our website to find out more.

Powered by

Tickets for good, not greed Humanitix donates 100% of profits from booking fees to charity

Refund policy

No refunds