Oracle Enterprise Data Quality: Profile, Audit & Operate

Course Fees: $2684.00 excl. GST
Printed Manual: $0.00 excl. GST
Course Duration: 2 days
Course Manual

Sorry, no course dates found

The Oracle Enterprise Data Quality course teaches the participants to import and analyse a new set of data. Participants learn about Oracle Enterprise Data Quality's user interface and how to use its profiling tools to delve into data and quickly identify inconsistencies, missing data and other problems. They learn to audit the profiled data and also to export the data.

Participants will then focus on automating data quality processes using jobs that run in batch .They will configure web services to run data quality procceses in real-time. Participants will be introduced to Oracle Enterprise Data Quality's Server Console user interface and to its Customer Data Extension Pack.They are also taught strategies to re-use their work by publishing processors, creating and importing packages and making use of Data Interfaces and Run Profiles.

This course is based on Enterprise Data Quality version 9.

Learn To:
  • Identify data problems and check data validity 
  • Import and Export data 
  • Create data quality processes and jobs to run in batch and real-time 
  • Re-use configuration in different processes
  • Business Analysts
  • Data Warehouse Administrator
  • End Users
  • Functional Implementer
  • Project Manager
  • Reports Developer
  • Sales Consultants
  • Technical Consultant
Oracle Enterprise Data Quality: Match and Parse
  • Profile data for analysis
  • Check data quality using audit processors
  • Transform data for auditing
  • Import and export data from Oracle Enterprise Data Quality
  • Automate and schedule Oracle Enterprise Data Quality processes using jobs
  • Re-use configuration with different processes and data sets
  • Describe the key features and high-level architecture of Oracle Enterprise Data Quality
Enterprise Data Quality Overview
Overview of Enterprise Data Quality and its Features
Overview of High-level architecture

Director User Interface and its Key Objects
About Process Canvas, Tool Palette, Results Browser and Project Browser
Saving Results to a Results Book
Setting up Projects, Data Stores, Snapshots and Processes

Profile
Using the Quickstats Profiler for a Fast Overview of Data
Identifying Trends with the Frequency Profiler
Examining Outliers with the Max / Min Profiler
Profiling Patterns
Assessing Record Completeness

Audit
Using Audit Processors to Check Your Data
Understanding Flags
Using Audit Processors to Branch Processes

Transform
Using Lookup and Return to Enrich Your Data
Using the Group and Merge Processor
Transforming Data to enable better auditing

Writing and Exporting Data
Using the Writer
Setting up an Export

Automated Processing: Jobs
Configuring and scheduling jobs

Re-using Your Work: Publishing, Packaging and Copying
Publishing processors
Creating and importing packages

Introduction to the Customer Data Extension Pack
Understanding the use of Customer Data Extension Pack
Installing the Customer Data Extension Pack
Examining a Customer Data Extension Pack Processor

Real-Time Processing Via Web Services
Configuring a web service within Enterprise Data Quality
Creating and testing a real-time process

Data Interfaces
Introducing Data Interfaces
Creating a data interface
Using a data interface in a process

The Server Console
Overview of the Server Console user interface
Running, Scheduling and Monitoring jobs from the Server Console user interface

Run Profiles
Overview of Run Profiles
Creating a Run Profile
Running a job with a Run Profile

Publishing to the Dashboard
Overview of the Dashboard
Configuring the Dashboard

Sampling
Sampling options

Users and Security
Overview of users and security
Configuring users and security