Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Dimensional Modeling

Bryan Cafferky via YouTube

Start learning Write review
Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More → DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This tutorial introduces the concepts and practice of dimensional modeling using the Kimball Method. It covers data warehouse design, facts and dimensions, star and snowflake schemas, surrogate keys, bus matrices, grain, conformed dimensions, and slowly changing dimensions.

Syllabus

Dimensional Modeling The Heart of the Data Warehouse
Bryan Cafferky
What's Ahead?
Why a Data Warehouse?
When is it Not Appropriate?
Where do you start to design a data warehouse?
Transactional Database Design (OLTP)
What is Dimensional Modeling?
What's a Dimension?
What's a Fact?
The Star Schema
Star Schema-Key Points
The Snowflake Schema The Snowflake Schema
Why Surrogate Keys?
Steps of Dimensional Modeling Review
The Bus Matrix
The Seven W's of Data Warehouse Design - User Story
Seven W's of Data Warehouse Design and the User Story
Slowly Changing Dimensions
Slowly Changing Dimension-Type 3
Some Additional Thoughts...

Taught by

Bryan Cafferky

Reviews

Start your review of Dimensional Modeling

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.