下载PDF
实例探究 > Hôpital Montfort builds a case for better healthcare with Power BI

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

技术
  • 分析与建模 - 预测分析
  • 分析与建模 - 实时分析
  • 应用基础设施与中间件 - 数据可视化
  • 应用基础设施与中间件 - 数据库管理和存储
适用行业
  • 医疗保健和医院
适用功能
  • 商业运营
  • 质量保证
用例
  • 实时定位系统 (RTLS)
  • 监管合规监控
  • 远程资产管理
服务
  • 数据科学服务
  • 系统集成
  • 培训
挑战
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.
关于客户
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.
解决方案
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.
运营影响
  • 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.
  • 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.
  • The hospital saw a dramatic shift in lab test ordering patterns within 30 days, with a significant reduction in unnecessary tests like electrolyte panels.
数量效益
  • The emergency department reduced lab utilization by 30%.

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

Thank you for your message!
We will contact you soon.