BI tools to monitor KPIs in operations management
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/10400.14/42636 |
Resumo: | Key performance indicators are crucial for decision-making and essential to quantify the efficiency and effectiveness of operations management. Nowadays, provided by information technologies, it is possible to gather large sets of data and estimates that help and support the acquisition and calculation of KPIs. Big Data enables companies to use data as a strategic asset for decision-making and create value through data analysis and integration into strategic and operational activities. This dissertation focusses on improving the monitorization of a KPI through BI tools. This KPI is from Carglass Portugal and has the goal of measuring conversion. In order to improve the monitorization of this KPI, an R Script was developed with the goal of improving data pre-processing and a Power BI dashboard was constructed with the aim of enhancing data visualization and data analysis, and consequently decision-making. The methodology adopted was action-research structured in two cycles: Data Pre-Processing and Dashboard Construction. The principal findings of this research conclude that, indeed, BI tools with different purposes can improve efficiency in daily tasks but also enhance and fasten decision-making. |
id |
RCAP_f75b6ca8a4c0ac380cbb62e79a8c034f |
---|---|
oai_identifier_str |
oai:repositorio.ucp.pt:10400.14/42636 |
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 |
BI tools to monitor KPIs in operations managementBusiness intelligence toolsKey performance indicatorsData pre-processingDashboardData visualizationFerramentas de business intelligenceKey performance indicatorsPré-processamento dadosDashboardVisualização de dadosDomínio/Área Científica::Ciências Sociais::Economia e GestãoKey performance indicators are crucial for decision-making and essential to quantify the efficiency and effectiveness of operations management. Nowadays, provided by information technologies, it is possible to gather large sets of data and estimates that help and support the acquisition and calculation of KPIs. Big Data enables companies to use data as a strategic asset for decision-making and create value through data analysis and integration into strategic and operational activities. This dissertation focusses on improving the monitorization of a KPI through BI tools. This KPI is from Carglass Portugal and has the goal of measuring conversion. In order to improve the monitorization of this KPI, an R Script was developed with the goal of improving data pre-processing and a Power BI dashboard was constructed with the aim of enhancing data visualization and data analysis, and consequently decision-making. The methodology adopted was action-research structured in two cycles: Data Pre-Processing and Dashboard Construction. The principal findings of this research conclude that, indeed, BI tools with different purposes can improve efficiency in daily tasks but also enhance and fasten decision-making.Os key performance indicators são cruciais para a tomada de decisão e essenciais para quantificar a eficiência e eficácia da gestão das operações. Atualmente, é possível reunir grandes conjuntos de dados e estimativas que ajudam e apoiam a aquisição e cálculo dos KPIs. O Big Data permite às empresas utilizar os dados como um ativo estratégico para a tomada de decisão e criar valor através da análise e integração de dados em actividades estratégicas e operacionais. Esta dissertação foca-se na melhoria da monitorização de um KPI através de ferramentas de BI. Este KPI é da Carglass Portugal e tem o objectivo de medir a conversão. A fim de melhorar a monitorização deste KPI, foi desenvolvido um R Script com o objectivo de melhorar o pre-processamento de dados e foi construído um dashboard em Power BI com o objectivo de melhorar a visualização e análise dos dados, e consequentemente a tomada de decisão. A metodologia adoptada foi action-research estruturada em dois ciclos: Pre processamento de dados e construção de um dashboard. As principais conclusões desta investigação foram que, de facto, as ferramentas de BI com diferentes propósitos podem melhorar a eficiência nas tarefas diárias, mas também melhorar e acelerar a tomada de decisão.Trindade, Maria Alice MoreiraVeritati - Repositório Institucional da Universidade Católica PortuguesaSilva, Sofia Cloé Morais da2023-09-26T15:10:01Z2023-07-142023-042023-07-14T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfhttp://hdl.handle.net/10400.14/42636TID:203350995enginfo: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-09-06T12:44:01Zoai:repositorio.ucp.pt:10400.14/42636Portal AgregadorONGhttps://www.rcaap.pt/oai/openairemluisa.alvim@gmail.comopendoar:71602024-09-06T12:44:01Repositó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 |
BI tools to monitor KPIs in operations management |
title |
BI tools to monitor KPIs in operations management |
spellingShingle |
BI tools to monitor KPIs in operations management Silva, Sofia Cloé Morais da Business intelligence tools Key performance indicators Data pre-processing Dashboard Data visualization Ferramentas de business intelligence Key performance indicators Pré-processamento dados Dashboard Visualização de dados Domínio/Área Científica::Ciências Sociais::Economia e Gestão |
title_short |
BI tools to monitor KPIs in operations management |
title_full |
BI tools to monitor KPIs in operations management |
title_fullStr |
BI tools to monitor KPIs in operations management |
title_full_unstemmed |
BI tools to monitor KPIs in operations management |
title_sort |
BI tools to monitor KPIs in operations management |
author |
Silva, Sofia Cloé Morais da |
author_facet |
Silva, Sofia Cloé Morais da |
author_role |
author |
dc.contributor.none.fl_str_mv |
Trindade, Maria Alice Moreira Veritati - Repositório Institucional da Universidade Católica Portuguesa |
dc.contributor.author.fl_str_mv |
Silva, Sofia Cloé Morais da |
dc.subject.por.fl_str_mv |
Business intelligence tools Key performance indicators Data pre-processing Dashboard Data visualization Ferramentas de business intelligence Key performance indicators Pré-processamento dados Dashboard Visualização de dados Domínio/Área Científica::Ciências Sociais::Economia e Gestão |
topic |
Business intelligence tools Key performance indicators Data pre-processing Dashboard Data visualization Ferramentas de business intelligence Key performance indicators Pré-processamento dados Dashboard Visualização de dados Domínio/Área Científica::Ciências Sociais::Economia e Gestão |
description |
Key performance indicators are crucial for decision-making and essential to quantify the efficiency and effectiveness of operations management. Nowadays, provided by information technologies, it is possible to gather large sets of data and estimates that help and support the acquisition and calculation of KPIs. Big Data enables companies to use data as a strategic asset for decision-making and create value through data analysis and integration into strategic and operational activities. This dissertation focusses on improving the monitorization of a KPI through BI tools. This KPI is from Carglass Portugal and has the goal of measuring conversion. In order to improve the monitorization of this KPI, an R Script was developed with the goal of improving data pre-processing and a Power BI dashboard was constructed with the aim of enhancing data visualization and data analysis, and consequently decision-making. The methodology adopted was action-research structured in two cycles: Data Pre-Processing and Dashboard Construction. The principal findings of this research conclude that, indeed, BI tools with different purposes can improve efficiency in daily tasks but also enhance and fasten decision-making. |
publishDate |
2023 |
dc.date.none.fl_str_mv |
2023-09-26T15:10:01Z 2023-07-14 2023-04 2023-07-14T00: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/10400.14/42636 TID:203350995 |
url |
http://hdl.handle.net/10400.14/42636 |
identifier_str_mv |
TID:203350995 |
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 |
mluisa.alvim@gmail.com |
_version_ |
1817547101914005504 |