Business intelligence-centered software as the main driver to migrate from spreadsheet-based analytics

Detalhes bibliográficos
Autor(a) principal: Rebelo, Tomás de Oliveira Saramago Brito
Data de Publicação: 2023
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/10362/152186
Resumo: Internship Report presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business Intelligence
id RCAP_cc5cb4199bdaa076f605c48cd83d55f4
oai_identifier_str oai:run.unl.pt:10362/152186
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-centered software as the main driver to migrate from spreadsheet-based analyticsETLData WarehouseBusiness IntelligenceDashboardsData VisualizationData EngineeringInternship Report presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business IntelligenceNowadays, companies are handling and managing data in a way that they weren’t ten years ago. The data deluge is, as a mere consequence of that, the constant day-to-day challenge for them - having to create agile and scalable data solutions to tackle this reality. The main trigger of this project was to support the decision-making process of a customer-centered marketing team (called Customer Voice) in the Company X by developing a complete, holistic Business Intelligence solution that goes all the way from ETL processes to data visualizations based on that team’s business needs. Having this context into consideration, the focus of the internship was to make use of BI, ETL techniques to migrate their data stored in spreadsheets — where they performed data analysis — and shift the way they see the data into a more dynamic, sophisticated, and suitable way in order to help them make data-driven strategic decisions. To ensure that there was credibility throughout the development of this project and its subsequent solution, it was necessary to make an exhaustive literature review to help me frame this project in a more realistic and logical way. That being said, this report made use of scientific literature that explained the evolution of the ETL workflows, tools, and limitations across different time periods and generations, how it was transformed from manual to real-time data tasks together with data warehouses, the importance of data quality and, finally, the relevance of ETL processes optimization and new ways of approaching data integrations by using modern, cloud architectures.Pinheiro, Flávio Luís PortasRUNRebelo, Tomás de Oliveira Saramago Brito2023-04-27T17:44:06Z2023-04-112023-04-11T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfhttp://hdl.handle.net/10362/152186TID:203277430enginfo: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-03-11T05:34:32Zoai:run.unl.pt:10362/152186Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-20T03:54:49.435275Repositó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-centered software as the main driver to migrate from spreadsheet-based analytics
title Business intelligence-centered software as the main driver to migrate from spreadsheet-based analytics
spellingShingle Business intelligence-centered software as the main driver to migrate from spreadsheet-based analytics
Rebelo, Tomás de Oliveira Saramago Brito
ETL
Data Warehouse
Business Intelligence
Dashboards
Data Visualization
Data Engineering
title_short Business intelligence-centered software as the main driver to migrate from spreadsheet-based analytics
title_full Business intelligence-centered software as the main driver to migrate from spreadsheet-based analytics
title_fullStr Business intelligence-centered software as the main driver to migrate from spreadsheet-based analytics
title_full_unstemmed Business intelligence-centered software as the main driver to migrate from spreadsheet-based analytics
title_sort Business intelligence-centered software as the main driver to migrate from spreadsheet-based analytics
author Rebelo, Tomás de Oliveira Saramago Brito
author_facet Rebelo, Tomás de Oliveira Saramago Brito
author_role author
dc.contributor.none.fl_str_mv Pinheiro, Flávio Luís Portas
RUN
dc.contributor.author.fl_str_mv Rebelo, Tomás de Oliveira Saramago Brito
dc.subject.por.fl_str_mv ETL
Data Warehouse
Business Intelligence
Dashboards
Data Visualization
Data Engineering
topic ETL
Data Warehouse
Business Intelligence
Dashboards
Data Visualization
Data Engineering
description Internship Report presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business Intelligence
publishDate 2023
dc.date.none.fl_str_mv 2023-04-27T17:44:06Z
2023-04-11
2023-04-11T00:00:00Z
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/10362/152186
TID:203277430
url http://hdl.handle.net/10362/152186
identifier_str_mv TID:203277430
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_ 1799138136580685824