Gestão e análise de informação de múltiplas fontes de dados

Abstract

Business Intelligence was traditionally a specialty explored primarily by professionals in IT data management, mathematicians and statisticians. The trend is now, and increasingly, the decentralization of access and data analysis across the organization, with more and more companies recognizing Business Intelligence as a component at the service of strategy. This work aims to test a Business Intelligence approach in the development of an analytics system to aid the management and analysis of information from multiple data sources in the business environment. In order to develop the analytics system, this project used as a case study the information taken from two different sources of data from a company that manufactured and sold bicycles, parts and accessories. The methodological design of the investigation was supported by the CRISP-DM approach, traditional in the construction of an analytics system that, in this case, resorted especially to Power BI. In the process of preparing the two structured databases, it was necessary to use the tools SQL Server Management, DAX and Excel. As a resource to support Business Intelligence, an interactive dashboard with several pages was designed in order to simulate the management potential of Power BI in the different aspects of the company, and descriptive and prescriptive techniques for data analysis were explored. Attending to the various aspects explored, the great potential of Power BI as a tool to support Business Intelligence was proven, both from an economic perspective and from an analytics perspective.

Date of Award	10 Jul 2020
Original language	Portuguese
Awarding Institution	Universidade Católica Portuguesa
Supervisor	António Andrade (Supervisor)