Dimensional Data Modelling
Free Intermediate course · 10 lessons · 3 weeks · Certificate on completion
Design star schemas, facts and dimensions that make analytics fast and understandable. Across 10 lessons you'll move from fundamentals to a portfolio-ready outcome — at your own pace, with quizzes after each lesson and a final exam to certify your mastery.
What you'll learn
- Why model data at all
- Kimball vs Inmon
- Facts and grain
- Dimensions and attributes
- Star vs snowflake schemas
- Slowly changing dimensions
Skills you'll pick up
- Why model data at all
- Kimball vs Inmon
- Facts and grain
- Dimensions and attributes
- Star vs snowflake schemas
- Slowly changing dimensions
Tools covered
- Dimensional Modelling
- Real-world projects
- Quizzes
- Final exam
Course modules
Module 1: Why model data at all
Module 1 of Dimensional Data Modelling. 3 lessons · 3h
Module 2: Dimensions and attributes
Module 2 of Dimensional Data Modelling. 3 lessons · 3h
Module 3: Conformed dimensions
Module 3 of Dimensional Data Modelling. 2 lessons · 2h
Module 4: Modelling for BI tools
Module 4 of Dimensional Data Modelling. 2 lessons · 2h
Lessons in this course
- Why model data at all
- Kimball vs Inmon
- Facts and grain
- Dimensions and attributes
- Star vs snowflake schemas
- Slowly changing dimensions
- Conformed dimensions
- Bridge tables
- Modelling for BI tools
- Case: an e-commerce model
Instructor
James Okafor — Data Platform Architect
James Okafor is a Data Platform Architect with years of hands-on experience teaching Dimensional Modelling to thousands of learners worldwide.
Certificate
Finish every lesson and pass the final exam to earn a free, verifiable Learnera certificate for Dimensional Data Modelling. It can be downloaded as a PDF and shared on LinkedIn.
Career outcomes
Median global salary $125,000 per year · median India salary ₹17,50,000 per year · 105,808 open roles worldwide
- Dimensional Modelling Specialist
- Senior Dimensional Modelling Lead
- Dimensional Modelling Consultant
Frequently asked questions
Is the Dimensional Data Modelling course free?
Yes. Every Learnera course, including Dimensional Data Modelling, is completely free — lessons, quizzes, the final exam, and the certificate.
How long does Dimensional Data Modelling take?
10 lessons, typically completed in 3 weeks at a comfortable pace.
Do I get a certificate?
Yes — pass the final exam and you receive a free, verifiable certificate you can share on LinkedIn.