Informatica Data Analyst 9.6

Instructor-led | Data Quality | 2 Days (50% lecture, 50% hands on lab)

Informatica Data Analyst 9.6

Course Overview

This two day, instructor-led course introduces the student to the Informatica 9.6 Analyst tool through lecture and hands-on exercises. The course is designed for business users and data stewards who are new to the Informatica Data Quality Analyst tool. Informatica Analyst is a web-based application client that analysts can use to analyze, profile, and score data in an enterprise. The course will familiarize students with the Analyst Tool and method of understanding the data set by creating projects and objects, profiling data and identifying anomalies. It will demonstrate how to use profiling results to understand relationships between tables and files, build Reference Tables and Scorecards, as well as how to collaborate with Developers across projects, platforms and technologies, boosting productivity and eliminating errors. The student will also learn how to manage Exceptions and Duplicate record tasks.

Objectives

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

Navigate through the Analyst Tool
Creating projects and setting permissions
Physical and Logical data objects
Perform Column and Rule Profiling

Apply prebuilt and custom built Rules

Apply Filters and Comments to objects in the project

Apply rules in Mapping Specifications
Create and Manage reference tables (RTM)
Rule Specifications
Collaborate on projects using comments
Perform Data Quality Scorecarding
Task Management

Target Audience

New users of Data Quality 9.6, including Business and Data Analysts and Data Stewards.

Prerequisites

Windows GUI

Agenda
1. Informatica Data Analyst 9.6 An introduction into the process and theory of Data Quality 2. Data Objects Create projects and assign permissions Explain the types of Data Objects that can exist in Informatica 9 Be able to import flat files and relational table physical data objects Data access and preview 3. Profiling, Mapping Specifications, Rules and Collaboration Introduction to Profiling Column and Rule Profiling in Informatica Analyst o Interpret Profiling results Drill down on the underlying data o Comment profiling results Building a Mapping Specification Rule Profiling Apply Prebuilt and Custom built Rules Apply rules to Mapping Specifications Project Collaboration Data Domain Discovery in the Analyst Tool	4. Reference Table Management Describe reference tables Create Reference Tables using the Reference Table Editor and the import flat files option Create Managed and Unmanaged Reference Tables o Edit and update reference tables Auditing of changes 5. Rule Specifications Convert business rules into logical objects that analyze business data Observe the use of Rule Builder to design and store business rule objects in a software environment Demonstrate use of Reference Tables with a Rule Specification Demonstrate use of Rule Specification outputs (mapplets) within a profile Informatica Developer users connect the objects to the business data sources and run the objects on the data 6. Scorecarding Understand how to build and configure a scorecard by applying Pre-built rules Specify valid column values 7. Task Management Manage Exception Records Consolidate Duplicate Records


Back to Course Overview

QUESTIONS?

Work Email:

First Name:

Last Name:

Company:

Phone:

Country:

Yes, I would like to receive communications from Informatica about products, solutions and events.

Lead Source:

Lead Source Campaign:

Employee Range:

Revenue Range: