Page 61 - CITP Review

Organizations need a strong metadata foundation to be able to answer these questions. Data stewards
should be able to view data lineage from a field in a report to the source table, from a business term to
the source table, from business terms to report semantics, and source records to aggregate values.

Manage stewardship process and workflows
Data stewards can save valuable time by leveraging automated workflow capabilities that render, for
example, the author, editor, approver, publish date and deprecated date.

Integrating glossary and metadata from structured and nonstructured sources

Big data is especially hard to govern because information is in structured and semi-structured formats. A
critical first step to governance is cataloging the data, then other governance functionality — such as
data profiling, data cleansing, and data enrichment — can be performed.

Linking data quality rules to business policies
Here are a few examples of data quality rules:

 FIRST_NAME should not have null values
 LAST_NAME should not have invalid characters
 EMAIL must adhere to the email address format

Tying it together with a quality dashboard

A data governance quality dashboard provides the data steward a comprehensive snapshot of quality
performance to identify trends that can influence future decision-making. For example, it might provide
the percentage pass rate for the fields FIRST_NAME, LAST_NAME and EMAIL.

9
Handling remediation and repair of bad data
Depending on the business rules associated with the data element, missing or invalid data may need to
be corrected before being passed on to a system of record. This may be accomplished by preventing
acceptance of an incomplete or invalid record in the original data capture system through the execution
of a real-time data quality check. Where this is not possible and poor quality data has already been
captured, the records in question may be reviewed and managed accordingly.

10
Policy
A data governance policy provides a set of guidelines to guarantee the proper management of an
organization's digital information. These guidelines often include policies and procedures for business
process management (BPM) and enterprise risk planning (ERP); they may also include polices for
security, data quality, and privacy as well.

9
Sunil Soares, Selling Information Governance to the Business. MC Press. (2010).
10
See https://searchcompliance.techtarget.com/definition/Data-governance-policy, accessed August 10, 2019.

© 2019 Association of International Certified Professional Accountants. All rights reserved. 2-15