Enhancing operational efficiency with business intelligence: Industrial applications

• Autorzy: Kočišová Michaela , Slota Ján , Sukopová Dominika , Fiľo Milan

Identyfikatory

DOI

10.12913/22998624/203797

• Języki publikacji: EN

Abstrakty

EN

In the rapidly evolving world of business intelligence (BI) and data analytics, MS Power BI Desktop has become a key tool for data visualization and improving decision-making across various sectors. This article examines the development of MS Power BI Desktop since its introduction in 2017 and provides a detailed analysis of its applications across different industries, with a focus on manufacturing. The aim was to create an analytical tool that would meet the specific requirements of a company facing challenges in efficiently processing and visualizing large amounts of data. As part of this research, we developed a dashboard in collaboration with a manufacturing company, designed according to its needs. In the process of selecting the tool, we compared MS Power BI Desktop with other popular tools such as Tableau and Qlik Sense. We found that MS Power BI Desktop best suited the company’s needs, especially in terms of cost-effectiveness, ease of integration with existing systems, and the ability to customize visualizations for different organizational needs. This tool provided valuable analytical insights that helped identify areas for improvement, such as optimizing manufacturing processes and reducing downtime. The results show how the use of MS Power BI Desktop led to significant improvements in operational efficiency and supported strategic decision-making. This paper contributes to the literature on practical applications of MS Power BI Desktop in real business conditions, providing concrete examples and recommendations for further use of this tool in various industrial sectors.

Słowa kluczowe

EN

data visualization; business intelligence; Microsoft Power BI; dashboard development

• Wydawca: Lublin University of Technology ; Polish Society of Ecological Engineering (PTIE), Branch of PTIE in Lublin
• Czasopismo: Advances in Science and Technology. Research Journal
• Rocznik: 2025
• Tom: Vol. 19, no. 7
• Strony: 252--265
• Opis fizyczny: Bibliogr. 39 poz., fig., tab.

Twórcy

autor

Kočišová Michaela

• Faculty of Mechanical Engineering, Technical University of Košice, Letná 1/9, 042 00 Košice-Sever, Slovakia

• https://orcid.org/0009-0004-6611-290X

autor

Slota Ján

• Faculty of Mechanical Engineering, Technical University of Košice, Letná 1/9, 042 00 Košice-Sever, Slovakia

• https://orcid.org/0000-0002-9054-0902

autor

Sukopová Dominika

• Faculty of Mechanical Engineering, Technical University of Košice, Letná 1/9, 042 00 Košice-Sever, Slovakia

• https://orcid.org/0000-0002-7920-9450

autor

Fiľo Milan

• Faculty of Mechanical Engineering, Technical University of Košice, Letná 1/9, 042 00 Košice-Sever, Slovakia

• https://orcid.org/0009-0002-8724-3701

Bibliografia

• 1. Negrut V. Power BI: Effective data aggregation. Quaestus 2018; 13: 146–152. https://www.proquest.com/scholarly-journals/power-bi-effective-data-aggregation/docview/2120790110/se-2.
• 2. Aspin A. Pro Power BI Desktop, 2nd ed.; Elsevier B.V.: Oxford, United Kingdom, 2017; 1–761.
• 3. Rad R. Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions, 1st ed.; Elsevier B.V.: New Zealand, 2018; 1–545.
• 4. Al Omari I., Al Omoush R., Innab H., Elhassan A. Visualizing Program Quality-A Topological Taxonomy of Features. In: Proceedings of the 2nd International Conference on New Trends in Computing Sciences (ICTCS 2019); King Hussein School of Computing Sciences, Princess Sumaya University for Technology, 2019.
• 5. Ballout A., Alhasan M., Fraihat S., Elhassan A. Business intelligence and data analytics framework: Case study of humanitarian organisations refugees’ registration system. Int. J. Innov. Comput. Appl. 2022; 13(1): 11–17.
• 6. Aspin A. Pro Power BI Desktop: Self-Service Analytics and Data Visualization for the Power User, 3rd ed.; Springer Nature: New York, NY, USA, 2020; 1–898.
• 7. Zhang F., Shi W., Chen M., Huang W., Liu X. Open HD map service model: an interoperable high-Definition map data model for autonomous driving. Int. J. Digit. Earth 2023; 16(1): 2089–2110. https://doi.org/10.1080/17538947.2023.2220615.
• 8. Ehrenmueller-Jensen M. Self-Service AI with Power BI Desktop: Machine Learning Insights for Business, 2020.
• 9. Wright C.Y., Wernecke B. Using Microsoft© Power BI© to visualise Rustenburg Local Municipality’s air quality data, 2020.
• 10. Chen L., Yan J., Liu J., Liang Y., Li W., Qi P., Baojian H., Guangzhi S., Tian P., Yang B., Liu B., Xu Z., Yang Z. Implementing Business Analytics Tool to Optimize Deep Shale Gas Drilling Operations: A Visualization Approach to Analyze Drilling Performance. In: Proceedings of the Society of Petroleum Engineers - SPE Conference at Oman Petroleum and Energy Show (OPES 2024); 2024. https://doi.org/10.2118/218625-MS.
• 11. Kolodii I., Kit N., Kotsur V., Shchokin R., Pobocha T. Information and analytical system of control, planning, and management of the educational process in educational institutions. J. Curric. Teach. 2023; 12: 113–122. https://doi.org/10.5430/jct.v12n2p113.
• 12. Hernández R.C., Moreno H.B.R. Implementación de un Dashboard para el apoyo en la toma de decisiones en el sector privado en Distribución de Maquinaria y Materia Prima para productos de Panificación. Rev. Ibérica Sist. Tecnol. Inf. 2021; E42: 103–112.
• 13. Aspin A. Pro Power BI Theme Creation: JSON Stylesheets for Automated Dashboard Formatting, 2021.
• 14. Fazaeli S., Khodaveisi T., Vakilzadeh A.K., Shokoohizadeh M., Mohammad-Pour S. Development, implementation, and user evaluation of COVID-19 dashboard in a third-level hospital in Iran. Appl. Clin. Informatics 2021; 12.05: 1091–1100.
• 15. Rivera K.M., Contreras M., Pineda G.M., Chaves E.G., Durón R.M. Diseño de un modelo innovador de ranking de investigadores para asistir el desarrollo de la ciencia en los países del Sur Global: el caso de Honduras, 2022.
• 16. Bublyk M., Shandurskyi V., Machita T., Grudowski P., Pavlyuk O. Analysing By-Products Interaction as an Industry Resource of Circular Economy in Ukraine and the World. In: MoMLeT+ DS, 2022; 333–344.
• 17. Bublyk M., Humeniuk V., Mikhalchuk T., Surek A., Filizhanko O. Analysing the Cases of Population Disease at Critical Levels of Environmental Pollution by Emissions, Discharges, and Waste. In: MoMLeT+ DS, 2022; 345–358.
• 18. Bublyk M., Vysotska V., Chyrun L., Slava O., Panasyuk V., Shevchenko M. Features of Big Data Analysis for Apps Sales via Google Play Store. In: Proceedings of the International Scientific and Technical Conference on Computer Sciences and Information Technologies (CSIT 2023); 19–21 October 2023. https://doi.org/10.1109/CSIT61576.2023.10324075.
• 19. Bosman L., Magana A., Kotla B. Promoting Evidence-Based Decision Making Practices to Develop the Entrepreneurial Mindset Enabled by Microsoft Power BI Desktop. In: 2022 IEEE Frontiers in Education Conference (FIE); IEEE, 2022; 1–6.
• 20. Tyulepberdinova G., Suleimen O. Development of Intellectual Information and Analytical System Using Cloud Technologies. In: 2022 International Conference on Smart Information Systems and Technologies (SIST); IEEE, 2022; 1–6.
• 21. Box A. Introducing Charticulator for Power BI: Design Vibrant and Customized Visual Representations of Data, 2022.
• 22. Bekheet M., Suresh V., Leonowicz Z. Microgrid Energy Management system with cost minimization. In: 2023 IEEE International Conference on Environment and Electrical Engineering and 2023 IEEE Industrial and Commercial Power Systems Europe (EEEIC/I&CPS Europe); IEEE, 2023; 1–5.
• 23. Harode A., Thabet W., Jamerson W.E., Dongre P. A tool-based system architecture for a digital twin: A Case Study in a Healthcare Facility, 2023.
• 24. Jahangir M.F., Schultz C.P.L., Kamari A. A review of drivers and barriers of digital twin adoption in building project development processes. J. Inf. Technol. Constr. 2024; 29: 141–178. https://doi.org/10.36680/j.itcon.2024.008.
• 25. Baioni e Silva G., Manicardi T., Longati A.A., Lora E.E.S., Milessi T.S. Parametric comparison of biodiesel transesterification processes using non-edible feedstocks: Castor bean and jatropha oils. Biofuels Bioproducts Biorefining 2023; 17: 297–311.
• 26. Sitka A., Szulc P., Smykowski D., Anwajler B., Tietze T., Jodkowski W. Conversion of Post-Refining Waste MONG to Gaseous Fuel in a Rotary Gasifier. Sustainability 2024; 16: 4251. https://doi.org/10.3390/su16104251.
• 27. Larabi I.A., Ghish A., Kintz P., Alvarez J.-C., Pélissier A.-L. Étude nationale du phénomène du chemsex en France: une collaboration interlaboratoire sous l’égide de la Société française de toxicologie analytique (SFTA). Toxicol. Anal. Clin. 2023; 35.3: 175–197.
• 28. Alvarez J.-C., Larabi I.A. Chemsex and cathinones. Bull. Acad. Natl. Med. 2024; 208: 208–214. https://doi.org/10.1016/j.banm.2023.11.011.
• 29. Simões A.C.C.D., Campos F.R.O., Câmara J.V.F., Cedro V.Q.M., Pereira A.C. Legislation in hospital dentistry: Gaps, perspectives and desires. Pesqui. Bras. Odontopediatria Clin. Integr. 2023; 24: e220153.
• 30. Liu C., Owning C. Using text analytics AI insights in microsoft power BI desktop to score sentiments, Extract key phrases, and discover unstructured data patterns. J. Inf. Syst. Educ. 2024; 35.1.
• 31. Teplická K., Steingartner W., Kádárová J., Hurná S. Dashboards - effective instrument of decision in synergy with software support. Pol. J. Manag. Stud. 2020; 22: 565–582. https://doi.org/10.17512/pjms.2020.22.1.36.
• 32. Microsoft. Power BI Desktop documentation. Available online: https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started (accessed on 28 February 2025).
• 33. Smith J. The integration of power BI in manufacturing. J. Bus. Intell. 2023; 15(3): 45–60.
• 34. Tableau Software. Tableau Overview. Available online: https://www.tableau.com/why-tableau/what-is-tableau (accessed on 28 February 2025).
• 35. Johnson L. Evaluating tableau for data visualization and analysis. Data Sci. Rev. 2022; 22(4): 78–90.
• 36. Qlik. Qlik Sense Product Overview. Available online: https://www.qlik.com/us/products/qlik-sense (accessed on 28 February 2025).
• 37. Brown M. Real-time data analysis with qlik sense. J. Analyt. 2023; 18(2): 30–50.
• 38. Miller T. Choosing the right data visualization tool for your industry. J. Data Manag. 2023; 14(1): 15–27.
• 39. Lee C. Cost-effectiveness and integration in data visualization tools. Bus. Technol. J. 2024.

Uwagi

Opracowanie rekordu ze środków MNiSW, umowa nr POPUL/SP/0154/2024/02 w ramach programu "Społeczna odpowiedzialność nauki II" - moduł: Popularyzacja nauki (2025).