摘要
目的利用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.
作者
付建飞
陆云飞
张庆玉
叶丽蓉
葛海波
李一萍
陈雪琴
Fu Jianfei;Lu Yunfei;Zhang Qingyu;Ye Lirong;Ge Haibo;Li Yiping;Chen Xueqin(Department of Medical Records and Statistics,Ningbo First Hospital,Ningbo 315010,China;Medical Administration Department,Ningbo First Hospital,Ningbo 315010,China;Medical Quality Management Department,Ningbo First Hospital,Ningbo 315010,China)
出处
《中国医院统计》
2020年第1期79-83,共5页
Chinese Journal of Hospital Statistics
基金
浙江省医学会临床科研基金项目(2018ZYC-A63)。
关键词
医院绩效
DRGS
商业智能
数据可视化
hospital performance
DRGs
business intelligence
data visualization