
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
