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.
Sid Adelman is founder of Sid Adelman & Associates, an organization specializing in planning and implementing data warehouses. He presents regularly at data warehouse conferences and conducts a Data Warehouse Project Management seminar. Sid is also a founding member of the BIAlliance. He jointly developed a methodology that provides a master plan for implementing data warehouses. He wrote Data Warehouse Project Management (Addison-Wesley, 2000) with Larissa Moss.
Larissa Moss is founder and president of Method Focus, Inc., a consulting firm specializing in business intelligence and data warehousing. She is a frequent lecturer and speaker at conferences in the United States, Europe, and Asia on data warehousing, project management, development methodologies, and organizational and cultural issues. Her articles on these topics are regularly published in magazines such as DM Review and Journal of Data Warehousing. She is coauthor of Data Warehouse Project Management (Addison-Wesley, 2000) and Impossible Data Warehouse Situations (Addison-Wesley, 2003). She is a senior consultant at the Cutter Consortium and one of the authors of their Business Intelligence Executive Reports.
List of Figures. Foreword. Preface. Acknowledgments. 1. Introduction to Data Warehousing.
The Role of Project Management.
Difficulty of Managing Data Warehouse Projects.
Workshop.2. Goals and Objectives.
Traditional Decision Support Deficiencies.
Data Management Solutions.
Data Warehouse Short-Term Objectives.
Data Warehouse Long-Term Objectives.
Workshop.3. Indicators of Success.
Measures of Success.
Critical Success Factors.
Types of Failures.
Types of Risks.
Workshop.5. Satisfying the User.
Understanding the Business.
Types of Users.
Communicating with the Users.
Workshop.6. Cost Benefit.
The Need for Cost Justification.
Workshop.7. Selecting Software.
Data Warehouse Tools.
Where the Tools Fit in the Technical Architecture.
Making the Decision.
Workshop.8. Organization and Cultural Issues.
Organization to Support the Data Warehouse.
Data Warehouse Roles.
Recruiting and Retention.
The Data Warehouse Team.
Data Warehouse Iterations.
Prototyping as a Development Approach.
Parallel Development Tracks.
Major Development Steps.
Workshop.10. Data Models.
Logical Data Model.
Physical Data Model.
Workshop.11. Data Quality.
Data Management and Data Delivery.
The Cost of Data Chaos.
Defining Data Quality for the Data Warehouse.
Data Cleansing Categories.
Triaging Data Cleansing Activities.
Workshop.12. Project Planning.
Need for Project Planning.
The Project Plan.
Controlling the Project.
First Project Selection.
Data Warehouse Applications by Industry.
User Responsibility Problem.
User Validation Template.
Words to Use/Words Not to Use.
Sample Letter to Interviewees.
Interview Results Template.
User Satisfaction Survey.
Benefits Analysis for Health Care.
Benefits Analysis for Finance.
Desired Types of References.
Questions for the References.
Vendor Rules of Engagement.
Plan to Select Products.
Data Warehouse Product Categories.
Service Level Agreement Standards.
Questions for External Data Vendors.
Project Plan Task Template.
Sample Project Plan.
Disaster Examples.Index. 0201616351T04062001