About this course

Course code TPD91754GC10
Duration 3 Days

This course (based on Oracle Enterprise Data Quality version 12.1.3) teaches the participants how to configure match processors to find and optionally merge exact and similar (fuzzy) matching records. Participants learn how to create sophisticated match rules, configure merge options and review match results. This offering also deals about the different match processors that are available, including those in the Customer Data Extension Pack. Participants also learn to standardize data and see how this can be used to prepare data for matching. In addition this course introduces the participants to Oracle Enterprise Data Quality's transliteration capabilities and shows how to use and interpret results from the Oracle Enterprise Data Quality Address Verification server. Participants learn to reach a semantic understanding of free text by using the Phrase Profiler. They also learn techniques to tailor a Customer Data Extension Pack parse processor to extract, standardize and re-structure data from a free text field and also to configure the Parse processor from scratch. Brief overviews of EDQ's Customer Data Services Pack and Case Management functionality are also provided.Learn To:Configure match processors to identify and optionally merge matching recordsUse Parse processors to extract key data from free text fieldsUse the Address Verification processor and interpret its resultsStandardize data using a number of Oracle Enterprise Data Quality processorsThis course is based on Oracle Enterprise Data Quality version 12.1.3 .Live Virtual Class FormatA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Delegates will learn how to

  • Tailor parse and match processors from the Customer Data Extension Pack
  • Explain the need and uses of matching
  • Explain the need and uses of parsing
  • Use the Phrase Profiler
  • Explain the essentials of matching and parsing
  • Cofigure match processors to identify and if necessary, consolidate matching data records
  • Use the Address Verification processor and interpret its results
  • Use transformation processors to standardize data
  • Configure parse processors

Outline

Match Overview

  • Discussing Business Examples of Matching
  • About the Match Processors
  • What Constitues a Match?

Oracle Enterprise Data Quality Matching Fundamentals

  • Discussing Inputs to Match
  • About Mapping Identifiers
  • Discussing Fundamentals of Clustering
  • Setting up Simple Match Rules
  • Browsing Results

Match Rule Lists and Fuzzy (inexact) Matching

  • Using Multiple Comparisons
  • Identifying Fuzzy (inexact) Matches
  • Tuning Match Rules

Clustering

  • Clustering for Performance
  • Clustering Strategies
  • Tuning Clusters

Merge

  • Discussing Defaults for Merging
  • Merging Options

Match Review

  • Discussing Review Groups
  • About the Match Review Interface

Customer Data Extension Pack Match Processors

  • About the Match Entities processor
  • About the Match Individuals processors
  • About the Match Households processor

Match Case Studies

  • Enhancing Records
  • Describing Deduplication

Introduction to Case Management

  • Overview of Case Management

Address Verification

  • Overview of Address Verification
  • Using the Address Verification Processor
  • About Accuracy flags: Interpreting Address Verification Results

Standardizing Data

  • Overview of Standarization
  • Overview of Simple Standardization
  • About the Character Replace and Replace Processors
  • About the Pattern Transform and RegEx Replace Processors
  • About the Merge Processor
  • Overview of Transliteration Capabilities

Introduction to the Customer Data Servcies Pack

  • Customer Data Services Pack Overview

Parse Overview

  • About Business Uses of Parsing
  • Parsing in Oracle Enterprise Data Quality

The Phrase Profiler

  • Using the Phrase Profiler
  • Identifying Common Words and Phrases
  • Identifying Misplaced Data

Tailoring a Customer Data Extenstion Pack Parse Profiler- Part I

  • Understanding Tokenization
  • Using the Classify sub processor

Tailoring a Customer Data Extenstion Pack Parse Profiler- Part II

  • Using the Reclassify sub processor
  • Classification vs. Reclassification

Tailoring a Customer Data Extenstion Pack Parse Profiler - Part III

  • Using the Select sub processor
  • Using the Resolve sub processor
  • Creating Exact and Fuzzy Resolution Rules

Optional- Case Studies

  • Discussing Parse Case Study
  • Discussing Overall Enterprise Data Quality Case Study

3 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Virtual learning

Recreates a classroom experience online, enabling full interactions with the learning professional leading the course.

Find dates and prices

The course is available on 3 different dates.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.