SCCA’s infusion bays where patients receive blood products, chemotherapy, hydration, and other services had capacity constraints due to the department’s growth and limited space. As SCCA kicked off Tableau use, they wanted to track daily and weekly infusion bay utilization and identify hotspots to try and level load the department and operate more smoothly. Galen Busch, SCCA’s Senior Tableau Developer and Tableau Administrator, says, “Tableau helped us discover areas for potential optimization and gauge the success of changes to clinical scheduling, hours of operation, and workflow.”
The Clinical Analytics Team, along with the Infusion Services Team, built dashboards in Tableau that measured bay allocation to utilization, and tracked scheduled and cancelled appointments to understand if they were effectively allocating space and resources throughout the day and week to treat patients from different disease groups.
SCCA knew when patients checked in and when they left the patient bay, but they also wanted to dig deeper to understand how long patients wait before their drug is infused or how long they wait once infusion stops and they depart the clinic. The Clinical Analytics Team, pharmacy team, and nursing staff aligned to monitor the timeframe during all of these appointment phases with other appointment data like disease category. By analyzing actual treatment time compared to expected time, SCCA was able to identify and investigate instances of longer-than-expected appointments and work to reduce patient wait times. The result is an improved patient treatment experience and smarter use of infusion resources across all disease groups.
Having a physician and clinic manager as data champions helped the Infusion Services Team gain traction with Tableau and drove interest in using data across operations. For instance, the clinic manager dove into specific visit types with Tableau to see if they ran longer or shorter than the scheduled time. Then they made adjustments to appointment length to appropriately schedule the visit, eliminate wait time, and better allocate resources and space.
With a macro-level view of the average infusion experience and the micro-view of specific patient visits analyzed in Tableau, SCCA understands the patient’s total experience and better identifies opportunities to make improvements to their infusion process and clinic operations.