Dimensional Modelling Foundations

Attendees of this one-day Dimensional Modelling Foundations course will learn the tried and tested Kimball techniques for designing robust dimensional models to support enterprise decision-making.

Please review the Course Outline below to ensure this Dimensional Modelling course is right for you. Please contact us if you’re not sure and we’ll be happy to advise you.

What is Dimensional Modelling and why do we do it?

• Dimensional Modelling foundations:
  • Dimensions
  • Facts
  • Granularity
  • Business Processes
  • Star Schemas
  • Surrogate Keys
  • Conformed Dimensions
  • Bus Matrix
  • Snowflake Schema
• Kimball’s 4 Steps to Dimensional Modelling
• Retail Sales Case Study
  • Walkthrough the business requirementsas 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.
• Slowly Changing Dimension fundamentals (Types 0, 1, 2, 3)
• Introduction to advanced Dimensional Modelling topics

Please review the Course Prerequisites below to ensure this Dimensional Modelling course is right for you. Please contact us if you’re not sure and we’ll be happy to advise you.

• Have a basic understanding of database design principles such as tables and how they are joined.
• This course is appropriate for anyone involved in the dimensional modelling process.

Private training

• Please contact your local regional office for pricing for private training.
• Private training is delivered remotely or at your offices.
• Training delivered remotely via online delivery or at your offices.
• 1-day course that can also be delivered as 2 x consecutive half-days.
• Capped at 15 attendees to ensure maximum personal attention.
• Training can be customised to suit your needs.
• We can also provide follow-on consulting to help students develop their first best-practice dimensional models. This can be an effective way to help students successfully transition from the classroom to the real world.

Public training (schedule at bottom of page)

• £400 per person ex. VAT.
• 20% discount when you book 3 or more people on the same course.
• 20% discount when an individual enrols in 3 or more courses.

• “All the examples were great, helped to refine the theory. I also enjoyed that the examples remained consistent throughout the course.”
• “Excellent for students new to Dimensional Modelling. Very interactive with hands on exercises.”
• “Really well explained examples, workshops so you could put everything into practice.”
• “There were lots of examples, which really helped my understanding.”
• “Really thorough explanations and good exercises to work through.”
• “I really enjoyed it and am hoping I’ve got a lot to take back and apply to my work. Thanks so much.”
• “Pace of the course and course content was excellent. some valuable skills and knowledge picked up.”
• “The exercises were really great in helping establish the learning.”
• “Well chuncked up into learning new concepts and practical exercises to solidify our understanding. It was really good to work in small groups and talk through our ideas and understanding.”
• “The course itself was brilliant, and really helpful.”

We recommend all students attend Data Visualisation Best Practices. It’s one thing to know how to build a Power BI report, but it’s another to know which chart types to use for different data scenarios, how to make it look good, and most importantly, how to make it easy for people to consume the information. This course will teach you how to design attractive reports that best convey the intended story to your audience.