Enhancing employee data integration in a data warehouse

As organizations increasingly rely on data-driven decision-making, ensuring high data quality in enterprise data warehouses becomes critical. This thesis examines data quality issues in the employee dimension in Íslandsbanki's Modern Data Warehouse, Trölli. Íslandsbanki, a financial institution...

ver descrição completa

Detalhes bibliográficos
Autor: Sólmundarson, Jóhannes Kári
Tipo de documento: dissertação
Data de publicação:2025
País:España
Recursos:Universitat Politècnica de Catalunya (UPC)
Repositório:UPCommons. Portal del coneixement obert de la UPC
Idioma:inglês
OAI Identifier:oai:upcommons.upc.edu:2117/445545
Acesso em linha:https://hdl.handle.net/2117/445545
Access Level:Acesso embargado
Palavra-chave:Data warehousing
Personnel management
Magatzems de dades
Qualitat de dades
Dimensió d'empleat
Data quality
Employee dimension
Gestor de dades
Personal--Administració
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació::Bases de dades
id ES_d34e2d2d621caac24e615f2622ea10be
oai_identifier_str oai:upcommons.upc.edu:2117/445545
network_acronym_str ES
network_name_str España
repository_id_str
spelling Enhancing employee data integration in a data warehouseSólmundarson, Jóhannes KáriData warehousingPersonnel managementMagatzems de dadesQualitat de dadesDimensió d'empleatData warehousingData qualityEmployee dimensionGestor de dadesPersonal--AdministracióÀrees temàtiques de la UPC::Informàtica::Sistemes d'informació::Bases de dadesAs organizations increasingly rely on data-driven decision-making, ensuring high data quality in enterprise data warehouses becomes critical. This thesis examines data quality issues in the employee dimension in Íslandsbanki's Modern Data Warehouse, Trölli. Íslandsbanki, a financial institution in Iceland, launched Trölli as part of its digital transformation to replace the legacy system Valhöll, which had become unsustainable due to ad hoc development and limited scalability. The work identifies critical shortcomings in the inherited employee dimension, including incomplete coverage of foreign employees, limited attribute richness, and inadequate modeling of the manager hierarchy. To address these issues, the thesis proposes a redesigned schema that integrates data from H3, an HR system in wide use in Iceland, ensuring completeness and improving analytical capabilities. A central insight of this work is the importance of the data exploration phase in data warehouse development. Early decisions about source systems and schema design have long-term implications for completeness, expressiveness, and sustainability. The work proposes a strategy to define a natural key, when limitations of the source system mean that no single attribute has the required qualities to be unique, persistent and mandatory. The new solution allows for accurate historical reporting of all employees and introduces attributes to improve lifecycle analysis. A recursive accumulating snapshot fact table is implemented to represent multi-parent, variable-depth hierarchies. Together, these enhancements provide a more robust foundation for HR analytics and organizational reporting, aligning the DW with best practices and future analytical needs.Universitat Politècnica de CatalunyaDruzin Halldorsson, ValthorAbelló Gamazo, Alberto20252025-10-2020252025-11-0520302030-01-01master thesishttp://purl.org/coar/resource_type/c_bdccNAhttp://purl.org/coar/version/c_be7fb7dd8ff6fe43info:eu-repo/semantics/masterThesisapplication/pdfhttps://hdl.handle.net/2117/445545reponame:UPCommons. Portal del coneixement obert de la UPCinstname:Universitat Politècnica de Catalunya (UPC)Inglésengembargoed accesshttp://purl.org/coar/access_right/c_f1cfinfo:eu-repo/semantics/embargoedAccessoai:upcommons.upc.edu:2117/4455452026-05-27T15:37:01Z
dc.title.none.fl_str_mv Enhancing employee data integration in a data warehouse
title Enhancing employee data integration in a data warehouse
spellingShingle Enhancing employee data integration in a data warehouse
Sólmundarson, Jóhannes Kári
Data warehousing
Personnel management
Magatzems de dades
Qualitat de dades
Dimensió d'empleat
Data warehousing
Data quality
Employee dimension
Gestor de dades
Personal--Administració
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació::Bases de dades
title_short Enhancing employee data integration in a data warehouse
title_full Enhancing employee data integration in a data warehouse
title_fullStr Enhancing employee data integration in a data warehouse
title_full_unstemmed Enhancing employee data integration in a data warehouse
title_sort Enhancing employee data integration in a data warehouse
dc.creator.none.fl_str_mv Sólmundarson, Jóhannes Kári
author Sólmundarson, Jóhannes Kári
author_facet Sólmundarson, Jóhannes Kári
author_role author
dc.contributor.none.fl_str_mv Druzin Halldorsson, Valthor
Abelló Gamazo, Alberto
dc.subject.none.fl_str_mv Data warehousing
Personnel management
Magatzems de dades
Qualitat de dades
Dimensió d'empleat
Data warehousing
Data quality
Employee dimension
Gestor de dades
Personal--Administració
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació::Bases de dades
topic Data warehousing
Personnel management
Magatzems de dades
Qualitat de dades
Dimensió d'empleat
Data warehousing
Data quality
Employee dimension
Gestor de dades
Personal--Administració
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació::Bases de dades
description As organizations increasingly rely on data-driven decision-making, ensuring high data quality in enterprise data warehouses becomes critical. This thesis examines data quality issues in the employee dimension in Íslandsbanki's Modern Data Warehouse, Trölli. Íslandsbanki, a financial institution in Iceland, launched Trölli as part of its digital transformation to replace the legacy system Valhöll, which had become unsustainable due to ad hoc development and limited scalability. The work identifies critical shortcomings in the inherited employee dimension, including incomplete coverage of foreign employees, limited attribute richness, and inadequate modeling of the manager hierarchy. To address these issues, the thesis proposes a redesigned schema that integrates data from H3, an HR system in wide use in Iceland, ensuring completeness and improving analytical capabilities. A central insight of this work is the importance of the data exploration phase in data warehouse development. Early decisions about source systems and schema design have long-term implications for completeness, expressiveness, and sustainability. The work proposes a strategy to define a natural key, when limitations of the source system mean that no single attribute has the required qualities to be unique, persistent and mandatory. The new solution allows for accurate historical reporting of all employees and introduces attributes to improve lifecycle analysis. A recursive accumulating snapshot fact table is implemented to represent multi-parent, variable-depth hierarchies. Together, these enhancements provide a more robust foundation for HR analytics and organizational reporting, aligning the DW with best practices and future analytical needs.
publishDate 2025
dc.date.none.fl_str_mv 2025
2025-10-20
2025
2025-11-05
2030
2030-01-01
dc.type.none.fl_str_mv master thesis
http://purl.org/coar/resource_type/c_bdcc
NA
http://purl.org/coar/version/c_be7fb7dd8ff6fe43
dc.type.openaire.fl_str_mv info:eu-repo/semantics/masterThesis
format masterThesis
dc.identifier.none.fl_str_mv https://hdl.handle.net/2117/445545
url https://hdl.handle.net/2117/445545
dc.language.none.fl_str_mv Inglés
eng
language_invalid_str_mv Inglés
language eng
dc.rights.none.fl_str_mv embargoed access
http://purl.org/coar/access_right/c_f1cf
dc.rights.openaire.fl_str_mv info:eu-repo/semantics/embargoedAccess
rights_invalid_str_mv embargoed access
http://purl.org/coar/access_right/c_f1cf
eu_rights_str_mv embargoedAccess
dc.format.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv Universitat Politècnica de Catalunya
publisher.none.fl_str_mv Universitat Politècnica de Catalunya
dc.source.none.fl_str_mv reponame:UPCommons. Portal del coneixement obert de la UPC
instname:Universitat Politècnica de Catalunya (UPC)
instname_str Universitat Politècnica de Catalunya (UPC)
reponame_str UPCommons. Portal del coneixement obert de la UPC
collection UPCommons. Portal del coneixement obert de la UPC
repository.name.fl_str_mv
repository.mail.fl_str_mv
_version_ 1869420448468434944
score 15,81155

Registros relacionados