Data Modeling (10)

The Three Types of Fact Tables

A concise tour of one of the basic components of Kimball dimensional data modeling. We explore the three types of fact tables, and then analyze why they have lasted the test of time.

How Would An Ideal Semantic Layer Look Like?

A 2020 Reader's Guide to The Data Warehouse Toolkit

Ralph Kimball's classic book The Data Warehouse Toolkit introduce the world to the practice of data modeling. Here's how to read it in 2022.

Applying The Principles of Agile to Data Modeling

In our third and final part on Agile Data Warehouse, we take a look at the origins of the Agile Manifesto, from which Corr and Stagnitto took inspiration.

A Business Process Worth Measuring

The second part of our series on Agile Data Warehouse Design, a 2011 attempt at applying the principles of agile to the practice of data modeling.

First Impressions from Agile Data Warehouse Design

Agile Data Warehouse Design is a 2011 attempt at applying the principles of agile to the practice of data modeling. This is the first post in a series on the ideas from the book.

Slowly Changing Dimensions (SCDs) In The Age of The Cloud Data Warehouse

What a new approach to slowly changing dimensions tell us about the future of dimensional data modeling.

OLAP != OLAP Cube

There's a tendency for people to conflate OLAP with OLAP cube. We take a quick look at how this happens, why it shouldn't, and why it matters if you're a data practitioner.

The Rise and Fall of the OLAP Cube

A definitive history of the rise of the OLAP cube, how it's affected our industry, and what comes after.

Holistics Data Modeling, Explained

Holistics's data modeling layer allows data teams to radically increase their productivity. No repeated queries. Self-serve reports and dashboards. Here's how it works.