Data Discovery and Advanced Profiling

onDemand | Data Quality | Self-Paced | Version 10

Course Overview

Discover the content and structure of data through topics such as Data Domain Discovery and Enterprise Discovery Profiling including; Join Analysis, Functional Dependency Profiling, Primary Key Inference, Overlap Discovery and Foreign Key Profiling.
Applicable for version 10.x users.

Objectives

After successfully completing this course, students should be able to:

  • Apply Data Domain Discovery to profiles in the Analyst Tool
  • Build and execute an Enterprise Discovery Profile in the Analyst Tool
  • Define the different types of Profiling that are available in the Developer Tool
  • Create and execute Enterprise Discovery Profiles in the Developer Tool
    • Perform Data Domain Discovery and Join Analysis Profiling
    • Perform Functional Dependency and Primary Key Inference
    • Perform Overlap Discovery and Foreign Key Profiling 
    • Update the model with Primary and Foreign Key relationships
    • Generate DDL from the updated model.

Target Audience

  • Data Analyst
  • Data Steward
  • Developer

Prerequisites

Agenda
Module 1: Analyst Tool: Data Domain Discovery and Enterprise Discovery Profiling
  • Data Domain Profiling 
  • Inferring/identifying sensitive data 
  • Building and executing an Enterprise Discovery Profile 
  • Lab: Update a Profile to perform Data Domain Discovery
  • Lab: Create, execute and review an Enterprise Discovery Profile
Module 2: Developer Tool: Advanced Profiling
  • Varieties of Profiling 
  • Column and Enterprise Discovery Profiles 
  • Navigating an Enterprise Discovery Profile
  • Inference Options 
  • Join Analysis Profiling 
  • Lab: Create and navigate an Enterprise Discovery Profile 
  • Lab: Perform Join Analysis Profiling

Module 3: Developer Tool: Functional Dependency and Primary Key Inference
  • Object content and structure
  • Primary Keys
  • Functional Dependencies
  • Sensitive Data across all objects in the model 
  • Lab: Import and Profile a new set of data
  • Lab: Perform Functional Dependency and Primary Key Inference
Module 4: Developer Tool: Overlap Discovery and Foreign Key Profiling 
  • Overlap Discovery between objects
  • Primary Key – Foreign Key relationships across objects
  • Verifying and Approving relationships
  • Generating DDL to create a new schema 
  • Lab: Overlap Discovery 
  • Lab: Primary Key – Foreign Key relationships


Enroll Now

Back to Course Overview

Power User Axon for Community Users (Instructor Led or onDemand) Axon Content Curation (Instructor Led) Axon for Power Users (Instructor Led) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Some more content to make this bigger asdf asdf asdf

Informatica offers programs to extend learning in convenient and economic packages. Programs include self-paced subscriptions as well as bundled instructor led training and certifications. Each program is curated around a specific skillset to enable customer success.

365University Data Governance Annual Subscription

Informatica MasterPass Education Subscription

Informatica Learning Library

Data Governance & Privacy Journey Master

View Full Course Offerings