Always Learning

Data Warehouse Project Management
Sid Adelman
Larissa T. Moss

ISBN-10: 0201616351
ISBN-13:  9780201616354

Publisher:  Addison-Wesley Professional
Copyright:  2000
Format:  Paper; 448 pp
Published:  09/14/2000
Status: Instock


Customers outside the U.S., click here.


Print this content

In this section:


Table of Contents



List of Figures.


Foreword.


Preface.


Acknowledgments.


1. Introduction to Data Warehousing.

Traditional Development.

Data Warehousing.

The Role of Project Management.

Difficulty of Managing Data Warehouse Projects.

Summary.

Workshop.



2. Goals and Objectives.

Traditional Decision Support Deficiencies.

Data Management Solutions.

Data Warehouse Short-Term Objectives.

Data Warehouse Long-Term Objectives.

Summary.

Workshop.



3. Indicators of Success.

Measures of Success.

Critical Success Factors.

Measuring Results.

Summary.

Workshop.



4. Risks.

Types of Failures.

Types of Risks.

Poison People.

Summary.

Workshop.



5. Satisfying the User.

Understanding the Business.

Types of Users.

Communicating with the Users.

Requirements.

Internal Selling.

Summary.

Workshop.



6. Cost Benefit.

The Need for Cost Justification.

Costs.

Benefits.

Summary.

Workshop.



7. Selecting Software.

Data Warehouse Tools.

Where the Tools Fit in the Technical Architecture.

Product Requirements.

Vendor Evaluation.

Research.

Making the Decision.

Summary.

Workshop.



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.

Training.

Summary.

Workshop.



9. Methodology.

Data Warehouse Iterations.

Prototyping as a Development Approach.

Parallel Development Tracks.

Major Development Steps.

Summary.

Workshop.



10. Data Models.

Logical Data Model.

Physical Data Model.

Summary.

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.

Summary.

Workshop.



12. Project Planning.

Need for Project Planning.

The Project Plan.

Estimating.

Controlling the Project.

First Project Selection.

Communication.

Summary.

Workshop.



Appendix.

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



Back to top

Print this content

In this section:


Author Bios

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.



0201616351AB09262002


Backcover Copy

"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

Back to top

Print this content

This product is a member of the following series. Click on the series name to see the full list of products in the series.

Back to top

Log in to the Instructor Resource Center

Login name: 

  Password: 

Forgot login/password?  |  Need to redeem an access code?

        

Instructor Resource Center File Download

This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.

Cancel     I accept, proceed with download

Print this content

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.

Back to top