Agile Data Warehousing for the Enterprise: A Guide for Solution Architects and Project Leaders

by Ralph Hughes

Overview

Building upon his earlier book that detailed agile data warehousing programming techniques for the Scrum master, Ralph's latest work illustrates the agile interpretations of the remaining software engineering disciplines:

• Requirements management benefits from streamlined templates that not only define projects quickly, but ensure nothing essential is overlooked.
• Data engineering receives two new "hyper modeling" techniques, yielding data warehouses that can be easily adapted when requirements change without having to invest in ruinously expensive data-conversion programs. 
• Quality assurance advances with not only a stereoscopic top-down and bottom-up planning method, but also the incorporation of the latest in automated test engines. 

Use this step-by-step guide to deepen your own application development skills through self-study, show your teammates the world's fastest and most reliable techniques for creating business intelligence systems, or ensure that the IT department working for you is building your next decision support system the right way.

Product Details

ISBN-13:	9780123964649
Publisher:	Elsevier Science
Publication date:	10/08/2015
Pages:	562
Product dimensions:	8.50(w) x 10.80(h) x 1.10(d)

About the Author

Ralph Hughes, former DW/BI practice manager for a leading global systems integrator, has led numerous BI programs and projects for Fortune 500 companies in aerospace, government, telecom, and pharmaceuticals. A certified Scrum Master and a PMI Project Management Professional, he began developing an agile method for data warehouse 15 years ago, and was the first to publish books on the iterative solutions for business intelligence projects. He is a veteran trainer with the world's leading data warehouse institute and has instructed or coached over 1,000 BI professionals worldwide in the discipline of incremental delivery of large data management systems.

A frequent keynote speaker at business intelligence and data management events, he serves as a judge on emerging technologies award panels and program advisory committees of advanced technology conferences. He holds BA and MA degrees from Stanford University where he studied computer modeling and econometric forecasting. A co-inventor of Zuzena, the automated testing engine for data warehouses, he serves as Chief Systems Architect for Ceregenics and consults on agile projects internationally.

Table of Contents

1. Solving Enterprise DataWarehousing’s “Fundamental Problem”

Part I Summaries of Generic Agile Development MethodsPart II Review of Fast EDW Coding and Risk MitigationPart III Agile EDW Requirements ManagementPart IV Agile EDW Data EngineeringPart V Agile EDW Quality Management PlanningPart VI Integrating the Pieces of the Agile EDW Method

What People are Saying About This

From the Publisher

Coordinate agile data mart projects into an enterprise data warehouse with a strategic plan using the frameworks provided by Agile Data Warehousing expert Ralph Hughes

Editorial Reviews

"Agile Data Warehousing, as outlined in Ralph’s multiple books, has transformed the way our BI team manages projects. In just two years, we are delivering releases in iterations three times more frequently on five times the number of concurrent projects, while improving application quality and the enterprise nature of our solutions." —Mark Giesbrecht, Senior Manager, Business Intelligence, major Canadian railroad

"Agile Data Warehouse for the Enterprise is a must read for any data professional tasked with delivering enterprise reporting and analytics in the nimble, speed-to-value environment that we find ourselves today. It marries agile methodology with data warehousing best practices to create a blueprint to deliver value fast." —Nik Green, Director of Business Intelligence for multi-billion dollar food retailer

"This comprehensive guide provides a solid and complete foundation for agile EDW development including revolutionary new paradigms. I especially like the ‘out of the box’ thinking, practicality of the techniques, and the research and case studies backing up the validity of the proposed approaches. Recommend reading for all DW/BI technical leaders." —Len Silverston, CEO of Universal Data Models and author of the Data Model Resource Book series

"If you’re still programming data warehouses by hand, you're wasting 90 percent of your time and money. Ralph’s guide for project leaders not only outlines the automated, metadata-driven development we've been practicing for years in the Netherlands, but also links that practice to agile requirements, coding, and quality assurance. It is a unique book, a must read." —Ronald Damhof, DW/BI Consultant to the Dutch Central Bank

"The industry has struggled to bring the mechanics and benefits of Agile to the data warehousing and business intelligence communities. Ralph’s works in this area is timely and important to assist in driving success within your enterprise and project teams. Following the guidance found in this book will help you deliver value at a rapid pace." —Tom Hammergren, President of Balanced Insight and author of Data Warehousing: Building the Corporate Knowledge Base

"Ralph has customized the agile development methodology for the unique needs of business intelligence. My project teams were able to quickly understand and apply his approach without losing time to adapting generic Scrum techniques to the rigors of data integration and analytics." —Ron Lewis, program manager at a Fortune 1000 financial services company

"As a friend of Ralph and fellow Agile DW/BI author, I am very excited about this book. Ralph’s extensive research into what works; his hands-on application of those techniques; and his well-organized method of presenting information, are combined in this game changing book for data warehouse practitioners seeking greater agility." —Ken Collier PhD, author of Agile Analytics, Addison-Wesley, 2011

"This book presents a thorough approach to building quality into enterprise data warehouses, mitigating risk by applying proven models for testing, and detailing alternatives so that you can experiment to find the alternatives that work best for your team. These aren’t mere off the cuff ideas, but proven techniques to overcoming the huge challenges of EDW by applying agile principles, illustrated with stories from the trenches." —Lisa Crispin, Co-Author of More Agile Testing: Learning Journeys for the Whole Team, and Agile Testing: A Practical Guide for Testers and Agile Teams

From the Publisher