APPLICATION OF POWER BI IN THE ANALYSIS OF CENTRALIZED PHARMACEUTICAL TENDERING AT CAN THO CITY IN 2023–2025
Main Article Content
Abstract
Background: Pharmaceutical tendering is a critical and recurrent activity that ensures the uninterrupted operation of healthcare facilities, particularly within the public sector. Reports across multiple provinces have repeatedly highlighted drug shortages occurring at various time points, largely attributable to challenges in the tendering and purchasing processes. To date, research on pharmaceutical tendering in Vietnam remains limited, especially studies applying analytical platforms such as Power BI to enhance data visualization and decision-making in tender management. Objectives: To analyze the characteristics of bidding plans and award results of six centralized pharmaceutical tender packages at the provincial level in Can Tho during 2023–2025. Material and Methods: A retrospective study was conducted using datasets extracted from the national electronic procurement portal administered by the Ministry of Finance. Data were cleaned, processed, and visualized through Power BI using a combination of charts and analytical dashboards. Results: A total of six tender packages for modern medicines were issued, comprising one originator-drug package and five generic packages (Groups 1–5), with an aggregated catalogue of 3,322 items. Generic packages accounted for 90 percent of the total item volume and 85 percent of the estimated contract value. The overall award rate reached 77.4 % of all listed items. Award rates by package were as follows: originator-drug package (75.5 %), Generic Group 1 (72.5 %), Group 2 (78.3 %), Group 3 (80.5 %), Group 4 (82.4 %), and Group 5 (61.3 %). Cost savings amounted to 10.7 % relative to the planned budget. Conclusion: The centralized local drug procurement process has achieved positive outcomes, with more than 77% of the items successfully awarded and cost savings exceeding 10% in terms of total value. However, over one-fifth of the pharmaceutical items failed to win bids due to various reasons, indicating that drug procurement activities at healthcare facilities still require further attention and improvement
Keywords
Pharmaceutical tendering, Power BI, Modern Medicines
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
References
2. Quốc hội. Luật Đấu thầu số 22/2023/QH15 ngày 23/06/2023.
3. Bộ Y tế. Công văn số 5882/BYT-KH-TC, về việc báo cáo khó khăn, vướng mắc trong công tác mua sắm, đấu thầu thuốc, thiết bị y tế ngày 30/09/2024.
4. Nikita Sharma, Dhrubasish Sarka. Healthcare Data Analytics Using Power BI. International Journal of Software Innovation (IJSI). 2022. 10(1),1-10. DOI: 10.4018/IJSI.293267.
5. Bộ Tài chính, Thông tư số 79/2025/TT-BTC. Hướng dẫn việc cung cấp, đăng tải thông tin về đấu thầu và mẫu hồ sơ đấu thầu trên hệ thống mạng đấu thầu quốc gia, ngày 04/08/2025.
6. Le Ngoc Danh, Do Van Dung, Lý Thanh Trung, và cộng sự. Analysis of the Centralized Drug Procurement Results at Ho Chi Minh City Department of Health. VNU Journal of Science: Medical and Pharmaceutical Sciences. 2021. Vol. 37, No. 1. https://doi.org/10.25073/25881132/vnumps.4292.
7. Nguyễn Thị Thanh Hương, Đào Thị Thúy Liên. Phân tích việc thực hiện kết quả đấu thầu thuốc tập trung tại sở y tế Hà Nam giai đoạn 2019 – 2021. Tạp chí Y học Việt Nam. 2023. 1, 130-134. 8. Trần Bá Kiên, Nghiên cứu đấu thầu thuốc generic tại các cơ sở y tế của tỉnh Hải Dương 2023, Tạp chí Y Dược học Cần Thơ, 2025, số 84, trang 92-100. https://doi: 10.58490/ctump.2025i84.3273.