Developing a Sales Dashboard with Power BI – A Case Study in a Pharmaceutical Company

Authors

  • Mariem Belghith Ep Kallel Laboratory of Modelling and Optimization for Decisional, Industrial and Logistic Systems, Faculty of Economics and Management of Sfax, University of Sfax, Sfax, Tunisia https://orcid.org/0000-0002-3725-1255
  • Sana Bouajaja OASIS Laboratory, National Engineering School of Tunis, University of Tunis El Manar, Tunis https://orcid.org/0000-0003-2523-3292
  • Abdelkarim Elloumi Laboratory of Modelling and Optimization for Decisional, Industrial and Logistic Systems, Faculty of Economics and Management of Sfax, University of Sfax, Sfax, Tunisia https://orcid.org/0009-0001-1364-4345

DOI:

https://doi.org/10.31181/dma21202438

Keywords:

Data analysis, Key Performance Indicators , KPIs, Sales dashboard, Industry 4.0, Pharmaceutical industry

Abstract

A dashboard is a steering tool for data-driven decision-making and a lever for innovation in the pharmaceutical industry. It makes it possible to integrate relevant performance measurement indicators, chosen according to the objectives to be achieved and according to specific criteria. In this context, our work is inscribed, which aims to develop a dashboard for the sales department of a pharmaceutical company. The choice of this tool is motivated by its importance and the strategic challenge it presents for companies today. The implementation of this dashboard will be broken down into four phases. First, we collect sales department sales and develop the data marts. Then, to generate the data model, we have to import the database into Power BI (Microsoft Power Business Intelligent). We select the adequate KPIs (Key Performance Indicators) to create the interactive sales dashboard. This dashboard allows the decision makers to analyze and visualize data, moving from traditional sales data storage to big data analytics. Based on this visualization tool, the sales manager can propose potential improvements and essential investments and develop the management review to be presented as an annual report. This report is important for managing and monitoring pharmaceutical activities. Existing data are used and visualized to target the goals of decision-makers.

Downloads

Download data is not yet available.

References

BIAT. (2017). Etude sectorielle sur l'industrie pharmaceutique 2017 [Online]. https://www.biat.com.tn/communication-financiere/document/etude-sectorielle-sur-lindustrie-pharmaceutique 2017, (last accessed 2023/08/22).

Pauwels, K., Ambler, T., Clark, B. H., LaPointe, P., Reibstein, D., Skiera, B., Wierenga, B., & Wiesel, T. (2009). Dashboards as a service: why, what, how, and what research is needed? Journal of service research, 12(2), 175-189. https://doi.org/10.1177/1094670509344213

Mahmodabadi, A. D., Langarizadeh, M., Mehrjardi, M. H. M., & Emadi, S. (2019). Development of managerial key performance indicators for a hospital pharmacy digital dashboard. Iranian Journal of Pharmaceutical Research: IJPR, 18(4), 2124. https://doi.org/10.22037/ijpr.2019.1100822

Suk, S. J., Hwang, B. G., Dai, J., Caldas, C. H., & Mulva, S. P. (2012). Performance dashboard for a pharmaceutical project benchmarking program. Journal of Construction Engineering and Management, 138(7), 864-876. https://doi.org/10.1061/(ASCE)CO.1943-7862.0000503

Howson, C. (2007). Successful business intelligence: Secrets to making BI a killer app. McGraw-Hill Osborne Media.

Rasmussen, N. H., Bansal, M., & Chen, C. Y. (2009). Business dashboards: a visual catalog for design and deployment. John Wiley & Sons.

Eckerson, W. W. (2010). Performance dashboards: measuring, monitoring, and managing your business. John Wiley & Sons.

Belghith, M., Ben Ammar, H., Masmoudi, F., & Elloumi, A. (2021). Data Visualization for Industry 4.0: Developing Dashboards with Power BI–A Case Study in a Pharmaceutical Company. In International Conference Design and Modeling of Mechanical Systems (pp. 402-408). Cham: Springer International Publishing. https://doi.org/10.1007/978-3-031-14615-2_45

Yigitbasioglu, O. M., & Velcu, O. (2012). A review of dashboards in performance management: Implications for design and research. International Journal of Accounting Information Systems, 13(1), 41-59. https://doi.org/10.1016/j.accinf.2011.08.002

Sakly, H., & Jeddou, K. B. (2022). Development and implementation of dashboard in the Pharmacy Department at University Hospital. Le Pharmacien Clinicien, 57(1), 6-15. https://doi.org/10.1016/j.phclin.2021.09.002

Khalil Zadeh, N., Sepehri, M. M., & Farvaresh, H. (2014). Intelligent sales prediction for pharmaceutical distribution companies: A data mining based approach. Mathematical Problems in Engineering, 2014. https://doi.org/10.1155/2014/420310

Sahoo, S. K., Routray, P., & Dash, A. K. (2014). Does Motivation Really Count for Sales force Performance in Pharmaceutical Industry?. Business and Management Research, 3(2), 1-9. http://dx.doi.org/10.5430/bmr.v3n2p1

Fourkiotis, K. P., & Tsadiras, A. (2024). Applying Machine Learning and Statistical Forecasting Methods for Enhancing Pharmaceutical Sales Predictions. Forecasting, 6(1), 170-186. https://doi.org/10.3390/forecast6010010

Dutta, S. R., Das, S., & Chatterjee, P. (2022, April). Smart sales prediction of pharmaceutical products. In 2022 8th International Conference on Smart Structures and Systems (ICSSS) (pp. 1-6). IEEE. https://doi.org/10.1109/ICSSS54381.2022.9782271

Sohrabi, B., Raeesi Vanani, I., Nikaein, N., & Kakavand, S. (2019). A predictive analytics of physicians prescription and pharmacies sales correlation using data mining. International Journal of Pharmaceutical and Healthcare Marketing, 13(3), 346-363. https://doi.org/10.1108/IJPHM-11-2017-0066

Renaud, J., Couturier, R., Guyeux, C., Courjal, B., & Christine, G. I. O. T. (2022, March). A Comparative Stud of Predictive Models for Pharmaceutical Sales Data. In 2022 2nd International Conference on Computer, Control and Robotics (ICCCR) (pp. 191-195). IEEE. https://doi.org/10.1109/ICCCR54399.2022.9790232

Kinney, A., Bui, Q., Hodding, J., & Le, J. (2017). Pharmacy dashboard: an innovative process for pharmacy workload and productivity. Hospital pharmacy, 52(3), 198-206. https://doi.org/10.1310/hpj5203-198

Bahl, V., McCreadie, S. R., & Stevenson, J. G. (2007). Developing dashboards to measure and manage inpatient pharmacy costs. American Journal of Health-System Pharmacy, 64(17), 1859-1866. https://doi.org/10.2146/ajhp060596

Azami-Aghdash, S., Tabrizi, J. S., Sadeghi-Bazargani, H., Hajebrahimi, S., & Naghavi-Behzad, M. (2015). Developing performance indicators for clinical governance in dimensions of risk management and clinical effectiveness. International Journal for Quality in Health Care, 27(2), 110-116. https://doi.org/10.1093/intqhc/mzu102

Karami, M. (2014). A design protocol to develop radiology dashboards. Acta Informatica Medica, 22(5), 341.

Published

2024-04-06

How to Cite

Belghith Ep Kallel, M., Bouajaja, S., & Elloumi, A. (2024). Developing a Sales Dashboard with Power BI – A Case Study in a Pharmaceutical Company . Decision Making Advances, 2(1), 142–147. https://doi.org/10.31181/dma21202438