Case Studies Hôpital Montfort builds a case for better healthcare with Power BI

Edit This Case Study Record

	Hôpital Montfort builds a case for better healthcare with Power BI

Hôpital Montfort builds a case for better healthcare with Power BI

Technology Category	Analytics & Modeling - Predictive Analytics Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Visualization Application Infrastructure & Middleware - Database Management & Storage
Applicable Industries	Healthcare & Hospitals
Applicable Functions	Business Operation Quality Assurance
Use Cases	Real-Time Location System (RTLS) Regulatory Compliance Monitoring Remote Asset Management
Services	Data Science Services System Integration Training
Challenge	Choosing Wisely Canada is a campaign aimed at reducing unnecessary medical tests and treatments. Hôpital Montfort in Ottawa, Ontario, needed a way to provide physicians with performance data to help them make informed decisions about lab and imaging interventions. The hospital's existing tools for creating medical reports were time-consuming and lacked interactivity, requiring significant IT department involvement. This made it difficult for physicians to access real-time, specific data needed to reduce unnecessary tests. Read More
About Customer	Hôpital Montfort is a healthcare institution located in Ottawa, Ontario, Canada. It is committed to providing high-quality medical care and is involved in the Choosing Wisely Canada campaign, which aims to reduce unnecessary medical tests and treatments. The hospital employs over 1,000 staff members and serves a diverse patient population. It has been leveraging Microsoft Power BI for business analytics in various departments, including finance, HR, and medical training statistics, to improve operational efficiency and decision-making processes. Read More
Solution	Hôpital Montfort adopted Microsoft Power BI to provide physicians with real-time, interactive data to support the Choosing Wisely Canada initiative. The hospital's Systems Administrator and Lead BI Architect, Marc-André Lépine, tested the new version of Power BI and found it user-friendly and compliant with the hospital's security requirements. The solution involved developing an ETL process with SQL Server Integration Services to extract data from the Meditech Medical System database, creating in-memory analytics tabular models, and connecting to the Power BI service through an on-premises data gateway. This setup allowed for quick dashboard creation and real-time data analysis, enabling physicians to make informed decisions about lab test orders. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Predictive Analytics

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Visualization

Application Infrastructure & Middleware - Database Management & Storage

Applicable Industries

Healthcare & Hospitals

Applicable Functions

Business Operation

Quality Assurance

Use Cases

Real-Time Location System (RTLS)

Regulatory Compliance Monitoring

Remote Asset Management

Services

Data Science Services

System Integration

Training

Challenge

Choosing Wisely Canada is a campaign aimed at reducing unnecessary medical tests and treatments. Hôpital Montfort in Ottawa, Ontario, needed a way to provide physicians with performance data to help them make informed decisions about lab and imaging interventions. The hospital's existing tools for creating medical reports were time-consuming and lacked interactivity, requiring significant IT department involvement. This made it difficult for physicians to access real-time, specific data needed to reduce unnecessary tests.

About Customer

Hôpital Montfort is a healthcare institution located in Ottawa, Ontario, Canada. It is committed to providing high-quality medical care and is involved in the Choosing Wisely Canada campaign, which aims to reduce unnecessary medical tests and treatments. The hospital employs over 1,000 staff members and serves a diverse patient population. It has been leveraging Microsoft Power BI for business analytics in various departments, including finance, HR, and medical training statistics, to improve operational efficiency and decision-making processes.

Solution

Hôpital Montfort adopted Microsoft Power BI to provide physicians with real-time, interactive data to support the Choosing Wisely Canada initiative. The hospital's Systems Administrator and Lead BI Architect, Marc-André Lépine, tested the new version of Power BI and found it user-friendly and compliant with the hospital's security requirements. The solution involved developing an ETL process with SQL Server Integration Services to extract data from the Meditech Medical System database, creating in-memory analytics tabular models, and connecting to the Power BI service through an on-premises data gateway. This setup allowed for quick dashboard creation and real-time data analysis, enabling physicians to make informed decisions about lab test orders.

Impact #1	The implementation of Power BI allowed Hôpital Montfort to provide physicians with interactive data to assess their performance and utilization profiles within their departments.
Impact #2	The lab utilization dashboard included several reports, such as a summary overview, departmental view, and individual physician results, with data access controlled by Azure Active Directory and Row-Level Security.
Impact #3	The hospital saw a dramatic shift in lab test ordering patterns within 30 days, with a significant reduction in unnecessary tests like electrolyte panels.

Impact #1

The implementation of Power BI allowed Hôpital Montfort to provide physicians with interactive data to assess their performance and utilization profiles within their departments.

Impact #2

The lab utilization dashboard included several reports, such as a summary overview, departmental view, and individual physician results, with data access controlled by Azure Active Directory and Row-Level Security.

Impact #3

The hospital saw a dramatic shift in lab test ordering patterns within 30 days, with a significant reduction in unnecessary tests like electrolyte panels.

Benefit #1	The emergency department reduced lab utilization by 30%.

Benefit #1

The emergency department reduced lab utilization by 30%.

Download PDF Version

Overview

Hôpital Montfort builds a case for better healthcare with Power BI

Operational Impact

Quantitative Benefit