Princess Margaret Integrated Dashboard
One of our objectives at the Princess Margaret Data Science Program is to increase the access to data for the broader PM community in a way that will help optimize research & clinical efforts. The COVID-19 pandemic has accelerated our roadmap for this initiative.
During the COVID-19 pandemic our Institute, led by the Smart Cancer Care Program, made a big push towards virtual care with the development of the Virtual Care Management System (VCMS). During this transition, there was a need to monitor near real-time patient visit information to inform PM executives making key data-driven decisions, and continuously measure the impact of the policies and procedures to limit the spread of the virus among cancer care providers and patients.
To address these pressing needs, we built a dashboard by leveraging the Microsoft Power BI platform & connecting with multiple data sources including clinics and radiotherapy scheduling systems (i.e. PHS & MOSAIQ, respectively). The result is a clear and dynamic view of patient ambulatory care activities across PMH sorted by clinic category (i.e. chemo daycare, imaging, lab, etc.) & clinic name (i.e. bone marrow transplant, breast oncology, ENT oncology, etc.)
Using this new integrated dashboard, we can also monitor the use of VCMS; by looking at the number of patients switched from in-person visits to over-the-phone or the number of physician’s orders signed off and processed in the system. These data will support further improvements to the system and drive implementation research endeavors to help transform the models of care during and beyond COVID-19.