master data management (mdm) - washington data management (mdm) “… a technology-enabled...
TRANSCRIPT
![Page 1: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/1.jpg)
Master Data Management
(MDM)
Potential WaTech Services
![Page 2: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/2.jpg)
Master Data
“…the consistent and uniform set of identifiers and extended attributes that describes the core entities of the enterprise including
• customers,
• prospects,
• citizens,
• suppliers,
• sites,
• hierarchies, and
• chart of accounts.”
![Page 3: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/3.jpg)
Single Client View
![Page 4: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/4.jpg)
Historical Approaches
• Master Files
• Reference Data
• Look-up Tables
• Point-to-Point Interfaces
![Page 5: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/5.jpg)
Master Data Management (MDM)
“… a technology-enabled discipline in which business and IT work together to ensure the
• uniformity,
• accuracy,
• stewardship,
• semantic consistency and
• accountability
of the enterprise’s official shared master data assets.”
![Page 6: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/6.jpg)
![Page 7: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/7.jpg)
Enterprise Context:
Master Data Fragmentation & Duplication
![Page 8: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/8.jpg)
Benefits of MDM
Managing Data As a Strategic Asset 1. Costs
• Improved error prevention– (proactive)
• Increased error detection and correction – (reactive)
• Reduced overpayments (claims/settlement costs)
2. Revenues
• Improved forecasting
• Reduced erroneous bill-backs/invoicing
• Increased confidence in analysis and reporting
3. Risks
• Quicker Integration of new systems
• Reduced fraud – improving processes and sharing across systems
• Better decision making – inaccurate information cannot support well informed decisions
4. Stakeholder Engagement
• Faster identification of challenges
• More information available when, where, and how the customer wants it
• Reputation, Increased confidence in the State/Agencies
![Page 9: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/9.jpg)
Use MDM only where it is needed NOW
![Page 10: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/10.jpg)
MDM Technology Approaches
Do It Yourself (DIY)
Purely code and database design
Hybrid, e.g. with Microsoft MDM
Domain Specific MDM products
Customer Data Integration (CDI)
Product Information Management (PIM)
Multi-Domain Master Data Management products
Market direction
Efficiencies of scale, skills
Flexibility to use data across subject areas
![Page 11: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/11.jpg)
MDM at WaTech
![Page 12: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/12.jpg)
WaTech Provides MDM Services
• Partnered with OFM on P20W Project, starting 2012
• Design/Build Longitudinal Data Warehouse (preschool through work)
• RFP for software, including robust Identity Matching
erdc.wa.gov
![Page 13: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/13.jpg)
WaTech MDM Tools, Capabilities
• Informatica suite of enterprise products • Multi-Domain Master Data Management (MDM)
• PowerCenter, Advanced Edition (ETL, data integration, data governance) • Metadata Manager, Business Glossary
• Data Quality
• Data Integration Hub (Real-time data integration)
• Related enterprise products • IBM WebSphere MQ
• Multiple database management systems
![Page 14: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/14.jpg)
Architectural Styles
• Golden Record • Latest, best version of each attribute.
• Federated, Contextual Record • Conflicting values maintained
• Third Party Data Matching Service • Send identifiers to service (e.g. WaTech)
• Get back new identifiers to contact trading partner
![Page 15: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/15.jpg)
Pricing Model: TBD
Cost factors include: • Type of service
• Data Warehouse client matching
• Third Party Matching Service
• Multiple Transactional Systems with High Availability • Would require additional investment
• Number of systems to connect
• Volume of records
• Transactional (real-time) or nightly batch
![Page 16: Master Data Management (MDM) - Washington Data Management (MDM) “… a technology-enabled discipline in which business and IT work together to ensure the •uniformity, •accuracy,](https://reader031.vdocuments.us/reader031/viewer/2022030419/5aa5f01c7f8b9a185d8dfae8/html5/thumbnails/16.jpg)
Executive Overview
• WaTech is exploring the possibility of adding MDM to our service catalog.
• When you have projects that need data to be consistent in more than one system, let us know.
Contact: Doug Buster
Data & Business Intelligence Manager