The average data warehouse takes three years to build and costs $3-5 million -- yet many data warehouse project managers are thrown into the position with no clear idea of their roles, authority, or even objectives. It's no wonder that 85% of all data warehouse projects fall short of their objectives, and 40% fail completely. In Data Warehouse Project Management, two leading data warehouse project management consultants present start-to-finish best practices for getting the job done right. Sid Adelman and Larissa Terpeluk Moss cover the entire lifecycle, from proposing a data warehouse project through staffing a team, developing project scope, justifying, negotiating, and marketing the data warehouse project internally, and then implementing the data warehouse. They present real-world case studies identifying the key pitfalls that arise repeatedly in data warehouse projects -- and offer proven solutions for addressing these challenges. The book and CD-ROM contain an extensive library of templates and checklists, plus self-tests to determine whether an organization is really ready for data warehousing.

"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.

0201616351B07092001