Dimensional Modeling

Fact tables, dimensions, star schemas, SCDs and conformed dimensions.

8 concepts4 labs1 projects2 challenges

0% complete

Keep going!

Concepts

Start learning

Work through the concepts in order, or jump to what you need.

Dimensional Modeling Overview

Concept · Hands-on lab included

Fact Tables

Concept · Hands-on lab included

Dimension Tables

Concept · Hands-on lab included

Star Schemas

Concept · Hands-on lab included

Slowly Changing Dimensions (SCD)

Concept · Hands-on lab included

Conformed Dimensions

Concept · Hands-on lab included

Advanced Fact Patterns

Concept · Hands-on lab included

Kimball vs Inmon

Concept · Hands-on lab included

Practice

Hands-on labs

Apply what you've learned in guided, production-style environments.

Browse all labs

Build Your First Star Schema

40 min · intermediate · Dimensional Modeling Overview

Classify Measures and Fix a Broken Balance Report

35 min · intermediate · Fact Tables

Model, Break and Repair a Star

40 min · advanced · Star Schemas

Implement SCD Type 2 in SQL

45 min · advanced · Slowly Changing Dimensions (SCD)

Build

Projects

Ship real projects and grow a portfolio that gets you interviews.

Browse all projects

intermediate

Northwind Dimensional Warehouse

A star-schema mart for orders, products and regional sales

14 hrs

Continue

Next modules

Keep your learning streak going with related modules.

BI Fundamentals

What BI is, the BI stack, and the analyst-to-executive reporting chain.

Business Metrics

KPIs, metric definitions and the business context behind dashboards.

SQL

The SQL BI professionals need — ETL views, joins and time-series queries.