Criação de um banco de dados e sua análise com indicadores gráficos em fiscalização de obra

Abstract

In contemporary business, the use of technologies becomes essential to promote efficient management. With this, this work aims at the improvement of a system that consists of manual assembly of Excel spreadsheets, to a database linked to Power BI, generating more efficient and quickly delivered reports. Using a spreadsheet as a basis for creating the database, its modeling was done to be implemented later. In a subsequent stage, the data was inserted into a database to be processed by the Power BI software. The results were presented graphically as dashboards, which are more intuitive and visually better, thus turning a manual process into an automatic one and facilitating decision-making. Additionally, with the implementation of a database with more information, it was possible to extract new ideas, improving management. These results contribute to a better understanding of the importance of new technologies and how they can improve the analysis of data from a system.