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

Bibliographic Details
Main Author: Rebelo, Tomás de Oliveira Saramago Brito
Publication Date: 2023
Format: Master thesis
Language: eng
Source: Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
Download full: http://hdl.handle.net/10362/152186
Summary: 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órios Científicos de Acesso Aberto de Portugal (RCAAP)
repository_id_str https://opendoar.ac.uk/repository/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órios Científicos de Acesso Aberto de Portugal (RCAAP)instname:FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologiainstacron:RCAAP2024-05-22T18:11:05Zoai:run.unl.pt:10362/152186Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireinfo@rcaap.ptopendoar:https://opendoar.ac.uk/repository/71602025-05-28T17:41:23.417543Repositórios Científicos de Acesso Aberto de Portugal (RCAAP) - FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologiafalse
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órios Científicos de Acesso Aberto de Portugal (RCAAP)
instname:FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologia
instacron:RCAAP
instname_str FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologia
instacron_str RCAAP
institution RCAAP
reponame_str Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
collection Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
repository.name.fl_str_mv Repositórios Científicos de Acesso Aberto de Portugal (RCAAP) - FCCN, serviços digitais da FCT – Fundação para a Ciência e a Tecnologia
repository.mail.fl_str_mv info@rcaap.pt
_version_ 1833596895645138944

Similar Items