Free Book Online
Book Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema


Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema

4.2 (2864)

Log in to rate this item

    Available in PDF - DJVU Format | Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema.pdf | Language: ENGLISH
    Jim Stagnitto(Author)

    Book details

Agile DataWarehouse Design is a step-by-step guide for capturing datawarehousing/business intelligence (DW/BI) requirements and turning theminto high performance dimensional models in the most direct way: bymodelstorming (data modeling + brainstorming) with BI stakeholders.

This book describes BEAM✲, an agile approach to dimensionalmodeling, for improving communication between data warehouse designers,BI stakeholders and the whole DW/BI development team. BEAM✲ providestools and techniques that will encourage DW/BI designers and developersto move away from their keyboards and entity relationship based toolsand model interactively with their colleagues. The result is everyonethinks dimensionally from the outset! Developers understand how toefficiently implement dimensional modeling solutions. Businessstakeholders feel ownership of the data warehouse they have created, andcan already imagine how they will use it to answer their businessquestions. 
Within this 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 patterns

4.2 (12279)
  • Pdf

*An electronic version of a printed book that can be read on a computer or handheld device designed specifically for this purpose.

Formats for this Ebook

Required Software Any PDF Reader, Apple Preview
Supported Devices Windows PC/PocketPC, Mac OS, Linux OS, Apple iPhone/iPod Touch.
# of Devices Unlimited
Flowing Text / Pages Pages
Printable? Yes

Book details

  • PDF | 328 pages
  • Jim Stagnitto(Author)
  • DecisionOne Press (24 Nov. 2011)
  • English
  • 5
  • Computing & Internet

Read online or download a free book: Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema


Review Text

  • By vanessa van gelder on 23 November 2013

    As someone who has been working in BI for quite a while, i have really enjoyed this take on collecting dw requirements in an agile way, the author is certainly knowledgeable on the topics, and this has given me a structured method to collect requirements. anyone who has been working in BI for a long time can attest to the fact that working in an agile way is vital to delivering a bi project that actually adds value to a business, waterfall is not something that works well with BI

  • By SwanieBoy on 12 May 2015

    This is the book we've been waiting for in the world of Data Warehousing and Multi Dimensional design. It genuinely tackles Agile for Data Warehousing and does it very well. The secret really is to have iterative collaboration across the board from all interested parties and there are templates and modeling canvases to remind you who should be involved and why. It's a natural and great extension to the wonderful work of Ralph Kimball and augments RB's work and more. I've really enjoyed the very clear notation practice it proposes and it seems to work very well thus far in my practical implementation of the proposed designs. Having been in the DW BI game for 30+ years Ralph's (and colleagues) and now this book makes the job both easier and enjoyable as you are presented with well proven and clear design methodologies. I have personally found it a sheer joy to read with its numerous real life examples and challenges, and better still put into immediate use on a very large scale Data Warehouse project for the Retail industry although it'll fit any industry vertical. Extremely well done Lawrence and Jim.

  • By Tom Breur on 24 June 2012

    Corr and Stagnitto have delivered a masterpiece. It's chockfull of dimensional modeling best practices from people who have been there in the trenches, solving the most challenging data modeling problems.A "model" should make reality look more simple. This holds for data models, or any other model, for that matter. But what does an Entity Relation model typically do? It alienates business people, the stakeholders you need so desperately for a business intelligence project to succeed.The power of Corr & Stagnitto's BEAM methodology is twofold. First of all, it revolves around language and interactions that business people can relate to: stories and examples. This makes BEAM a truly Agile data modeling approach. And besides enabling a genuinely collaborative and data-driven approach, the output of "Modelstorming" (a pun on brainstorming) is concise, efficient, and can be then be translated to working SQL code with no additional effort. Lean and mean. To this end, Corr has developed a "Modelstormer" Excel template that he has made freely available. By executing the code, you can quickly perform data validation checks on the modeling suggestions from your business partners. It doesn't get any better, or more Agile!Besides the BEAM methodology, the book goes into considerable detail on how to deal with some particularly tricky dimensional modeling challenges. Ragged hierarchies, recursive relationships, hybrid SCD's, and several design patterns that are notoriously difficult and interesting to optimize, form the last chapters of the book.This book should be mandatory reading for any serious (dimensional) data modeler and information analyst in the BI space!

  • By Chloe on 3 February 2013

    I love Business Intelligence and data warehousing, in fact you could say my career is my 'hobby'. There are very few books I have read on the topic in recent years that have excited me as much as this one! It confirms what I always suspected - data warehousing CAN be done in an agile way!The BEAM* approach as laid out in this book is so 'accessible' and practical to EVERYone who may be involved in a data warehousing project, from business users, to business analysts, project managers and even the most hardened techy developers. It creates a new 'easy language' for communication between these different contributors to the project/solution. The method is inclusive and collaborative, as well as thorough and logical, yet so simple and practical, and can be adapted to any complexity with ease i.e. agile.The book it's self is nicely laid out, with plenty of real examples to demonstrate the concepts. Even concepts I was familiar with before, are explained very well and a great intro for anyone not familiar with or a bit daunted by data warehousing.I recommended this book to my colleagues (PM's, BA's, developers, architects) and since going on the course with Lawrence they haven't stopped talking about the methods and can't wait to unleash their new found skills on the next analaysis meetings we are having with the business.I personally think the approach is 'revolutionary' in it's simple elegance and real life usefulness, and will be recommending this book with all my BI passion to anyone remotely attached to any data warehouse project!

  • Name:
    The message text*: