Quality management of data processing on the DSA system

The bachelor's thesis focuses on data quality management within the DSA system in the data warehouse of a Financial institution. The main objective of the thesis is to develop an efficient SLA alert design in comparison to existing processes. To achieve this primary goal, several sub-goals were defined and fulfilled, mainly concerning the analysis of data ingestion principles, data quality within the DSA system, and its most critical components. The initial chapters contain a review of publicly available sources, which served as a theoretical foundation for the thesis. The subsequent sections focus on the data warehouse as a whole and the key role of the DSA system within it, followed by a detailed description of the system itself. Familiarization with the systems and principles of the data warehouse was essential to understanding the data lifecycle, which further supported the proper configuration and unification of SLA alerts. Data quality and measures for maintaining it are discussed in chapter five, which, in addition to theoretical aspects, provides potential solutions for ensuring data quality. A significant portion of this chapter is dedicated to issues related to character encoding, which can be a major source of incompatibility and often require specialized solutions, which are also addressed in the thesis. The final chapter fulfils the main objective of the thesis and reinforces its focus on data quality management. The primary prerequisite for managing data quality is ensuring that data reaches the DSA system and the data warehouse in the correct shape and format. The outcome of this chapter is an optimization proposal that will contribute to a future development project in alerting in case of data delivery failures and SLA violations.