Power BI Desktop在医院DIP精细化管理中的应用

Application of Power BI Desktop in the fine management of hospital DIP

目的利用Power BI Desktop对医院DIP分组明细进行多维度对比分析及数据可视化,寻找医院DIP亏损原因。方法提取某三甲肿瘤专科医院2022年度部分出院结算DIP入组明细数据,通过数据导入、数据类型转换、建立数据关系、数据建模、数据可视化等方法,建立全院、科室、病种等多个维度的可视化动态分析报表。结果Power BI Desktop能有效提升DIP精细化管理水平,提升工作效率,精准分析亏损原因,指导科室进行改进,有效减少医院DIP医保资金亏损。结论Power BI Desktop具有成本低廉,定制化、可视化、自动化程度高,用户界面友好等特点,值得在各医院尤其是信息化程度低、专科运营人员不足、资金预算不足的医院DIP精细化管理中进行推广。

Objective To use Power BI Desktop for multidimensional comparative analysis and data visualization of hospital DIP subgroup details,in order to identify the causes of DIP losses in hospitals.Methods The data were extracted from the DIP subgroup discharge settlement details of a tertiary oncology hospital in 2022.Methods such as data import,data type conversion,data relationship establishment,data modeling,and data visualization were used to build dynamic analysis reports for different dimensions such as the entire hospital,departments,and disease categories.Results Power BI Desktop can effectively enhance the level of fine management for DIP,improve work efficiency,accurately analyze the causes of losses,guide departments in making improvements,and effectively reduce the DIP insurance fund losses for the hospital.Conclusion Power BI Desktop is characterized by its low cost,customization,high level of visualization and automation,as well as a user-friendly interface,making it suitable for promotion in hospitals,especially those with low levels of informatization,insufficient specialized operational personnel,and limited budget for DIP fine management.