Oslo University analyzes healthcare data in hours rather than months
Oslo University Hospital is Scandinavia's largest hospital, born from the merger of four smaller hospitals in 2010. The hospitals had separate databases that had to be merged for enterprise-wide analyses. For instance, the two radiology departments used various types of medical imaging at different frequencies, making it difficult to determine things like what type of test was more commonly used at one facility. Analysis often required programming skills that researchers and administrators lacked and reports had to be run by the IT department.
The hospital implemented a solution that used Power Query to collect radiology data from department systems. The data was loaded into a cloud-based database and then prepared and organized in a Power Query workbook in Excel, hosted on a Power BI website that can be used as a collaboration site for sharing queries among researchers. By implementing Power BI, radiology data that would have taken months to collect and analyze could now be analyzed and presented to executives and researchers within hours.
"This is a dream," says Eli Marie Sager, MD, CEO of The Clinic for Diagnostics and Intervention at Oslo University Hospital. "With Power BI, we can understand what is happening in the departments in a few hours, rather than after months."
Sign up for CIO Asia eNewsletters.