Desenvolvemento do modelo analítico para a avaliación dos KPI dunha software factory

Abstract

[Resumo] Nos últimos anos, a implementación de Business Intelligence pasou de ser un ‘luxo’ de organizacións que podían permitirse destinar partidas de presupostos para tal efecto, a convertirse nunha necesidade en grandes e medianas empresas debido ao gran volume de datos que é preciso estruturar e analizar. A principal motivación para a realización do presente Traballo de Fin de Grao é a necesidade de obter información de maneira visual e dende calquera dispositivo sobre todos os proxectos que se están a desenvolver na organización. Para a visualización, os usuarios empregan a ferramenta de Microsoft Power BI. Os datos, previamente foron integrados nun modelo tabular creado en Analisys Services cuxa orixe é a ferramenta de xestión de proxectos na nube Azure Devops. Para a obtención dunha parte dos datos foi preciso crear un servizo implementado en C# que obtén periódicamente os datos mediante API Rest de Azure Devops e os almacena nun ficheiro plano. O resto dos datos foi obtido directamente dende SSAS co protocolo oData.

[Abstract] Over the last few years, the companies conception about Business Intelligence has changed a lot. From being an extra section, financed with leftover budget, to be something completely necessary, in part, because the big amount of data who need to be managed. Considering this, companies have need for obtaining the data from all internally developed projects, and they need them structured, and accessible from any device; that’s the main motivation of this Bachelor’s Degree Dissertation. In order to visualize this information, the employees use the tool Microsoft Power BI. The way followed to make these data available is divided into the next two steps. In a first step, data are obtained from the tool Azure Devops for project management and, in a second step, it is integrated in a tabular model that is created in Analisys Services. It was necessary to create a service to obtain part of the data periodically, which, finally, are stored in a plain file. This service, developed in C#, uses an Azure Devops Rest API. The remaining data were obtained from SSAS, using oData protocol.