Abstract
Accurate documentation of reasons for psychiatry consultations is critical for developing an effective treatment plan for the patient and improving quality of care through targeted interventions. The purpose of this project was to create an interactive dashboard on Power BI. We downloaded the report from Epic on SAP BI. On an Excel sheet, we recoded the reason for consults and categorized using a keyword list and recoded the consults into distinct, categories such as "anxiety," "depression," and "altered mental status (AMS)," with data spanning 2 fiscal years.
Key findings from the dashboard revealed that anxiety and depression accounted for most psychiatry consults, with significant variability across patient demographics and hospital services. The enhanced dashboard derived from this categorization enabled the identification of high-demand areas, such as leukemia and stem cell transplant services, and provided insights into unmet patient and provider needs. The Power BI Report-Psychiatry Consult Dashboard will be updated monthly until the institution establishes a safe, direct connection between Epic and Power BI; at that point, the data will be in real time. These findings underscore the potential of using this dashboard to transform psychiatry consult workflows, optimize resource allocation, and drive targeted quality improvement projects. Future research should explore broader applications of this dashboard to other hospital services and its scalability across healthcare systems.
DOI
https://doi.org/10.52519/ACEQI.25.1.2.a7
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-Share Alike 4.0 International License.
Recommended Citation
Shabih M, Martinez AD, Valentine AD, Chopra DA. Interactive Clinical Dashboard for Psychiatric Oncology Services at a Cancer Institution: A Quality Initiative. Advances in Cancer Education and Quality Improvement. 2025; 1(2). doi: https://doi.org/10.52519/ACEQI.25.1.2.a7.