群邑中国主数据管理方案

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
MDM Business Opportunity/Needs
Data governance and Quality assurance to be improved. – Encounter Quality issue when it comes to use master data.
Sample (Inconsistent payment term between Minder and Adept)
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 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)
– 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?
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)
Manually Automatically Automatically (Finance) Automatically (Media) Automatically (HR / Admin)
User
Finance Domain
Domain?
HR/Admin Domain
Governance & Quality Standards & guideline
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
PeopleSoft
Minder
CDCI
Others
(MF,MMS…)
Adept
Admin
Too much manual work involved, human error is inescapable If information inconsistent between systems, which system own the right information?
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
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.
– 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
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
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
Duplicated efforts to do data profiling, data cleansing, data mapping when comes to data warehouse.
Do ETL(huge effort) for master file in each system one by one
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
Minder
Adept
MDM Business Opportunity/Needs
Data governance and Quality assurance to be improved. – Encounter data governance issue when it comes to use master data.
ຫໍສະໝຸດ Baidu
– Core in Enterprise Information Management
MDM Conceptual Solution
Centralized Master Data, one time input effort and push to all systems
Online Application
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
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:
MDM Business Opportunity/Needs
• Input duplicated master data in multi-systems. • Master data mapping with other relevant systems in every system. • Duplicated efforts to do data profiling, data cleansing, data mapping when comes to data warehouse. • Data governance and Quality assurance to be improved. • Benefit from eApproval.
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)