Collaborative Dimensional Modeling, from Whiteboard to Star SchemaAgile 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 frankly 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 patternsFor more information including a downloadable preview and BEAM✲ templates visit modelstorming.com (launching soon)
You'll need an account to access this in our app. Please create a password to continue.
Download from the App Store or text yourself a link to the app
Thank you for buying our book. We hope to update it soon to add more hyperlinks and some colour! We'll let you know when this free update becomes available.