Florida Healthcare Costs

If you read any Stephen Few for more than a minute, you’d realize he emphatically stresses clear and simple-looking visualizations.  Well, he does in the one O’Reilly book I have of his where he spends a considerable amount of time pointing out what NOT to do.

With this in mind and looking for an excuse to keep playing with Awesome Tableau Software, I decided to take another look at the Healthcare Costs Data previously talked about at Centers for Medicare and Medicaid Services’.

This time, I restricted the data to the state of Florida (I’m here) and decided to drop the map.  The hopeful intent of this visualization is to provide the needed information as fast as possible.  As before, I cannot embed here but provide the link instead.  Just click on the images to play with visual.

Capture1

 

And for perspective, this is what Stephen did.

Capture2

Medical Provider Charge Database Download

Data is provided at Centers for Medicare & Medicaid Services here. This dataset is being both in Excel and CSV formats.

Data looks like this:

DRG Definition

039 – EXTRACRANIAL PROCEDURES W/O CC/MCC

Provider Id

10001

Provider Name

SOUTHEAST ALABAMA MEDICAL CENTER

Provider Street Address

1108 ROSS CLARK CIRCLE

Provider City

DOTHAN

Provider State

AL

Provider Zip Code

36301

Hospital Referral Region Description

AL – Dothan

Total Discharges

91

Average Covered Charges

32963.07692

Average Total Payments

5777.241758

Continue reading