Data Solutions That Make Businesses Better
// Training
Bare Bones Data Modelling
Dimensional modelling in a day.
Why Care About Dimensional Modelling Training?
Data teams can build pipelines. They can wrangle data. They can even deploy the latest lakehouse architecture. But when it comes to actually delivering analytics that stakeholders understand and trust? That's where things fall apart.
Dimensional modelling isn't sexy. It's not the latest framework getting hyped on LinkedIn. But it's the difference between a data platform that serves reports and one that actually serves a business.
The Cost Of Not Modelling Analytics Data Effectively
When a team doesn't understand dimensional modelling, it shows up everywhere:
- Analysts writing increasingly complex SQL to answer basic business questions.
- Data models that duplicate the same concepts and data in multiple places.
- Business users who've given up on self-service because they can't figure out which table to use.
- And that all-singing, all-dancing AI chatbot doesn't stand a chance of figuring the data out either.
What Training Actually Does
Good dimensional modelling training gives a team:
A Shared Language
Facts, dimensions, grains and hierarchies aren't abstract concepts - they're practical tools for talking about data structures.
Design Patterns That Work
Star schemas, slowly changing dimensions, bridge tables. Battle-tested approaches that prevent reinventing the wheel (badly).
The "Why" Behind The "What"
Understanding user requirements means a team builds with purpose, not just by following recipes.
It's about giving a team foundational knowledge they can apply whether they're building in Fabric, Databricks, Snowflake, BigQuery, or whatever comes next.
The Outcome
Teams that understand dimensional modelling deliver analytics faster, with fewer rework cycles, and build trust with stakeholders because the data makes sense to the people (and tools) using it.
That's it. No grand promises. Just pragmatic skills that pay off every day.
What Does The Course Cover?
Six modules, covering everything from first principles to advanced patterns:
Dimensional Modelling Introduction
- Dimensional model history
- Database fundamentals
- Why dimensional model?
- What is a dimensional model?
Dimensional Modelling 101
- Fact table basics
- Types of dimension table - type 0 to 7 SCDs
- Surrogate keys
- Relational integrity
Advanced Dimensional Modelling Patterns
- Timespan accumulating snapshot fact tables
- Factless fact tables
- Centipede fact tables
- Junk dimensions
- Degenerate dimensions
- Role-playing dimensions
- Bridge tables
Product Thinking In Data Modelling
- Why product thinking matters
Gathering Requirements For A Star Schema
- Requirements gathering framework overview
- Event storming
- Sun modelling
Implementation Considerations
- Design decisions for delivery
- Data structures, naming conventions, surrogate key strategies, loading patterns
The Damage
How much will this training actually cost?
£449/ person / day
Excluding VAT
- Minimum 5 people (or a minimum fee of £2,245)
- Maximum 10 people - training works best with a targeted group, not a packed classroom
Delivered face to face wherever possible - attendees are more attentive and better able to interact with the instructor and each other. Pricing excludes travel expenses, venue hire and catering. Online delivery can be arranged on request. Not got a team of 5 to bring? Join the waitlist instead.
Just You, Not A Team Of Five?
This course runs for groups of 5-10. Join the waitlist and Johnny will get in touch once there's enough interest to run a session open to individuals.
Want A Team Booked In?
Share a few details below and Johnny will get back to you directly.
Ready To Get Your Team Booked In?
Team training gets everyone speaking the same language on day one.