data governance kpis · pdf file28/02/2012 · importance of history to data...

29
Data Governance KPIs February 28, 2012

Upload: hoangtu

Post on 08-Feb-2018

212 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Data Governance KPIs

February 28, 2012

Page 2: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Goals

• Background

• Present some ideas for KPI monitoring

• Initiate dialogue and discussion

• Discuss some keys to success

Page � 2

Page 3: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Company Overview

• Schweitzer-Mauduit International, Inc.

• Manufactures and sells paper and reconstituted tobacco products to the tobacco industry, as well as specialized paper products for use in various applications.

• Operates in two segments, Paper and Reconstituted Tobacco

Page � 3

• Founded in 1520, SWM is a premier specialty company and global leader of engineered solutions for the tobacco industry worldwide.

• SWM is the largest cigarette paper manufacturer in the world• 2800+ global employees

• Sell products directly to customers in approximately 90 countries.

• Founded in 1995 and is headquartered in Alpharetta, Georgia

Page 4: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

History

Page � 4

Page 5: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Importance of history to data governance approaches

• Growth through acquisition

• Autonomous , independent mills, product lines and approaches

• Very embedded ways of doing things …. 1500s !!!!!

Page � 5

• Very embedded ways of doing things …. 1500s !!!!!

• Very little policies / governance on SWM wide initiatives.

• 2 instances of Oracle, Cognos - - Nothing standardized or consistent

Page 6: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

AS IS

Page � 6

Data, process and systems autonomy

Page 7: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

TO BE

Page � 7

Page 8: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Data governance goals

� Improve with applications and projects … not a stan d alone project- Change management issue too complex to address enterprise wide

- Too time consuming to do stand alone

- Difficult to relate by customers

� Try to integrate with existing initiatives- Lean Six Sigma - Lean Six Sigma

- “AS IS” / “TO BE” - - Cost of non compliance.. Multiple formats, excel reporting, etc.

� Involve finance in calculations for benefits, plans - We are the end of it all…. Inconsistency causes us the most pain

- Partner to calculate the benefits

- Probably the #1 success criteria

The most common objective of Data Governance progra ms is to standardize data definitions across an enterprise…. “actually more”

Page � 8

Page 9: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How we measure success?

Culture

Ownership

Page � 9

Ownership

Recognition

Data Governance is really part of building a Qualit y Culture

Page 10: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Data governance goals and approach

� Appoint global “process champions”- Process and data standardization

- 5 in total- Forecast to cash

- Finance

- Supply chain

- HR

- Manufacturing

� Standardize, simplify and improve

Page � 10

Page 11: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Metrics and KPIs

Page � 11

Page 12: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Metric priority

Page � 12

Page 13: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Policies and metrics

• Break the Data Governance Policy into discrete subp arts.

� Establish Data Governance for each subpart of The P olicy.

� Create Scorecards for Objectives that involve multi ple processes. These will be used in Management Reviews.

� Establish Metrics requirements within Operating Pro cedures that support each Objective.

� When feasible, consider establishing Dashboard requ irements within Production Procedures, Work Instructions, or Process, Material and Product Specifications for critical Me trics.

Page � 13

Page 14: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Be careful with metrics…..

Page � 14

Page 15: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How do we measure SUCCESS

Page � 15

Page 16: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How we measure success

� KPI #1:- Do customers / users not fall asleep….. Can we get time to talk about this ?

Page � 16

#1 – The “Rolling of the eyes” metric.

Page 17: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How we measure success

� KPI#2- Does any one have it as even a part of their job?

Page � 17

#2 – The “Does anybody REALLY want to work on this”

metric

Page 18: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How we measure success

� KPI #3- Can the CEO explain why it’s important in 2 sentences or less?

Page � 18

#3 – The “Elevator speech” metric

Page 19: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How we measure success

� KPI #4

- Training – is there any time dedicated to edcuation on the CONCEPT… first

Page � 19

Page 20: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Do dogs understand the concept of time?

Page � 20

Page 21: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How we measure success

� KPI #4

- Training – is there any time dedicated to edcuation on the CONCEPT… first

Page � 21

#4 – The “…Doggone Concept” metric

Page 22: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How we measure success

� KPI #5

- Training – and the procedures also.

Page � 22

#5 – The “…How do I “ metric

Page 23: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How we measure success

� KPI #6

- Can you quantify what data governance is?- How many files, records, fields etc…

Page � 23

#6 – The “Numbers are Fun” metric

Page 24: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

How we measure success

� KPI #7

- Can you priortize?... Core data elements and “non-e ssential” …

Page � 24

#7– The “Juggle ONLY what you can “ metric

Page 25: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Summary

#2 – The “Does anybody REALLY want to work on this” metric

#3 – The “Elevator speech” metric

#4 – The “…Doggone Concept”

Quality

#1 – The “Rolling of the eyes” metric.

Page � 25

#4 – The “…Doggone Concept” metric

#5 – The “…How do I “ metric

#6 – The “Numbers are Fun” metric

#7– The “Juggle ONLY what you can “metric

Quality

culture

Page 26: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

� KPI #8 If you build it will they come ?

Page � 26

#8– The “Field of Dreams”metric

Page 27: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

�Thank you

�Questions and comments

Page � 27

Page 28: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Discussion topic ?

Page � 28

Page 29: Data Governance KPIs · PDF file28/02/2012 · Importance of history to data governance approaches • Growth through acquisition • Autonomous , independent mills, product lines

Some possible things to discuss and consider

�What if data governance controls and strategies were part of SOX?- Visibility, attention, commitment,

Page � 29