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 a dimensional model. A single enterprise typically contains many business areas (e.g. Sales, Manufacturing, Finance) A single business area (e.g. …

Continue reading

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 (and typically more complicated) metrics spanning multiple business processes. Note: there are many additional benefits of conformed dimensions…for a more …

Continue reading