Enabling data governance with technology

Data Governance Concepts

Courtney Smith

Strategic Initiatives Manager

Data governance solutions

A diagram showing seven features of data governance solutions

Data Governance Concepts

Business glossary

  • Standard descriptions and definitions
  • For business terms
  • Creates common vocabulary

Example for Social Security number:

  • Unique identifier assigned by the U.S. government to citizens
  • Used for taxes, credit reporting, and health-related purposes

Icon of a business glossary

Data Governance Concepts

Data dictionary

  • Technical information
  • Usage, values, location, relationships
  • Promotes consistency, transparency

Example for Social Security number:

  • Must be in a nine-digit format, separated by hyphens, i.e., XXX-XX-XXXX.
  • Stored in the "customer_attribute" table under the "social_sec_number" column.

Image of a relational database

Data Governance Concepts

Data catalog

  • Metadata management tool
  • Organized inventory of data
  • Enables easy, quick location of data
  • Improves efficiency and transparency
  • Automated workflows for data sharing, leading to better collaboration
  • Similar to being able to search a library

People using a database to search a library

Data Governance Concepts

Automated data lineage

Lineage:

  • Describes how data flows from origination to consumption, including transformation
  • Time-consuming to manually document
  • New capabilities to auto-extract and maintain
  • Increases trust, accuracy and validity of data

Abstract image to indicate data flow

Data Governance Concepts

Data protection, privacy, and quality

Data protection:

  • Data access capabilities

Data privacy management:

  • Data classification and regulation tagging

Data quality management:

  • Rule writing
  • Data health metrics
  • Exception reporting

Picture to represent data quality and security

Data Governance Concepts

Choosing a solution

  • Understand the primary users
  • Basic or advanced capabilities
  • Prevent issues with integration
  • Popular data management platforms:
    • Collibra
    • Atlan
    • Informatica
    • IBM

Two people next to a checklist

Data Governance Concepts

Let's practice!

Data Governance Concepts

Preparing Video For Download...