Agile Data Warehouse Design eBook

19 ratings

Collaborative Dimensional Modeling, from Whiteboard to Star Schema

Agile Data Warehouse Design is a step-by-step guide for capturing data warehousing /business intelligence (DW/BI) requirements and turning them into high performance dimensional models in the most direct way: by modelstorming (data modeling + brainstorming) with BI stakeholders.

The book describes BEAM✲, an agile approach to dimensional modeling, for improving communication between data warehouse designers, BI stakeholders and the whole DW/BI development team. BEAM✲ provides tools and techniques that will encourage DW/BI designers and developers to move away from their keyboards and entity relationship based tools and model interactively with their colleagues.

Within the book, you will learn:

  • Agile dimensional modeling using Business Event Analysis & Modeling (BEAM✲)
  • Modelstorming: data modeling that is quicker, more inclusive, more productive and more fun!
  • Telling dimensional data stories using the 7Ws (who, what, when, where, how many, why and how)
  • Modeling by example not abstraction; using data story themes, not crow's feet, to describe detail
  • Storyboarding the data warehouse to discover conformed dimensions and plan iterative development
  • Visual modeling: sketching timelines, charts and grids to model complex process measurement simply
  • Agile design documentation: enhancing star schemas with BEAM✲ dimensional shorthand notation
  • Solving difficult DW/BI performance and usability problems with proven dimensional design patterns

For more information including a downloadable eBook sampler and BEAM templates visit


You'll get an eBook (Tablet-Friendly, DRM-free PDF).

77.8 MB
314 pages
Copy product URL


(19 ratings)
5 stars
4 stars
3 stars
2 stars
1 star

Agile Data Warehouse Design eBook

19 ratings