dashboarding with ibm cognos n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Dashboarding with IBM Cognos PowerPoint Presentation
Download Presentation
Dashboarding with IBM Cognos

Loading in 2 Seconds...

play fullscreen
1 / 17
evanthe

Dashboarding with IBM Cognos - PowerPoint PPT Presentation

0 Views
Download Presentation
Dashboarding with IBM Cognos
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. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Dashboarding with IBM Cognos Cognos User Group August 5th 2011

  2. Dashboarding with IBM Cognos Agenda • CBMS Overview • CBMS Dashboarding Concepts • Dashboard Review • IBM Cognos Technical Overview

  3. Dashboarding with IBM Cognos CBMS Overview • CBMS is an eligibility determination system that supports 16 programs within two separate State agencies (CDHS and HCPF) • The project is maintained by staff from OIT, Deloitte and other firms

  4. Dashboarding with IBM Cognos CBMS Overview • Approximately 4,000 users within 64 counties, multiple eligibility sites, CDHS, HCPF and OIT • Over 400,000 active cases with over 750,000 programs • Generating over $3 billion in benefits annually

  5. Dashboarding with IBM Cognos CBMS Dashboard Concepts Business Intelligence Dashboard A business intelligence dashboard can be compared with an automobile. It is intended to translate complex data into various gauges, maps, charts, graphs or other visual presentations so that the end user can quickly assess how well things are running.

  6. Dashboarding with IBM Cognos CBMS Dashboard Concepts • Multiple Dashboards for various user groups • Division Directors and Managers • County Directors and Mangers • Front-line Workers and Supervisors • Prioritization of dashboards

  7. Dashboarding with IBM Cognos Dashboard Review • The Workload Management Dashboard is intended to provide front-line workers with an organizational tool that will display simple metrics of case activities that have exceeded certain defined limits, or are approaching those limits within the CBMS application. • This dashboard is not intended to be a traditional executive dashboard that uses fancy graphs, charts or other types of visual aides to provide trend analysis or high-level views of key system components.

  8. Dashboarding with IBM Cognos Dashboard Review Requirements • Provide a simple means of access, and auto-populate based on login ID • Provide means of supervisory access only • Daily data refresh • Drill through for client specific data • Link to application • PERFORMANCE!!!

  9. Dashboarding with IBM Cognos Dashboard Review Implementation Strategy • Proof of Concept • Phased Pilot • Monthly phased implementations

  10. Dashboarding with IBM Cognos

  11. Dashboarding with IBM Cognos

  12. Dashboarding with IBM Cognos

  13. Dashboarding with IBM Cognos

  14. Dashboarding with IBM Cognos

  15. Dashboarding with IBM Cognos

  16. Dashboarding with IBM Cognos IBM Cognos Technical Overview • Cognos 8.2 • Single Data Model (Framework) • Created IQD for each subject area • Created Single Cube for each subject area (Transformer) • Single Package with framework and cubes • Report Studio used for dashboard, each subject area, and drill through reports

  17. Dashboarding with IBM Cognos IBM Cognos Technical Overview • Canned Cognos security function used to pull user signed into application • Drill through reports done against database, not cubes • Performance achieved using roll up tables, when source tables are too large • Cubes refresh daily after report environment refresh has completed