Desenvolvimento de DASHBOARD dinâmico de projetos utilizando o processo de Business Intelligence sobre um sistema de solicitação de serviço em um ambiente governamental

Abstract

Business Intelligence (BI) is the process that allows you to transform data into information and knowledge with strategy value, in order to support decision-making with quality and speed. And it is this process that has been developed step by step through a case study in project management approach. The case study is the development of a BI process using data from a service request system of projects and systems in a government environment, Secretaria de Estado de Fazenda do Mato Grosso. In this work, the management needs and multidimensional modeling necessary for project execution have been defined. The database was created from the multidimensional modeling made and the loading data through the ETL process (Extract, Transform and Load - Extract, Transform and Load) was finished. And for last, there are the implementation of dashboards, where data can be viewed in one location dynamically, allowing the accuracy of the decision-making process.