This book takes a unique approach to the problems faced by data warehouse professionals. The author and the contributors have gathered over 90 situations that they have been asked about in their seminars and presentations, that they have faced in their own work, and that have been submitted to the very popular "Ask the Experts" forum at DMReview. These are all real situations, but they have been disguised to protect the guilty. Topics covered include staffing, budgeting, security, vendors, architecture, and data quality. Each of the "impossible" situations will have one or more solutions contributed by the expert panel. Their different answers and viewpoints, especially when they disagree with one another, provide enlightening reading, as well as useful ideas. This approach should appeal to a broad range of people involved in all aspects of Data Warehouses.

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.