基于Power BI的医院绩效数据分析与可视化展示

Application of Power BI visualization tool to build performance evaluation system in a hospital

目的利用Power BI对医院绩效数据进行数据分析和可视化展示,提供一种较快捷、可视化程度高的分析方法。方法提取某三甲医院于2017年1月1日至2018年6月30日的住院绩效数据,经过数据导入、数据类型转换、建立数据关系、数据建模等方法,利用内置的可视化模板,结合实际需求和展示效果,从医疗服务整体技术难度、医疗效率、外科能力、医疗安全、重点专科能力等多个维度创建可视化绩效展示报表。结果完成临床科室数据指标总览、临床科室相对权重分布情况、临床科室手术情况、临床科室病组病历详细查询等报表制作,这些报表具有可视化程度高、图表丰富、定制方便快捷等特点。结论Power BI具有不依赖IT部门、门槛低且定制化程度高、可视化模板丰富、函数易于理解等特点,可作为医院统计工作人员进行医院绩效数据分析的优选工具。

Objective To provide a fast and rich visualized-template analysis method for the hospital statisticians.Methods The hospital performance data from January 1,2017 to June 30,2018 were extracted.After data import,data type conversion,data relationship,and data modeling method,using the built-in visualization template,combined with the actual demand and display effect,the study constructed a series of delicate visualized reports from the overall technical difficulty of medical services,medical efficiency,medical safety,and key specialist capabilities.Results The study produced several reports such as an overview of clinical department data indicators,RW distribution of clinical department,clinical department surgery,and detailed query of clinical department medical records.These reports have the characteristics of high degree of visualization,rich chart,convenient and quick customization.Conclusion Power BI has the characteristics of not relying on IT department,low threshold and a high degree of customization,rich visual template and easy function to understand,and can be used as the preferred tool for hospital statisticians to analyze hospital performance data.