Description

What is the role of a Data Catalog in Data Governance programs?

In recent years, numerous vendors have introduced data catalog software, resulting in a market now comprising over 40 products. But what exactly is this software, and what drives its necessity? Mike Ferguson explains this and more in this video.

 

Many businesses today are operating in a distributed computing environment with data and processes running across on-premises systems, multiple clouds on SaaS applications and the edge. In this environment, with so much going on, data is much harder to find and govern. Also, the number of data sources continues to grow and master data, the most widely used data in any business, is becoming harder to find, manage and keep synchronized across so many systems in a hybrid computing environment.  

This two-day course looks at this problem and shows how to successfully implement a data governance program to govern data across a distributed data landscape. This includes governing data access security, data privacy, data sharing, data retention and data quality with data quality encompassing master data management to create a 360-degree view of customers, products, suppliers and other core entities.

The course takes a detailed look at the business problems caused by poorly governed data and how it can seriously impact business operations, cause unplanned operational costs, and destroy confidence in the accuracy of business intelligence, machine learning model predictions and recommendations. It also defines the requirements that need to be met for a company to confidently define, manage and govern data as well as create and share consistent reference and master data across operational applications and analytical systems both on-premises and in one or more clouds.

Having understood the requirements, you will learn what should be in a governance program. This includes a data governance framework that includes data governance roles and responsibilities, processes, policies, technologies, and a core set of data governance capabilities to govern data across a distributed data landscape. It also includes a master data management strategy and what you need to do to bring your master data under control. You will look at how to make use of a business glossary, a data catalog with automated data discovery, data profiling, sensitive data classification, enterprise-wide and domain-oriented data governance policy definition by data owners around the business and policy enforcement across a distributed data landscape. You will also look at data cleaning and integration to provision master data and reference data products and how Customer Master Data can be combined with data warehouse and big data to create a Customer Data Platform (CDP) for a customer intelligent omni-channel front-office.

During the course, we take an in-depth look at the technologies and best practice methodologies and processes for governing data across on-premises systems, SaaS applications, multiple clouds, and the edge.

Why attend

  • You will learn how to set up an enterprise data governance program to systematically govern data and content across a distributed data landscape from a single place. 
  • Using a data governance framework and key technologies like data catalogs, data classifiers, data fabric and MDM, you will learn what is needed to discover, classify and govern data and content. This includes data access security, data privacy, data loss prevention, data sharing, data retention, and data quality.

Who should attend

This course is intended for:

  • Business and IT professionals responsible for enterprise data governance including data access security, data privacy, data sharing, data retention, data quality (includes master data management) of both structured data and content
  • Chief Data Officers, heads of data governance, enterprise architects, data architects, MDM professionals, business professionals, database administrators, data engineers, and compliance managers responsible for data governance

Prerequisites

This course assumes a basic understanding of data governance, data management, metadata, data warehousing, data cleansing, data integration etc. 

 

Code: DG2024
Price: 1.450 EUR

Inquire about this course

Outline

 
 
 
 
 
 
 
 
 
 

What is Data Governance and Why Do We Need It?

This module looks at what data governance is and what the main reasons are for needing to implement a data governance program. It looks at the need to comply with multiple data privacy regulations and legislation in a global business, the need to avoid data breaches and the challenges posed by a growing number of data sources and an increasingly complex distributed data landscape. It looks at the problems ungoverned data can bring and how they impact business operations, decision-making and increase risk.

  • The ever-increasing distributed data landscape – on-premises, multiple clouds, SaaS applications and the edge
  • The impact of ungoverned data on business profitability and the ability to respond to competitive pressure 
  • Protecting personal data in a global business – the impact of the data privacy legislation in multiple jurisdictions
  • Data breaches and how they impact business

What Are the Requirements and What’s Needed to Govern Data Across a Distributed Data Landscape?

This module looks at what the requirements are to govern data in a modern enterprise and what is needed to make it happen.

  • Key requirements for governing data and content across a distributed data landscape
  • What do you need to know to govern data?
  • Introducing a data governance framework to help meet the challenge
  • People 
    • Key roles and responsibilities
    • Getting the organisation and operating model right
    • Data owners, data stewards, data governance control board and working groups
  • Core processes needed to establish and govern commonly understood data
  • Types of policies and rules needed to govern
    • Data quality 
    • Data access security
    • Data privacy
    • Data retention
    • Data loss prevention
    • Data sharing
    • Data use and maintenance
  • Technology
    • Data catalog
    • Trainable ML classifiers
    • Data Fabric
    • Dynamic data masking
    • Data loss prevention
    • Master Data Management
  • Core data governance capabilities needed
  • Tasks involved in governing a distributed data landscape 

The Importance of a Business Glossary

This module looks at the need to understand your data landscape from a business perspective. The key to making this happen is to establish a common business vocabulary in the business glossary of a data catalog to create common data names and definitions for your data. This enables you to search for and govern data across your data estate from a business perspective.

  • Data standardization using a shared business vocabulary
  • The purpose of a common vocabulary in data governance
  • Business glossary software – now a capability of a data catalog
    • Alation, Amazon Glue, Collibra, Informatica IDMC Business Glossary, IBM Watson Knowledge Catalog, Microsoft Azure Purview, Qlik (Talend) Business Glossary and Data Catalog, SAS Business Data Network, TopQuadrant TopBraid EDG Business Glossary
  • Planning for a business glossary
  • Glossary roles and responsibilities
  • Glossary term submission, voting approval and dispute resolution processes
  • Approaches to creating a common vocabulary
  • Organizing data definitions in a business glossary
  • The role of a data concept model
  • Utilizing a common vocabulary in Data Modelling, ETL, BI, ESB, APIs, & MDM

Understanding Your Data Landscape - Auto Data Discovery, Cataloguing and Mapping to a Business Glossary

Having defined your data, this module looks at discovering what data you have, where it is and how it maps to your business glossary to provide a business understanding of your data landscape.

  • Understanding your data landscape - the critical role of data catalog software
  • The Data Catalog Marketplace
    • Alation, Ataccama, Atlan, AWS Glue Data Catalog, BigID, Cambridge Semantics Anzo Data Catalog, Collibra Data Catalog, data.world, Google Data Catalog, Hitachi Vantara Lumada, IBM Watson Knowledge Catalog, Informatica Data Governance and Catalog, Microsoft Purview, Oracle, SAP DataSphere, Qlik (Talend) Data Catalog, TopQuadrant TopBraid, Zaloni Data Catalog
  • The data discovery process
  • Registering data sources for discovery
  • Automated data discovery, profiling and using a Data Catalog
  • Mapping data assets to a business glossary

Classifying Data and Content to Know How to Govern It

This module looks at manually and automatically labeling data to know how to govern it using predefined classifiers, user-defined classification schemes and trainable classifiers. It then looks at how classified data shows up in a data catalog and how policies can be assigned to labelled data to govern it across your data estate.

  • What is data classification?
  • Automated sensitive data type detection and classification using pre-defined trained classifiers
  • Creating your own data classification schemes for data confidentiality and retention
  • Manually classifying content using your own classification scheme e.g. Office documents, SharePoint, Email, Chat, Microsoft Teams or Zoom Meetings
  • Training classifiers to automatically label content    
  • Using trained classifiers to auto-label content in the cloud and on-premises
  • Using your own classification schemes with a data catalog
  • Automatically classifying sensitive structured data and objects using a data catalog
  • Using classification insights to understand sensitive data proliferation and data redundancy across your estate
  • Setting policies in a data catalog to govern data across your data estate

Governing Data Security Across Your Distributed Data Landscape

Having classified the data and content in your data estate, this module looks at protecting data and content in your data estate with a focus on that which is classified as sensitive or confidential. It looks at setting and enforcing policies to govern data access and usage security as well as governing data loss prevention.

  • Data security objectives
  • Key technologies in governing data security
    • Policy establishment
    • Policy enforcement
  • Steps to implement data security
  • Setting policies in your data catalog to govern data access across your data estate
    • Attribute-based access control
  • Unifying data access control across multiple data stores
  • Universal authorization fabric software (e.g. IBM, Immuta, Databricks (Okera)) and how they integrate with data catalogs
  • Setting enterprise-wide and domain-specific policies in your data catalog to govern data usage across your data estate
  • What are cloud application security brokers?
    • Auto-discovery of cloud application usage
    • Setting policies to govern access to and use of sensitive data and content from applications
    • Monitoring cloud application activity

Governing Data Privacy Across Your Distributed Data Landscape

This module looks at governing access to personal data across your data estate to remain compliant with legislation in multiple jurisdictions in which your company operates.

  • Data privacy objectives 
  • Data privacy legislation – GDPR, CCPA, HIPAA and more
  • Steps involved in an enterprise-wide data privacy governance process 
  • Automatically identifying where unprotected personal data is located
  • Data privacy policy enforcement across a distributed data landscape
    • Linking your data catalog to other technologies
    • Encrypting and de-identifying personal data
    • Using data loss prevention (DLP) to avoid loss of personal data
    • Protecting personal data in email, chat, documents, file shares, cloud storage and endpoints

Governing Data Retention Across Your Distributed Data Landscape

This module looks at governing the lifecycle of data across your data estate and how you can set policies to control how long data is kept and what happens to it on expiry. It also looks at special purpose conditions such as “legal holds” placed on data by legal departments.

  • Creating a data retention classification scheme
  • Complying with country and region-specific legislation
  • Classifying data and content using retention labels
  • Setting policies centrally to retain data
  • Setting actions to destroy or archive it on expiration

Governing Data Sharing Across Your Distributed Data Landscape

This module looks at producing trusted, compliant data to be shared across the enterprise and beyond and how data sharing can be governed.

  • Data sharing objectives 
  • Key technologies to help produce trusted data products for sharing
  • Steps to creating data products
  • A unified approach to producing trusted data products using Data Fabric and DataOps pipelines
  • Publishing trusted, compliant data products in a data marketplace
  • Governing data-sharing and consumption using data sharing agreements and a data marketplace
  • Creating a standard data sharing approval process for consumers
  • Monitoring and tracking shared data consumption and usage

 

 

 

Governing Data Quality Across Your Distributed Data Landscape

This module looks at consistently governing data quality across your data estate.

  • The business impact of bad quality data 
  • Common data quality metrics
  • Setting up data validation and matching rules in your data catalog
  • Using your data catalog to automatically profile and validate your data 
  • Monitoring data quality and policies across your distributed data estate
  • Integrating data catalogs with self-service data cleansing software
  • AI-assisted data cleansing

Governing Data Quality Using Master Data Management

This module looks at master data management (MDM) and reference data management (RDM) and how to implement them to improve data quality.

  • What is master data management and why is it needed?
  • What is reference data management?
  • Components of an MDM solution
  • MDM implementation styles and options 
    • Real-time master data synchronization 
    • Virtual MDM (Index / Registry)
    • Single Entity Hub 
    • Enterprise Multi-Domain MDM
  • Identifying master data entities 
  • Defining a common vocabulary for master data entities e.g. customer, supplier, product
  • Master data modelling
  • Master Data Hierarchy Management 
  • Master Data discovery – identifying where your disparate master data is located using a data catalog
  • Mapping your disparate master data to your business glossary
  • Profiling disparate master data to understand data quality 
  • Using Data Fabric to clean, match and integrate master data to create trusted master data entities
  • Master data matching – fuzzy matching and survivorship rules 
  • Implementing outbound master data synchronization 
  • Standardizing business processes to create and maintain master data 
  • Governing maintenance of master data 
  • The MDM solution marketplace 
    • Ataccama, CluedIn, IBM, Informatica, Oracle, Profisee, Reltio, Syndigo Riversand, SAP, SAS, Semarchy, Qlik (Stibo), Talend, Tamr, TIBCO & more
  • Evaluating MDM products
  • Integration of MDM solutions with data catalogs and data fabric 
  • MDM in the cloud – what’s the advantage? 
  • Accessing and maintaining master data via shared master data services 
  • Integrating MDM with operational applications and process workflows
  • Using master data to tag unstructured content e.g. supplier contracts

Transitioning to a Common Approach to Centralised Master Data Maintenance – the Change Management Process

This module looks at the most difficult job of all – the change management process needed to get to a common approach to master data maintenance. It looks at the difficulties involved, what really needs to happen and how to make it happen. 

  • The impact of centralized update of master data on existing processes
  • Transitioning from multiple data entry systems to one data entry system
  • Planning for incremental change management
  • Creating an MDM change management program 
  • Changing application logic to use shared MDM services
  • Changing user interfaces 
  • Leveraging a REST APIs, GraphQL and a SOA to access MDM shared services 
  • Changing existing business processes to take advantage of MDM
  • Changing ETL jobs to leverage master data as a data source
  • Hierarchy change management in MDM 

Combining MDM With Big Data and Your Data Warehouse to Create a Customer Data Platform

This last module looks at combining customer master data, big data and your data warehouse to create a customer data platform to support marketing, sales and customer service in the digital enterprise.

  • Integrating master data with big data and data warehouses
  • New data sources related to customers 
  • Creating new customer insights using analytics
  • Creating a CDP in your enterprise
  • Integrating CDPs with digital and traditional marketing, sales and service applications

Dates

This course is only available as customer specific training, whereby we can deliver private courses arranged at both a location (or virtual) and time to suit you, covering the right content to address your specific learning needs. Contact our learning advisors by e-mail at info@q4k.com.

Copyright ©2023-2024 quest for knowledge