Brains Up AnalyticsBRAINSUPAnalytics

Practical Data Modeling

From concept to a production-ready dimensional model

A no-nonsense guide to modeling data for real: normalization, dimensional modeling (star and snowflake), slowly changing dimensions and the design decisions that separate a reliable warehouse from a maintenance nightmare.

What you get

  • 180 pages with real examples from enterprise projects
  • Ready-to-use dimensional model templates
  • A modeling review checklist
  • Free updates and PT/EN/FR editions

Contents

  1. 1Fundamentals: OLTP vs. OLAP
  2. 2Normalization and when to break it
  3. 3Dimensional modeling: facts and dimensions
  4. 4Slowly Changing Dimensions (Types 1, 2 and 3)
  5. 5Modeling for the Lakehouse (medallion)
  6. 6Anti-patterns and how to avoid them