One of the more interesting types of fact tables is the factless fact table for conditions – also known as Coverage Fact table by Kimball purists. I was recently reminded of this type of fact … Continue reading A Closer Look at the Coverage Fact Table
Types of Fact Tables
In a presentation I’ve been delivering lately, Bus Matrix – the Foundation of your Dimensional Data Model, I briefly cover the hierarchy of an enterprise and how it can be conceptually broken down and mapped into … Continue reading Types of Fact Tables
Conformed Dimensions: the Key to Cross Process Analysis
Over the past few months, I’ve been spending a lot of time reading about, thinking about, and working on conformed dimensions for a client. The reason is simple, conformed dimensions enable businesses to track richer … Continue reading Conformed Dimensions: the Key to Cross Process Analysis
Dimensional Modeling: Junk vs Degenerate
Two commonly misunderstood dimensional modeling techniques are Junk Dimensions and Degenerate Dimensions. This post is aimed at clearing up the confusion and providing some context and use-cases for each. Junk Dimensions There are certain scenarios … Continue reading Dimensional Modeling: Junk vs Degenerate