|
|
|
| Application of Power BI visualization tool to build performance evaluation system in a hospital |
| Fu Jianfei1, Lu Yunfei1, Zhang Qingyu2, Ye Lirong1, Ge Haibo1, Li Yiping1, Chen Xueqin3. |
1. Department of Medical Records and Statistics, Ningbo First Hospital, Ningbo 315010, China;
2.Medical Administration Department, Ningbo First Hospital, Ningbo 315010, China;
3.Medical Quality Management Department, Ningbo First Hospital, Ningbo 315010, China |
|
|
|
|
Abstract 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 builtin 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.
|
|
Received: 28 August 2019
|
|
|
|
| ［1］浙江省卫生和计划生育委员会. 浙江省卫生计生委办公室关于应用疾病诊断相关组（DRGs）开展医院医疗服务质量与绩效评价工作的通知:浙卫办医政〔2016〕7号［EB/OL］.(2016-12-21)［2019-06-16］.http://www.zjwjw.gov.cn/art/2016/12/21/art_1208235_4657098.html.
［2］周敏. Power BI Premium 提供价格亲民的企业级功能［J］.计算机与网络，2017，43（10）：39.
［3］国家卫生计生委，国家中医药管理局，国务院医改办，等.关于巩固破除以药补医成果持续深化公立医院综合改革的通知:国卫体改发〔2018〕4号［EB/OL］.(2018-03).［2019-06-01］.http://www.nhfpc.gov.cn/tigs/s3581/201803/cf5b6ff7f55b4bc1a0d244f236008b32.shtml.
［4］郭永瑾，岑珏，许岩，等.疾病诊断分组系统的建立及其在医院绩效管理中的应用［J］.中国卫生政策研究，2015，8（9）：6-9.
［5］许岩，孙木，何萍，等.上海市医院疾病诊断分组模型及分组器的建立［J］.中国卫生政策研究，2015，8（9）：15-18.
［6］盖欧. 企业商业智能应用模式的研究［D］.西安：西安电子科技大学，2009.
［7］张会会，马敬东，邸金平.商业智能在医疗卫生领域的应用［J］.中国卫生信息管理杂志，2014，11（3）：255-259.
［8］邵晗征，陈朝晖，杜楚康.公立医院BI数据可视化模块设计研究:以CM医院为例［J］.卫生软科学，2018，32（4）：41-47.
［9］翟志斌，曹晓均.基于商业智能的医疗质量管理系统建设与应用［J］.中国数字医学，2016，11（7）：71-73.
［10］徐巧云，诸纪，陆雯珺.医疗大数据可视化系统架构研究与实践［J］.现代计算机（专业版），2017（30）：27-30.
［11］李晓华，张晓祥.住院病人医疗信息商业智能系统开发应用［J］.医学信息学杂志，2013，34（9）：42-46.
|
| [1] |
Wang Yuqin, Zhao Qinhua, Duan Congzhe, Lu Yao, Hu Junjun. Analysis on the enrollment of DRGs in MDCQ group[J]. journal1, 2022, 29(1): 54-57. |
| [2] |
Wu Li, Lü Zhijie, Lu Hanti, Huang Sijia, Zhou Penglei. Research on DRGs grouping for patients with chronic obstructive pulmonary disease based on quantile regression and decision tree model[J]. journal1, 2022, 29(1): 42-46. |
| [3] |
Guo Zhiwu. . Introduction to data visualization specification and discussion on its key elements[J]. journal1, 2020, 27(6): 572-576. |
| [4] |
Guo Zhiwu.. Application of Power BI in hospital data analysis [J]. journal1, 2020, 27(3): 280-283. |
| [5] |
Jia Nong, Luo Wei. Application of DRGs evaluation system in hospital management operation mode[J]. journal1, 2019, 26(4): 289-292. |
| [6] |
Liang Jingxing, Zhao Yuebao, Huang Yong, Wu Yuewen, Huang Xiaolin, Lun Yanhong, Ye Mingkun, Yang Hongjuan, Wu Xiaomin, Xie Liling, Zhou Tingting. Diagnosis and operation filling and coding defect of the first page of high rate paying cases based on DRGs payment[J]. journal1, 2019, 26(4): 307-310. |
|
|
|
|
