Agile Data Warehouse Design eBook

Lawrence Corr
18 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

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

  • Size
    77.8 MB
  • Length
    314 pages
  • You'll get an eBook (Tablet-Friendly, DRM-free PDF).
  • Size77.8 MB
  • Length314 pages


(18 ratings)
5 stars
4 stars
3 stars
2 stars
1 star
Powered by


Agile Data Warehouse Design eBook

Enter your info to complete your purchase


You'll be charged US$25.98.