PM4: Master Data Management - A Best Practice Guide to Design and Implementation
Share this Session:
  Mike Ferguson   Mike Ferguson
Managing Director
Intelligent Business Strategies Ltd
 


 

Monday, April 29, 2013
01:30 PM - 04:45 PM

Level:  Intermediate


This tutorial focuses at the end-to-end implementation of master data management and tries to address the hardest problems that arise in an MDM project. It looks at the broader picture of information governance, data quality and metadata management before applying these to an MDM project. It also addresses design issues such as inbound integration of master data to consolidate master data when it is scattered across many different data sources, and the outbound synchronization of it to supply both operational and analytical systems. It also looks at master data virtualization when you have a hybrid state of some master data consolidates and some not. In particular it looks at what needs to be considered when dealing with data integration and data synchronization to achieve best practice in design and implementation. The session covers the following

  • An introduction to data governance
  • Introducing a shared business vocabulary
  • Metadata management
  • Enterprise data quality and data integration
  • The main approaches to implementing MDM
  • What kind of MDM system are you building? - a System of Record, Centralised Master Data Entry System or both
  • Understanding master data maintenance in your enterprise
  • Best practices in designing master data consolidation
    • Data capture techniques
    • The benefits of standardizing inbound data to a an MDM system
    • Should history be kept in a MDM system?
    • Approaches to cleansing, and matching
    • Consolidation vs virtualizing master data to create an MDM system
  • Best practices in designing outbound master data synchronization
    • Integrating an MDM system with an enterprise service bus for outbound synchronization of operational systems
    • Schema and integrity synchronisation problems that can occur and what to do about them
    • Conflict resolution on outbound synchronization
    • Design considerations when integrating MDM with ETL tools for synchronizing data warehouses and data marts
  • Maximising the use of data virtualization in MDM
  • The implications of switching to centralized master data entry
  • The change management program imposed by centralized master data entry


Mike Ferguson is Managing Director of Intelligent Business Strategies. An independent IT analyst and consultant he specialises in BI/Analytics, big data and data management. He has over 33 years of experience with 25 years in BI/Analytics, 34 years in Data Management, 11 years in Smart Business and 4 years Big Data Analytics on Hadoop and NoSQL. Mike works at board, senior IT and detailed technical IT levels on a strategy for BI/Analytics, technology selection, enterprise architecture, data strategy, MDM and Big Data. He has spoken at events all over the world and written numerous articles. Formerly a principal and co-founder of Codd and Date Europe Limited – the inventors of the Relational Model, a Chief Architect at Teradata on the Teradata DBMS and European Managing Director of Database Associates. He teaches popular master classes in Big Data Fundamentals, Big Data, New Technologies for DW and BI, Operational BI, Data Governance, Master Data Management, Big Data Management.


   
Close Window