Migrace datového skladu z MS SQL Server on-premise prostředí do cloudu

This thesis focuses on the issue of moving from a traditional data warehouse implemented on-premises to a cloud solution using Microsoft technologies. The aim of the thesis is to identify the benefits and reasons for using a Microsoft Azure cloud solution, describe in detail the architecture of MS Azure, and formulate an effective process for adopting a cloud with a minimal negative impact for companies that have a similar data warehouse architecture described in this thesis. The thesis consists of two logical parts. The first part is devoted to mapping the benefits of migrating a data warehouse to the cloud. It also discusses the three most used cloud services providers, their differences, specific features, and products offered. The second part of the work focuses on the creation of the recommendation and methodology for the migration of a specific enterprise data warehouse, with regard to both the current state of the data warehouse, and available components in the cloud that can be used. Subsequently, this methodology is verified in practice. The main benefit of this work is the design of a methodology for moving the data warehouse to the cloud environment based on a project for migration to Azure. The proposed methodology takes into consideration the main steps of data warehouse migration with a focus on Microsoft technologies and services and allows companies to take advantage of Microsoft's cloud platform implementation.