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

Belghith, Mariem; Ammar, H. Ben; Masmoudi, Faouzi; Elloumi, Abdelkarim

doi:10.1007/978-3-031-14615-2_45

Cited by 3 publications

(3 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Data storage can rely on traditional solutions such as relational databases or more advanced ones such as cloud databases. Data visualization and processing can be handled, instead, through Business Intelligence (BI) software (Microsoft PowerBI), allowing the management of large amounts of data and the creation of graphical interfaces for easy reference by all stakeholders [35].…”

Section: Discussionmentioning

confidence: 99%

Supporting Asset Management with GIS and Business Intelligence Technologies: The Case Study of the University of Turin

Gasbarri,

Accardo,

Cacciaguerra

et al. 2024

IJGI

View full text Add to dashboard Cite

Despite the promising outcomes achieved over time in Asset Management, data accessibility, correlation, analysis, and visualization still represent challenges. The integration, readability, and interpretation of heterogeneous information by different stakeholders is a further concern, especially at the urban scale, where spatial data integration is required to correlate virtual information with the real world. The Geographic Information System (GIS) allows these connections, representing and digitizing extensive areas with significant benefits for asset analysis, management, and decision-making processes. Such benefits are central for managing large and widespread university campuses as they are comparable to small cities, covering a wide urban region and including resources highly integrated into the urban context. The paper presents how GIS integrated into Business Intelligence (BI) tools can support university Asset Management System (AMS) creation for the optimal use of resources, illustrating the University of Turin case study. The results discussion considers the relationship between the different elements of the assets and their synergy with the city. It focuses on four themes, dealing with the asset identification of buildings and resources, especially the educational ones, asset spatiotemporal evolution, and buildings’ distances for proximity analysis. The benefits achievable through the AMS, related challenges, and possible future developments are highlighted.

show abstract

Section: Discussionmentioning

confidence: 99%

Supporting Asset Management with GIS and Business Intelligence Technologies: The Case Study of the University of Turin

Gasbarri,

Accardo,

Cacciaguerra

et al. 2024

IJGI

View full text Add to dashboard Cite

show abstract

“…Several works were presented in the literature in order to design, create and implement dashboards in different fields, such as Production [8]. For more information on dashboard visualization and user his properties, interested readers can refer to the full review suggested by [9].…”

Section: Introductionmentioning

confidence: 99%

“…Though some work has been done in the literature on the implementation of dashboards in the pharmaceutical sector to propose key indicators and develop dashboards in the pharmaceutical sector [3,4,8,10]. Particularly, we can cite papers focusing on studying sales performance and predictions in pharmaceutical companies as [11,12].…”

Section: Introductionmentioning

confidence: 99%

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

Ep Kallel,

Bouajaja,

Elloumi

2024

Decis. Mak. Adv.

View full text Add to dashboard Cite

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.

show abstract

Deriving inferences through natural language from structured datasets for asset lifecycle management

Sanchit,

Bhattacharjee,

Pandhare

2024

IFAC-PapersOnLine

View full text Add to dashboard Cite

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

Cited by 3 publications

References 9 publications

Supporting Asset Management with GIS and Business Intelligence Technologies: The Case Study of the University of Turin

Supporting Asset Management with GIS and Business Intelligence Technologies: The Case Study of the University of Turin

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

Deriving inferences through natural language from structured datasets for asset lifecycle management

Contact Info

Product

Resources

About