1 / 9

OSUMC:Decision Support Services

OSUMC:Decision Support Services. The Information Warehouse: Analysis at Your Fingertips. Information Warehouse(IW) Conceptual View. Information Warehouse. Data Acquisition. Data Transfer. Data Access . Scrubbing Reconciliation Integration Validation Transformation.

Mia_John
Download Presentation

OSUMC:Decision Support Services

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. OSUMC:Decision Support Services The Information Warehouse: Analysis at Your Fingertips

  2. Information Warehouse(IW)Conceptual View Information Warehouse Data Acquisition Data Transfer Data Access Scrubbing Reconciliation Integration Validation Transformation External Data Source Multidimensional analysis Data Mart Data Mining External Data Source Adhoc query & reports Data Mart Internal Data Source Consolidated Data Repository Data Mart Web reporting & dashboard Internal Data Source Internal Data Source De-identify Outside benchmarking National/State/Regional database Error Report

  3. Information Warehouse (IW): OSUMC Environment Data Acquisition Data Transfer Information Warehouse Data Access Encounter DM ICU DM Readmt DM Consolidated Data Repository Patient Management HCC Cost Accounting D A T A V A L I D A T I O N Pharmacy DM ED Visits DM Mom/Baby DM Patient Accounting COE/DI DM Multidimensional analysis/Data Miming Lab DM Blood Bank DM CPOE Pt Sat. DM Adhoc query Sunquest Lab System Rejection DM Web reporting & dashboard Patient Satisfaction CCG DM De-identify Ohio Hospital Association Revenue DM OHA DM Outside data for benchmarking Genetic Consolidated Data Entry Census DM

  4. Information Warehouse (IW): Historical Genetic Data Data Acquisition Data Transfer Information Warehouse Data Access D A T A V A L I D A T I O N Main Genetics Existing Data Marts Multidimensional analysis/Data Miming Amish Barrett’s Adhoc query CCG Data Mart HNPCC Web reporting & dashboard Cowden Samples Direct Data Entry

  5. OSUMC: IW/DM Benefits • Easy Access • Data Integrity • Trending/Forecasting • Centralized reporting • Ad hoc Query • Consistent definitions/data • Outcomes measurement/better patient care • Data for research • Data for community outreach • Data mining • Analysis for cost savings • Data security • One source of data for vendors- UHC,OHA,HCIA

  6. OSUMC: IW/DM Sample Data Information on individuals on a research protocol Family risk assessment of individuals on protocol

  7. Discoverer Allows user to create reports by running ad hoc queries and performing counts and calculations on specific values (or range of values) of the data elements in the IW. Holos Allows data in the IW to be pre-calculated, aggregated and stored in an application, that can be presented in multiple ways for analysis, trending and forecasting without the user having to write and run queries. Many Holos applications have been developed at the OSUMC. Tools to access data Web Census, Revenue, COE • For outside vendors like UHC, HCIA etc, programs have been developed by the IW staff to extract the data for the desired time period and export on a quarterly basis.

  8. Information Warehouse: Current data sources • HCC Managed Care System • Provides medical and financial encounter related data • Siemens Patient management Provides daily census data by hospital service, nurse station and admitting physician • Siemens Patient accounting • Provides daily revenue data • SunquestLab information system • Provides daily patient lab results • Siemens/Invision • Provides ‘computerized order entry’ and ‘discharge instructions’ • data • Centralized Physician database • Provides physician data

  9. Leadership Council for Clinical Value Enhancement Primary Internal & External Customers Internal: • Clinical services • Quality and Operations Improvement • Medical Information Management • Strategic and Business Planning • Fiscal Services • Transplant Services External: • University Healthcare Consortium (UHC) • Ohio Hospital Association (OHA)

More Related