Sudbury Regional Hospital
Steve Volpini is Clinical Information System Project Coordinator for the Regional Cancer Program (RCP) at Sudbury Regional Hospital in Sudbury, Ontario, Canada, one of 14 in the province of Ontario. RCPs (created and funded through Cancer Care Ontario) "respond to local cancer issues, coordinate care across local and regional healthcare providers, and work to continually improve access to care, reduce wait times and improve quality" for their patients. A key consideration for RCP funding is reducing patient wait times so, for Sudbury Ontario, obtaining daily updates on patient wait times is a critical issue. Clinicians and management alike need detailed wait time information on a per-site, per-provider basis to make adjustments in staffing patterns to better serve their fluctuating patient population.
Until recently Steve had not been able to acquire this type of data in a timely manner. In fact, the only option was to wait for Cancer Care Ontario to provide access to their data portal - a process that in some cases took two months from the time the patient activity had occurred. Unfortunately, by the time the data was published in the portal, it was often too late for actionable use. Even worse, the vast majority of reporting tools available required a significant amount of development and programming savvy. In order to get to the type of information needed to make changes, Steve reported that it was a "mountainous task to use our standard reporting tools to create sub-report upon sub-report to get to the patient specific information necessary to take action".
What Steve needed was the ability to mine clinical data in real time on his own, so that he could have up-to-the-minute snapshots relating to his clinic's performance, with the ability to drill down to specific site, provider, and patients.
Steve found what he wanted in MedAdvizor, a data visualization and analysis software application that grabs his production data "on the fly" - loading directly from his IMPAC MOSAIQ SQL Server database and puts it into memory for browser based interaction with a highly visual dashboard interface. Now he can "pop open a project, click and drill down. It takes 20 seconds versus a couple of days to get the answers and detail I need. What used to be an impossible two month project can now be done very quickly". As for ease-of-use, Steve reported, "The user interface is intuitive. I like it."
In addition to intuitive design, other benefits include the ability to "drill anywhere", get updated data instantly from the MOSAIQ database, and customize the data that is loaded using SQL queries as needed.
He noted that his administrators can create their own STAT reports with little training. In addition, his managers can run full reports in seconds, with the added benefit of the results being displayed in visually appealing graphs and charts which his oncologists can instantly comprehend.