International Journal of Information Engineering and Electronic Business (IJIEEB)
IJIEEB Vol. 16, No. 4, 8 Aug. 2024
Cover page and Table of Contents: PDF (size: 940KB)
Indicator Automation with Power BI in the Innovation Sector of a Transformer Company
PDF (940KB), PP.16-27
Views: 0 Downloads: 0
Author(s)
Ana Julia Dal Forno
1,*
Leticia Marques Bauler
2
Selene de Souza Siqueira Soares
1
Marilise Luiza Martins dos Reis Sayao
2
Index Terms
Project management, KPI, Process automation, Visual Control, productivity
Abstract
The use of indicators is increasingly common, as they allow the visualization and analysis of useful data to assist in decision-making and planning. In this context, this article aimed to evaluate the process of automating indicators in the area of innovation in a multinational company located in Brazil, a transformer manufacturer. To this end, the themes of indicators and the application of Business Intelligence (BI) and process automation for project manager functions were conceptualized. The action research methodology developed automated indicators to facilitate decision-making and improve the productivity of the project team. These results also allowed for the improvement of visual and systemic management, by presenting all current projects and information on the occupancy rate of each team member, in addition to real-time control of whether goals are being achieved in the company. Thus, it was evident that centralizing data helps managers make more assertive decisions and the case reported can be replicated to other industrial sectors. In the academic sphere, the research also contributed to the evolution of the topic of project integration, automation and visual management of indicators using the Power BI tool.
Cite This Paper
Ana Julia Dal Forno, Letícia Marques Bauler, Selene de Souza Siqueira Soares, Marilise Luiza Martins dos Reis Sayão, "Indicator Automation with Power BI in the Innovation Sector of a Transformer Company", International Journal of Information Engineering and Electronic Business(IJIEEB), Vol.16, No.4, pp. 16-27, 2024. DOI:10.5815/ijieeb.2024.04.02
Reference
[1]T. P. Raptis, A. Passarella, and M. Conti, “Data Management in Industry 4.0: State of the Art and Open Challenges,” IEEE Access, vol. 7, pp. 97052–97093, 2019, doi: 10.1109/ACCESS.2019.2929296.
[2]J. Tidd and J. R. Bessant, Managing innovation: integrating technological, market and organizational change. John Wiley & Sons, 2020.
[3]S. Paton and B. Andrew, “The role of the Project Management Office (PMO) in product lifecycle management: A case study in the defence industry,” Int J Prod Econ, vol. 208, pp. 43–52, Feb. 2019, doi: 10.1016/j.ijpe.2018.11.002.
[4]A. J. Dal Forno, F. A. Forcellini, L. M. Kipper, and F. A. Pereira, “Method for evaluation via benchmarking of the lean product development process: Multiple case studies at Brazilian companies,” Benchmarking, vol. 23, no. 4, 2016, doi: 10.1108/BIJ-12-2013-0114.
[5]Ronielton. Rezende Oliveira and H. C. Martins, “Project management office performance: Divergence of the perceptions between academic instruction and professional experience.,” Innovar, vol. 30, no. 75, pp. 119–134, 2020.
[6]M. Li and Y. Liu, “The influence of digital innovation ecosystem of high-end equipment manufacturing on the intelligent maturity of enterprise – an empirical study on the configuration of the ‘three-layer core-periphery’ structure,” Business Process Management Journal, vol. 30, no. 1, pp. 199–221, Feb. 2024, doi: 10.1108/BPMJ-01-2023-0005.
[7]A. Erro-Garcés and J. A. Alfaro-Tanco, “Action Research as a Meta-Methodology in the Management Field,” Int J Qual Methods, vol. 19, p. 160940692091748, Jan. 2020, doi: 10.1177/1609406920917489.
[8]S. Iepsen, D. G. Helfer, R. Frozza, D. P. Lacerda, A. J. Dal Forno, and L. M. Kipper, “Competences for Industry 4.0 in Innovation Environments: A Field Study at Technology Parks in Rio Grande Do Sul, Brazil,” Academy of Entrepreneurship Journal , vol. 29, no. 6S, pp. 1–17, 2023.
[9]Chen, Chiang, and Storey, “Business Intelligence and Analytics: From Big Data to Big Impact,” MIS Quarterly, vol. 36, no. 4, p. 1165, 2012, doi: 10.2307/41703503.
[10]R. D. C. dos Santos, “Power BI: a experiência de implantação em um escritório de contabilidade,” Trabalho de Conclusão de Curso, UNIVERSIDADE FEDERAL DA PARAÍBA – UFPB, João Pessoa, 2018.
[11]D. Appelbaum, A. Kogan, M. Vasarhelyi, and Z. Yan, “Impact of business analytics and enterprise systems on managerial accounting,” International Journal of Accounting Information Systems, vol. 25, pp. 29–44, May 2017, doi: 10.1016/j.accinf.2017.03.003.
[12]C. L. da Silva and L. Assis, “Aplicabilidade do Planejamento Estratégico em Hospitais Universitários Federais,” Revista de Gestão em Sistemas de Saúde, vol. 5, no. 2, pp. 39–56, Dec. 2016, doi: 10.5585/rgss.v5i2.257.
[13]P. Girardin, C. Bockstaller, and H. Van der Werf, “Indicators: Tools to Evaluate the Environmental Impacts of Farming Systems,” Journal of Sustainable Agriculture, vol. 13, no. 4, pp. 5–21, Mar. 1999, doi: 10.1300/J064v13n04_03.
[14]W. S. de S. Costa, J. V. Queiroz, N. C. Lima, J. A. P. Silva, and F. C. B. P. Queiroz, “Indicadores como base para a gestão estratégica de supermercados varejistas,” Revista de Gestão e Secretariado, vol. 13, no. 3, pp. 1189–1217, Nov. 2022, doi: 10.7769/gesec.v13i3.1398.
[15]G. R. D. S. Costa, “Manutenção e confiabilidade: Um modelo para análise de dados de performance em caminhões de mineração utilizando o power bi.,” Trabalho de Conclusão de Curso, UFRA, Parauapebas, 2023.
[16]J. A. S. Riva, “Power BI como ferramenta de tomada de decisões: um estudo de caso na empresa Capgemini,” Trabalho de Conclusão de Curso, Faculdade de Tecnologia de Americana “Ministro Ralph Biasi,” Americana, 2022.
[17]K. Gowthami and M. R. P. Kumar, “Study on Business Intelligence Tools for Enterprise Dashboard Development,” International Research Journal of Engineering and Technology (IRJET), vol. 4, no. 4, pp. 2987–2992, 2017.
[18]Microsoft, “Microsoft Power BI,” www.microsoft.com. Accessed: May 21, 2024. [Online]. Available: www.microsoft.com
[19]L. T. Becker and E. M. Gould, “Microsoft Power BI: Extending Excel to Manipulate, Analyze, and Visualize Diverse Data,” Serials Review, vol. 45, no. 3, pp. 184–188, Jul. 2019, doi: 10.1080/00987913.2019.1644891.
[20]R. Bhatti, D. Gao, and W.-S. Li, “Enabling policy-based access control in BI applications,” Data Knowl Eng, vol. 66, no. 2, pp. 199–222, Aug. 2008, doi: 10.1016/j.datak.2008.03.003.
[21]N. A. Jalil, P. Prapinit, M. Melan, and A. Bin Mustaffa, “Adoption of Business Intelligence - Technological, Individual and Supply Chain Efficiency,” in 2019 International Conference on Machine Learning, Big Data and Business Intelligence (MLBDBI), IEEE, Nov. 2019, pp. 67–73. doi: 10.1109/MLBDBI48998.2019.00021.
[22]O. Zwikael and S. Globerson, “From Critical Success Factors to Critical Success Processes,” Int J Prod Res, vol. 44, no. 17, pp. 3433–3449, Sep. 2006, doi: 10.1080/00207540500536921.