Input Your Data. Output Your Website.

Input Your Data. Output Your Website. Visit our Website at: www.monahrq.ahrq.gov For technical assistance or to join the MONAHRQ mailing list, email:monahrq@ahrq.gov

Overview of MONAHRQ The MONAHRQ reporting Website Overview • The MONAHRQ host application: how to generate your reporting Website Input Your Data. Output Your Website.

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

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

Introducing MONAHRQ • MONAHRQ is a free desktop software tool from AHRQ • MONAHRQ helps convert health care data into useful information • MONAHRQ helps you quickly and easily generate your own health care reporting Website • 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

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

What Does MONAHRQ Do? …and turns it into a Website that reports: Potentially avoidable hospital stays by county Hospital quality ratings • AHRQ Quality Indicators • Hospital Compare measures • HCAHPS patient survey measures • AHRQ Quality Indicators Hospital utilization and costs County rates of hospital use You host the Website yourself

Who Can Use MONAHRQ? • Who can use MONAHRQ? • Hospital Associations • Health plans • Individual providers • Local data organizations • Local public health departments • Who can use a MONAHRQ reporting Website? • Consumers • Providers • Analysts • Policy makers

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 MONAHRQ generates your Website onto your own computer Internal: better understand your data and answer questions Private: provide a password-protected site for member organizations Public:report healthcare information to the community Select data analysis and Website options, and run MONAHRQ

More on How to Use MONAHRQ 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 Step 5: Generate your Website MONAHRQ calculates local benchmarks You download the Hospital Compare file You load the Hospital Compare file You link hospitals … and/or load pre-calculated results from Hospital Compare

More on Hospital Compare Measures and MONAHRQ What AHRQ does … • Download from CMS Hospital Compare files when they are available. • Clean and format the files to work with MONAHRQ. • Post the formatted files on the MONAHRQ Website, monahrq.ahrq.gov. What you do … • Download from the MONAHRQ Websitea formatted Hospital Compare file. Files from other sources may not load correctly into MONAHRQ. • 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.

The MONAHRQ Reporting Website • Hospital Quality Ratings • Maps of Avoidable Hospital Stays • Hospital Utilization • County Rates of Hospital Use

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

Hospital Quality Ratings: Search Page Select hospitals by name, ZIP Code, or region Select quality measures by health topic

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 HealthData.gov

Hospital Quality Ratings: Classification Table A closer look at the classification table – Synthetic data –

Hospital Quality Ratings: Detailed Classification Table The detailed version includes rates and confidence intervals – Synthetic data –

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 –

Hospital Quality Ratings: Detailed Bar Charts The detailed version includes confidence intervals, if available – Synthetic data –

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 –

Hospital Utilization Hospital utilization statistics (similar to AHRQ’s HCUPnet)

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

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

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 –

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

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

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

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

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

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 –

County Rates of Hospital Use Rates of health conditions and procedures by county Denominators are county populations from Census data

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

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 –

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 –

How Do I Import Local Data into MONAHRQ?

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

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

Map Data Elements Click and drag data elements to map your data to the format required by MONAHRQ – Synthetic data –

Map Input Values Recode your data elements to values understood by MONAHRQ, based on the UB04 standard

Load Your Local Data MONAHRQ loads and error checks your data

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

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

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

How Do I Define Local Regions & Hospitals?

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

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

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

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

Input Your Data. Output Your Website.