A new rolling forecasting framework using Microsoft Power BI for data visualization: A case study in a pharmaceutical industry
Annales Pharmaceutiques Françaises · 2024
DOI: 10.1016/j.pharma.2023.10.013 ↗Kurz gefasst
Fachartikel in der Zeitschrift Annales Pharmaceutiques Françaises, 2024. Verfasst von Mariem Belghith und 3 weiteren Autor:innen. Beteiligte Einrichtung: Laboratory of Modelling and Optimization for Decisional, Industrial and Logistic Systems (MODILS), Faculty of Economics and Management of Sfax, Unive…. Hauptthemen laut MEDLINE: Data Visualization, Drug Industry. Die Arbeit wurde bisher 10-mal zitiert (Crossref) und nennt 29 Literaturangaben. Gefördert von: Taif University, Deanship of Scientific Research, King Saud University.
Abstract (Originalsprache)
CONTEXT AND OBJECTIVES: Demand forecasting is a vital step for production planning and consequently, for supply chain efficiency, especially for the pharmaceutical (pharma) supply chain due to its unique characteristics. Numerous models and techniques that are proposed in the literature but little in concrete and generic framework to forecasting process, mainly for pharmaceutical supply chain. Unlike studies in the literature, this study not only perfectly predict the sales of a pharma manufacturer, but also visualize the results via a developed dashboard using modern information technology and business intelligence. MATERIAL AND METHODS: In this research, a rolling forecasting framework comprising of different steps and specialized tools is proposed that can assist supply chain managers to perform an accurate sales forecasting and consequently a better performance and specifically patient satisfaction. The proposed generic framework combines the use of Visual studio C++ software to extract optimal forecasting and the Power BI software to monitor the accuracy of the obtained sales forecasts. Three exponential smoothing methods are integrated in the proposed framework, which is open to adding more new forecasting methods. RESULTS: The proposed framework is tested for many data sets from a pharmaceutical manufacturer company, and the results obtained show superior performance, especially a clear decline in both forecast errors, which can reach 75% and a drop of stock level to 50%. Therefore, the company is currently using it and a future integration with their ERP is being carried out. CONCLUSION: The proposed rolling forecasting framework contributes to insightful decision-making through the visualization of accurate future sales and turnover, and consequently, an efficient stock management and effective production planning.
Schlagwörter
MeSH-Schlagwörter (MEDLINE)
Stichwörter der Autor:innen
Substanzen
Autor:innen und Institutionen
- Laboratory of Modelling and Optimization for Decisional, Industrial and Logistic Systems (MODILS), Faculty of Economics and Management of Sfax, University of Sfax, 3039 Sfax, Tunisia. Electronic address: maryembelghithe…
- Mechanics, Modelling and Production Research Laboratory (LA2MP), Mechanical Department, National School of Engineers of Sfax, University of Sfax, Sfax, Tunisia.
- Laboratory of Modelling and Optimization for Decisional, Industrial and Logistic Systems (MODILS), Faculty of Economics and Management of Sfax, University of Sfax, 3039 Sfax, Tunisia.
- Department of Industrial Engineering, College of Engineering, Taif University, P.O. Box 11099, 21944 Taif, Saudi Arabia.
Förderung
- Taif University
- Deanship of Scientific Research, King Saud University
Zitieren
APA
Belghith, M., Ben Ammar, H., Elloumi, A., & Hachicha, W. (2024). A new rolling forecasting framework using Microsoft Power BI for data visualization: A case study in a pharmaceutical industry. Annales Pharmaceutiques Françaises. https://doi.org/10.1016/j.pharma.2023.10.013
Vancouver
Belghith M, Ben Ammar H, Elloumi A, Hachicha W. A new rolling forecasting framework using Microsoft Power BI for data visualization: A case study in a pharmaceutical industry. Annales Pharmaceutiques Françaises. 2024. doi:10.1016/j.pharma.2023.10.013
BibTeX
@article{Belghith2024,
author = {Belghith, Mariem and Ben Ammar, Hanen and Elloumi, Abdelkarim and Hachicha, Wafik},
title = {A new rolling forecasting framework using Microsoft Power BI for data visualization: A case study in a pharmaceutical industry},
journal = {Annales Pharmaceutiques Françaises},
year = {2024},
doi = {10.1016/j.pharma.2023.10.013}
}
EUVIMED