1 / 17

UCSF Developments in Business Intelligence and Enterprise Data Warehouse

UCSF Developments in Business Intelligence and Enterprise Data Warehouse. Data and Analytics Needs. Access to and analysis of data is the number one underserved IT need across UCSF. Joe Bengfort – UCSF CIO. Data And Analytics Needs – Just a Sampling.

ila-calhoun
Download Presentation

UCSF Developments in Business Intelligence and Enterprise Data Warehouse

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. UCSF Developments in Business Intelligence and Enterprise Data Warehouse

  2. Data and Analytics Needs Access to and analysis of data is the number one underserved IT need across UCSF. Joe Bengfort – UCSF CIO

  3. Data And Analytics Needs – Just a Sampling • Ability to identify and stratify patients for research and population health. • Integration of clinical, financial, research, education data. • Targeting interventions for patients based on evidence. • Connecting resident performance to patient satisfaction and outcomes. • Enable continuous performance measurement and quality improvement. • Self-service tools and dashboards. • Ability to pull data from textual files. • Comparisons to outside sources (e.g., UHC and other national data) and trend modeling. • Support an interface with ACO-wide databases/tools. • Historical and Real-time analysis. • … • … • …

  4. Current “Islands” of Capability • Omniview – Medical Center and Department of Medicine financial analysis • EPSI – Cost accounting for Medical Center activities • APeX Clarity Reports – Operational reports from UCSF’s integrated EHR • Data Warehouse and BI for Academic and Administrative Systems – Supports campus, schools and administrative systems including HR, financial, facilities and more. • IDR – De-identified view of APeX and AxiUm (dental) data sets for researchers. Identified data is available by request with CHR approval. • UC-ReX – Provides cohort counts across the five-UC-Medical Campuses. Facilitates cooperation among researchers at different campuses. • Many others…

  5. Current “Islands” of Data SCIP NSQIP Surgical Site infections Hospital acquired illness/ condition Implant rejections Ortho- Database APeX Quality Improvement Research Hospital Admin. Patient Registries (UCSF, CJRR and others) CostData OB – Perinatal Plus Beacon Report Joint Commission Reports Birth Trauma & Perinalta; Elective Delivery Data Research, Quality, Hospital Admin. Patient Self-Reported information Point-to-point Interfaces Optum Health Report HRIF Data Manual Chart Review ICN NICU Research NICU Hospital Admin. NICU Quality Improvement L&D Birth Calendar CPQCC CCS CPQCC/VON Reports ICN log book ICU Quality NQF- ICU Specification NQF- ICU Report Patient Transport (CPeTS) Preventive strategies Predictive models of disease Therapeutic Targets Gene-Disease Relationships Genomic raw data 5 Medication Safety Data Predictive Risk for Medication Errors Preventive strategies Medication Error Reports

  6. Concept of Future BI World Core EDW Various Analyses and Reports: Example Data Types: Business Intelligence Tools Clincal- Data Marts Clinical data SCIP SQIP SCIP NSQIP Enterprise Data Warehouse SCIP SQIP SCIP NSQIP SCIP SQIP SCIP NSQIP Cost Data Business-unit Specific Reports Financial Data Marts Patient Self-Reported information Research Data Marts Student Data Business-unit Specific Datasets Financial Data Marketing Data Marts EPSI Business-unit Specific Analyses ACO Data Mart PeopleSoft - HR Genomic Data … Business-unit Specific Dashboards … … Other Data Marts Other Sources 6

  7. …But We Must Build that Future Incrementally • Implement priority business use cases first. • Deliver immediate business value. • Build and spread data governance structures as we go. • Build more centralized data warehousing assets as we go. • Develop the IT and departmental analytics skills required as we go. Leverage the skills and analytical tools we have today to bring immediate value while creating long term BI assets such as the Enterprise Data Warehouse.

  8. Immediate BI Areas of Work to Drive • Create delivery capacity via internal and external resources sufficient to drive at least three concurrent analytical work products. • Advance EDW capability by developing analytical work product from top priority use case(s). • Create a UCSF data management and governance framework to instruct our decisions. • Recruit an Executive Director of Networked Data Warehousing and Analytics Support. • In the meanwhile, create a core team and start solving business problems while incrementally maturing our data culture and assets: • Joe Bengfort to lead these efforts in the interim. • Sandy Ng: BI Program Leader • Doug Berman: Data Architecture and Warehousing • Jeff Love: BI Technology and Development

  9. Leveraging What We’ve Already Created:Intake, Prioritization and Development Process

  10. Leveraging What We’ve Already Created:Business Case Prioritization Tool High High Low

  11. Leveraging What We’ve Already Created:Skills, Tools, Expertise and Data Assets • Omniview – Medical Center and Department of Medicine financial analysis • EPSI – Cost accounting for Medical Center activities • APeX Clarity Reports – Operational reports from UCSF’s integrated EHR • Data Warehouse and BI for Academic and Administrative Systems – Supports campus, schools and administrative systems including HR, financial, facilities and more. • IDR – De-identified view of APeX and AxiUm (dental) data sets for researchers. Identified data is available by request with CHR approval. • UC-ReX – Provides cohort counts across the five-UC-Medical Campuses. Facilitates cooperation among researchers at different campuses. • Many others…

  12. Leveraging What We’ve Already Created:Decision Making / Governance • Enterprise Data Warehouse Committee • Sub-Committee of the IT Governance Steering Committee • Chaired by Dr. Michael Blum • Representation across • Education • Research • Patient Care • Administration / Financial • Medical Center Business Intelligence Steering Committee • Focused on prioritizing and funding analytical work. • Microcosm of decision making we’ll need in other parts of the business. • Primarily focused on continuous improvement of hospital operations.

  13. Dashboard Development & Demo • FlashDash – Live Aug 2013 • DischDash (D/C before 12) – Live Nov 2013 • Quality (QualDash) - Tentative Go Live Dec 2013 The perfect is the enemy of the good

  14. Analytic Activities, Guided by Data Mgmt Plan to Build the EDW • Business Unit Data integrated in back-end: • Data Reqs • Definitions • Docs • Meta-data Data Mart(s) Agile Development Process • Reports • Analyses • Dashboards 14

  15. Analytic Activities, Guided by Data Mgmt Plan to Build the EDW Data Mart(s) Agile Development Process • Reports • Analyses • Dashboards Data Mart(s) 15

  16. Analytic Activities, Guided by Data Mgmt Plan to Build the EDW Data Mart(s) Core EDW Data Mart(s) Data Mart(s) Data Mart(s) Data Mart(s)

  17. Questions? IDR/UC-ReX Academic Research Systems Dashboard UCSF Medical Center Business Intelligence

More Related