Dimensional Modelling
(DEDM-100)
Course overview
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 a solid foundation in dimensional modelling that they can apply directly to their workplace projects.
Dimensional Modelling is an approach to make it easier and faster to store, read, summarise, 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) which established a whole new vocabulary including “facts” and “dimensions”.
Learning outcomes
By the end of this course, participants will be able to:
Intended audience
The intended audience for this course is data analysts, database developers, data warehouse architects, business intelligence professionals, or anyone who is involved in designing, implementing, or managing a data warehouse. This training is suitable for both beginners who are new to dimensional modelling as well as experienced professionals who want to refine their skills and learn best practices.
Delivery
This course is offered as a public course suitable for individuals and small groups as well as privately for groups of around 10–12 participants. Private courses are delivered either onsite or remotely by our experienced consultants and can be tailored to meet your organisation’s specific needs.
Download the full agenda.
Upcoming public training
For a selection of our most popular courses, we offer public training sessions - perfect for individuals or small teams who don’t have enough participants for a private course.
There is no upcoming public training for this course.
Highly recommend!
"Julia conducted the Data Visualisation session at the highest professional level. I broadened my knowledge a lot during the training. Highly recommend!"
Marat Tolgambayev
Data Engineer, BUPA
Kept us interactive
"The training was just the right level of content, kept us interactive and didn't feel overwhelming. Looking forward to intermediate course. Thank you."
Gemma Hicks
Hunter Water
Thorough and well-presented
"The training provided by Altis was really thorough and well-presented. I was able to follow along and the instructor, Julia, was approachable and helpful. I highly recommend the training courses!"
Neha Morparia
Snr Student Admissions Officer, Macquarie University