Joe Garrett Inteneo Systems DAMAMN April 21 2010 What is the Data Governance Function Defines common strategies procedures standards for caring for data and making it available for use ID: 613739
Download Presentation The PPT/PDF document "Data Governance Overview" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Data Governance Overview
Joe Garrett
Inteneo
Systems
DAMA-MN
April 21, 2010Slide2
What is the Data Governance Function?
Defines
common strategies, procedures, standards for
caring
for data and making it available for use
Advises
and
Educates
about data
Monitors
/
Enforces
data and processes
Ensures
Corporate Data Resource (CDR) is formally
managed
Makes
sure data is cataloged, defined, secured, available, consistent, accurate, maintained, and documentedSlide3
Why do Data Governance?
Better decisions
Lower costs
of handling data
Higher confidence
in reporting and business intelligence data and tools
One set of numbers
Reduced time to deliver and integrate new IT solutions
Simpler data environment /
more understandable
Higher
consistency
across business areas
Faster development / more agility due to consistent and
documented data
Easier Integration
across business areas
Reduced number of data management systems and QA processes
Higher security of sensitive data
Enhanced compliance due to less redundancy
Clearer insight into business processesSlide4
DG Educates
Problem:
Sales reports by Country Show Different Dollar Amounts
Reporting System 1
Reporting
System 2
Sales
Revenue Amt (2009)
BANGLADESH
INDIA
2,200,123
CHILE CHILI
3,566,872
FREN.POLYNESIA
FRANCE
1,554,980
ITALY SLOVENIJA 7,554,825
MARTINIQUE
FRANCE
6,880,276
SLOVAKIA SLOVAK REP
4,896,823
SOUTH KOREA
KOREA
9,142,611
SWITZERLAND
GEORGIA
3,993,156
Education:
What is the definition of Country?
1 Customer located at Address in Country
2 Customer sold to by Sales Rep located at Address in Country
3 Customer buys from Distributor (Customer located at Address in Country)
etc… Slide5
DG Monitors / Enforces
Problem
: Can't report easily by Insured Name
BEFORE DG
AFTER DG
Client Name Insured Name Client Name Insured Name
ELLIS, HARRY ELLIS, MASON ELLIS, HARRY ELLIS, MASON
BRAMEL, JUNE BRAMEL, JUNE BRAMEL, JUNE BRAMEL, JUNE
LYONS, JERRY LYONS, SALLY LYONS, JERRY LYONS, SALLYWRITE, JAMES SAME WRITE, JAMES WRITE, JAMESELS, LARRY SELF ELS, LARRY ELS, LARRYEnforcement: All Insured Names will be populated – no defaultsSlide6
DG Enforcement vs Education
The BIG Question:
Is
our DG Function going to focus more on Enforcement or Education?
Enforcement
EducationSlide7
DG Enforcement vs Education
“DG slows our projects too much”
“Oh
oh
– Here comes the data cops again”
Value
Decreases over time
Enforcement
EducationSlide8
DG Enforcement vs Education
“I see how DG can help”
“I'm learning a lot about the organization”
“I still can't match up Mfg and Equipment data”
Value
levels out quickly
Enforcement
EducationSlide9
DG Enforcement vs Education
“I see how DG can help”
“I'm learning a lot about the organization”
“I was reluctant at first but it speeds up project work now”
Value Increases over time
Enforcement
EducationSlide10
DG Education with a Little Nudge of Enforcement
Problem:
Can't link Mfg and Maintenance systems to get a full picture of Mfg Cost
Manufacturing System
Factory Nm
Line
Nm Loc Nm (Area)________ Chicago CHI B1 – MFG Line 1 CHI Building 1 Chicago CHI B1 – MFG Line 2 CHI Building 1 Equipment Maintenance System Site Location Description__________
CO1CHI
CB01FL2-A77-LINE
1.1
Chicago
Bldg 1 2nd
Flr
Line 1.1
CO1CHI
CB01FL2-A77-LINE
1.2
Chicago
Bldg 1 2nd
Flr
Line 1.2
CO1CHI
CB01FL2-A77-LINE
2
Chicago
Bldg 1 2nd
Flr
Line 2
CO1CHI
CB01FL2-A77-LINE
2.1
Chicago
Bldg 1 2nd
Flr
Line 2.1
CO1CHI
CB01FL2-A77-LINE
2.2
Chicago
Bldg 1 2nd
Flr
Line 2.2Slide11
DG Education with a Little Nudge of Enforcement
Proposed Solution:
Add 1 new field to Maintenance System
Manufacturing System
Factory Nm Line Nm Loc Nm (Area
)___________________________
Chicago CHI B1 – MFG Line 1 CHI Building 1 Chicago CHI B1 – MFG Line 2 CHI Building 1 Equipment Maintenance System Site Location Description Line Nm__________CO1CHI CB01FL2-A77-LINE 1.1 Chicago Bldg 1 2nd Flr Line 1.1 CHI B1 – MFG Line 1CO1CHI
CB01FL2-A77-LINE
1.2 Chicago Bldg 1 2nd
Flr
Line 1.2
CHI B1 – MFG Line 1
CO1CHI
CB01FL2-A77-LINE
2 Chicago Bldg 1 2nd
Flr
Line 2
CHI
B1 – MFG Line 2
CO1CHI
CB01FL2-A77-LINE
2.1 Chicago Bldg 1 2nd
Flr
Line 2.1
CHI B1 – MFG Line 2
CO1CHI
CB01FL2-A77-LINE
2.2 Chicago Bldg 1 2nd
Flr
Line 2.2
CHI B1 – MFG Line 2Slide12
Data Governance Steps
Capture
Examples of Data Pain
High
Level
Survey / Score
– How Ready Is The Organization for DG?
1
Detailed
Survey / Score – Where Are We Now on DG? 2Where Do We Want to Be? What Does DG Mean To The Organization?Gain High Level Management SupportPlan and Implement A - Create Steering Committee and Working Group B - Create DG Presentation and Educate Business and IT
C - Pick First Data Set To Address
D - Continually Reassess Pain Areas
E - Continually Measure ROI
1 http://www-935.ibm.com/services/us/cio/pdf/data-governance-best-practices.pdf
2 http://www-935.ibm.com/services/uk/cio/pdf/leverage_wp_data_gov_council_maturity_model.pdf