Starter Kit II – Revenue Cycle Management Dashboard

Almost one year ago, I was lucky enough to be offered an exciting job opportunity to join Tableau’s Healthcare Team after spending much of my professional career working for a leading healthcare revenue cycle management (RCM) company. It was there where I experienced, first-hand, how important it was for healthcare providers to be able to leverage data and analytics across their entire revenue cycle. As one of the more technical members on the Customer Success Team, I enjoyed partnering with my customers to provide them with reporting and analytics so that they could make informed decisions about claims denials, charge capture and coding, payment posting, appeals and collections (just to name a few areas). I quickly witnessed how dependent these organization’s RCM teams were on us, as a vendor, to provide them with high-quality reporting and analytics, so they could gain more insight into how their revenue cycle was performing and identify potential improvement areas.

After building and delivering hundreds of ad-hoc solutions for my customers, I found that there are several reasons for this dependency, but many of them can be summarized by 1) Lack of internal access to operational, financial, and clinical data which has been curated to solve “revenue cycle problems” or 2) Rigid or complex technology which can be intimidating to those who are most familiar with Excel.

Earlier this year I came across a study based on a survey conducted by Kaufman Hall, where 96% of healthcare financial executives (CFOs) said that their organization needs to do more to leverage financial and operational data analytics to optimize their care delivery model from both a financial and clinical standpoint. Given what I described above, this was shocking to me to have almost 100% consensus among these Executives about the importance of data analytics in RCM and yet still having the level of dependency on outside vendors.

Figure 1: The Healthcare Provider Revenue Cycle Management Dashboard

For that reason, I decided to build the Healthcare Provider Revenue Cycle Management Starter Kit, which I’d like to think is an entry-point for Providers to take back control of the reporting and analytics that impact their own organization’s revenue cycle. The Healthcare Provider RCM Dashboard is designed to provide healthcare providers of all types and sizes with increased visibility and insight into three key areas of their revenue cycle: 1) Transactional Trending; 2) Accounts Receivables; 3) Denials Management.

As part of the starter kit, you will find:

1) The Tableau workbook, built increase visibility and insight into three key areas of their revenue cycle: 1) Transaction Trending; 2) Accounts Receivables; 3) Denials Management.

2) The Starter Guide to help you deploy the workbook

3) Three Excel based data sources to enable the robust features of the workbook

4) A Sample Tableau Prep Flow to tie the data together

My hope is that with this Starter Dashboard, you can you ask and answer questions from your revenue cycle data in an easy, valuable, and secured manner.

Please contact your Tableau Account Manager to get started today.

Starter Kit: Executive KPI Dashboard

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 and hard work. With that, I would like to introduce you to the Executive KPI Dashboard Starter Kit for Tableau.

Figure 1. The Executive KPI Dashboard

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.

Give it a spin and unleash the power of your data!

Download the Starter kit today!