Course Overview
About Course
Master Data Management (MDM) is a holistic discipline and technology stack designed to create and maintain a single, trusted “golden record” for critical entities—such as customers, products, suppliers, and locations—across an organization . MDM tackles common issues like inconsistent data, duplicate records, and fragmented systems through data modeling, quality profiling, matching, and governance . Core architectural patterns—hub‑and‑spoke, registry, or hybrid—enable flexible designs suited to various enterprise needs .
This 40‑hour training begins with foundational concepts, exploring MDM domains, governance, and data stewardship. It then delves into modeling complex entity relationships and hierarchies while refining data through profiling, cleansing, and standardization. Participants learn matching algorithms, de‑duplication strategies, survivorship rules, and how master data is propagated (consolidated, federated, or virtualized) across systems .
Governance modules cover compliance (GDPR, ISO 8000), policy frameworks, role-based access, and stewardship workflows. Deep dives into platforms like Informatica MDM, SAP NW MDM, Microsoft SQL MDS, and Profisee equip learners with practical system knowledge . The training wraps up with building governance dashboards, monitoring quality, and executing a capstone project simulating full lifecycle MDM implementation—from data onboarding to “golden record” activation. By the end, professionals will be equipped to design, deploy, and govern enterprise-grade MDM solutions that enhance data consistency, drive efficiency, and support regulatory compliance.
Course Syllabus
- MDM Fundamentals & Domains (4 h)
- What is MDM? Importance & benefits
- Key domains: Customer, Product, Location, Supplier
- MDM maturity models & data governance landscape
- MDM Architecture & Data Modeling (6 h)
- Hub‑and‑spoke, registry, hybrid models
- Entity‑relationship design, hierarchies & metadata-driven modeling
- Hands‑on modeling exercise
- Data Quality, Profiling & Standardization (6 h)
- Profiling datasets, identifying inconsistencies
- Cleansing, standardization, enrichment techniques
- Matching, De‑duplication & Survivorship (6 h)
- Record linkage & deduplication strategies
- Survivorship rules, merging logic and conflict resolution
- Integration & Data Propagation (6 h)
- Connectivity to source systems and syndication
- Data propagation, consolidation, federation, and virtualization
- Governance, Security & Compliance (4 h)
- Data stewardship, policies, and organizational roles
- Privacy, encryption, role-based access, GDPR, ISO 8000 . Operational vs Analytical MDM & Use Cases (4 h)
- Operational hub vs analytical usecases
- Real-world examples: CRM, supply‑chain, compliance
- MDM Tools & Platform Deep Dive (4 h)
- Overview of MDM solutions (Informatica, SAP NW MDM, SQL Server MDS, Profisee)
- Hands-on: build a model, execute matching, manage workflow
- Monitoring, Dashboards & Governance Reporting (4 h)
- Data quality scorecards, lineage & metrics
- Building dashboards for OLTP, analytics, policy compliance
- Implementation Best Practices & Capstone (4 h)
- Technology stack, project phases, change management
- Capstone: end‑to‑end MDM deployment
- Review: SLA, scalability, future trends (AI‑augmented MDM)
-
Key Features
Real-world labs: modeling, matching, stewardship
Multiple platform demos: Profisee, Informatica, SAP, SQL MDS
Governance workshops, role-play stewardship duties
Integration demos, privacy/compliance scenarios
Hands-on dashboard building and anomaly detection
Capstone project simulating enterprise MDM deployment



