Related business intelligence articles:

12 Microsoft Power BI success stories

Microsoft Power BI provides organizations with self-service business intelligence tools that allow users to analyze, visualize and share data using the familiar Microsoft Excel spreadsheet. Here are 12 success stories built on Power BI.

Related business intelligence articles:

Show More
1 2 Page 2
Page 2 of 2

"We can visualize our medical data much more quickly and easily than before. Our reports and more dynamic and more detailed than anything we've seen before," says Anund Rannestad, head of innovation for Stavanger University Hospital, the second-largest hospital in the Helse Vest system.

For instance, Helse Vest can now view combined surgery data, providing the ability to compare operating checklist trends from the different hospitals in the region.

"We now have real-time data, which means we get updated data metrics for the staff at each hospital," Rannestad says. “This will help us act on those metrics much sooner, while the metrics are still valid for the staff, and we believe this will have a significant positive impact on patient safety measures."

MediaCom boosts productivity and optimizes ad campaigns

Global advertising agency MediaCom needed to measure the health of ad campaigns it created to optimize performance and spending. It needed to pull together the results into a single, composite score within hours. But it was faced with isolated systems, a variety of third-party data sources and expensive and complicated BI software.

With Microsoft and Power BI, MediaCom created a "health check" that quickly captured the many facets of a multi-platform media campaign, boosting productivity by 10 percent and gain anywhere from thousands to millions of dollars per campaign.

"Power BI will fundamentally change the way we manage campaign performance," says Lowell Simpson, CIO of MediaCom. "Digital moves much faster than traditional campaigns, so gaining the ability to optimize all channels on a daily basis is a real improvement."

North Tees uses BI to boost clinical outcomes

For years, the North Tees and Hartlepool National Health Services Foundation Trust used an on-premises Ascribe clinical intelligence system to track the clinical use of drugs, the costs associated and efficacy of treatment. But the system did not allow North Tees to include external data sets or explore the data in real-time.

Then North Tees become a test site for a self-service BI toolset based on Power BI. Developers took an extract of North Tees data and imported it into a Power Pivot model built in a day; previously, it would've taken five days. Now North Tees can incorporate external data sets into its analyses, deliver more intuitive and persuasive reports and reduce costs.

"With Microsoft Power BI and Ascribe, we could understand which bacteria are resistant to which antibiotics in various areas at various times," says Prof. Philip Dean, head of the Department of Pharmacy and Quality Control Laboratory Services at the North Tees and Hartlepool National Health Services Trust. "We could understand how socio-economic status affects the health of, and medicines used by, our population. There's virtually nothing we can't understand better with this technology."

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."

Related articles

Copyright © 2017 IDG Communications, Inc.

1 2 Page 2
Page 2 of 2
Survey says! Share your insights in our 2020 CIO Tech Poll.