
Executing Data Quality Projects
Ten Steps to Quality Data and Trusted Information (TM)
Description
Key Features
- Includes numerous templates, detailed examples, and practical advice for executing every step of The Ten Steps approach
- Allows for quick reference with an easy-to-use format highlighting key concepts and definitions, important checkpoints, communication activities, and best practices
- A companion Web site includes links to numerous data quality resources, including many of the planning and information-gathering templates featured in the text, quick summaries of key ideas from The Ten Step methodology, and other tools and information that is available online
Readership
Table of Contents
Introduction
The Reason for This Book
Intended Audiences
Structure of This Book
How to Use This Book
AcknowledgementsChapter 1. Overview
Impact of Information and Data Quality
About the Methodology
Approaches to Data Quality in Projects
Engaging ManagementChapter 2. Key Concepts
Introduction
Framework for Information Quality (FIQ)
Information Life Cycle
Data Quality Dimensions
Business Impact Techniques
Data Categories
Data Specifications
Data Governance and Stewardship
The Information and Data Quality Improvement Cycle
The Ten Steps™ Process
Best Practices and GuidelinesChapter 3. The Ten Steps
1. Define Business Need and Approach
1.1 Prioritize the Business Issue
1.2 Plan the Project
2. Analyze Information Environment
2.1 Understand Relevant Requirements
2.2 Understand Relevant Data and Specifications
2.3 Understand Relevant Technology
2.4 Understand Relevant Processes
2.5 Understand Relevant People/Organizations
2.6 Define the Information Life Cycle
2.7 Design Data Capture and Assessment Plan
3. Assess Data Quality
3.1 Data Specifications
3.2 Data Integrity Fundamentals
3.3 Duplication
3.4 Accuracy
3.5 Consistency and Synchronization
3.6 Timeliness and Availability
3.7 Ease of Use and Maintainability
3.8 Data Coverage
3.9 Presentation Quality
3.10 Perception, Relevance, and Trust
3.11 Data Decay
3.12 Transactability
4. Assess Business Impact
4.1 Anecdotes
4.2 Usage
4.3 Five “Whys”
4.4 Benefit vs. Cost Matrix
4.5 Ranking and Prioritization
4.6 Process Impact
4.7 Cost of Low Quality Data
4.8 Cost-Benefit Analysis
5. Identify Root Causes
5.1 Five “Whys” for Root Cause
5.2 Track and Trace
5.3 Cause-and-Effect / Fishbone Diagram
6. Develop Improvement Plans
7. Prevent Future Data Errors
8. Correct Current Data Errors
9. Implement Controls
10. Communicate Actions and ResultsChapter 4. Structuring Your Project
Projects and The Ten Steps
Data Quality Project Roles
Project TimingChapter 5. Other Techniques and Tools
Introduction
Information Life Cycle Approaches
Capture Data
Analyze and Document Results
Metrics
Data Quality Tools
The Ten Steps and Six SigmaChapter 6. A Few Final Words
Appendix. Quick References
Framework for Information Quality
POSMAD Interaction Matrix Detail
POSMAD Phases and Activities
Data Quality Dimensions
Business Impact Techniques
The Ten Steps™ Overview
Definitions of Data Categories
Product details
- No. of pages: 352
- Language: English
- Copyright: © Morgan Kaufmann 2008
- Published: July 11, 2008
- Imprint: Morgan Kaufmann
- eBook ISBN: 9780080558394
- Paperback ISBN: 9780123743695
About the Author
Danette McGilvray
Affiliations and Expertise
Ratings and Reviews
There are currently no reviews for "Executing Data Quality Projects"