UBC IT Integrated Reporting Governance Committee

1. UBC IT Integrated Reporting Governance Committee June 13th, 2011

2. Agenda Introductions (10 min, Ian Burgess) UBC IT Governance Update (10 min, Oliver Gruter-Andrew) Terms of Reference (30 min, David Truong) Confirm Terms of Reference Confirm IR Governance Committee membership Program Overview (30 min, David Truong) Background Conceptual Solution Integrated Reporting Roadmap (draft) Next Steps (10 min, David Truong)

3. Introductions • Name • Role at UBC • Familiarity with Reporting/Analytics and Data Management • Expectations for the IR Program

4. UBC IT Governance Update

5. Terms of Reference • Refer to Word document handout:

6. Program Overview: Background Based on the current state of reporting and data management solutions at UBC, there is significant benefits that can be gained through a central IR platform. • Multiple departmental BI solutions • Varied landscape of licensed tools including Oracle, IBM, MSFT, SAP, Jaspersoft, MSTR, SPSS, Custom, Open Source • Spaghetti of interconnections for data integration with many point to point interfaces that are manual, incomplete, and of uncertain quality • Early “Data Warehouses” in PAIR and in Enrolment Services • Critical stakeholder needs not fully met for integrated information and query/reporting access • Data governance is distributed • Data Model and Dictionary lacking or non-existent in some areas

7. Program Overview: Conceptual Solution (1 of 5) The program will seek to establish a standard information management framework to service the broader University community. Governance Metadata Data Integration Data Management Data Sources Data Access Data Security Operations

8. Program Overview: Conceptual Solution (2 of 5) The Data Integration layer will extract key operational data, apply transformation logic, cleanse and conforming the data; typically 60% to 80% of effort spent here. Governance Metadata Data Integration Data Management Data Access Data Sources Finance Extract, Transform, Load Student Near Real-time Batch HR Data Quality Profiling Research Cleansing Land & Building Data Enrichment • Harmonization • Demographic • Lineage • Etc. Academic External Data Security Operations

9. Program Overview: Conceptual Solution (3 of 5) The Data Management layer contains the different data stores of operational and enriched data; key here is properly documented data model and dictionaries. Governance Metadata Data Management Data Integration Data Access Data Sources Finance Data Warehouse Extract, Transform, Load Source Data Sets Master Data Student Near Real-time Batch Subject Specific Data Marts HR Operational Data Store Data Quality Profiling Business Views Research Cleansing Atomic Data Warehouse Land & Building Data Enrichment • Harmonization • Demographic • Lineage • Etc. Enterprise Data Warehouse Unstructured Information Academic External Data Security Operations

10. Program Overview: Conceptual Solution (4 of 5) The Data Access layer is where the various information delivery channels are used depending on the type of analysis being done. Governance Metadata Data Management Data Integration Data Access Data Sources Finance Reporting / Analysis Enterprise Portal Data Warehouse Extract, Transform, Load Source Data Sets Master Data Reports Student Near Real-time Batch Ad-hoc Analysis Subject Specific Data Marts HR Operational Data Store Data Quality Dashboards Profiling Business Views Research Mobile Cleansing Atomic Data Warehouse Data Mining Land & Building Data Enrichment Publish / Alerts • Harmonization • Demographic • Lineage • Etc. Enterprise Data Warehouse Unstructured Information Academic Performance Management External Data Security Operations

11. Program Overview: Conceptual Solution (5 of 5) Governance, Metadata, Security, and Operations provide important supporting processes. Governance Strategy/Vision Demand Planning Methodology Capability Definition Release Management Standards Skills/Training Metadata Technical Metadata Business Data Management Data Integration Data Access Data Sources Finance Reporting / Analysis Enterprise Portal Data Warehouse Extract, Transform, Load Source Data Sets Master Data Reports Student Near Real-time Batch Ad-hoc Analysis Subject Specific Data Marts HR Operational Data Store Data Quality Dashboards Profiling Business Views Research Mobile Cleansing Atomic Data Warehouse Data Mining Land & Building Data Enrichment Publish / Alerts • Harmonization • Demographic • Lineage • Etc. Enterprise Data Warehouse Unstructured Information Academic Performance Management External Data Security Authentication Data Privacy ID & Access Mgmt Single Sign-on Authorization Operations Capacity Data Retention Audit Error-Handling Schedule Backup/Archive Performance

12. Roadmap (1 of 4) The IR Roadmap provides a blueprint to achieve the desired target state over the next 5 years.

13. Roadmap (2 of 4) Initial focus is to mobilize the program and understanding the Oracle BI packaged solution.

14. Roadmap (3 of 4) Finance & Procurement, Student, and PAIR have initially been identified as key areas of focus.

15. Roadmap (4 of 4) The program will focus on growing the maturity of reporting/analytics and enterprise data management.

16. Next Steps Over the next couple of months, the program will focus on: • Continue to mobilize the program • Evolve and confirm the roadmap • Establish the Program Organization including the working committee • Train key resources • Establish the Oracle BI Environment • Install and demo the Oracle BI solution • Identify a meaningful proof of concept • Confirm the scope of work against the approved budget • Identify quick win initiative(s) to begin leveraging Oracle BI platform