University of Wisconsin Business Intelligence Initiative Updates
The University of Wisconsin's Business Intelligence (BI) initiative is making significant progress with key updates on completion of engagements, RPD architecture recommendations, training initiatives, and system transition plans. The focus is on implementing OBIEE 12C, enhancing data connectivity, and preparing for campus-specific reporting needs. The agenda includes Rittman-Mead Consulting's involvement, system administrator training, and a closer look at transitioning to a new BI tool. Recommendations for RPD architecture alignment with distributed data sources and operational governance are highlighted for effective BI implementation.
Uploaded on Sep 27, 2024 | 0 Views
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Business Intelligence @ University of Wisconsin Wisconsin Welcome! BI Executive Sponsors May 5, 2016 U N I V E R S I T Y O F W I S C O N S I N S Y S T E M
Agenda Welcome and Check-In Rittman-Mead Consulting Engagement Complete Implementation Status Recommended RPD Architecture OBIEE 12C Training Campuses Readiness Attendees Timeline Classes, content Status RFP for BI Consulting Services UWBI Project Planning at UW Milwaukee Bob Beck and Ed Melchior U N I V E R S I T Y O F W I S C O N S I N SYSTEM 2
Rittman-Mead Engagement Complete - Ron Grim/Andy Rocha Environment Setup Install and configure OBIEE 12c for Dev/QA environments Imported RPD from UW-Platteville for testing Established connections to UW-Platteville and UW-Madison Preparing for use after June OBIEE Training Reviewed Security and Authentication Proof of concepts started Shibboleth integration OBI LDAP integration Successful tests will move toward Overall Architectural Design Preparing design for IAM Steering Committee U N I V E R S I T Y O F W I S C O N S I N SYSTEM 3
Rittman-Mead Engagement Complete - Ron Grim/Andy Rocha System Administrator Training Curriculum reviewed RPD Architecture Recommendations Review with Core Planning Team U N I V E R S I T Y O F W I S C O N S I N SYSTEM 4
A closer look: UW System Transition from Interactive Reporting to New BI Tool U N I V E R S I T Y O F W I S C O N S I N SYSTEM 5
R-M : Recommended RPD Architecture Best Practice for our Environment Distributed Data Sources => one OBIEE RPD Quickest way for us to get started once developers trained Need to manage metadata because of our complexity Operational Governance Group in place Other (future) options Centralized Data Warehouse => one OBIEE RPD Hybrid Approach One RPD for Central Data (HRS, SFS, Budget, CDR) Departmental Reporting Tools for Campus-specific Sources Pluggable BI? Multi-tenancy capabilities Not currently available, on Oracle s Roadmap U N I V E R S I T Y O F W I S C O N S I N SYSTEM 6
Campuses Readiness for Training U N I V E R S I T Y O F W I S C O N S I N SYSTEM 7
OBIEE 12 c Training Attendees (15) Dates Dimensional Modeling June 8, 9, 10 Break to practice! Repository Development June 20, 21, 22 Course Content Dimensional Modeling Repository Development U N I V E R S I T Y O F W I S C O N S I N SYSTEM 8
Status: RFP for Consulting Services Reviewed by Gartner Analyst, enhanced RFP More detail on IR Workspace content Specify expected years of experience on rate card Request vendors expectations of UW resources SMEs, IT, other U N I V E R S I T Y O F W I S C O N S I N SYSTEM 9
UWBI Project Planning at Milwaukee Bob Beck and Ed Melchior U N I V E R S I T Y O F W I S C O N S I N SYSTEM 10
Good-bye! Next Meeting June 2, 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 11
Update: OBIEE 12c Tool - Timeline Sep- Oct 2016 Nov- Dec 2016 Mar- Apr 2017 May- Jun 2017 Jul- Aug 2017 Mar- Apr 2016 May- Jun 2016 Jul- Aug 2016 Jan- Feb 2017 Jan- Feb 2016 Sep- Oct 2017 BI Base Budget Project Shared Queries & UW-Platteville Migration Discovery & Planning Installation & Configuration Installation and Configuration Consultant Campus Training (June) - Developers - Admins Interactive Reporting End of UW-System Paid Maintenance (Out of Support by Oracle April 2018) Campus Student Content Analysis Complete, 6/1 Student Data Consultant Engagement CSRG Proposed Project Consulting Semantic Data Layer Dimensional Data Model Training Curriculum Development Train-the-Trainer
