Developing a Sales Dashboard with Power BI – A Case Study in a Pharmaceutical Company
DOI:
https://doi.org/10.31181/dma21202438Keywords:
Data analysis, Key Performance Indicators , KPIs, Sales dashboard, Industry 4.0, Pharmaceutical industryAbstract
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
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.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2024 Scientific Oasis

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.