Atlanta User Group Introduction to Data Quality Master

Atlanta User Group Introduction to: Data Quality & Master Data Management

Atlanta User Group Introductions Rick Lee Director Business Services and Project Delivery Richard. Lee@softpath. net Hemang Desai VP Professional Services Hemang. Desai@softpath. net John Potluri Certified MDM Professional John. Potluri@softpath. net

Atlanta User Group Today’s Agenda Introduction to Data Quality - Overview - Demo Introduction to Master Data Management - Overview - Demo Questions

Atlanta User Group Data Quality is a costly issue

Atlanta User Group What is Data Quality? Parsing Address Matching &Monitoring Data Analysis and & Validation. De-duplication & Discovery Standardization Reporting

Atlanta User Group Business and IT Align to product quality Data! Data Steward ANALYZE 1. Profile Line of business manager 5. Monitor DQ goals 4. Exception management 2. Define Metrics and Rules 3. Design and Implement Data Quality Rules IMPROVE IT Developer

Atlanta User Group Data Quality Demo Profile Data Cleanse – Apply Rules Address Doctor Contact us for a demo of these features Match Monitor

Atlanta User Group Master Data Management

Atlanta User Group Master Data – What is it? Master data represents the business objects which are agreed on and shared across the enterprise. NOUNS of the business: Employees, Products, Materials/Parts, Plants, Suppliers and Customers. One Version of the Truth: Truth • Current and relevant data using CRUD • Data manage in an MDM system by Data Stewards (Not IT). • Clean, accurate and consistent data.

Atlanta User Group Master Data Management Best Version of Data • Mastering process links related entities from Different systems • Mastered Name (i. e. “Best Version of Truth”) determined based on many factors such as source system, last update time, and conformity to business rules • Data stewards can tweak or override system determined Master Name values Data & Address Standardization • Using Cleanse List or Mappings for Data Cleansing • Address Doctor software standardizes address lines/ • Missing/invalid zip codes can be corrected • Address validation score indicates deliverability of each customer address Data Governance Publishing and Distribution of Trusted Data • Multi Domain (Customer, Product, Reference, etc. ) • Data Governance using IDD – Work routed to Data Stewards • Review Data (Lineage, History) • Rules based Merging – Ability to override • Mastered data published to EDW for enterprise use • Broad range of integration options can be used to automatically propagate master data and cleansed addresses back to source

Atlanta User Group Informatica MDM Hub – Process Flow

Atlanta User Group Informatica MDM Hub – Process Flow

Atlanta User Group Informatica MDM Hub – Process Flow

Atlanta User Group Informatica MDM Hub – Process Flow

Atlanta User Group Informatica MDM Hub – Process Flow

Atlanta User Group Informatica MDM Hub – Process Flow

Atlanta User Group MDM User Interfaces

Atlanta User Group MDM Capabilities - Summary

Atlanta User Group Questions Rick Lee Director Business Services and Project Delivery Richard. Lee@softpath. net Hemang Desai VP Professional Services Hemang. Desai@softpath. net John Potluri Certified MDM Professional John. Potluri@softpath. net