Search:

Product Information All Elsevier Sites   Advanced Product Search
SiteStat.jsp
EXECUTING DATA QUALITY PROJECTS
Executing Data Quality Projects
Ten Steps to Quality Data and Trusted Information (TM)
To order this title, and for more information, click here

By
Danette McGilvray, Granite Falls Consulting, Inc.

Description
Information is currency. Recent studies show that data quality problems are costing businesses billions of dollars every year, with poor data linked to waste and inefficiency, damaged credibility among customers and suppliers, and an organizational inability to make sound decisions. In this important and timely new book, Danette McGilvray presents her "Ten Steps" approach to information quality?a proven method for both understanding and creating information quality in the enterprise. Her trademarked approach, in which she has trained Fortune 500 clients and hundreds of workshop attendees, applies to all types of data and all types of organizations.

Audience
Database analysts, data analysts, data administrators, data architects, enterprise architects, data warehouse engineers, business analysts, developers, DBAs, subject matter experts, data modelers, and data stewards and their managers.

Contents




Introduction

The Reason for This Book
Intended Audiences
Structure of This Book
How to Use This Book
Acknowledgements



Chapter 1. Overview

Impact of Information and Data Quality
About the Methodology
Approaches to Data Quality in Projects
Engaging Management



Chapter 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 Guidelines



Chapter 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 Results



Chapter 4. Structuring Your Project

Projects and The Ten Steps
Data Quality Project Roles
Project Timing



Chapter 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 Sigma



Chapter 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




Bibliographic details
Paperback, 352 pages, publication date: JUL-2008
ISBN-13: 978-0-12-374369-5
Imprint: MORGAN KAUFFMAN

Price and Ordering
Price:
EUR 38.95
GBP 32.99
USD 54.95
order now
Books and book related electronic products are priced in US dollars (USD), euro (EUR), and Great Britain Pounds (GBP). USD prices apply to the Americas and Asia Pacific. EUR prices apply in Europe and the Middle East. GBP prices apply to the UK and all other countries.
See also information about conditions of sale & ordering procedures, and links to our regional sales offices.

077/762
Last update: 5 Sep 2009
Book contents
Table of contents
Reviews
View other people's reviews
Submit your review
Bookmark this page
Recommend this publication
Overview of all books
Printer-friendly version   Printer-friendly version