Utilização do PowerBI na gestão de equipes de desenvolvimento de software: estudo de caso

Abstract

This paper presents a Business Intelligence (BI) solution aimed at constructing a performance dashboard for company located in the southern region. The adopted methodology aims to replace the current Excel-centric approach with the use of PowerBI. The Excel solution relies on scattered files with manual data entries, leading to errors and inconsistencies. The new method utilizes SharePoint Lists for data storage and entry, conducting analysis, enhancing data integrity, accessibility, and management. To structure the development process of the new solution, it was decided to utilize the agile Scrum framework, with bi-weekly Sprints and daily meetings via Teams for progress updates and task alignment. Additionally, comprehensive bi-weekly meetings facilitated review, reflection, and planning for future Sprints. The incorporation of dedicated Product Owners and a multifunctional Scrum team reflects the adaptation of Scrum principles to meet the team's unique context. Through supervision from the Project Management Office (PMO) and validation from stakeholders, the final BI solution met and exceeded expectations, offering a more efficient, agile, and results-oriented approach to enterprise data analysis. This combination of SharePoint Lists, PowerBI, and Scrum methodology represents a significant advancement over the previous Excel-centric method, providing a more integrated and effective approach to project development and management.