View Course Agenda

Data Discovery and Advanced Profiling 10

onDemand | Data Quality | Self-Paced

Data Discovery and Advanced Profiling

Course Overview

Applicable for version 10.x users. 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. 

Enroll Now

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


QUESTIONS?

onDemand | Data Quality |Self-Paced | Version 10

Print Friendly and PDF