Data Quality: Advanced Techniques Training Course

Module 1: Course Introduction

• Introduction, Agenda, and Overview of the Course

Module 2: Developer Review & Join Profiling

• Review of Informatica Developer functionalities
• Utilization of Enterprise Discovery to establish Join Profiles for government data environments
• Lab: Execution of Join Profiling via an Enterprise Discovery Profile

Module 3: Standardizing and Classifying Data

Module 4: Advanced Parsing Techniques

• Definition and scope of Probabilistic Labeling and Parsing
• Development, refinement, and application of a Probabilistic Model
• Additional Parsing Techniques:
  • Construction of regular expressions for data integrity
• Labs: Development, refinement, and application of a Probabilistic Model for government systems
• Lab: Review of an Advanced Parsing example within a federal context
• Lab: Generation and testing of Regular Expressions

Module 5: Grouping & Matching Data

• Additional Grouping Techniques
  • Application of Composite keys for government data organization
• Advanced Matching Techniques
  • Output handling for Matched pairs
  • Operation of Match Mapplets in federal workflows
  • Data manipulation via Driver ID identifiers
  • Execution of Dual Matching processes
• Lab: Creation of a Match mapping utilizing Matched Pairs for government data
• Lab: Construction and update of a Match Mapplet
• Lab: Manipulation of Matched Data using the Driver ID
• Lab: Execution of Dual Matching using a Master Dataset

Module 6: Automatically Associate and Consolidate Matched Data

• Overview of the Data Consolidation Process for government operations
• Utilization of the Consolidation Transformation to aggregate matched data.
• Application of the Association Transformation to link matched data prior to consolidation.
• Lab: Automated consolidation of matched data within federal systems
• Lab: Execution of multi-criteria Matching, Association, and Consolidation for government requirements.

Module 7: Task and Workflow Management

• Advanced Task and Workflow functionality:
  • Permission configurations for secure data access and editing in government environments
  • Notification protocols, including Human Task Notification Variables
  • Configuration of Workflow Timeouts
  • Review procedures for government tasks
  • Configuring Workflow Recovery mechanisms
• Lab: Update of the Exception Workflow for federal applications
• Lab: Review of the Consolidation Workflow in government contexts

Module 8: Processing Updated Exception and Cluster Data

• Procedures for processing updated exception records
• Procedures for processing consolidated records
• Identification of Fields of Interest for government reporting
• Lab: Creation of a mapping to process updated exception data
• Lab: Creation of a mapping to process consolidated data
• Lab: Update and deployment of Exception and Cluster Workflows

Module 9: Analyst Tasks

• Update of exception and duplicate records within Informatica Analyst for government use
• Lab: Record updates and task progression through the Exception Process
• Lab: Record updates and task progression through the Consolidation Process

Module 10: Parameterization

• Differentiation between System and User-defined parameters in government software
• Application of Parameters in Data Quality mappings.
• Lab: Creation of a parameterized mapping for federal systems
• Lab: Construction and deployment of an Application
• Lab: Creation and execution of parameter files for government operations

Module 11: Performance tips and tricks

• General Installation and Memory Optimization Information
• DQ Component Configuration
  • Service Settings for federal infrastructure
• DQ Transformations
  • Configuration Settings for government performance standards

Module 12: Optional - Data Quality at work

• Analysis of Data Quality implementation across various federal projects

Module 13: CRM and Dashboard and Reporting Templates

• Review of available CRM, Dashboard, and Reporting Templates for government agencies
• Lab: Review of the CRM Template for federal use cases