Abstract
Performance measurement is the key to controlling and optimizing organizational activities. Pharmaceutical companies need to retrieve, process, compare and update information. Dashboards are a new tool to track key performance indicators by displaying information to managers to improve campaign performance. This work presents a case study in a pharmaceutical industry that produces drugs in solid and liquid forms. It identifies key indicators and sets up and to develop and validate a new production dashboard. This last is used for the management and the monitoring of pharmaceutical activities which utilize and visualize existing data in order to allow the decision-makers to target their goals.
First, the data are collected from the production process then, the entity-relationship diagram is developed. Second, the database has been imported into Microsoft Power Business Intelligent (Microsoft Power BI). The selected key performance indicators (KPIs) will be used to create an interactive dashboard to be analyzed and visualized and to help the decision-makers to move from the traditional style of production data storage to big data analytics. Finally, based on all the results, the production manager can make investment proposals and will prepare a management review which will be presented to the owner in the form of an annual result.
Keywords
- Key performance indicators
- Dashboard
- Industry 4.0
- Pharmaceutical industry
- Data analysis
- Power BI
This is a preview of subscription content, access via your institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Tung, A., Baird, K., Schoch, H.P.: Factors influencing the effectiveness of performance measurement systems. Int. J. Oper. Prod. Manag. 31(12), 1287–1310 (2011a)
Azami-Aghdash, S., Tabrizi, J.S., Sadeghi-Bazargani, H., Hajebrahimi, S., Naghavi-Behzad, M.: Developing performance indicators for clinical governance in dimensions of risk management and clinical effectiveness. Int. J. Qual. Health Care 27(2), 110–116 (2015)
Clark, B.H., Abela, A.V., Ambler, T.: Behind the wheel. Mark. Manag. 15(1), 19–23 (2006)
Howson, C.: Successful Business Intelligence: Secrets to Making BI a Killer App. McGraw-Hill, New York (2008)
Eckerson, W.W.: Performance Dashboards: Measuring, Monitoring, and Managing Your Business, 2nd edn., pp. 212–215. Wiley, New York (2010)
Lempine, H.: Design framework for performance management systems: an ensemble approach. Aalto University (2013)
Sakly, H., Ben Jeddou, K.: Development and implementation of dashboard in the Pharmacy Department at University Hospital. Le Pharmacien Hospitalier et Clinicien (2021)
July, J., Sabzghabaee, A.M., Badri, S., Ashari, H.E., Hosseini, S.M.: The design and equipments of hospital pharmacies in IsfahanIran. J. Res. Med. Sci. 15(4), 219 (2010)
Karami, M.: A design protocol to develop radiology dashboards (2014)
Kinney, A., Bui, Q., Hodding, J., Le, J.: Pharmacy dashboard: an innovative process for pharmacy workload and productivity. Hosp. Pharm. 52, 198–206 (2017)
Pauwels, K., et al.: Dashboards as a service: why, what, how, and what research is need? J. Serv. Res. 12(1), 175–189 (2009)
Mahmodabadi, A.D., Langarizadeh, M., Mehrjardi, M.H.M., Emadi, S.: Development of managerial key performance indicators for a hospital pharmacy digital dashboard. Iran. J. Pharm. Res. 18(4), 2124–2130 (2019)
Abdelfattah, M.: A comparison of several performance dashboards architectures. Intell. Inf. Manag. 5(2), 35–41 (2013)
Rasmussen, N.H., Bansal, M., Chen, C.Y.: Business Dashboards: A Visual Catalog for Design and Deployment. Wiley, Hoboken (2009)
Yigitbasioglu, O.M., Velcu, O.: A review of dashboards in performance management: implications for design and research. Int. J. Account. Inf. Syst. 13(1), 41–59 (2012)
Cocca, P., Alberti, M.: A framework to assess performance measurement systems in SMEs. Int. J. Product. Perform. Manag. 59(2), 186–200 (2010)
Stevenson, J.G.: Developing dashboards to measure and manage inpatient pharmacy costs. Am. J. Health Syst. Pharm 64, 1859–1866 (2007)
Tung, A., Baird, K., Choch, H.P.: Factors influencing the effectiveness of performance measurement systems. Int. J. Oper. Prod. Manag. 31(12), 1287–1310 (2011b)
Acknowledgments
The authors gratefully acknowledge insightful comments and suggestions in the development of this paper from The Mechanics, Modelling and Manufacturing LAboratory (LA2MP) of the National School of Engineers of Sfax and the Mechanical Engineering Laboratory (LGM) of National School of Engineers of Monastir and seminar participants of the International Congress Design and Modelling of Mechanical Systems (CMSM’2021), and two anonymous reviewers. The authors would also like to acknowledge support from the Sfax Industrie 4.0 Center.
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Belghith, M., Ben Ammar, H., Masmoudi, F., Elloumi, A. (2023). Data Visualization for Industry 4.0: Developing Dashboards with Power BI – A Case Study in a Pharmaceutical Company. In: Walha, L., et al. Design and Modeling of Mechanical Systems - V. CMSM 2021. Lecture Notes in Mechanical Engineering. Springer, Cham. https://doi.org/10.1007/978-3-031-14615-2_45
Download citation
DOI: https://doi.org/10.1007/978-3-031-14615-2_45
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-14614-5
Online ISBN: 978-3-031-14615-2
eBook Packages: EngineeringEngineering (R0)