Class Title
Data Governance – Can It Help? Presented by: Lorinda L Bishop University of Toledo Director of Project EntERPrise University Registrar
AACRAO 2008 March 30, 2008
1
Introduction Do you have a Data Standards Manual? – Is it followed?
Have you ever been asked to write a report? – Ever hear YOUR results were wrong?
Does the same Department over and over enter inaccurate information? – Does staff just ignore the procedures?
Are you a part of the duplicate clean up process? March 30, 2008
2
Agenda Slide Data Governance – History of our installation Data Warehouse(really ODS) Data Standards Committee
– What is Data Governance? – University of Toledo’s Organization Front-line staff accountability
– Duplicate Process Not automated March 30, 2008
3
History University of Toledo’s Installation
March 30, 2008
4
University of Toledo SIS, HRS, FRS Plus – Created in house relational tables for reporting Our own Data Warehouse but was really an ODS
ERP initiated 2003 – Collaborated with other institutions on the Advantiv Study
Banner Implementation – HR live April 2006 – Finance July 2007 – Student/Financial Aid - January 2008
Data Standards Committee – General and Shared Tables March 30, 2008
5
What Is Data Governance? More than a Data Standards Manual!
March 30, 2008
6
Data Governance Industry Standard Definition – The overall management of the availability, usability, integrity, and security of the data employed in an enterprise. – A sound data governance program includes a governing body or council, a defined set of procedures, and a plan to execute those procedures.
March 30, 2008
7
Implementation Steps Define Data Owners and Custodians – Owner – legally or by position responsible for the data – Custodian – responsible for accuracy, integrity and security of the data on a day to day basis
Policy Statement – Specifies who is accountable for various portions or aspects of the data, including its accuracy, accessibility, consistency, completeness, and updating.
March 30, 2008
8
Implementation Steps Process – Defining storage, archival, back ups and protection from mishap, theft or attack. – Standards for data, shared or not. – Controls and Audits
March 30, 2008
9
University of Toledo’s Organization Don’t bite off more than you can chew!
March 30, 2008
10
UT’s Process Data Standards Manual – Completed for General Person Data in time for HR – People did not follow it
Sponsor Committee Policy – Added to the Data Standards Manual – People still did not follow it
Duplicates – HR had 4 core offices entering General Information Needed specific training and they had to be held accountable. March 30, 2008
11
UT’s Process Reporting – ODS was installed and functional staff needed to define where certain data was and how it was used. – W2 process is tested to find an employee with a permanent address of Perrysburg, Ohio Pakistan Yes we have zips tied to county, city and state – Departments complaining that their employee reports are not correct Not all of my employees are listed No current job for my employee so benefits are wrong March 30, 2008
12
UT’s Process How could we get people to care? – Needed a process that involved the end-users – The process needed to reward good behavior but cause some type of pain for bad behavior
Committee structure now includes frontline not just custodians
March 30, 2008
13
Duplicates This process is NOT automated – Reports tell us when we have duplicates – Whoever entered the duplicate helps pull the 2 person records together
March 30, 2008
14
Summary Data Governance needs to be everyone responsibility Rewards and Punishments need to be in place Written procedures must be shared – We use the local help for most of ours – We have a group within the portal
High level support is needed March 30, 2008
15
Questions & Answers What have you done?
March 30, 2008
16
Thank You! Lorinda L Bishop [email protected]
March 30, 2008
17
AACRAO 2008 March 30, 2008
1
Introduction Do you have a Data Standards Manual? – Is it followed?
Have you ever been asked to write a report? – Ever hear YOUR results were wrong?
Does the same Department over and over enter inaccurate information? – Does staff just ignore the procedures?
Are you a part of the duplicate clean up process? March 30, 2008
2
Agenda Slide Data Governance – History of our installation Data Warehouse(really ODS) Data Standards Committee
– What is Data Governance? – University of Toledo’s Organization Front-line staff accountability
– Duplicate Process Not automated March 30, 2008
3
History University of Toledo’s Installation
March 30, 2008
4
University of Toledo SIS, HRS, FRS Plus – Created in house relational tables for reporting Our own Data Warehouse but was really an ODS
ERP initiated 2003 – Collaborated with other institutions on the Advantiv Study
Banner Implementation – HR live April 2006 – Finance July 2007 – Student/Financial Aid - January 2008
Data Standards Committee – General and Shared Tables March 30, 2008
5
What Is Data Governance? More than a Data Standards Manual!
March 30, 2008
6
Data Governance Industry Standard Definition – The overall management of the availability, usability, integrity, and security of the data employed in an enterprise. – A sound data governance program includes a governing body or council, a defined set of procedures, and a plan to execute those procedures.
March 30, 2008
7
Implementation Steps Define Data Owners and Custodians – Owner – legally or by position responsible for the data – Custodian – responsible for accuracy, integrity and security of the data on a day to day basis
Policy Statement – Specifies who is accountable for various portions or aspects of the data, including its accuracy, accessibility, consistency, completeness, and updating.
March 30, 2008
8
Implementation Steps Process – Defining storage, archival, back ups and protection from mishap, theft or attack. – Standards for data, shared or not. – Controls and Audits
March 30, 2008
9
University of Toledo’s Organization Don’t bite off more than you can chew!
March 30, 2008
10
UT’s Process Data Standards Manual – Completed for General Person Data in time for HR – People did not follow it
Sponsor Committee Policy – Added to the Data Standards Manual – People still did not follow it
Duplicates – HR had 4 core offices entering General Information Needed specific training and they had to be held accountable. March 30, 2008
11
UT’s Process Reporting – ODS was installed and functional staff needed to define where certain data was and how it was used. – W2 process is tested to find an employee with a permanent address of Perrysburg, Ohio Pakistan Yes we have zips tied to county, city and state – Departments complaining that their employee reports are not correct Not all of my employees are listed No current job for my employee so benefits are wrong March 30, 2008
12
UT’s Process How could we get people to care? – Needed a process that involved the end-users – The process needed to reward good behavior but cause some type of pain for bad behavior
Committee structure now includes frontline not just custodians
March 30, 2008
13
Duplicates This process is NOT automated – Reports tell us when we have duplicates – Whoever entered the duplicate helps pull the 2 person records together
March 30, 2008
14
Summary Data Governance needs to be everyone responsibility Rewards and Punishments need to be in place Written procedures must be shared – We use the local help for most of ours – We have a group within the portal
High level support is needed March 30, 2008
15
Questions & Answers What have you done?
March 30, 2008
16
Thank You! Lorinda L Bishop [email protected]
March 30, 2008
17
