Master Data Management with William McKnight

Learn how Master Data Management (MDM) can help improve the Productivity and Performance of your organisation.

Altis Consulting is excited to announce that William McKnight (McKnight Consulting Group, USA) is delivering a 3-day Master Data Management course in Sydney, 7-9 November 2011.

William McKnight has authored hundreds of articles and white papers and given hundreds of international keynotes and public seminars.

 This course provides a practical guide to implementing successful MDM from experience. It covers all the aspects of MDM, from justification to architecture to data management and project management.

This course gives the common process, organisational and architectural focus for building strategies and implementing MDM programs such as those that have consistently, for many years, improved the productivity and performance for clients including global corporate giants.

By attending this course you will learn:

• How MDM provides benefits to an organisation and how to justify an MDM project
• The various architectural styles of MDM
• How to incorporate syndicated data to MDM
• What MDM provides for hierarchy management and data governance
• How to improve data quality in an MDM system
• How to go to market for an MDM tool
• How to understand the workload given a tool and the requirements
• How to manage an MDM project
• All the roles and responsibilities on an MDM project
• How to manage the organisational change that occurs with MDM projects
• How some other companies effectively did MDM.

Who Should Attend the Master Data Management Course?

• Business Analysts
• Chief Information Officers
• Data Administrators
• Data Architects
• Data Modelers
• Data Stewards
• Database Administrators
• Database Designers
• Enterprise Architects
• Information Technology Leadership
• Project and Program Managers
• Systems Analysts

Course Details

Master Data Management Course

Nov 7-9, 2011

Vibe Hotel 
111 Goulburn St

Sydney

Altis have negotiated a special room rate. To take advantage of the offer, you can contact Vibe Hotel directly (+61 2 8272 3300) and quote “Altis Consulting”.

For more information, please email us at training@altis.com.au.

Master Data Management Full Course Outline

MDM Overview

• What is MDM?
• Typical MDM Subject Areas
• Modes of MDM Operation
• The MDM Journey
• Challenges to Implementing MDM
• Tangible Deliverables of MDM
• MDM is Getting Mainstream Recognition

MDM Justification

• The process of master data management justification
  • Types of Justification: Program vs. Project
  • Tangible vs. Intangible Metrics
  • Probability Distribution and Risks
  • Master Data Management Costing
  • Program governance and long-term planning
• Return on Investment
  • Return on Investment Formulations
  • Return on Investment Examples
• Investments in MDM
  • Ordered Benefits
  • Variations on a Theme
  • Business Case Examples
  • Enterprise Subject Areas
  • How to Attain Business Qualification

MDM Architecture

• Architecture Approaches
  • Information Architecture
  • Master Data Landscape
  • Data Warehouse as Master
  • Separate MDM Hub
  • Synchronization
  • Pros and Cons of the Approaches
  • Hybrid Architecture
  • Architectural Guidelines
  • Wither the Data Warehouse?
• Conforming Dimensions for the Enterprise
  • Conformed Dimensions in the Data Warehouse
  • Elements of a Master File
  • Model Development: Common Semantics
  • Working with Pre-Built Data Models
• Business Process Workflows
  • Workflow Components
  • Sample Workflows
  • Organizational MDM Program Components
  • Roles & Responsibilities of the Data Steward
  • Common Tasks of the Data Steward
  • Business Participation
• Hierarchy Management
  • Different types of hierarchies
  • Managing the hierarchy
  • Example hierarchies
• Customer Data Integration
  • Focus on the Customer Master
  • Customer Lifetime Value
  • ROI for CDI
  • Targeted Marketing
  • Marketing Expense Reduction
  • Churn Management
  • Periodic Recalculation

Master Data

• Data Modeling
  • Configuring the model
  • Choosing an approach
  • Building the MDM data model
  • Updating the data model

• Data Security
  • Data Security Requirements
  • Secure Hypertext Transfer Protocol
  • Encryption
  • Lightweight Directory Access Protocol
• Syndicated Data
  • Why Do We Need Syndicated Data?
  • What is Syndicated Data?
  • Reverse Append
  • Matching and Consolidation
  • Syndicators
  • Data Available from Syndicators
  • Architecture Best Practices
  • Derivation and Quality
  • Syndicated Sourcing
  • Questions for Syndicators
  • Score the Match
• International Data
  • Character Sets
  • International Address Handling
  • Multiple Currencies

Data Quality

• Data Quality Methodology
  • Define the Quality Expectations
  • Profile Data Against the Defined Expectations
  • Data Quality Scoring
  • Measure Data Quality Impact Across Various Thresholds
  • Improve Quality of Data and Improve the Business
  • Iterate Data Quality Improvement
• Data Quality Rules
  • Data Correctness
  • Data Integrity
  • Data Quality Rule Categories

MDM Tool Selection

• Tool Functionality
  • Data Management
  • Data Integration
  • Data Access
  • Data Governance
  • Data Quality
• Request for Information and Request for Proposal
  • Shortlist
  • Vendor Profiles
  • Relevant Dimensions of Requirements
  • Shop Considerations
  • Less Important
  • Best Practice Recommendations
  • Ground Rules for Success
• Proof of Concept and Final Selection
  • Best Practice Recommendations
  • Sample Scoring
  • Customer Scenarios
  • Product Scenarios
  • Other Scenarios
• MDM Software Pricing
  • Costing Models
  • Sample Prices
  • Maintenance Costing
• Marketplace Review
  • Oracle
  • IBM
  • Others – overview

MDM Project Management

• Agile Methodology
  • Balancing a Methodology: Lasting Architecture, Fast Business Results
  • Unbalanced Heavy Methodology: Excessive Overhead and Costs
  • Unbalanced Light Methodology: Excessive Breakage and Rework
  • Balanced, Agile Methodology
  • Agile Results and Takeaways
• Project Phases
  • Planning Phase
  • Design Phase
  • Test Strategy
  • Data Migration Plan
  • Non-Functional Requirements
  • Functional Design
  • Development Phase
  • Integration Phase
• MDM Project Roles and Responsibilities
  • Project Sponsor
  • Program Manager
  • Business Analyst
  • Lead Architect
  • MDM Architect
  • MDM Developer
  • MDM Database Administrator
  • MDM QA Analyst
• Data Governance
  • The contributions of each level of the business to data governance
  • Aligning governance with business strategy
  • Building a business case for data governance
  • The role of governance in technology domains of business intelligence and master data management
  • Improving corporate data quality through data governance
  • Extending data governance across the enterprise
• Documenting Information Management Projects
  • Non Functional Requirements
  • Decisions Capture
  • Logical Data Model
  • Interface Specification
  • Startup Plan
  • Data Access Specification
• Organisational Change Management
  • OCM Guiding Principles
  • Stakeholder Analysis determines who will be affected by the change
  • Post-Implementation Job Roles specifies how jobs will be changed
  • Training Development and Delivery transfers the knowledge required
  • Deployment Preparation ensures the organization is ready to manage the implementation
  • Communications Planning ensures continual communication with the affected parties

Case Study

• Company Environment
• Reference Data
• Project Objectives
• Project Justification
• Project Timeline
• Project Challenges
• MDM Environment
• Lessons Learned
• Next Steps

William McKnight, McKnight Consulting Group

William McKnight functions as Strategist, Lead Enterprise Information Architect, and Program Manager for sites worldwide utilising the discipline of master data management. Many of his clients have gone public with their success stories.

Download the Master Data Management with William McKnight brochure for full details and course outline.