Data mart of regulatory reporting in the cloud environment

This diploma thesis is focused on the problematics of cloud computing and its usage in the field of data warehouses and data marts. The main goal of this work is to create a "Proof of Concept", which aim is to propose an improvement of the data mart performance in daily regulatory reporting, that is used in selected banking institutions. Most of the vendors offer more than one product suitable for the implementation of data warehouses and data marts. The goal of the diploma thesis is accomplished through the implementation of a banking institution's data mart into two selected products of Microsoft - Microsoft Azure and Microsoft SQL Database, their subsequent testing, and comparison based on defined criteria. The implementation was preceded by the definition of the necessary theoretical framework, followed by the analysis of the current state of the company and analysis and design of solutions, including the identification of the risks of holding sensitive data in the cloud. The outсome of the work is the mentioned "Proof of Concept", in which the possibility of significant acceleration of performance with the help of the Azure Synapse tool was demonstrated, which is an important aspect of meeting the prescribed regulatory SLA.