Input Your Data.
Download
1 / 58

Input Your Data. Output Your Website. - PowerPoint PPT Presentation


  • 82 Views
  • Uploaded on

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:

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 ' Input Your Data. Output Your Website.' - eze


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.

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 information?

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 information?

  • 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? information?

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? information?

…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? information?

  • 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 information?

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 information?

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 information?

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 information?

The MONAHRQ reporting Website

Overview

  • The MONAHRQ host application:

    how to generate your reporting Website

Input Your Data. Output Your Website.


The MONAHRQ Reporting Website information?

  • Hospital Quality Ratings

  • Maps of Avoidable Hospital Stays

  • Hospital Utilization

  • County Rates of Hospital Use


Hospital quality ratings
Hospital Quality Ratings information?

  • 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 information?

Select hospitals by name, ZIP Code, or region

Select quality measures by health topic


Hospital quality ratings classification table
Hospital Quality Ratings: Classification Table information?

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 information?

A closer look at the classification table

– Synthetic data –


Hospital quality ratings detailed classification table
Hospital Quality Ratings: Detailed Classification Table information?

The detailed version includes rates and confidence intervals

– Synthetic data –


Hospital quality ratings bar charts
Hospital Quality Ratings: Bar Charts information?

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 information?

The detailed version includes confidence intervals, if available

– Synthetic data –


Hospital quality ratings detailed statistical table
Hospital Quality Ratings: Detailed Statistical Table information?

  • Provides statistics for specific measures, as available:

    • numerator

    • denominator

    • observed rate

    • expected rate

    • risk-adjusted rate

    • confidence intervals

– Synthetic data –


Hospital utilization
Hospital Utilization information?

Hospital utilization statistics (similar to AHRQ’s HCUPnet)


Hospital Utilization: Search Page information?

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 information?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: information?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: information?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: information?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 information?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 information?

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 information?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 information?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 information?

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 information?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 information?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 information?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 information?

The MONAHRQ reporting Website

Overview

  • The MONAHRQ host application:

    how to generate your reporting Website

Input Your Data. Output Your Website.



Import local data wizard
Import Local Data Wizard information?

  • 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 information?

Browse to and select your

data file

  • Accepted formats:

  • text (.csv)

  • Microsoft Excel (.xls)

  • Microsoft Access (.mdb)


Map data elements
Map Data Elements information?

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

– Synthetic data –


Map input values
Map Input Values information?

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


Load your local data
Load Your Local Data information?

MONAHRQ loads and error checks your data


Run analysis
Run Analysis information?

  • 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? information?

Using Hospital Compare measure results in MONAHRQ is optional


Load hospital compare measures
Load Hospital Compare Measures information?

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



Define regions hospitals wizard
Define Regions & Hospitals Wizard information?

  • 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 information?

  • 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 information?

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 information?

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

– Synthetic data –


Select hospitals to report
Select Hospitals to Report information?

Choose which hospitals to include in your reporting Website



Website wizard
Website Wizard information?

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


Set reporting parameters
Set Reporting Parameters information?

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


Select measures to report
Select Measures to Report information?

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 information?

  • 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 information?

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? information?

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.


ad