Book Description
"Anyone who finds Data Warehouse Project Management has found for themselves a veritable gold mine, a wealth of wisdom and experience from some real pros . . . it is the most thorough and thoughtful work on data warehouse projects I have ever read." --From the Foreword by John A. Zachman
Data warehouse development projects present a unique set of management challenges that can confound even the most experienced project manager. Data Warehouse Project Management addresses these challenges and provides a comprehensive roadmap to managing every aspect of data warehouse design, development, and implementation. Drawing on their extensive experience in the field, Sid Adelman and Larissa Moss point to critical success factors, reveal the many pitfalls to watch out for, and offer proven solutions that will enable you to put a successful data warehouse project into place.
You will find in-depth coverage of such topics as:
Critical success factors and reasons for failures
Measuring results
Cost-benefit analysis
Selecting the right software and vendors
Roles and responsibilities of team members
Methodology, including rapid application development and parallel development tracks
Developing a logical and physical data model for smooth data integration
The important issue of data quality and how to cleanse dirty data from source files
At the end of each chapter, "A Cautionary Tale" warns you of potential problems, and a workshop enables you to practice what you've just learned. The book concludes with a comprehensive example that illustrates project planning and management in action, from determining milestones, schedules, and tasks to maintaining control when the project goes off course. An accompanying CD-ROM contains the workshops in electronic format as well as helpful templates and additional reading material.
From the Inside Flap
You have been a project manager for years and have successfully implemented many systems, but on your data warehouse project nothing seemed to work. All those proven techniques you've acquired over the years did not smooth the path. The methodology you so faithfully followed for years did not seem to help you as much in controlling the activities on the project. Tasks had to be repeated many times, and some new tasks that you had never considered before had to be performed. Roles and responsibilities assigned to your staff seemed inadequate and sometimes inappropriate. Your users had not planned on spending so much time on your project, and you had not realized what was going to be required of them. You knew your source files had some bad data, but you had not anticipated the impact it would have on the extract/transform/load (ETL) process.
Maybe you are just planning your first data warehouse project and you have heard that it will be different and difficult. In either case, whether you already managed a data warehouse project or you are planning your first data warehouse project, this book will help you pave the road for a successful implementation. But before you immerse yourself into the content of this book, we would like to explain