Business intelligence solution for the economic and financial area

Detalhes bibliográficos
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
Resumo: 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.
id RCAP_d30bdeb8ee767a128036347d9832fee9
oai_identifier_str oai:ria.ua.pt:10773/25127
network_acronym_str RCAP
network_name_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository_id_str 7160
spelling Business intelligence solution for the economic and financial areaBusiness IntelligenceData WarehouseETLERPWhen 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.Quando usada correctamente, a ferramenta mais poderosa que uma empresa tem ao seu dispor para compreender o seu negócio são os dados gerados pelo próprio negócio. Actualmente todas as médias e grandes empresas usam um sistema de Enterprise Resource Planning (ERP) que junta informação sobre o estado de todas as diferentes divisões da empresa e armazena essa informação, disponibilizando-a para ser depois usada por todos os departamentos da empresa. Os dados armazenados são muito valiosos para uma empresa, e devidamente analisados podem ajudar as empresas a tomar melhores acções de negócio. As soluções actuais de Business Intelligence são óptimas ao analisar dados de uma única fonte, mas não foram pensadas para analisar dados de fontes diferentes. O objectivo desta dissertação é criar uma solução de Business Intelligence, com foco na área económico-financeira, capaz de extrair dados de diferentes ERPs que existem actualmente e armazenar esses dados numa Data Warehouse, disponibilizando-os para serem mais tarde processados e analisados. Este projecto foi proposto por uma empresa portuguesa, Satbyte, sendo realizado em ambiente empresarial em colaboração com a mesma por forma a desenvolver um novo produto que possa ser comercializado pela empresa. Este documento apresenta a solução proposta para o problema e a implementação da mesma. Esta consistiu na construção de uma Data Warehouse para guardar os dados de forma integrada, proveninentes de diversos ERPs e o desenvolvimento, em ambiente web, de diversos casos de uso do âmbito da análise financeira e económica empresarial. A solução desenvolvida provou ser eficaz para o propósito inicialmente formulado e foi validada pela empresa como a peça crucial para a continuação do desenvolvimento da solução de Business Intelligence alargada na qual pretendem continuar a investir.2019-01-16T11:25:14Z2018-07-23T00:00:00Z2018-07-23info:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfhttp://hdl.handle.net/10773/25127TID:202234096engBrito, João Renato Figueiredoinfo:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2024-02-22T11:48:58Zoai:ria.ua.pt:10773/25127Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-20T02:58:32.370090Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse
dc.title.none.fl_str_mv Business intelligence solution for the economic and financial area
title Business intelligence solution for the economic and financial area
spellingShingle Business intelligence solution for the economic and financial area
Brito, João Renato Figueiredo
Business Intelligence
Data Warehouse
ETL
ERP
title_short Business intelligence solution for the economic and financial area
title_full Business intelligence solution for the economic and financial area
title_fullStr Business intelligence solution for the economic and financial area
title_full_unstemmed Business intelligence solution for the economic and financial area
title_sort Business intelligence solution for the economic and financial area
author Brito, João Renato Figueiredo
author_facet Brito, João Renato Figueiredo
author_role author
dc.contributor.author.fl_str_mv Brito, João Renato Figueiredo
dc.subject.por.fl_str_mv Business Intelligence
Data Warehouse
ETL
ERP
topic Business Intelligence
Data Warehouse
ETL
ERP
description 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.
publishDate 2018
dc.date.none.fl_str_mv 2018-07-23T00:00:00Z
2018-07-23
2019-01-16T11:25:14Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/masterThesis
format masterThesis
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://hdl.handle.net/10773/25127
TID:202234096
url http://hdl.handle.net/10773/25127
identifier_str_mv TID:202234096
dc.language.iso.fl_str_mv eng
language eng
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.source.none.fl_str_mv reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron:RCAAP
instname_str Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron_str RCAAP
institution RCAAP
reponame_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
collection Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository.name.fl_str_mv Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
repository.mail.fl_str_mv
_version_ 1799137639628013568