Click here to

Session: Professional General ePoster Viewing [Return to Session]

Connecting Tableau to An Oncology Informatics System to Identify Treatment Planning Workflow Delays

A Witztum1*, P Sharma2, E Hirata1, (1) University of California, San Francisco, San Francisco, CA, (2) University Of San Francisco, CA


PO-GePV-P-5 (Sunday, 7/25/2021)   [Eastern Time (GMT-4)]

Purpose: Over one-third of patient treatment plans at our institution are approved by the physician the day of, or the day prior to the new treatment start date. With the mean number of new starts increasing to over 10 per day, it is important to quickly identify plans held up at any stage in the planning process. This work develops a Tableau dashboard to visualize the status of quality check list (QCL) tasks for upcoming new start appointments.

Methods: The Mosaiq SQL database was connected to Tableau, a commercial data visualization toolkit. The treatment planning workflow was separated into seven components: simulation, contouring, planning, quality assurance, physics check, document approval, and therapist check. Each of these elements were classified as pending, completed, or in progress, with further information such as staff responsible, elapsed time, and any notes from Mosaiq shown where relevant. Upcoming patient new start appointments were extracted from the database, sorted by date, and stratified by clinic location. Filters were added to allow users to search for patients or drill-down to specific start dates, clinic locations, and machines.

Results: A web-based platform was created through which users can get an overview of plan status for upcoming new start appointments. Elapsed time of QCL tasks can be used to identify when and where tasks are held up, and the responsible staff member initials make it easy to identify a point of contact for follow-up. Notes from the QCL in Mosaiq are displayed with a hover-over action, allowing additional information to be relayed. Comments can be added directly to the Tableau dashboard to facilitate communication about plans between staff.

Conclusion: Tableau allows for a clean web-based display of information and eliminates multi-click searches within Mosaiq. Thoughtful data visualization and simple filters facilitate a proactive approach to workflow bottlenecks and challenges.



    Quality Assurance, Quality Control, Operations Research


    Not Applicable / None Entered.

    Contact Email