Skip navigation

Healthcare

2 Posts authored by: Derek Cyr Employee

Check out the blog to download the starter kit today!

I was looking over the hospital compare website the other day and was amazed at how many measures are now publicly reported here (78 distinct KPIs). Many of these are directly tied to reimbursement and all are considered critical. And this is just the tip of the iceberg! NQF endorsed measures now number over 700 and KPIs like Employee engagement, internal productivity, strategic market share, and Physician Satisfaction all play critical roles in determining a Health Provider’s success. Many of my colleagues have wondered where to begin, how to make sense of prioritizing what to work on next and how to respond to the ever-changing needs. With fixed resources to improve the Patient experience of care, reduce the cost of care and improve the health of populations (IHI’s Triple Aim), having an agile framework that supports rapid deployment is key.

As I thought about how to solve this problem, I drew inspiration from a number of excellent Community posts over the years. Andy Kriebel’s A New Way to Visualize an Income Statement Analytic served as a great starting point and I knew I needed to build upon Jonathan Drummey’s work outlined in User Defined Functions and Process Control Charts to include support for the widely used u, p, x and c Statistical Process Control charts. I also want to acknowledge the thought leadership of Lloyd P. Provost and Sandra Murray. Their contributions around demystifying Statistical Process Control Charts in Healthcare delivered via the Institute for Healthcare Improvement (IHI) has had a tremendous impact on the process improvement community at large.  Also shout outs to Patrick Murphy, Alexis Guinebertiere, Matt McWhorter, Ray Ready and Diane Campbell who all helped bring this to life through their influence, inspiration and hard work over the years (and over the last couple weeks!). With that, I would like to introduce you to the Executive KPI Dashboard Starter Kit for Tableau.

KPI Dashboard.png

The Executive KPI Dashboard Starter Kit for Tableau was designed to help Hospitals rapidly deploy a solution to see and understand their most critical Key Performance Indicators.   With Hospitals facing as much as a 6% reduction in Inpatient Medicare reimbursement annually ($Millions if not $10’s of $Millions of dollars per hospital), it is imperative that Hospitals clearly understand their performance so they can focus efforts where they stand to maximize returns and not get distracted by or overwhelmed with the 100’s of publicly reported measures that are out there.  This Starter Kit serves to accelerate the sharing of information and provides a scaffolding to further automate the collection of critical data elements as well as unify analytics across multiple platforms. 

The Executive KPI Dashboard itself accomplishes this by employing a consistent, simple, easy to understand visualization of your most critical measures. A 3 second glance at the Dashboard allows you to quickly understand the state of 12 KPIs and see how you are doing (The number on each bar) against a goal (the color based on performance against benchmark), over time (sparkline) and most recently (ball color at end of sparkline). From here you can drill through to a linked Dashboard to learn more (perhaps another Tableau Dashboard that you recently built or even a Dashboard on another platform so you can provide a one-stop shop for your KPIs). You can also link to reference material (perhaps an NQF measure specification or an internal wiki page) and even look at the performance through the lens of an SPC chart (with the signals for special cause variation automatically called out). And with Dashboard layouts designed specifically for the Tableau Mobile App, you can check on how you are performing while waiting for a plane at the airport.

As part of the starter kit, you will find:
1) The Tableau workbook, built to handle customization of number formats, desired directions for measures (Up is good for net margin, but bad for infection rates) and multiple measure/dashboard combinations
2) The Starter Guide to help you deploy the workbook
3) An Excel based data source to enable the robust features of the workbook
4) a Tableau Prep Flow to tie the data together
5) Some sample Tableau Prep flows to inspire you to further automate your data collection.

I hope you find this helpful as a good way to accelerate your Data Driven Culture!  Check out the blog to download the starter kit today!

Recently our Tableau Solutions Consultant Team presented a webinar on how to build a real time floor plan dashboard.  We had a solid turnout (Thank you, we hope you found it helpful!) and some excellent Q&A!  For those of you that missed it, for those of you that would like to replicate the process and for those of you that would like to see how the data was constructed, I have included several resources here for you:

 

1) A Link to a recording of the session(Tableau Mapping for Healthcare | Tableau Software) as part of the larger Tableau for Healthcare Series (Tableau for Healthcare | Tableau Software )

2) The Data (Current ED Patients.xlsx)

3) The Presentation (Real-Time Floorplan Dashboard Presentation (shareable).twbx)

4) The Blank Floor plan Dashboard with the instructions in the captions (Floorplan Dashboard - blank.twb)

5) The sample image of a floor plan (hospital-floor-plan.png)

6) The blank floor plan data file (Floor Plan - blank.xlsx)

7) The completed floor plan data file (Floor Plan.xlsx)

8) The javascript page that has the nice refresh (RefreshIFRAME3.html)

 

Items 2 through 8 are in the attached zip file.  I hope you find this helpful!

 

For those of you that want to jump right in....

 

1) get an image of the floorplan you want to use as your background.

2) open Floorplan Dashboard - blank.twb and start from the leftmost tab and follow the instructions in the captions.