Data Warehouse Project Management / Edition 1

Data Warehouse Project Management / Edition 1

5.0 2
by Sid Adelman, Larissa T. Moss

ISBN-10: 0201616351

ISBN-13: 9780201616354

Pub. Date: 09/14/2000

Publisher: Addison-Wesley

"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

…  See more details below


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


Read More

Product Details

Publication date:
Addison-Wesley Information Technology Series
Edition description:
Product dimensions:
7.30(w) x 9.20(h) x 1.00(d)

Related Subjects

Table of Contents

List of Figures.




1. Introduction to Data Warehousing.

Traditional Development.

Data Warehousing.

The Role of Project Management.

Difficulty of Managing Data Warehouse Projects.



2. Goals and Objectives.

Traditional Decision Support Deficiencies.

Data Management Solutions.

Data Warehouse Short-Term Objectives.

Data Warehouse Long-Term Objectives.



3. Indicators of Success.

Measures of Success.

Critical Success Factors.

Measuring Results.



4. Risks.

Types of Failures.

Types of Risks.

Poison People.



5. Satisfying the User.

Understanding the Business.

Types of Users.

Communicating with the Users.


Internal Selling.



6. Cost Benefit.

The Need for Cost Justification.





7. Selecting Software.

Data Warehouse Tools.

Where the Tools Fit in the Technical Architecture.

Product Requirements.

Vendor Evaluation.


Making the Decision.



8. Organization and Cultural Issues.

Current Situation.

Cultural Imperatives.

Organization to Support the Data Warehouse.

Data Warehouse Roles.

Advisory Boards.

Recruiting and Retention.

The Data Warehouse Team.




9. Methodology.

Data Warehouse Iterations.

Prototyping as a Development Approach.

Parallel Development Tracks.

Major Development Steps.



10. Data Models.

Logical Data Model.

Physical Data Model.



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.



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.

User Scorecard.

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.

Organizational Structures.

Salary Survey.

Service Level Agreement Standards.

Questions for External Data Vendors.

Project Plan Task Template.

Sample Project Plan.

Disaster Examples.

Index. 0201616351T04062001

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network


Most Helpful Customer Reviews

See all customer reviews >

Data Warehouse Project Management 5 out of 5 based on 0 ratings. 2 reviews.
Guest More than 1 year ago
Data Warehouse Project Management provides a practical and pragmatic approach to planning and managing the Data Warehouse project. Even if you are an experienced Project Manager, Data Warehouse projects present a new set of challenges. Sid and Larisaa have captured all you need to know in this book and laid it out for you. As they point out, most Data Warehouse projects fail because the do not meet the expectations of the clients. If you don't want to be in the minus column, then this book is must reading.
Guest More than 1 year ago
'Data Warehouse Project Management' is an excellent tool for the challenging information systems field. This is truly a defintive book on data warehousing that emphasizes the way data warehouses should be developed and how it impacts everyone...from the people who design and develop a data warehouse and to those who, on a daily basis, are involved in corporate decision making. And, if you are on the hiring side of the equation, you need to know what to look for when interviewing top talent. Using the 'Data Warehouse Project Management' is a great method for learning while doing, especially if you do not have the time to train employees in this discipline. As growth through technology changes the way corporations do business, Sid and Larissa highlight the importance of how a well defined and developed data warehouse can bring process improvement, productivity and innovation to the overall success of the corporation.