DESIGNING A BUSINESS INTELLIGENCE DASHBOARD FOR DEMAND-DRIVEN INVENTORY MANAGEMENT: A CASE STUDY OF MEDIKLUG PHARMACEUTICAL DISTRIBUTION COMPANY
DOI:
10.5281/zenodo.18821611Published:
2026-01-06Downloads
Abstract
In pharmaceutical distribution, balancing high product variety with fluctuating demand is a constant challenge. When inventory decisions don’t reflect actual customer usage, companies face a frustrating cycle of stock-outs for popular items and dusty shelves for slow-movers—eventually hurting the bottom line. Mediklug, a healthcare tech firm, faced this exact issue; despite having detailed clinic-level consumption data from their EMR system, they saw a significant revenue dip in late 2025. This study explores how to bridge that gap using Demand-Driven Supply Chain (DDSC) principles. By leveraging Business Intelligence (BI), we aimed to turn Mediklug’s "data wealth" into actual insights. The research focused on three areas: identifying where demand and inventory were mismatched, building a BI dashboard to guide better purchasing, and seeing if the team would actually find the tool useful. We took a mixed-methods approach, cleaning up messy EMR data to match inventory records and interviewing the people on the front lines. The results were clear: the mismatches were systemic, but the new dashboard made demand much easier to see and manage. Most importantly, the stakeholders found the solution practical and easy to use. Ultimately, this case shows that even in complex pharmaceutical environments, BI can make "demand-driven" management a reality rather than just a theory.
Keywords:
Business Intelligence Dashboard Demand-Driven Supply Chain Pharmaceutical Distribution CompanyReferences
Bvuchete, M., Grobbelaar, S. S., & Eeden, J. van. (2021). A Network Maturity Mapping Tool for Demand-Driven Supply Chain Management: A Case for the Public Healthcare Sector. Sustainability, 13(21), 1–29. https://doi.org/10.3390/su132111988
Chopra, S., & Meindl, P. (2016). Supply Chain Management: Strategy, Planning, and Operation (6th ed.). Pearson.
Few, S. (2013). Information Dashboard Design: Displaying Data for At-a-glance Monitoring (2nd ed.). Analytics Press.
Heryawan, L., Mori, Y., Yamamoto, G., Kume, N., Lazuardi, L., Fuad, A., & Kuroda, T. (2025). Fast Healthcare Interoperability Resources (FHIR)–Based Interoperability Design in Indonesia: Content Analysis of Developer Hub’s Social Networking Service. JMIR Formative Research, 9(April), 1–12. https://doi.org/10.2196/51270
Kim, D. (2005). An Integrated Supply Chain Management System: A Case Study in Healthcare Sector (Vol 3590; In: Bauknecht, K., Pröll, B., Werthner, H. (Eds) E-Commerce and Web Technologies. EC-Web 2005. Lecture Notes in Computer Science, Vol 3590. Springer, Berlin, Heidelberg.). https://doi.org/10.1007/11545163_22
Lee, H. L., Padmanabhan, V., & Whang, S. (1997). Information Distortion in a Supply Chain: The Bullwhip Effect. Management Science, 43(4), 546–558. https://doi.org/10.1287/mnsc.43.4.546
Mendes, P. (2011). Demand Driven Supply Chain: A Structured and Practical Roadmap to Increase Profitability. Springer Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-19992-9
Myers, M. D. (2020). Qualitative Research in Business & Management (3rd ed.). SAGE Publications Ltd. https://doi.org/10.4135/9781036208417
Turban, E., Sharda, R., Delen, D., King, D., & Aronson, J. E. (2011). Business Intelligence: A Managerial Approach (2nd ed.). Prentice Hall : New Jersey. https://davidhason.com/wp-content/uploads/2024/05/Business-Intelligence_-A-Managerial-Approach.pdf
Watson, H. (2009). Business Intelligence: Past, Present and Future. Americas Conference on Information Systems (AMCIS), 153. https://aisel.aisnet.org/amcis2009/153/
Wixom, B., & Watson, H. (2010). The Bi-Based Organization. International Journal of Business Intelligence Research, 1(1), 13–28. https://doi.org/10.4018/jbir.2010071702
Zaki, M. R. S., Ramadiani, A. D., & Sinay, I. R. (2023). The Impact of the Peduli Lindungi Electronic System on Human Rights and Personal Data Protection. E3S Web of Conferences, 388(04038), 1–5. https://doi.org/10.1051/e3sconf/202338804038
License
Copyright (c) 2026 Nicolaus Ernest Mamonto, Leo Aldianto
This work is licensed under a Creative Commons Attribution 4.0 International License.
Downloads
How to Cite
