Application Data Management vs Master Data Management
ADM v MDM Application Data Management versus Master Data Management
Kristian Kalsing | Winshuttle
The Data Steward Goals Enable the business to operate efficiently with minimal disruption
Ensure compliance and auditability of business processes
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
2
The Data Steward Profile Business
Decentralized
Operational
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
IT
Centralized
Strategic
3
The Data Steward Responsibilities Operational
Tactical
Strategic
• • • • •
Monitor incoming request queue Debug and fix data-related issues - firefighting Fulfil ad-hoc requests for data maintenance Fulfill requests for data reports Meet published SLAs
• Maintain and manage data rules • Extract and profile data • Data cleansing and planned maintenance
• • • •
Participate in business process improvement Drive data improvement initiatives Knowledge management Evangelize the strategic importance of data
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
4
What is Master Data?
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
5
Application Data versus Master Data Material
Customer
Vendor
Master Data Shared across many different applications
Material Number Description Etc.
Name Address Etc.
Name Address Etc.
Application Data Used only by a specific application (e.g. SAP)
Storage bin Routings Classifications Forecast params Etc.
Bank details Info records Sales org Etc.
Payment terms Info records Purchasing org Etc.
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
6
Three Rings of Information Governance
Master data Application suite data Single-application data WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
7
Three Layers of Government
Money printing Army and navy Treaties with foreign govs Driver/marriage licenses Intrastate commerce Public health and safety Education, police, fire Urban planning/zoning Parks and recreation WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
Federal State Local 8
The Bloated MDM Hub Without a clear distinction between Application Data and Master Data, the risk is that your MDM hub will develop into a bloated data model. Only 8-10% of data needs to be mastered. However, the rest still needs to be governed and managed.
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
9
Example: Multi-national Manufacturing & Engineering Customers
MDM
Line of Business
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
Line of Business
Finished Goods
Components
Raw Materials
Finished Goods
Components
Raw Materials
Finished Goods
Components
Raw Materials
ADM
Vendors
Line of Business
10
Different Needs, Different Capabilities What capabilities does a Data Steward need for ADM versus MDM?
ADM
MDM
Governance model
Decentralized
Centralized
Owner
Business
IT
Enabler for
Business processes
Business intelligence
Data model
Pre-existing
Designed ground up
Integrations with other systems
Few
Many
Local variations
Many
None
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
11
Key Takeaways • Data Stewards are responsible for accuracy and completeness of data. • Use Gartner’s Three Rings of Information Governance to distinguish between Application Data and Master Data
• Only 8-10% of data needs to be mastered in a hub. The rest is Application Data requiring a different governance model and different capabilities allowing for local optimization
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
12
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
13
Kristian Kalsing | Winshuttle
The Data Steward Goals Enable the business to operate efficiently with minimal disruption
Ensure compliance and auditability of business processes
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
2
The Data Steward Profile Business
Decentralized
Operational
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
IT
Centralized
Strategic
3
The Data Steward Responsibilities Operational
Tactical
Strategic
• • • • •
Monitor incoming request queue Debug and fix data-related issues - firefighting Fulfil ad-hoc requests for data maintenance Fulfill requests for data reports Meet published SLAs
• Maintain and manage data rules • Extract and profile data • Data cleansing and planned maintenance
• • • •
Participate in business process improvement Drive data improvement initiatives Knowledge management Evangelize the strategic importance of data
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
4
What is Master Data?
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
5
Application Data versus Master Data Material
Customer
Vendor
Master Data Shared across many different applications
Material Number Description Etc.
Name Address Etc.
Name Address Etc.
Application Data Used only by a specific application (e.g. SAP)
Storage bin Routings Classifications Forecast params Etc.
Bank details Info records Sales org Etc.
Payment terms Info records Purchasing org Etc.
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
6
Three Rings of Information Governance
Master data Application suite data Single-application data WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
7
Three Layers of Government
Money printing Army and navy Treaties with foreign govs Driver/marriage licenses Intrastate commerce Public health and safety Education, police, fire Urban planning/zoning Parks and recreation WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
Federal State Local 8
The Bloated MDM Hub Without a clear distinction between Application Data and Master Data, the risk is that your MDM hub will develop into a bloated data model. Only 8-10% of data needs to be mastered. However, the rest still needs to be governed and managed.
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
9
Example: Multi-national Manufacturing & Engineering Customers
MDM
Line of Business
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
Line of Business
Finished Goods
Components
Raw Materials
Finished Goods
Components
Raw Materials
Finished Goods
Components
Raw Materials
ADM
Vendors
Line of Business
10
Different Needs, Different Capabilities What capabilities does a Data Steward need for ADM versus MDM?
ADM
MDM
Governance model
Decentralized
Centralized
Owner
Business
IT
Enabler for
Business processes
Business intelligence
Data model
Pre-existing
Designed ground up
Integrations with other systems
Few
Many
Local variations
Many
None
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
11
Key Takeaways • Data Stewards are responsible for accuracy and completeness of data. • Use Gartner’s Three Rings of Information Governance to distinguish between Application Data and Master Data
• Only 8-10% of data needs to be mastered in a hub. The rest is Application Data requiring a different governance model and different capabilities allowing for local optimization
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
12
WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016
13
