Input Your Data.
This presentation is the property of its rightful owner.
Sponsored Links
1 / 58

Input Your Data. Output Your Website. PowerPoint PPT Presentation


  • 57 Views
  • Uploaded on
  • Presentation posted in: General

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: [email protected] Overview of MONAHRQ The MONAHRQ reporting Website. Overview. The MONAHRQ host application:

Download Presentation

Input Your Data. Output Your Website.

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


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:[email protected]


Overview

Overview of MONAHRQ

The MONAHRQ reporting Website

Overview

  • The MONAHRQ host application:

    how to generate your reporting Website

Input Your Data. Output Your Website.


Rationale

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

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

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

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 do1

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?

  • 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

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


Input your data output your website

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


Input your data output your website

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.


Overview1

Overview of MONAHRQ

The MONAHRQ reporting Website

Overview

  • The MONAHRQ host application:

    how to generate your reporting Website

Input Your Data. Output Your Website.


Input your data output your 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

  • 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

Hospital Quality Ratings: Search Page

Select hospitals by name, ZIP Code, or region

Select quality measures by health topic


Hospital quality ratings classification table

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 table1

Hospital Quality Ratings: Classification Table

A closer look at the classification table

– Synthetic data –


Hospital quality ratings detailed classification table

Hospital Quality Ratings: Detailed Classification Table

The detailed version includes rates and confidence intervals

– Synthetic data –


Hospital quality ratings bar charts

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 –


Input your data output your website

Hospital Quality Ratings: Detailed Bar Charts

The detailed version includes confidence intervals, if available

– Synthetic data –


Hospital quality ratings detailed statistical table

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

Hospital utilization statistics (similar to AHRQ’s HCUPnet)


Input your data output your website

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

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

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

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

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

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

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

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

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

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

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

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

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 –


Overview2

Overview of MONAHRQ

The MONAHRQ reporting Website

Overview

  • The MONAHRQ host application:

    how to generate your reporting Website

Input Your Data. Output Your Website.


How do i import local data into monahrq

How Do I Import Local Data into MONAHRQ?


Import local data wizard

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

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

Map Data Elements

Click and drag data elements to map your data to the format required by MONAHRQ

– Synthetic data –


Map input values

Map Input Values

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


Load your local data

Load Your Local Data

MONAHRQ loads and error checks your data


Run analysis

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

How Do I Load Hospital Compare Measures into MONAHRQ?

Using Hospital Compare measure results in MONAHRQ is optional


Load hospital compare measures

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

How Do I Define Local Regions & Hospitals?


Define regions hospitals wizard

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

  • 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

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

Link Hospitals

If needed, crosswalk your local hospitals to hospitals in the Hospital Compare data

– Synthetic data –


Select hospitals to report

Select Hospitals to Report

Choose which hospitals to include in your reporting Website


How do i build my website

How Do I Build My Website?


Website wizard

Website Wizard

The Website Wizard takes you step by step through the process of building your MONAHRQ reporting Website


Set reporting parameters

Set Reporting Parameters

Set thresholds for cell suppression (to protect confidentiality) and other reporting parameters


Select measures to report

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


Customize your website

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


Host your website

Host Your Website

Now you’re done!

Your MONAHRQ-generated Website is yours to host as you prefer


For more information or to visit our live demo site

Questions?

For more information or to visit our live demo site:

http://www.monahrq.ahrq.gov

For technical assistance or to join the MONAHRQ mailing list email:

[email protected]

Input Your Data. Output Your Website.


  • Login