Data Warehouse Project Management (Paperback)
$999The Data Warehouse ETL Toolkit : Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data
A complete, start-to-finish roadmap for the data warehouse project manager!
- Best practices, templates, examples, checklists, and much more.
- Specific solutions to the complex problems that arise most often in data warehousing projects.
- CD-ROM includes hands-on workshops and easy-to-adapt project templates.
Sid Adelman is a world-recognized data warehousing consultant. He is Chairman of the International Data Warehousing Board, and President & Founder of Sid Adelman & Associates. Larissa Terpeluk Moss, also an internationally known data warehousing consultant, is President and Founder of MethodFocus, Inc. Larissa is the developer of RSDM-2000, a Relational System Development Methodology. Both have published extensively in DM Review.
1. Introduction to Data Warehousing.
The Role of Project Management.
Difficulty of Managing Data Warehouse Projects.
2. Goals and Objectives.
Data Management Solutions.
Data Warehouse Short-Term Objectives.
Data Warehouse Long-Term Objectives.
3. Indicators of Success.
Critical Success Factors.
Types of Risks.
5. Satisfying the User.
Types of Users.
Communicating with the Users.
6. Cost Benefit.
7. Selecting Software.
Where the Tools Fit in the Technical Architecture.
Making the Decision.
8. Organization and Cultural Issues.
Organization to Support the Data Warehouse.
Data Warehouse Roles.
Recruiting and Retention.
The Data Warehouse Team.
Prototyping as a Development Approach.
Parallel Development Tracks.
Major Development Steps.
10. Data Models.
Physical Data Model.
11. Data Quality.
The Cost of Data Chaos.
Defining Data Quality for the Data Warehouse.
Data Cleansing Categories.
Triaging Data Cleansing Activities.
12. Project Planning.
The Project Plan.
Controlling the Project.
First Project Selection.
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.