Master Data Management Assessment

The Impact of Master Data Management (MDM)

Data Assessment Framework

MDM Assessment Requirements

  • Incomplete, inconsistent, duplicate data
  • Do not have reliable, 360-degree or complete view of a customer/supplier
  • Incomplete view undervalues high-value relationships
  • Not able to make relevant cross-sell/up-sell recommendations
  • Lack of data foundation or governance to go digital
  • Too expensive to identify and attract new customers/markets
  • Match / Merge Analysis
  • Decide High Level Technical Architecture
  • Design Conceptual Data Model

MDM Assessment Approach

Access Capabilities

  • Ability to access source systems such as
    • Relational databases (Oracle, SQL Server, DB2, PostgreSQL etc.)
    • Mainframes (Db2 for z/OS)
    • Big data platforms (Cloudera, Hortonworks, MapR, HDInsights)
    • Flat Files

Analyze Capabilities

  • Column Profiling for gathering statistics such as
    • Value Frequency and Pattern
    • Null and Distinct value ratios
    • Max and Min values
  • Definition of match/merge rules
  • Displaying match score
  • Ready to use reports to deep-dive insight

Design & Architect Capabilities

  • Decide Different Deployment Model
  • Design Conceptual Data Model
  • Decide High Level Technical Architecture
    • Inbound / Outbound
    • Integration Method
    • Data Flow