Business intelligence solution for the economic and financial area

• Autor(a) principal: Brito, João Renato Figueiredo
• Data de Publicação: 2018
• Tipo de documento: Dissertação
• Idioma: eng
• Título da fonte: Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
• Texto Completo: http://hdl.handle.net/10773/25127
• topic: Business Intelligence; Data Warehouse; ETL; ERP

When used properly, the most powerful tool that companies have to understand their business is the data generated by the business. Nowadays every mid-to-large size company uses an Enterprise Resource Planning (ERP) system that collects information about the state of all di erent divisions of the enterprise and stores this information, making it available to be used by every department of the company. The data stored is very valuable to a company and properly analyzed it can help companies take better business actions. The current Business Intelligence solutions work great when analyzing data from a single source, but struggle to collect data from di erent sources. The objective of this dissertation is to create a Business Intelligence solution, focused in the nancial and economic eld, that can extract data from all the di erent ERPs that currently exist and store that information in a Data Warehouse, making it available to further processing and analyzing. This project was proposed by a portuguese company, Satbyte, and it was done in a business environment in collaboration with it to develop a new marketable product for the company. This document contains the proposed solution to the problem and a implementation of it. That consisted in the creation of a Data Warehouse to store the data in an integrated way, coming from several ERPs and the development, in web environment, of several use cases from the economic and nancial analysis eld. The developed solution proved to be e ective for the purpose initially formulated and was validated by the company as having a crucial role for the continuation of the development of the extended Business Intelligence solution in which they intend to continue to invest.