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.