[1]胡志伟.基于PowerBI的病案首页可视化统计分析[J].医学信息,2023,36(21):21-26.[doi:10.3969/j.issn.1006-1959.2023.21.005]
　HU Zhi-wei.Visual Statistical Analysis of Medical Record Home Page Based on PowerBI[J].Journal of Medical Information,2023,36(21):21-26.[doi:10.3969/j.issn.1006-1959.2023.21.005]
点击复制

基于PowerBI的病案首页可视化统计分析()
分享到：

医学信息[ISSN:1006-1959/CN:61-1278/R]

卷:
36卷
期数:
2023年21期
页码:
21-26
栏目:
卫生管理信息学
出版日期:
2023-11-01

文章信息/Info

Title:
Visual Statistical Analysis of Medical Record Home Page Based on PowerBI
文章编号:
1006-1959（2023）21-0021-06
作者:
胡志伟
（珠海市第三人民医院医教部，广东 珠海 519000）
Author(s):
HU Zhi-wei
(Medical Education Department of Zhuhai Third People’s Hospital,Zhuhai 519000,Guangdong,China)
关键词:
PowerBI; 病案首页; 医疗质量; 可视化分析
Keywords:
PowerBI; Medical record home page; Medical quality; Visual analysis
分类号:
R197.32
DOI:
10.3969/j.issn.1006-1959.2023.21.005
文献标志码:
A
摘要:
以某医院广东省医疗机构病案统计管理系统数据为研究对象，使用PowerBI构建病案首页可视化统计分析工具，对工作效率、病人来源、疾病谱与手术、费用结构与特征分布、绩效考核、DIP入组6个方面进行分析。其优点在于可节约人工重复统计数据的时间成本且避免人为出错，将工作效率提高67%；社会效益上，能为广东省信息化水平不足的医院提供可借鉴使用的工具模板，为医院提供准确的病案首页及医疗质量监测指标，极大提高病案统计工作效率，实现医疗机构管理上的提质增效与高质量发展。
Abstract:
Taking the data of the medical records statistical management system of a hospital in Guangdong Province as the research object, the paper uses PowerBI to build a visual statistical analysis tool for the medical record home page, and analyzes six aspects of work efficiency, patient source, disease spectrum and surgery, cost structure and characteristic distribution, performance evaluation, and DIP grouping. Its advantages are that it can save the time cost of manual repeated statistical data and avoid human error, and improve the work efficiency by 67%. In terms of social benefits, it can provide a tool template that can be used for reference for hospitals with insufficient informatization level in Guangdong Province, provide accurate medical record home page and medical quality monitoring indicators for hospitals, greatly improve the efficiency of medical record statistics, and realize the improvement of quality and efficiency and high-quality development in the management of medical institutions.

参考文献/References:

[1]舒婷,赵韡,刘海一.2020年我国医院电子病历系统应用水平分析[J].中国卫生质量管理,2022,29(1):8-10.[2]卢建军,辛子艺,余俊蓉.广东省电子病历系统建设现状及对病案质量的影响[J].中国医院统计,2022,29(3):228-231.[3]郭志武.PowerBI在医院数据分析中的应用[J].中国医院统计,2020,27(3):280-283.[4]陈蕾,李文源.基于知识图谱的病案首页研究可视化分析[J].现代医院,2021,21(12):1818-1821.[5]陈宇邦.住院病案首页数据挖掘和统计分析服务医院管理的研究[J].医学信息,2020,33(1):17-18.[6]陈美玲,温星来,冯素花.SQL语言在医院统计工作中的应用[J].中国病案,2022,23(1):24-26.[7]阳雅雯,江涛,杨翠.基于床位效能评价优化综合医院床位配置的应用研究[J].现代预防医学,2021,48(22):4219-4224.[8]张平,郭慧敏,杜军.基于病案首页的患者来源空间可视化研究[J].中国病案,2019,20(3):31-33.[9]欧嘉新,朱宏,张远妮.2017-2019年广东省综合公立医院住院费用结构变化的研究[J].中国卫生经济,2021,40(6):71-74.[10]杨嘉麟,杨巍,钟力炜.综合医院和中医类医院日间手术病种住院费用及结构的对比分析[J].华西医学,2023,38(2):220-225.[11]丁甜甜,钱爱兵,王璐瑶.基于CiteSpace的我国公立医院绩效考核研究可视化分析[J].中国医疗管理科学,2023,13(1):51-56.[12]陈妍霖,邓玮,陈幼花.基于绩效考核背景下某三级公立医院提高医院四级手术量的实践探讨[J].中国医疗管理科学,2022,12(6):81-84.[13]黄俊杰,黄明智,朱敬蕊.基于三级公立医院绩效考核标准的手术患者并发症统计分析[J].中华全科医学,2022,20(8):1423-1426.[14]庾静雯,廖南南.基于广州市某医院2016-2020年住院病案首页数据对急诊入院患者疾病谱特征分析[J].华南预防医学,2022,48(7):838-842.[15]刘彩芳,冯素花,郭慧玲.某三甲医院2016-2021年内科住院患者疾病谱分析[J].现代医院,2023,23(2):217-220.[16]李倩,高建民,牟怡平.某院2015年-2019年罕见病住院病例特征分析[J].中国卫生质量管理,2021,28(8):27-30.[17]陈韧,彭彬,李震洋.医院应用DIP管理系统实施按病种分值付费改革的实践[J].中国卫生信息管理杂志,2021,18(5):584-588,598.[18]滕璐.县级公立医院实施按病种分值付费（DIP）的现状研究[D].济南:山东大学,2022.[19]沈佳伦,张亚林,周伟.按病种分值付费背景下公立医院医疗行为分析[J].中国医疗保险,2023(1):98-101.

相似文献/References:

[1]郭筱萍.PDCA循环在提升病案首页信息质量的应用及持续改进[J].医学信息,2018,31(05):27.[doi:10.3969/j.issn.1006-1959.2018.05.010]
　GUO Xiao-ping.Application and Continuous Improvement of PDCA Circulation in Improving the Information Quality of First Page of Medical Record[J].Journal of Medical Information,2018,31(21):27.[doi:10.3969/j.issn.1006-1959.2018.05.010]
[2]张中花.病案首页书写缺陷分析及解决对策[J].医学信息,2019,32(06):29.[doi:10.3969/j.issn.1006-1959.2019.06.011]
　ZHANG Zhong-hua.Analysis of the Writing Defects on the Front Page of Medical Records and Solutions[J].Journal of Medical Information,2019,32(21):29.[doi:10.3969/j.issn.1006-1959.2019.06.011]
[3]李玉萍.疾病诊断名称与分类编码对照对提升病案首页质量的意义[J].医学信息,2020,33(09):17.[doi:10.3969/j.issn.1006-1959.2020.09.006]
　LI Yu-ping.Significance of the Comparison of Disease Diagnosis Name and Classification Code to Improve the Quality of the First Page of Medical Records[J].Journal of Medical Information,2020,33(21):17.[doi:10.3969/j.issn.1006-1959.2020.09.006]
[4]高宏富,赵 辉,关 雪.2019年河北省某医院住院病案首页质量填写的帕累托图分析[J].医学信息,2021,34(02):145.[doi:10.3969/j.issn.1006-1959.2021.02.040]
　GAO Hong-fu,ZHAO Hui,GUAN Xue.Pareto Chart Analysis of the Quality of the Front Page of Inpatient Medical Records in a Hospital in Hebei Province in 2019[J].Journal of Medical Information,2021,34(21):145.[doi:10.3969/j.issn.1006-1959.2021.02.040]
[5]唐 路,宋 萍,谢冰珏,等.基于自主研发智能审核平台的病案首页质控效果评价[J].医学信息,2023,36(07):27.[doi:10.3969/j.issn.1006-1959.2023.07.005]
　TANG Lu,SONG Ping,XIE Bing-jue,et al.Evaluation of Quality Control Effect of Medical Records Front Pages Based on Self-developed Intelligent Audit Platform[J].Journal of Medical Information,2023,36(21):27.[doi:10.3969/j.issn.1006-1959.2023.07.005]
[6]窦一峰,崔金广,杨 洁,等.基于天津市某三甲医院的病案首页数据质量与DRGs评测分析[J].医学信息,2022,35(04):24.[doi:10.3969/j.issn.1006-1959.2022.04.007]
　DOU Yi-feng,CUI Jin-guang,YANG Jie,et al.Medical Case Home Page Data Quality and DRGs Evaluation Analysis Basedon a Tertiary Hospital in Tianjin[J].Journal of Medical Information,2022,35(21):24.[doi:10.3969/j.issn.1006-1959.2022.04.007]
[7]李 文.PDCA循环改进对提高胸科医院病案首页主要诊断正确率的影响[J].医学信息,2023,36(15):164.[doi:10.3969/j.issn.1006-1959.2023.15.035]
　LI Wen.Effect of PDCA Circulation Improvement on Improving the Main Diagnostic Accuracy of the Front page of Medical Records in Chest Hospital[J].Journal of Medical Information,2023,36(21):164.[doi:10.3969/j.issn.1006-1959.2023.15.035]

更新日期/Last Update: 1900-01-01