摘要
目的基于Power BI构建国家集中采购(集采)药品精细化管理平台,实现高效自动化数据分析,助力国家药品集采政策实施。方法利用Power BI软件构建信息化管理模板,并导入国家集采药品数据进行分析,最终呈现可视化的数据分析画布。结果基于Power BI构建的国家集采药品精细化管理平台能够提供标准化、同质化、可视化分析视图,显著提升国家集采药品全院任务量上报测算、科室任务量分配、全使用情况监测、完成情况分析等相关工作的效率。结论通过该国家集采药品精细化管理平台,实现高效便捷的国家集采药品数据可视化分析。
Objective To facilitate the implementation of the centralized procurement policy,we build a refined management platform for the national centralised drug procurement(NCDP)that can achieve efficient and automated data analysis based on Power BI.Methods Power BI software is used to build information management templates,and import NCDP data for an efficient analysis,and and ultimately present a convenient visual display of the usage data.Results Based on Power BI,the NCDP Refined Management Platform is able to provide standardised,homogenised and visualised analysis views,which significantly improves the efficiency of related work.Hospital managers can make decisions quickly and effectively,such as reporting and calculating the workload of volume-based NCDP in the whole hospital,assigning the workload of departments,monitoring the whole use situation and analyzing the completion situation.Conclusion The refined management platform for NCDP based on Power BI can provide standardized,homogeneous and visual analysis.
作者
辛昊
梁宇
姜明燕
邢曼
曹建华
XIN Hao;LIANG Yu;JIANG Mingyan;XING Man;CAO Jianhua(Department of Pharmacy,the Third People's Hospital of Qingdao City,Affiliated to Qingdao University,Qingdao 266041,China;Department of Pharmacy,the First Affiliated Hospital of China Medical University,Shenyang 110001,China)
出处
《医药导报》
CAS
北大核心
2023年第10期1497-1501,共5页
Herald of Medicine
基金
中国药学会科技开发中心项目(CMEI2022KPYJ00529)。