Skip to main content

Data Visualization for Industry 4.0: Developing Dashboards with Power BI – A Case Study in a Pharmaceutical Company

  • 888 Accesses

Part of the Lecture Notes in Mechanical Engineering book series (LNME)


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.


  • 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

USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
USD   189.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   249.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions


  • 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)

    CrossRef  Google Scholar 

  • 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)

    CrossRef  Google Scholar 

  • Clark, B.H., Abela, A.V., Ambler, T.: Behind the wheel. Mark. Manag. 15(1), 19–23 (2006)

    Google Scholar 

  • Howson, C.: Successful Business Intelligence: Secrets to Making BI a Killer App. McGraw-Hill, New York (2008)

    Google Scholar 

  • Eckerson, W.W.: Performance Dashboards: Measuring, Monitoring, and Managing Your Business, 2nd edn., pp. 212–215. Wiley, New York (2010)

    Google Scholar 

  • Lempine, H.: Design framework for performance management systems: an ensemble approach. Aalto University (2013)

    Google Scholar 

  • Sakly, H., Ben Jeddou, K.: Development and implementation of dashboard in the Pharmacy Department at University Hospital. Le Pharmacien Hospitalier et Clinicien (2021)

    Google Scholar 

  • 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)

    Google Scholar 

  • Karami, M.: A design protocol to develop radiology dashboards (2014)

    Google Scholar 

  • Kinney, A., Bui, Q., Hodding, J., Le, J.: Pharmacy dashboard: an innovative process for pharmacy workload and productivity. Hosp. Pharm. 52, 198–206 (2017)

    CrossRef  Google Scholar 

  • Pauwels, K., et al.: Dashboards as a service: why, what, how, and what research is need? J. Serv. Res. 12(1), 175–189 (2009)

    CrossRef  Google Scholar 

  • 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)

    Google Scholar 

  • Abdelfattah, M.: A comparison of several performance dashboards architectures. Intell. Inf. Manag. 5(2), 35–41 (2013)

    MathSciNet  Google Scholar 

  • Rasmussen, N.H., Bansal, M., Chen, C.Y.: Business Dashboards: A Visual Catalog for Design and Deployment. Wiley, Hoboken (2009)

    Google Scholar 

  • 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)

    CrossRef  Google Scholar 

  • Cocca, P., Alberti, M.: A framework to assess performance measurement systems in SMEs. Int. J. Product. Perform. Manag. 59(2), 186–200 (2010)

    CrossRef  Google Scholar 

  • Stevenson, J.G.: Developing dashboards to measure and manage inpatient pharmacy costs. Am. J. Health Syst. Pharm 64, 1859–1866 (2007)

    CrossRef  Google Scholar 

  • 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)

    CrossRef  Google Scholar 

Download references


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

Correspondence to Mariem Belghith , Hanen Ben Ammar or Faouzi Masmoudi .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

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.

Download citation

  • DOI:

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-14614-5

  • Online ISBN: 978-3-031-14615-2

  • eBook Packages: EngineeringEngineering (R0)