How the UW Overcame the Great Data Depression!

1. How the UW Overcame the Great Data Depression! The New Deal DGIQ Conference, June 25th, 2012 • Bill Yock • Director of Enterprise Information Services • UW IT – Information Management

2. UW a Diverse and Complex University! • Celebrating our 150th year! • Multi-campusUW Seattle, UW Tacoma, UW Bothell and a world class academic medical center • 17 schools and collegesoffer 250 degrees across 150+ programs and confer 12,000 degrees annually • 47,238 studentsand 27,900 faculty and staff • 50 centers, institutes and research operations in 20 states, and 10 countries around the world • $5.6 billion operating budget this FY 67% from tuition as UW lost half its state funding since 2009 • Over 700 Applications in our IT portfolio

3. The UW New Deal Programs • DMC • ERS • PEM • DSS • DAC • EDW • DQM

4. DMC – Data Management Committee Working hard to build a data governance foundation!

5. DMCData Management Committee Makeup Operations Meet every 2 weeks Annual assessment and review of needs Enterprise Risk Management (ERM) based approach to informed decisions • 20 plus committee members from various units (Managers, Directors and AVP level representatives) • 5 member Steering Committee (STIC) • Various Sub-committees

6. DMC – ERM Example Enterprise Risk Management involved with retaining historical data in the data warehouse • Two primary scenarios were evaluated • Historical data decentralized and deleted from EDW • Historical data centralized and retained in EDW • 6 Risk Statements were developed • Breach of PII data • Inability to analyze data historically • Etc. • ERM Framework ranks risks according to “Likelihood” and “Impact” • Likelihoods and Impacts are multiplied together to come up with a “Risk Score” for each risk statement.

7. DMC – ERM Example Enterprise Risk Management Assessment Likelihood and impact scale Likelihood and impact are multiplied to produce a level of risk

8. DMC – ERM Results Enterprise Risk Management Results • Centralizing and retaining historical data in EDW will significantly reduce risk to UW. • Risk estimated to decrease by two risk levels, or over 50%, from risk level “High” (orange) to risk level “Medium” (green). • Risk 6: Breach of PII shows most significant decrease.

9. ERS – Enterprise Reporting Service Working hard to conserve our data assets

10. ERSEnterprise Reporting Services The Enterprise Reporting Service is charged by our Provost to… • Drive adoption and implementation of performance metrics that measure the University’s strategic educational, research and service missions • Develop and implement Enterprise Reports that monitor progress towards performance targets • Deliver Enterprise Reports that assist in making key resource allocation decisions. • Centralize the production of Enterprise Reports for consistency, clarity and ease of access. • Establish necessary support and training mechanisms for interpretation and use of Enterprise Reports

11. ERSEnterprise Reporting Services Executive Sponsors Planning & Budgeting Data Custodians Data Mgmt Committee ERS Domain Leaders UW-IT Info Mgmt Data Trustees AdminUnits Deans & Academic Advisory Groups Academic Units Governance & Priority Sponsor & Support Key Stakeholders & Communication

12. PEM – Performance Evaluation Metrics Working hard to feed data to our administrators!

13. PEMPerformance Evaluation Metrics PEM Reporting is a key business imperative that… • Establishes consistent metrics for comparison across units • Defines key terms and ratios for easy analysis • Delivers data from a single central source for non repudiation • Begins to answer questions like “What are the cost drivers of delivering education to our students?”

14. PEMPerformance Evaluation Metrics Enrollments per FTE Majors per FTE Budget $ / Student Credit Hrs Taught

15. DSS – Decision Support Services Working hard to deliver data efficiently

16. DSSDecision Support Services Delivering Information for Decision Making by providing… • Business Intelligence Services • Metadata Management Services • Training and education Services • Quality Assurance Services • Data Access Control (DAC) Services

17. DACData Access Control Recently awarded a Campus Technology Innovation Award!

18. EDW – Enterprise Data Warehouse Working hard to power our data into information

19. EDW Enterprise Data Warehouse The Enterprise Data Warehouse Program is evolving in several significant ways... • Business Functional Requirements (BFR) and Business Dimensional Modeling (BDM) • Kanban Agile development Processes • Integrated Build-Out Teams • Master Data Management (MDM) • Data Quality Management (DQM)

20. DQMData Quality Management Several new DQM techniques are being implemented… • Rigorous Data Profiling and Correction • Scenario and Stage Gate based quality processes • Data Quality Rules based on Criticality and Acceptance ratings

21. DQMData Quality Management Gate 1 Filter based on Criticality Rules Gate 2 Filter based on Acceptance Rules Integration Cube Source Data Staging Presentation DQM Framework Data Profiling DQ Criticality Rules DQ Auditing DQ Accept Rules Data Correction Data Tagging DQ Notifications DQ Testing EDW Analysts EDW Engineers Data Custodians SME’s

22. DQMData Quality Management Scenario: Out of Range Lookup Code Values • Suspect data “Tagged” and brought into the EDW • Data Custodians notified to correct source system

23. Questions ? Visit the DMC Web Pagehttp://www.washington.edu/uwit/im/dmc/ Visit the DSS Web Page http://decisionsupport.washington.edu Visit the OPB Web Page http://opb.washington.edu/ Contact: Bill Yock byock@uw.edu 206.685.7535