Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema (Anglais) Broché – 24 novembre 2011
|Neuf à partir de||Occasion à partir de|
- Choisissez parmi 17 000 points de collecte en France
- Les membres du programme Amazon Premium bénéficient de livraison gratuites illimitées
- Trouvez votre point de collecte et ajoutez-le à votre carnet d’adresses
- Sélectionnez cette adresse lors de votre commande
Les clients ayant acheté cet article ont également acheté
Descriptions du produit
Biographie de l'auteur
Lawrence Corr is a data warehouse designer and educator. As Principal of DecisionOne Consulting, he helps clients to review and simplify their data warehouse designs, and advises vendors on visual data modeling techniques. He regularly teaches agile dimensional modeling courses worldwide and has taught dimensional DW/BI skills to thousands of students.
Jim Stagnitto is a data warehouse and master data management architect specializing in the healthcare, financial services, and information service industries. He is the founder of the data warehousing and data mining consulting firm Llumino.
Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.
Pour obtenir l'appli gratuite, saisissez votre numéro de téléphone mobile.
Détails sur le produit
Quels sont les autres articles que les clients achètent après avoir regardé cet article?
Commentaires en ligne
Commentaires client les plus utiles sur Amazon.com (beta)
Lawrence and Jim show how dimensional design is tailor made for agile software development, with its emphasis on business value and on getting to results. But don't skip this book just because you think agile is not for you. If you make use of dimensional models, you can make use of their methods.
A solid contribution, both to the world of agile software development, and to the cannon of dimensional modeling. If you've enjoyed any of my books, I am sure you will enjoy this one as well.
Why are these my "Big Three" BI/DW authors, and why does Lawrence Corr deserve to join the list? The numerous Kimball Group books and the three Adamson books all provide a useful blend of theoretical and practical information and techniques to guide the DW/BI professional in creating systems that are affordable, maintainable, accurate, and useful to clients. In his new book, Corr fills in a critical missing component: how to effectively engage business and technical personnel in a dialogue to perform agile design where the emphasis is on content, understandability, rigor, and usefulness, instead of on producing reams of documentation. In short, this book is about agile dimensional design including "why" and the all-important "how to" with supporting templates.
Though many of the book's topics are previously addressed by other authors, Corr expands upon these and presents a large set of fresh ideas and techniques that are robust and adaptable, while incorporating the concepts of the Agile Manifesto. He provides an emphasis on collaboration and flexibility, not just on theoretic agility, while adapting a method called BEAM* (Business Event Analysis & Modeling) for dimensional design.
BEAM* is an agile modeling method that lends itself to rapid, collaborative dimensional design sessions with business and technical participants. BEAM* utilizes a set of diagram types that, taken together, provide a complete design that is understandable by business people and is immediately useful for implementation people. The diagram types are:
1. Example Data Table (or BEAM* Table) - Primary diagram type used to capture data stories and describe data requirements through sample data. Supports modeling by example rather than by abstraction, making them useful to all participants in the design activities. Uses sets of short codes to capture and indicate design details.
2. Hierarchy Chart - Shows hierarchical relationships among related entities within a dimension. This is a much cleaner and more concise version of the traditional dimensional hierarchy chart.
3. Timeline - Concisely captures sequences and durations as an aid to understanding and design.
4. Event Matrix - A fresh twist on the classic fact/dimension matrix, with better organization, which provides an accessible overview of multiple star data mart and data warehouse designs.
5. Enhanced Star Schema - Traditional star schema diagrams augmented with BEAM* codes to indicate dimensional design aspects that are not supported by traditional modeling tools.
These "tools" facilitate design discussions, detailed design work, communication, implementation, and provide concise yet through documentation.
In addition to the methodology and diagram types, extensive coverage of the design process and the designs themselves are covered. All of the dimensional modeling basics receive thorough treatment and many of the more challenging dimensional modeling problems receive substantial coverage with mature techniques and solutions drawn from Corr and Stagnitto's extensive consulting work. Examples include several types of hierarchies and hierarchy maps, multiple calendars, time (clock time), and the always exciting Customer and Employee dimensions, among many other design challenges.
Agile Data Warehouse Design is an eminently useful book and a long-needed complement to the dimensional modeling literature.
Don't forget to also register at the author's website for very useful tools and templates.