Dimensional Modeling - A Whirlwind Tour of How and Why
This talk is an extract from a 2 Day Workshop on Dimensional Modeling and will include:
INTRODUCTORY TOPICS
The place for dimensional models
Where they fit in an enterprise reporting architecture and why
Overview of dimensional modeling
Major approaches
Terminology & key concepts
A complete framework for dimensional modeling including:
The two Guiding Principles - knowing these will guide almost every design decision
Five Basics for Information Presentation
Foundations for (ABCs of) Success
A quick Case Study to illustrate the basics
INTERMEDIATE TOPICS
Reality meets Theory
When to break the rules and why
The ubiquitous DATE Dimension
An exercise in Time Travel
To surrogate or not to surrogate, or is that the question?
Going global - handling international concerns
A few exercises in time & $$
ASSORTED BONUS TOPICS & TIPS
Motivation for Good Content
Guidelines for partitioning and Indexing
Techniques for handling drill-down to detailed data
