Best Sellers in Books
Discover the most popular and best selling products in Books based on sales

Disclosure: I get commissions for purchases made through links in this website
Databases & Big Data - Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema

Description

Book Synopsis: 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. The result is everyone thinks dimensionally from the outset! Developers understand how to efficiently implement dimensional modeling solutions. Business stakeholders feel ownership of the data warehouse they have created, and can already imagine how they will use it to answer their business questions.

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
Read more

Details

Are you tired of the traditional, time-consuming process of data warehousing and dimensional modeling? Look no further! Introducing Agile Data Warehouse Design: Collaborative Dimensional Modeling. This groundbreaking book offers a step-by-step guide to capturing data warehousing and business intelligence (DW/BI) requirements and transforming them into high-performance dimensional models. With our agile approach, you can say goodbye to endless back-and-forth communication between designers and stakeholders. Our modelstorming technique encourages interactive collaboration, resulting in quicker, more inclusive, and more productive data modeling.

With Agile Data Warehouse Design, you'll learn how to tell dimensional data stories using the 7Ws (who, what, when, where, how many, why, and how), enabling you to answer your business questions effortlessly. Emphasizing modeling by example rather than abstraction, we provide you with data story themes that make detail description a breeze. Plus, our visual modeling techniques allow you to sketch timelines, charts, and grids to simplify the modeling of complex process measurements.

Not only does Agile Data Warehouse Design offer innovative modeling approaches, but it also provides solutions to common DW/BI problems. Our design patterns for dimensional models are proven to enhance performance and usability, ensuring that your data warehouse operates seamlessly. With our interactive approach and effective documentation, you and your team will have a clear understanding of how to efficiently implement dimensional modeling solutions.

Don't miss out on this opportunity to optimize your data warehousing and dimensional modeling. Take the first step towards a more agile and collaborative approach to DW/BI development. Get your copy of Agile Data Warehouse Design: Collaborative Dimensional Modeling today!

Click here to learn more.

Disclosure: I get commissions for purchases made through links in this website