Diseño e implementación de un framework para la evaluación de la calidad de datos en un datawarehouse en el sistema de registro fuente (clientes) de una entidad financiera

Abstract

The objective of this work is the design and implementation of a framework for the evaluation of data quality of a data warehouse, in the source registration system (clients) of a financial institution. The proposed framework was based on a bibliographic review of similar sources that fit the needs, which provides a framework composed of phases that facilitate and guarantee quality information.

Based on the content of the information, four dimensions with their respective seven quality factors were selected for the evaluation of the data warehouse. Understanding these concepts allowed for a broader perception of the evaluation process. In the same way, it was determined that the dimension of completeness of the density factor (null and blank fields) obtains the lowest average of the analysis, which corresponds to 8.27/10.

With the results obtained in the evaluation, a total average of 9.347 is determined, which places it in a satisfactory range. With this, it can be seen that the quality of the data warehouse is admissible; however, for a financial institution, it is required to achieve a highly satisfactory degree, because its line of business demands quality information.

In a business environment such as finance, its successes are based on the quality and enrichment of data; however, although it is true that the evaluated financial entity presents an average data quality of 9.35/10 in the source record, this is not enough, since an adequate data quality strategy must also be considered, which will allow the entity to improve its image and brand.