Rapid Data Warehouse Design

User-Focused Techniques for Designing Dimensional Data Warehouses

ISBN: 978-0-470-53303-1
Verlag: Wiley

Buch, Englisch, 336 Seiten

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.

Autoren/Hrsg.

Corr, Lawrence

Fachgebiete

• Wirtschaftswissenschaften Betriebswirtschaft Wirtschaftsinformatik, SAP, IT-Management
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Data Warehouse