Migration of On-Premises Database to Cloud and Perform Explanatory Analytics on Sales Data

This paper explores the migration of an industrial company's sales database from its servers to the cloud using Microsoft Azure, emphasizing three unique aspects of the process. First, it integrates the Delta Lake format within Azure Data Lake Storage Gen2, which is critical for maintaining multiple versions of data securely and ensuring ACID compliance. Second, the paper addresses significant adoption challenges such as data security, recovery, and vendor lock-in. It provides practical advice and strategic insights to help organizations navigate the complexities of cloud migration. Third, it offers a comparative analysis of two cloud storage methods—serverless and dedicated pool storage. This analysis evaluates their performance, cost-effectiveness, and suitability for different workload sizes, providing valuable insights for selecting the optimal storage strategy. Overall, this study contributes to a deeper understanding of cloud migrations, emphasizing practical applications and strategic decision-making necessary for enhancing operational efficiency and effective data management in cloud environments.