This is a presentation on how to design an analytical database. It’s primarily about how to divide data into facts and dimensions then organize them into a star schema.
It’s one of my favorite presentations to do for the B.I. crowd because there is not always a clear set rules that let you know if a particular data element is a fact or dimension. On the surface, it’s usually obvious. The interesting part is when the discussion turns to concepts that many folks, even experienced ones, hadn’t considered.
Here’s a PDF version of the presentation.