130 likes | 296 Views
Data Governance Overview. Joe Garrett Inteneo Systems DAMA-MN April 21, 2010. 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
E N D
Data Governance Overview Joe Garrett Inteneo Systems DAMA-MN April 21, 2010
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 documented What is the Data Governance Function?
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 processes Why do Data Governance?
Problem: Sales reports by Country Show Different Dollar Amounts Reporting System 1 Reporting System 2 Sales Revenue Amt (2009) BANGLADESH INDIA2,200,123 CHILE CHILI 3,566,872 FREN.POLYNESIA FRANCE1,554,980 ITALY SLOVENIJA 7,554,825 MARTINIQUE FRANCE6,880,276 SLOVAKIA SLOVAK REP 4,896,823 SOUTH KOREA KOREA9,142,611 SWITZERLAND GEORGIA3,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… DG Educates
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, SALLY WRITE, JAMES SAMEWRITE, JAMES WRITE, JAMES ELS, LARRY SELFELS, LARRY ELS, LARRY Enforcement: All Insured Names will be populated – no defaults DG Monitors / Enforces
The BIG Question: Is our DG Function going to focus more on Enforcement or Education? DG Enforcement vs Education Enforcement Education
“DG slows our projects too much” “Oh oh – Here comes the data cops again” Value Decreases over time DG Enforcement vs Education Enforcement 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 DG Enforcement vs Education Enforcement 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 DG Enforcement vs Education Enforcement Education
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.2 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 DescriptionLine Nm__________ CO1CHI CB01FL2-A77-LINE 1.1 Chicago Bldg 1 2nd Flr Line 1.1 CHI B1 – MFG Line 1 CO1CHI 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 2 DG Education with a Little Nudge of Enforcement
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? 2 Where Do We Want to Be? What Does DG Mean To The Organization? Gain High Level Management Support Plan 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 Data Governance Steps