Implementing MDM for BI Data Integration by

Implementing MDM for BI & Data Integration by Kabir Makhija

What’s the holdup?

What is Master Data? Any enterprise has 6 mutually exclusive, collectively exhaustive (MECE) types of organizational data, which are: Type 1) Transaction Structure Data – Dimensional context to business transactions. Eg: Products, Customers, Departments etc. Type 2) Enterprise Structure Data - Inter-relationships between organization elements. Eg: Chart of Accounts, Org Structure, Bill of materials, etc. Typical understanding of “Master Data” Holistic view of “Master Data” Type 3) Reference Data - Set of codes, typically name-value pairs that drives business rules. Eg: Region Codes, Customer Types etc. Type 4) Transaction Activity Data - These are the transactions themselves. Eg: Purchase Order data, Sales Invoice data etc. Type 5) Metadata – Data about Data Type 6) Audit Data – For Compliance Comprehensive view of “Master Data” encompasses Transaction Structure Data, Enterprise Structure Data and Reference Data.

Master Data Management Master data management (MDM) enables dependable cross-system, enterprise-wide business processes and analytics – ensuring that everyone involved in the process has access to the same information and knowledge MDM is the opportunity to: • Implement a data integration platform that can access the facts about core business entities from anywhere in the enterprise • Automate the creation of a single logically correct view, based on business rules that agrees with the facts in the real world • Deliver that high quality master data to the current suite of business applications in real time

Customer FAQ • What is MDM ? • How to get started ? • Who are the vendors ? • How do the products compare ? • What is the ROI ?

System Integrator FAQ • Does the organization consider data governance as a nice to have or must have ? • How does the client rate the current Data Quality ? • What is the current solution in place ? • Is an enterprise data model available ? • Operational and / or Analytical MDM ? • Is there a service oriented architecture ?

Business Drivers • Runaway Costs • Missed Revenue Opportunity • M & A Integration • Support existing initiatives • Regulatory Pressures

MDM – Critical Leverage Points MDM is not just Technology – Process Institutionalization is critical Keeps Evolving over time - MDM systems are dynamic in nature MDM is at the heart of business decisioning – Needs “Total Alignment” with corporate vision Data Management & Governance is crucial for Business Buy-in Organization should be geared for “Change” – Cultural issue

Challenges Vs Solutions MDM Vendor Offerings • CDI / PIM • DQ • ETL Enterprise Challenges • • Scoping Data Governance Organization Culture Prioritization

Technology Solutions Enterprise Solutions • Enterprise Data Warehouse (EDW) • Data Federation • Customer Relationship Management (CRM) • Enterprise Resource Planning (ERP) Domain Specific Solutions • Customer Data Integration (CDI) • Product Information Management (PIM)

Implementation Styles q Single Physical Data Store Approach – Single consolidated master data store that contains master data from multiple source systems – Latency depends on whether batch or on-line data consolidation is used, and update frequency q Federated Approach – Virtual business view of the reference data in source systems is defined. Used by business applications to access current master information – May employ a metadata reference file to connect related master information together based on a common key q Hybrid Approach – Combines data consolidation and data federation approach – Common master data (name, address, etc) could be consolidated in a single store, but master data unique to a specific source application (customer orders, for example) could be federated. – This hybrid approach can be extended further using data propagation

Customer Data Integration Multiple & Federated Data Sources • Standardization of different sources that store data in different formats • Integration of data from multiple data sources • Consolidating diverse data integration tools • Global time synchronization in multi-geography systems • Identification of common batch windows for extraction and processing Data Cleanliness & De-Duplication • Conversion from free form text of Source systems • Cross-organization data standardization • Geo-coding and cleansing • Consumer data de-duplication - Identify a customer uniquely across organization - Identify the parameters for house-holding - Defining survivor and merge rules

Product Information Management Data Source / Domain Data Completeness & Validity • Standardization of data source format and layout across the multiple regional databases • Master data completely updated with all regional data • Consistency of data type and allowable range of values • Checks and balances to ensure that source - regional data and regionalmaster data match • Seamless handling of changes to data attributes • Master database is maintained with integral data • Reusable framework for implementing new data sources and regional databases • Setup and Maintenance of Validated meta data Data Lifecycle Management • Maintenance of obsolete data from source system in the master Data Management • Optimal storage mechanisms and capacity planning for regional and master databases • Tracking and handling of bulk movement of data between departments • Efficient data roll-up decisions for SKU realignment- SKU to department or brand can be automatically realigned & SKU orients under the brand • Efficient historic treatment of changing data • Reduced Data mismatch with respect to SKU realignment

BI Solution Architecture

Deployment Framework

Steps in a MDM Implementation q Identify sources of master data q Identify the producers and consumers of the master data q Collect and analyze metadata about for your master data q Appoint data stewards q Implement a data-governance program and data-governance council q Develop the master-data model q Choose a toolset q Design the infrastructure q Generate and test the master data q Modify the producing and consuming systems q Implement the maintenance processes

MDM Maturity Levels Level 1 • Data Integration with minimal focus on DQ Level 2 • Managing basic Data Quality Level 3 • Master Data within Silos Level 4 • Enterprise Master Data for a single domain Level 5 • Cross-Enterprise Master Data for multiple domains

Marketplace Mega Vendors Pure Play Data Quality IBM Siperian Data. Flux Oracle Kalido Trillium SAP Initiate Informatica Microsoft Purisma Netrics Teradata, TIBCO, etc One. Data, Acxiom, etc Pitney Bowes, Zoomix, etc

Thank You Research Credits : Hexaware BI & A team