View Course Agenda

Enterprise Data Catalog: Data Discovery and Lineage Analysis

Instructor Led | Data Catalog | 2 Days | Version 10.5

Enterprise Data Catalog: Data Discovery and Lineage Analysis

Course Overview

This course is applicable to version 10.5. Gain the skills necessary to use Enterprise Data Catalog (EDC) to discover and explore datasets. Using EDC, learn to perform a semantic search, customize searches, analyze data lineage and impact, associate assets with existing business terms from the Business Glossary, and add custom attributes to assets.

Enroll Now 

Objectives

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

  • Perform semantic search
  • Customize search
  • Configure search filters
  • View asset details
  • View profiling statistics
  • Perform quick edit of asset properties
  • View data lineage and impact details
  • Configure application
  • Review and certify assets
  • Collaborate with other EDC users
  • Follow changes made to assets
  • View transformation logic for an asset
  • View relationship between assets
  • Associate business terms with assets
  • Associate custom attributes with assets
  • Preview and provision data
  • Analyze data asset dashboards and reports

Target Audience

  • Data Analyst
  • Data Steward
  • End User

Prerequisites

  • None

Agenda

Module 1: Overview of Enterprise Data Catalog

  • Major Business Challenges
  • Scale of Challenges
  • EDC as a Solution
  • EDC Metadata Lifecycle
  • EDC Architecture
  • EDC Key Features
  • Walkthroughs

Module 2: Exploring the Enterprise Data Catalog User Interface

  • EDC User Interface
  • Semantic Search
  • Searching in EDC
  • Additional Search Options in EDC
  • Explore Search Results
  • Search Filters
  • Search Prefilters
  • Additional Search Options
  • Certified Assets
  • Rated Assets
  • View Asset Details
  • Types of Assets
  • View Data Lineage
  • View Relationships
  • Data Profiling
  • Lab: Review Resources
  • Lab: Perform Semantic Search
  • Lab: Perform Wildcard Search
  • Lab: Explore the assets

Module 3: Analyzing Profiling Results

  • Data Profiling
  • Data Similarity
  • Value Frequency
  • Similar Columns
  • Unique Keys
  • Patterns and Inferred Data Types
  • Lab: View and Analyze Profiling Results
  • Lab: Discover and Curate Unique Keys 

Module 4: Data Domains and Curation

  • Data Domain Discovery
  • Data domain creation and association
  • Curation
  • Search for Assets Through Data Domains
  • Data domain inference
  • Propagation of curated data domains
  • Data Domain Groups
  • Composite Data Domains
  • Lab: Create and assign data domains
  • Lab: Curate data domains
  • Lab: Curate data domains using Export/Import

Module 5: Enhancing Asset Details

  • Business Terms
  • Business Titles
  • Association of business terms
  • Business Terms Inference and Curation
  • Bulk curation of business terms
  • Custom Attributes
  • Types of Custom Attributes
  • Extended Custom Attributes
  • Exporting and Importing Custom Attributes
  • Lab: Associate a business term
  • Lab: Associate a business title
  • Lab: Curate Business Terms
  • Lab: Add multiple business terms

Module 6: Analyzing Lineage and Impact

  • Lineage and Impact
  • Connected Business Terms
  • Transformation Details
  • Asset Lineage and Impact Summary View
  • Exporting Lineage and Impact Summary
  • Lab: Explore Data Lineage and Impact View
  • Lab: View Transformation Details

Module 7: Discovering Related Assets

  • Asset Relationship Overview
  • Relationship View
  • Relationship Diagram of Related Assets
  • Customizing the View
  • Type of Relationships
  • Difference Between Lineage and Impact View, and Relationship View
  • Lab: View relationship between assets

Module 8: Tracking Asset Changes

  • Follow an asset
  • Get notifications
  • View summary of changes
  • Lab: Track changes made to a Resource
  • Lab: Follow Assets
  • Lab: Unfollow Assets

Module 9: Collaborating on Assets

  • Review and Rate Assets
  • Certify and Decertify Assets
  • Questions and Answers
  • Lab: Review and rate assets
  • Lab: Certify an Asset
  • Lab: Collaborate through Queries

Module 10: Data Preview and Provisioning

  • Supported resources
  • Connecting to the database
  • Preview data
  • Provision data
  • Lab: Preview and provision an Oracle table

Module 11: Customizing Search and Views

  • Filter panel
  • Search result views
  • Asset Overview
  • Search Results
  • Search Ranks
  • Prefilters
  • Lab: Create a prefilter

Module 12: Data Asset Analytics

  • Business Case
  • Dashboards
  • Reports
  • Lab: Analyze the DAA Dashboard
  • Lab: Create a Report
 
Enroll Now 

Back to Course Overview


QUESTIONS?

Instructor Led | Data Catalog | 2 Days | Version 10.5

Print Friendly and PDF