Creating a clinical dashboard is easier than you think – and with this template and tips you’ll be on your way to having a dashboard in no time.
Quick Tips to Get You Started
First, you need the design for the Total Knee Replacement (TKR) Dashboard. Download it here in excel format.
Second, you need to remember three “truths” about quality data.
The Associated Press reported recently that Medicare launched mandatory bundled payment for hip and knee replacements effective April 1. 67 metropolitan areas are on the list and more will likely follow, so preparing for bundled payment ASAP is the smart play.
What’s Your First Move?
Here’s the first of more than a dozen clinical dashboards that I’ll share in the coming weeks. Why? Because the pressure on physicians and hospitals to manage clinical outcomes increased exponentially when ProPublica published surgeon complication rates on the web in July.
This dashboard is for total knee replacement (click here to download an excel file). It’s one of eight surgical procedures reported on the Surgeon Scorecard and is also a high volume procedure in many hospitals. It’s also included in your hospital’s Healthgrades ratings and Truven 100 Top Hospital profiles.
I’ve used this dashboard for over 15 years. It has always been a critical part of my quality programs because it provides all of the important information needed to manage the quality of care for total knee replacement patients. Just as administrators use a monthly financial report to manage their budgets, the total knee replacement dashboard becomes the monthly report to manage quality and safety for these patients.
The Total Knee Dashboard contains several important sections:
- Process measures. These represent treatments recommended by evidence based medicine guidelines and order sets.
- Outcome measures. These are patient outcomes such as complications, readmission rates, mortality and LOS. In this example, only rates for “not present on admission” are included, because we only want to know what occurred during the hospital stay.
- Core measures.
- Comprehensive rates for Healthgrades complications and the HealthGrades star rating.
- Direct costs divided into the usual cost buckets. Implant costs could also be included here.
- Estimates for the cost of complications based on the complication rates reflected in the dashboard.
Where You Can Get The Data for The Dashboard
Most of the dashboard data comes directly out of your finance, coding, and/or cost accounting systems. This is one of the best kept secrets in healthcare. Frankly, there is enough data in these systems, (that can be converted into clinical dashboards), to keep you busy for the next 10 years. I’ve used this type of administrative data for the past 20 years and it’s been key to all of the 100 Top Hospital, 15 Top Health System, and Healthgrades designations.
I’ll post a second dashboard next week. Until then, if you have any questions about this dashboard feel free to email me at firstname.lastname@example.org and I’ll get back to you as quickly as possible.
PS: The data contained in the dashboard is for demonstration purposes only.
In an article posted October 13, 2015, ProPublica announced that the American Board of Orthopaedic Surgery (ABOS ) will use ProPublica’s Surgeon Scorecard to help assess the competency of its surgeons.
According to ABOS Director Shepard Hurwitz, MD, “The American Board of Orthopaedic Surgery will incorporate (ProPublica) Scorecard’s ratings into its recertification process, in which surgeons are formally re-evaluated every 10 years.” He said, ‘Surgeons may also be put on a watch list based on their Scorecard rating.”
Dr. Hurwitz said the ABOS board of directors approved the decision on Oct. 5.
The ABOS is the first surgical board to formally use ProPublica’s Scorecard in it’s recertification process.
About 11,500 orthopedic surgeons are rated on the Surgeon Scorecard for complications following hip and knee replacements, two types of lumbar spinal fusion, and cervical fusion.
The Surgeon Scorecard has been controversial since it’s introduction in July, but publishing physician performance has been long overdue. It’s a good first step in helping patients find surgeons based on the physician’s outcomes.
Dr. Hurwitz went on to say that the decision by the ABOS “… is controversial, but the fact that we’re doing it is in the spirit of transparency and holding people accountable for what’s already in the public domain.”
Like this story? Read my previous post, Surgeon Complication Rates Now Posted on the Internet where I share how I used this information when my sister underwent a knee replacement.