Power BI在我院药品数据可视化中的应用

Application of Power BI in the Visualization of Drug Data in Our Hospital

目的加强医院药品精细化管理,提升药师对药品的数据分析能力,实现数据分析自动化及查询功能,为集采药品、麻精药品的动态监管提供数据支撑。方法使用数据可视化工具Power BI搭建服务,制作报表,能够查询药品使用情况和对比情况,实现各科室药品使用情况的可视化管理。结果通过该软件,药师可以精确查询任意时间维度下药品的使用数量、金额等情况,实现数据分析自动化。结论借助数据管理工具能够帮助药师提升数据分析能力和工作效率,有助于加强医院药品的精细化管控。

OBJECTIVE To strengthen the fine management of drugs in hospitals,improve the data analysis ability of pharmacists,realize the automation and query function of data analysis,and provide data support for the dynamic supervision of centralized procurement of drugs and anesthetic drugs.METHODS The data visualization tool Power BI was used to build a service,make reports,query the drug usage and comparison,and realize the visual management of drug use in each department.RESULTS Through the software,pharmacists can accurately query the quantity and amount of drugs used in any time dimension,and realize data analysis automation.CONCLUSION With the help of data management tools,pharmacists can improve their data analysis ability and work efficiency,and help strengthen the fine control of drugs in hospitals.