
Chapter 8 n Data Correction and Controlling Data Redundancy 347
PARTICIPANT IQ ACTIVITY ROLE
Business
Information Steward
Ensures the Completeness, Correctness, and Clarity of the Data
Definition, Valid Value Sets, and Business Rule Specification.
Information
Architect
Develops the Information Model and attributes to support
the standardized data parsed from overloaded attributes.
Techniques and Tools for Step P5.4
Information Standards:
■n
Used to guide the standardization process. Often
these will be updated with the various data correction initiatives as over-
loaded data elements are discovered.
Modeling Software with Matrix Facility:
■n
Used to document the nonstan-
dard data to standardized data that is correctly named and defined
Business Rule Discovery Software:
■n
Used to find patterns in the data that
lead to standardization and atomic data values
Data Transformation and Data Correction Software:
■n
Used to electroni-
cally parse the data into atomic-level facts
Facilitated Data Definition Workshop:
■n
Used to ensure that data is identified,
named, and defined in a standard way, that is correct, complete and clear
Step P5.4: Process Steps and Guidelines
1. Identify the data elements that require parsing. These will include data ele-
ments that have been overloaded like Person Name, Address, and Product
Code such as Catalog Code or VIN (vehicle Identification Number).
This enables better ma