Jim Stagnitto | Akateeminen Kirjakauppa

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.