ucsf developments in business intelligence and enterprise data warehouse n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
UCSF Developments in Business Intelligence and Enterprise Data Warehouse PowerPoint Presentation
Download Presentation
UCSF Developments in Business Intelligence and Enterprise Data Warehouse

Loading in 2 Seconds...

play fullscreen
1 / 17

UCSF Developments in Business Intelligence and Enterprise Data Warehouse - PowerPoint PPT Presentation


  • 164 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'UCSF Developments in Business Intelligence and Enterprise Data Warehouse' - ila-calhoun


Download Now 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
data and analytics needs
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
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.
current islands of capability
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…
current islands of data
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

concept of future bi world
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

but we must build that future incrementally
…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.

immediate bi areas of work to drive
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
leveraging what we ve already created intake prioritization and development process
Leveraging What We’ve Already Created:Intake, Prioritization and Development Process
leveraging what we ve already created skills tools expertise and data assets
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…
leveraging what we ve already created decision making governance
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.
dashboard development demo
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

analytic activities guided by data mgmt plan to build the edw
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

analytic activities guided by data mgmt plan to build the edw1
Analytic Activities, Guided by Data Mgmt Plan to Build the EDW

Data Mart(s)

Agile Development

Process

  • Reports
  • Analyses
  • Dashboards

Data Mart(s)

15

analytic activities guided by data mgmt plan to build the edw2
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)

questions
Questions?

IDR/UC-ReX Academic Research Systems

Dashboard UCSF Medical Center Business Intelligence