Business Intelligence Wisconsin University of Wisconsin Welcome BI
Business Intelligence Wisconsin @ University of Wisconsin Welcome! BI Executive Sponsors April 7, 2016 UNIVERSITY OF WISCONSIN–SYSTEM
Agenda • Welcome and Check-in • Information Items – – – – Implementation Status HEDW Conference with Benchmark Responders Status on FY 17 Funding & RFP Common Role Definitions Approved Campus Student Data Assessment Complete by 6/1 Campuses Determine Staff to be Trained by 5/1 UWBI Operational Governance Team Definition of UWBI Named User • For Discussion and/or Decision – Policy on distribution of UWBI named user licenses U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 2
Implementation Status • Virtual Environments – VMs are sized and are ready for the installation • Rittman Mead Engagement Starts 4/11 – Install & Configure QA environment – Security & Authentication Architecture Discussions – Planning for deployment U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 3
HEDW Conference • UW Staff Attending – – – – – Dave Halderman, UW Oshkosh Cary Abrahamson, UW Madison Randy Carey, UW Madison Mary Kirk, UW Madison Kathy Luker, UW Madison/System Ashi Yusuf, UW Parkside Stephanie Dolejsi, UW Platteville Valerie Wachuta, UW Platteville Rochelle Day, UW Whitewater Lynsey Schwabrow, UW Whitewater • Benchmark Sessions with. . . – – Cornell University The Ohio State University of Minnesota University of Arizona U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 4
HEDW Conference • Conference Take Aways. . . – From BI Executive Sponsor Perspective • BI Team – Built on Critical Relationships • Forward Thinking • Hiring a Consultant/Learning from and with other OBIEE Institutions – Consistent Messages from Peers • Dimensional Data Models – ‘Heart of Activity’ – Ideal to build dimensional models in warehouse, connect to physical layer – Takes specialists to create dimensional models – centralize that skill – Once Dimensional Model populated many can use – Plan to built it twice. . . • • Notion that can’t change could be enemy Don’t have just one chance; consultants buys time but need to get people up to speed • Build a ‘central’ BI Team • BI Publisher Problematic – – Doesn’t work well with complex SQL Doesn’t deal well with local joins U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 5
Status on FY 17 Funding & RFP • FY 17 Funding – Additional CSRG proposal was submitted for consulting resources to help campuses implement student content (dimensional data modeling and semantic layer expertise) and training resources. – Accepted by CSRG; will be forwarded to President Cross for approval. • RFP – UW does not have a contract in place to procure consulting resources to support OBIEE implementation. . – RFP is now being drafted. U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 6
RFP Scope • Seeking an OBIEE implementation consulting firm. • A team of consultants to: – Work with institutions to develop template dimensional data model & semantic layer for People. Soft student data. – Develop curriculum and materials for author, consumer, and train-the-trainer courses that can be used across the institutions. • Evaluative criteria includes experience with complex settings in higher education environments. U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 7
RFP Scope • Extending requirements to include technical, functional and project management roles that may be needed beyond CSRG-funded initiative. • Resulting UW System contract that can be used by: – Individual institutions (using their own funding) to transition from IR to OBIEE. – Individual institutions (using their own funding) to extend OBIEE functionality beyond scope of IR transition. – System-wide enterprise applications (i. e. HRS or SFS) to support transition from IR to OBIEE, and to extend functionality beyond scope of transition. U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 8
RFP Time line • Issue RFP in April • Evaluate responses in June • Target contract award for July 1 (to coincide with availability of CSRG funding) U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 9
Other Information Items • UWBI Coordinator Discussions – Common Role Definitions • UWBI Coordinators reviewed and approved with the expectation that items may change slightly as we learn more – Campus Student Data Assessment • Planning for campus to have analysis ready by 6/1 – Campus Based Training • UWBI Coordinators will determine staff by 5/1 • Training is tentatively planned for June U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 10
Jan. Feb 2016 Update: OBIEE 12 c Tool Timeline Mar. Apr 2016 May. Jun 2016 Jul. Aug 2016 Sep. Oct 2016 Nov. Dec 2016 Jan. Feb 2017 Mar. Apr 2017 May. Jun 2017 Jul. Aug 2017 Sep. Oct 2017 BI Base Budget Project Discovery & Planning Shared Queries & Installation & Configuration Installation and Configuration Consultant UW-Platteville Migration Campus Training (June) - Developers - Admins Campus Student Content Analysis Complete, 6/1 Student Data Consultant Engagement Interactive Reporting End of UW-System Paid Maintenance (Out of Support by Oracle April 2018) CSRG Proposed Project Consulting Training • Semantic Data Layer • Dimensional Data Model • Curriculum Development • Train-the-Trainer
Other Information Items • UWBI Operation Governance Team • Definition of UWBI Named User U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 12
Discussion / Decision Policy of distribution of UWBI named user licenses • Interactive Reporting License Distribution by Campus Today • Number Active IR Users Today by Campus • OBIEE License Distribution by Campus U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 13
Good-bye! Next Meeting May 5, 2016 10: 00 – 11: 00 Wisline Web U N I V E R S I T Y O F W I S C O N S I N – SYSTEM 14
- Slides: 14