For this session, download the workbook from our SurgViz Tableau Public profile.

Ex- Dashboard 1

The Dataset

Our workbook and examples use the publically available 2011 CMS Inpatient Charges dataset.

What does this dataset contain?

All hospital-specific charges from more than 3,000 U.S. hospitals that receive Medicare Inpatient Prospective Payment System (IPPS) payments for the top 100 most frequently billed discharges. Payments by Medicare are based on a rate per discharge using the Medicare Severity Diagnosis Related Group (MS-DRG) for Fiscal Year (FY) 2011. These DRGs represent more than 7 million discharges or 60% of total Medicare IPPS discharges.

Variables of interest

**All variables are calculated at the individual hospital level.

Average Hospital Charges–The average amount the individual hospital charges for items and services provided to patients.
Average Medicare Payment–The average Medicare payment paid to the hospital for each DRG.
Average Total Payments–The average amount the hospital usually is paid from all sources (includes the MS-DRG amount, bill total per diem, beneficiary primary payer claim payment amount, beneficiary Part A coinsurance amount, beneficiary deductible amount, beneficiary blood deductible amount and DRG outlier amount).
Users will be able to make comparisons between the amount charged by individual hospitals within local markets, and nationwide, for services that might be furnished in connection with a particular inpatient stay.

Calculated fields of interest

**In our workbook, we will calculate a few additional measures:

Average Charges Gap–the difference between the hospital charges and what Medicare paid
Average Payment Gap–the difference between the total payment and what Medicare paid
Percent of Charges–the percent of the charges Medicare paid
Percent of Payment–the percent of the total payments that was paid by Medicare
Revenue–the number of discharges by the average total payments
Volume Indicator–a categorical indicator for hospital discharge volume by quartile.
From CMS Website:
Also available from