O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Dimensional Data Modeling

Video Description

Learn all about dimensional data modeling and how to build this powerful data model for analytics. We cover how dimensional differs from relational and explain each of the dimensional modeling components such as meters, dimensions, measures, and hierarchies. We also explore more advanced dimensional modeling components such as behavioral dimensions, factless facts, and conformed dimensions. Learn about the three types of measures: Transaction, Snapshot, and Accumulating. Understand the differences in modeling and data warehouse architecture approaches from the legends, Bill Inmon and Ralph Kimball. Practice several dimensional modeling exercises to reinforce the material in this video. This video was recorded live during Steve Hoberman’s Data Modeling Master Class. More on this 3-day data modeling course at stevehoberman.com.

Table of Contents

  1. Dimensional Data Modeling 1:22:49