Business intelligence-centered software as the main driver to migrate from spreadsheet-based analytics
Autor(a) principal: | |
---|---|
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 |