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.
付建飞,陆云飞,张庆玉,叶丽蓉,葛海波,李一萍,陈雪琴. 基于Power BI的医院绩效数据分析与可视化展示[J]. 中国医院统计, 2020, 27(1): 79-83.
Fu Jianfei, Lu Yunfei, Zhang Qingyu, Ye Lirong, Ge Haibo, Li Yiping, Chen Xueqin.. Application of Power BI visualization tool to build performance evaluation system in a hospital. journal1, 2020, 27(1): 79-83.
