Skip to Main Content
Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems
book

Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems

by Larry P. English
October 2009
Beginner to intermediate content levelBeginner to intermediate
839 pages
29h 16m
English
Wiley
Content preview from Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems
Chapter 5 Assessing Information Quality 237
Summary Charts and Pareto Diagrams for identifying Defect Types,

such as Inaccurate Values in the various data elements in one Pareto,
Missing Data in another Pareto, and Invalid Values, or Non-conformance
to Business Rules in yet another Pareto. See Figure 5-28 for an example
of a summary chart.
Completeness Accuracy Duplicates
40.0%
35.0%
30.0%
25.0%
20.0%
15.0%
10.0%
5.0%
0.0%
Records with
incomplete fields
10.0%
28.4%
Fields
incomplete
3.0%
6.3%
Records
with errors
8.0%
20.0%
Total errors
2.0%
Duplicate
records
15.0%
37.2%
Temp Quality Goal
Summary IQ Assessment Results
Assessed Defects
Figure 5-28: Summary Chart of Critical IQ Characteristics
Summary charts should be exploded into meaningful Pareto Diagrams, by
error type or data elements in error, as illustrated in Figure 5-29.
The number at the top of each column represents the number of defects of
that type found. The cumulative percentage graph represents the cumulative
percent of errors of each type from most frequent to least frequent.
A more useful Pareto, however, is the “Impact Pareto,” where you weight
the different defect types by actual cost of process failure downstream and
Information Scrap and Rework, or by relative estimated impact on process
failure downstream.
Figure 5-30 is an illustration of an Impact Pareto Diagram by costs or impact
of error type.
34474c05.indd 237 8/31/09 1:25:02 PM
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits

Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits

Larry P. English
Information Quality

Information Quality

Ron S. Kenett, Galit Shmueli
Business Metadata: Capturing Enterprise Knowledge

Business Metadata: Capturing Enterprise Knowledge

W.H. Inmon, Bonnie O'Neil, Lowell Fryman

Publisher Resources

ISBN: 9780470134474Purchase book