1 / 14

Open Forum Presentation BI Tools Upgrade Project

Open Forum Presentation BI Tools Upgrade Project. July 25, 2008. Agenda. Project Goals and Objectives What’s In Scope Roles and Assigned Staff High Level Timeline Why Dashboards ? BI Tools Capability Demo Q & A. Project Goals.

ardara
Download Presentation

Open Forum Presentation BI Tools Upgrade Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Open Forum PresentationBI Tools Upgrade Project July 25, 2008

  2. Agenda • Project Goals and Objectives • What’s In Scope • Roles and Assigned Staff • High Level Timeline • Why Dashboards ? • BI Tools Capability Demo • Q & A

  3. Project Goals • The primary goal of the Business Intelligence (BI) Tools Upgrade project is to replace Brio Query with the Web enabled Oracle Business Intelligence Enterprise Edition (OBIEE) toolset by no later than December 31, 2008. • Secondary goals: • Establish strategy, funding and capability for ongoing ITS support for Business Intelligence • Establish strategy and plan for rolling out and supporting additional Business Intelligence analytics capability

  4. Primary Objectives • Convert all ITS delivered Brio Query “repository” queries to equivalent OBIEE requests • Implement Business Process Oriented Dashboards which provide interactive as well as simple report content

  5. Secondary Objectives • Establish end user support capability to insure successful implementation and ongoing use • Provide tool training and support to all users. • Integrate the OBIEE application with the existing environment • Authentication - CAS/LDAP • Account Provisioning • PolyData (Enterprise Data Warehouse)

  6. Roll Out Strategy • Reach out to the existing user base to make sure we understand current uses of Brio Query • Arrange content based on support for related common business processes (e.g.. Financial Budget Analysis, Class Enrollment Analysis or Salary Analysis) • Based on “value added”, deliver content via an interactive dashboard or simplified report dashboard for each common business process • Base security on need for access to perform a particular business process with underlying value based security (such as dept) where needed. • Develop and Release Dashboards via a Phased, Iterative approach using planned, regularly scheduled releases

  7. Project Team Roles

  8. Functional Staff Roles

  9. High Level Time Table

  10. Why Dashboards ? • Ease of Use! • Intuitive • Flexible • Adapt to various working styles • Easy download to desktop software (e.g. Excel) • Fast • Content organized (and secured) based on business process • “Peel the onion” approach • Provide summarized views that progressively drill down to appropriate detail but also provide single click drill down to full detail

  11. OBIEE Demo • Tool Capability Demo

  12. Questions & Answers • Q & A • Web: http://polydata.calpoly.edu • Email Contacts: • General Questions/Concerns: polydata@calpoly.edu • Specific Feedback on Brio Query Migration: astets@calpoly.edu

  13. Demo Screen Shots

  14. Dashboard Terminology • Dashboard – content separated by Functional Areas • Dashboard Page Prompt – controls requests on dashboard page • Narrative text – allows static and variable text • Request – query • Hyperlinks - hierarchical drills, drill to detail options, and links to related information • Filter – request selection criteria appears below the display • Column Selector – view different columns of data • View Selector – select different reports • Conditional formatting using green, yellow, red symbols • Presentation Catalog Folder – list of content related requests

More Related