Advancing Excellence in Health Care Agency for Healthcare

Advancing Excellence in Health Care Agency for Healthcare Research and Quality Advancing Excellence in Health Care • www. ahrq. gov Input Your Data. Output Your Website. Visit our Website at: www. monahrq. gov For technical assistance or to join the MONAHRQ mailing list, email: monahrq@ahrq. gov

Advancing Excellence in Health Care Overview n Overview of MONAHRQ n The MONAHRQ reporting Website n The MONAHRQ host application: how to generate your reporting Website Input Your Data. Output Your Website.

Advancing Excellence in Health Care Rationale n Why should it be so expensive to generate and put out basic information? n Why should information be so hard to get? n Why does every organization have to reinvent the wheel?

Advancing Excellence in Health Care From Data to Information to Action Hospital discharge data are already being collected Hospital discharge data can generate valuable health care information Quality of care in hospitals Rates of diseases in particular areas Utilization and costs in hospitals Rates of procedures in particular areas Information can be used to make decisions Preventable hospital stays suggesting breakdowns in primary care

Introducing MONAHRQ Advancing Excellence in Health Care n MONAHRQ is a free desktop software tool from AHRQ n MONAHRQ helps convert health care data into useful information n MONAHRQ helps you quickly and easily generate your own health care reporting Website n MONAHRQ is a desktop tool, not a service – you control your data and you host your Website ─ ─ Input your data, output your reporting Website Integrate local data with national datasets Report data in a friendly, accessible format Report without reinventing the wheel

Advancing Excellence in Health Care What Does MONAHRQ Do? MONAHRQ takes health care data and information… § Local hospital discharge data § Hospital Compare inpatient measure results from CMS § § Mortality Readmissions Process of care HCAHPS survey of patients’ experiences

Advancing Excellence in Health Care What Does MONAHRQ Do? …and turns it into a Website that reports: 1. Hospital quality ratings – AHRQ Quality Indicators – Hospital Compare measures – HCAHPS patient survey measures 2. Hospital utilization and costs 3. Potentially avoidable hospital stays by county – AHRQ Quality Indicators 4. County rates of hospital use You host the Website yourself

Advancing Excellence in Health Care Who Can Use MONAHRQ? n Who can use MONAHRQ? ─ ─ ─ Hospital Associations Health plans Individual providers Local data organizations Local public health departments n Who can use a MONAHRQ reporting Website? ─ ─ Consumers Providers Analysts Policy makers

Advancing Excellence in Health Care How to Use MONAHRQ Load hospital discharge data and/or Hospital Compare measure results Download the free MONAHRQ software from AHRQ’s Website Host your MONAHRQ Website as you prefer Internal: Internal better understand your data and answer questions Private: provide a passwordprotected site for member organizations Public: report healthcare information to the community 9 MONAHRQ generates your Website onto your own computer Select data analysis and Website options, and run MONAHRQ

More on How to Use MONAHRQ Advancing Excellence in Health Care Load your own hospital discharge data … You load your local data You specify local hospital information MONAHRQ analyzes your local data Step 1: Download MONAHRQ Step 2: Load data Step 3: Specify hospitals Step 4: Calculate results You download the Hospital Compare file You link hospitals MONAHRQ calculates local benchmarks Step 5: Generate your Website … and/or load pre-calculated results from Hospital Compare

Advancing Excellence in Health Care More on Hospital Compare Measures and MONAHRQ What AHRQ does … n Download from CMS Hospital Compare files when they are available. n Clean and format the files to work with MONAHRQ. n Post the formatted files on the MONAHRQ Website, monahrq. gov. What you do … n Download from the MONAHRQ Website a formatted Hospital Compare file. Files from other sources may not load correctly into MONAHRQ. n Load the formatted Hospital Compare file into MONAHRQ. You can load your own hospital discharge data as well. Now you’re ready to process your data and generate a reporting Website.

Advancing Excellence in Health Care Overview n Overview of MONAHRQ n The MONAHRQ reporting Website n The MONAHRQ host application: how to generate your reporting Website Input Your Data. Output Your Website.

Advancing Excellence in Health Care The MONAHRQ Reporting Website ■ Hospital Quality Ratings ■ Hospital Utilization ■ Maps of Avoidable Hospital Stays ■ County Rates of Hospital Use

Advancing Excellence in Health Care Hospital Quality Ratings Hospital quality ratings can include: • AHRQ provider-level Quality Indicators • Hospital Compare inpatient measures • HCAHPS patient survey measures Two quality paths to choose from: • one friendlier path for the public • one path with statistical details for other audiences

Advancing Excellence in Health Care Hospital Quality Ratings: Search Page Select hospitals by name, ZIP Code, or region Select quality measures by health topic

Advancing Excellence in Health Care Hospital Quality Ratings: Classification Table Shows quality ratings for each indicator and hospital selected Understandable icons Sortable columns Help popups Choose national or local benchmarks Drill down to details * Available from Health. Data. gov

Advancing Excellence in Health Care Hospital Quality Ratings: Classification Table A closer look at the classification table – Synthetic data –

Advancing Excellence in Health Care Hospital Quality Ratings: Detailed Classification Table The detailed version includes rates and confidence intervals – Synthetic data –

Advancing Excellence in Health Care Hospital Quality Ratings: Bar Charts One bar chart per indicator Bars ordered from best to worst Bars labeled with the numeric value Benchmarks shown in contrast color – Synthetic data –

Advancing Excellence in Health Care Hospital Quality Ratings: Detailed Bar Charts The detailed version includes confidence intervals, if available – Synthetic data –

Advancing Excellence in Health Care Hospital Quality Ratings: Detailed Statistical Table Provides statistics for specific measures, as available: • numerator • denominator • observed rate • expected rate • risk-adjusted rate • confidence intervals – Synthetic data –

Advancing Excellence in Health Care Hospital Utilization Hospital utilization statistics (similar to AHRQ’s HCUPnet)

Advancing Excellence in Health Care Hospital Utilization: Search Page Select hospitals by name, Zip Code, region, or all combined Select discharges by condition, procedure, MDC, DRG, or all combined

Advancing Excellence in Health Care Hospital Utilization: One Hospital, One Condition Shows: • discharges • estimated costs • length of stay Stratified by: • age group • gender • payer • race Includes national and regional benchmarks – Synthetic data –

Advancing Excellence in Health Care Hospital Utilization: All Hospitals, One Condition Shows information for the selected condition for each hospital Sortable columns Drill down to stratified tables showing one hospital, one condition – Synthetic data –

Advancing Excellence in Health Care Hospital Utilization: All Conditions, One Hospital Shows information for the selected hospital for each condition individually Sortable columns – Synthetic data – Drill down to stratified tables showing one hospital, one condition

Advancing Excellence in Health Care Hospital Utilization: All Hospitals, All Conditions Shows information for the selected condition for all hospitals combined Sortable columns – Synthetic data – Drill down to stratified tables for all hospitals combined, one condition

Advancing Excellence in Health Care Maps of Avoidable Hospital Stays Includes the AHRQ area-level Quality Indicators Denominators are county populations from Census data

Advancing Excellence in Health Care Maps of Avoidable Stays: Search Page Choose a health topic These topics group the area-level AHRQ Quality Indicators measure the quality of community care, not hospital care

Advancing Excellence in Health Care Drilldown for more details Maps of Avoidable Stays: County Maps Shows rates of potentially avoidable hospital stays by county Rates are based on patient residence, not hospital location Higher rates are darker blue – Synthetic data –

Advancing Excellence in Health Care Maps of Avoidable Stays: Potential Cost Savings Shows rates of potentially avoidable hospital stays by county Estimates cost savings from reducing these stays Can be downloaded to Excel – Synthetic data –

Advancing Excellence in Health Care County Rates of Hospital Use Rates of health conditions and procedures by county Denominators are county populations from Census data

Advancing Excellence in Health Care County Rates of Hospital Use: Search Page Select hospitals by county or all combined Select discharges by condition, procedure, MDC, DRG, or all combined

Advancing Excellence in Health Care County Rates of Hospital Use: All Counties, One Condition Shows for each county: • number of discharges • discharge rate • estimated costs Drill down to map display Rates are based on patient residence, not hospital location Includes national and local benchmarks Sortable columns – Synthetic data –

Advancing Excellence in Health Care County Rates of Hospital Use: County Maps Shows rates by county in quintiles Rates are based on patient residence, not hospital location Higher rates are darker blue – Synthetic data –

Advancing Excellence in Health Care Overview n Overview of MONAHRQ n The MONAHRQ reporting Website n The MONAHRQ host application: how to generate your reporting Website Input Your Data. Output Your Website.

Advancing Excellence in Health Care How Do I Import Local Data into MONAHRQ?

Advancing Excellence in Health Care Import Local Data Wizard The Import Data Wizard helps you: • import your data • map it to the format required by MONAHRQ • analyze the data

Advancing Excellence in Health Care Select Your Local Data File Browse to and select your data file Accepted formats: • text (. csv) • Microsoft Excel (. xls) • Microsoft Access (. mdb)

Advancing Excellence in Health Care Map Data Elements Click and drag data elements to map your data to the format required by MONAHRQ – Synthetic data –

Advancing Excellence in Health Care Map Input Values Recode your data elements to values understood by MONAHRQ, based on the UB 04 standard

Advancing Excellence in Health Care Load Your Local Data MONAHRQ loads and error checks your data

Advancing Excellence in Health Care Run Analysis MONAHRQ uses your data to calculate: • AHRQ Quality Indicators • hospital utilization • county rates of hospital use • local benchmarks

Advancing Excellence in Health Care How Do I Load Hospital Compare Measures into MONAHRQ? Using Hospital Compare measure results in MONAHRQ is optional

Advancing Excellence in Health Care Load Hospital Compare Measures First, download a specially-formatted CMS Hospital Compare data file from the MONAHRQ Website at monahrq. gov Next, browse to and select your Hospital Compare data file

Advancing Excellence in Health Care How Do I Define Local Regions & Hospitals?

Advancing Excellence in Health Care Define Regions & Hospitals Wizard The Define Regions and Hospitals Wizard helps you: • define regions used in hospital selection • assign hospital information such as region or cost-to-charge ratio • crosswalk local hospitals with hospitals in the Hospital Compare data, if needed

Advancing Excellence in Health Care Define Regions Define regions to use for hospital selection in: • the hospital quality ratings path • the hospital utilization path Regions can be: • Dartmouth Atlas Hospital Referral Regions (HRRS) • Dartmouth Atlas Hospital Service Areas (HSAs) • custom defined by you

Advancing Excellence in Health Care Load Hospitals Mask hospital names if desired Assign hospital cost-to-charge ratios using CMS provider ID Assign hospitals to regions – Synthetic data –

Advancing Excellence in Health Care Link Hospitals If needed, crosswalk your local hospitals to hospitals in the Hospital Compare data – Synthetic data –

Advancing Excellence in Health Care Select Hospitals to Report Choose which hospitals to include in your reporting Website

Advancing Excellence in Health Care How Do I Build My Website?

Advancing Excellence in Health Care Website Wizard The Website Wizard takes you step by step through the process of building your MONAHRQ reporting Website

Advancing Excellence in Health Care Set Reporting Parameters Set thresholds for cell suppression (to protect confidentiality) and other reporting parameters

Advancing Excellence in Health Care Select Measures to Report Choose which measures to include in your reporting Website MONAHRQ tells you which measures are endorsed by the National Quality Forum

Advancing Excellence in Health Care Customize Your Website Specify Website options: • where to output it • which pages to generate • style specifics • your logo to display in the site • your organization’s name to display in the site

Advancing Excellence in Health Care Host Your Website Now you’re done! Your MONAHRQ-generated Website is yours to host as you prefer

Advancing Excellence in Health Care Questions? For more information or to visit our live demo site: http: //www. monahrq. gov For technical assistance or to join the MONAHRQ mailing list email: monahrq@ahrq. gov Input Your Data. Output Your Website.