Rapid Data Warehouse Design: User-Focused Techniques for Designing Dimensional Data Warehouses

by Lawrence Corr, Jim Stagnitto

An exciting new approach to dimensional data warehouse design, invented by the author

This how-to guide shows you how a revolutionary new approach to dimensional modeling invented by the author can be used throughout the data warehouse analysis and design phases to improve communication between IT and business users-and consequently-produce better results.

Featuring proven techniques devised by the author, this book introduces Business Event Analysis and Modeling (BEAM), a powerful, yet simple, technique for modeling directly with business users. You'll learn how to run facilitated BEAM sessions with users to create consensus on data definitions and a sense of business ownership of the data warehouse design. Demonstrates how to use Business Event Analysis and Modeling (BEAM) to readily capture the 5W1H combinations that represent the unique business events of any organization Presents common reusable modeling techniques for handling the complexities of people and groups (the "who"), products and services (the "what"), geography (the "where") for each dimension type Offers extensive, detailed examples for translating each BEAM model into a dimensional (star schema) model The companion website will include all sample models, document templates, and SQL code examples

These proven techniques will help you accomplish your end goal: ensuring that the data warehouse design meet the real needs of users.

336 pages, Paperback

First published December 3, 2010