Minder
PeopleSoft
Adept DW / BI
Master Data Repository
CDCI Others
(MF,MMS…)
MDM Architecture
(GroupM Global IT Solution)
MDM is not easy
MDM-Ecosystem
MDM Approach
MDM Business Case
Core in Information/Enterprise Data Management
Business Case
Summary
– Improved Data Quality and improvements in Data Governance – Prerequisites for Data warehouse (Enterprise Data Level)
Master Data Management (MDM)
Concept Design
Agenda
• MDM Business Opportunity/Needs • What’s Master Data Management?
• MDM Objective
• MDM Business Case • MDM Conceptual Design • MDM Approach
Manually Automatically Automatically (Finance) Automatically (Media) Automatically (HR / Admin)
User
Finance Domain
Domain?
HR/Admin Domain
Governance & Quality Standards & guideline
– Part of MDM features and few master data have been implemented in eApproval, benefit of efficiency and data quality are well-known.
What’s Master Data Management?
CDCI Client Code in Minder
PeopleSoft
Adept
Others
It is hardly to get complete information from one place Maintain information is difficult
MDM Business Opportunity/Needs
Media Domain
Check & Submit by Finance Admin
Check & Submit by Media Admin
Check & Submit by HR/Admin Admin
Governance & QA (Domain Admin)
Interface(APP+DB) Management Module Interface(APP+DB)
Master Data Management is a framework of processes and technologies aimed at creating and maintaining an authoritative, reliable, and sustainable, accurate, and secure data environment that represents a “single version of truth,” an system of It’saccepted not only technologies record used both intra- and interenterprise across a diverse set of application systems, lines of business, and user communities.
MDM Business Opportunity/Needs
Master data mapping with other relevant systems in every system
CDCI Minder
Client Code in Minder Adept Client Code in Minder
Benefit from eApproval
– User apply vender/ ratecard in eApproval system (online approval). – Admin check and approval in eApproval system.
– Admin can do regular vendor/ratecard quality check in eApproval through running some report or query.
MDM Business Opportunity/Needs
Input duplicated master data in multi-systems
Offline Application (hard copy)
User
Manual Input
Manual Input Manual Input Manual Input Manual Input
MDM Objectives
Logical Architecture
MDM Business Case
Improved Data Quality and improvements in Data Governance
– Reduces errors – Provides centralized clean data for the system – Establishes an authoritative single source of information – Eliminates data inconsistency and improves accuracy and consistency – Increases reporting accuracy – Provides trustworthy data – Improves data sharing – Improves data usability – Enables consistent interactions between systems – Increases the quality and reliability of data – Helps staff members use information consistently – Simplifies design by standardizing data validation – Complements a services-oriented architecture (SOA)
MDM Objectives
W hat’s in MDM? – Governance - Ownership and accountability for master data processes and data elements
– Data Management - Business process and master data procedures to create and manage master data
1. Define & Classify the Master Data entities
Entity
19
MDM Approach
2. Identify producers and consumers of Master Data
A CRUD Matrix is a simple but efficient tool to visualize the Master Data life-cycle specifying which applications (or processes) produce or consume each entity: sample as following:
– Quality Assurance - Data quality initiatives, establishment of data quality metrics, conducting quality audits – Architecture and Standards - Technology and data architecture issues, establishing data quality standards – Technology - Tools for the MDM architecture landscape
Sample (Duplicated vendor records due to multiple bank accounts for that vendor)
Same Vendor One for GroupM One for CCM
Different bank account
MDM Business Opportunity/Needs
Duplicated efforts to do data profiling, data cleansing, data mapping when comes to data warehouse.
Do ETL(huge effቤተ መጻሕፍቲ ባይዱrt) for master file in each system one by one
– Core in Enterprise Information Management