1 / 38

Business Intelligence ( BI) Improvements

Business Intelligence ( BI) Improvements. What is BI?. Tools and methods to convert raw data into powerful information for the organization. What can BI do?. Allow organizations to gather, store, and query data for reporting and analytical purposes to make informed strategic decisions .

asta
Download Presentation

Business Intelligence ( BI) Improvements

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. Business Intelligence (BI) Improvements

  2. Business Intelligence?

  3. What is BI? • Tools and methods to convert raw data into powerful information for the organization.

  4. What can BI do? • Allow organizations to gather, store, and query data for reporting and analytical purposes to make informed strategic decisions. BI Business Intelligence?

  5. How have we improved BI?

  6. Longitudinal Data Initiative (LDM) How have we improved BI?

  7. Approach Data Repository “Systems” Outcomes Information IBES, SharePoint, EPICS, ICSES etc. e.g. Data Warehouse Dashboards, Scorecards, etc. Cost, Service Efficiency, etc. Who? What? When? What info? Decisions & Decision Maker 1st • Approach: • Create an easy to use data warehouse • Hierarchies, Taxonomies, Business Rules Applied • Data is turned into easy to use and understand information • Terminology defined • Progression • Create Analytics that monitor processes • Create Analytics that will help you understand why things are happening • Create Analytics that will help you change an outcome for the better How have we improved BI?

  8. Data Sources Decision Makers Framework Hierarchies & Taxonomy Access Data Warehouse Staging Datamarts & Cubes MDM Driver Vehicle Current Historical Current Historical Unify Canonical Model Pre-Prod Production Enterprise Data Warehouse Dimensional Model ETL Business Rules Customer Resource Data How have we improved BI?

  9. A Clear Vision of Information • ICSES: Each unique APP_ID in table apps. • IBES: Rollup applications from the pgm_app table by app_date, and create_date. Transforming Data into Information • Term: Case_Application_Count Analytics & Analysis Source Systems Technology Enabling Transparency Terminology Business Rules Information Transparency Definition: When someone from the household(CASE) applies for one or more programs benefits System Business Rules

  10. How have we improved BI?

  11. Hierarchies and Taxonomies Where do male clients go? How have we improved BI?

  12. Where do male clients go? How have we improved BI?

  13. Where do male clients go? In a new taxonomy! How have we improved BI?

  14. What is the outcome? Pre-wired Relationships Business Rules Managed Through SharePoint Simple Queries Simple Reporting Query Performance Fast Aggregations Source of Truth Master Data Management Hierarchies How have we improved BI? Taxonomies

  15. Definitions and Metrics C S S U C E S How have we improved BI?

  16. Analytical Tools How have we improved BI?

  17. Processes Insights Understanding clients, workers, policy and procedures leads to inspired strategy. Strategy Inspiration sparks creative thinking that leads to ideas. Action Ideas come to life to engage and inspire people to action. Results Continuous measurement optimizes programs, improves success, and reveals insights and inspiration for future strategy. How have we improved BI?

  18. Customer’s Process: Traditional How have we improved BI?

  19. Customer’s Process: Re-engineered Idaho: 1 hour How have we improved BI?

  20. How have we improved BI?

  21. Still room for improvement?

  22. Additional subject areas for LDM Still room for improvement?

  23. More data connections Still room for improvement?

  24. Better data integrity Still room for improvement?

More Related