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 