implementing kpi reporting in the college of lsa rob wilke nick hadwick
TRANSCRIPT
![Page 1: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/1.jpg)
Implementing KPI Reporting in the College of LSA
Rob WilkeNick Hadwick
![Page 2: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/2.jpg)
• Our Data Environment• LSA in Context• KPI Development Process• System Demo• How used• Technical Infrastructure• Challenges encountered• Future Directions
![Page 3: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/3.jpg)
BI: Data -> Information ->Knowledge -> Action
![Page 4: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/4.jpg)
UM Data EnvironmentThousands of tables in PeopleSoft
Large datasetsPersonal data table – 2.3 million rows
Admissions Program table – 2.3 million rows
Student Enroll table – 6.7 million rowsJob table – 1.4 million rows
Pay Check table – 8.5 million rowsDept table – 20,000 rows/3700 distinct
DeptIDs
![Page 5: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/5.jpg)
LSA:UMDistinct DeptIDs - 144:3700
Student Enrollments – 3.8 million:6.7 million
![Page 6: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/6.jpg)
College of LSA• ~ 40 Academic Depts/Programs (3 Divisions – Humanities, Social
Sciences, Natural Sciences)
• Museums
• Michigan Learning Communities
• Student Support: Advising, Language Resource Center, Science Learning
Center, Study Abroad
• Dean’s Office
• 80% of Budget is Salary/Benefits
![Page 7: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/7.jpg)
Heterogeneous Organization
• What to measure?• Can you compare the Exhibit
Museum with the English Department?
• Why did we develop the KPI measures?
![Page 8: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/8.jpg)
LSA KPI History
• New Dean and Associate Deans• “Provost Indicators”– Student Headcount, Diversity– Faculty Appointments
![Page 9: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/9.jpg)
Charge
“Work within the realm of information we’re already producing to make information useful for planning at the Associate Dean and Executive Committee level that will show changes in the College over time and project to the future.”
![Page 10: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/10.jpg)
Goals
• Clear, Consistent and shared measures
• Benchmarks to help think about resource distribution in the College
• Not be reliant on self-reported data by departments
![Page 11: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/11.jpg)
Principal Data Areas
• Faculty/Staff – Counts and Characteristics• Graduate Student Characteristics• Funding• Space and Energy Utilization• Student Credit Hours• Degrees• Relationships between Inputs and Outputs
![Page 12: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/12.jpg)
Development Process
• Top down mandate from upper management• Modeled after Provost Indicators• Push detail down to departmental level• Team of Finance, Budget and IS personnel• 2 year trial period with departments• Incremental changes to add/subtract measures• Initial system was a Spreadsheet and PDF File
![Page 13: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/13.jpg)
System Demonstration
http://www-a1.lsa.umich.edu/AdminData/KPIDeptCompare.aspx
![Page 14: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/14.jpg)
0100200300400500600700800
2002 2003 2004 2005 2006
Student Credit Hours per FTE
Visualize Trends
![Page 15: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/15.jpg)
100
150
200
250
300
350
400
450
2002 2003 2004 2005 2006
Student Credit Hours per FTE
Visualize Trends
![Page 16: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/16.jpg)
Decision Making
Student Credit Hours/TTFTEComputed Course Releases/TTFTE% Small Sections% Over or Under Target
Faculty lines (Resource Commitment)Position requestsGSI, grader and fellowship fundingLecturer positions
![Page 17: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/17.jpg)
Technical Environment
• SQL Server 2000 database – 3 tables• IIS Web Server• ASP.Net 2.0 Development Environment• Originally Excel with Macros
![Page 18: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/18.jpg)
Tables• Header– Key, Description, URL, DisplayOrder, Page,
Classification (Profile, Indicator, Outline Separator)
• Data– Key, DeptID, Year, Data value
• Notes– Key, Title, Note content
(Notes and Header tables include HTML stored with data)
![Page 19: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/19.jpg)
Sample dataKPICode DeptID AcadYear KPIValue
1A 172000 2002 31.5
1A 172000 2003 32.5
1A 172000 2004 33.5
1A 172000 2005 31.5
1A 172000 2006 30.25
1A 172000 2007 30.25
1A 172000 2008 32
1B 172000 2005 25.52
45,000+ rows
![Page 20: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/20.jpg)
Data must be pivoted
![Page 21: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/21.jpg)
![Page 22: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/22.jpg)
Challenges• Inconsistent Source Data• Lack of Understanding of Source Data• Source Data Not Reflecting “Reality”• Numeric Values only• Making Assumptions Transparent• Conflicting Indicators• Minimizing # of Indicators• Communicating Context to Depts
![Page 23: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/23.jpg)
Future Direction
• Create Charts on the fly• Drill down to see detail• “Top 10” lists of key values• Additional Research Indicator
![Page 24: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/24.jpg)
Terminology Check
1. Key result indicators (KRIs) tell you how you have done in a perspective.
2. Performance indicators (PIs) tell you what to do.
3. KPIs tell you what to do to increase performance dramatically
David Parmenter, Key Performance Indicators
![Page 25: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/25.jpg)
Key Performance Indicators
"KPIs represent a set of measures focusing on those aspects of organizational performance that are the most critical for the current and future success of the organization."
![Page 26: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/26.jpg)
Key Result Indicators
“KRIs typically cover a longer period of time than KPIs; they are reviewed on monthly/quarterly cycles, not on a daily/weekly basis as KPIs are.”
![Page 27: Implementing KPI Reporting in the College of LSA Rob Wilke Nick Hadwick](https://reader035.vdocuments.us/reader035/viewer/2022062712/56649ca75503460f94969093/html5/thumbnails/27.jpg)
Ask the Right Questions
“Rarely is the question asked, is our children learning?”