EDW to Azure SQL Data Migration: 1-Day Workshop

This 1-day, instructor-led workshop is intended for data professionals who want to want to learn more about Azure and Azure services. In this workshop, you will migrate a retail chain from an existing data warehouse in an on-premises SQL Server into Azure SQL Data Warehouse. Prepare a detailed migration plan including data preparation, importing data into Azure SQL Data Warehouse, and architecting a data orchestration strategy to move data from the existing on-premises source systems to Azure SQL Data Warehouse.

What You’ll Learn

• Configure a Data Management Gateway to access on-premises data sources from Azure
• Configure Power BI Dashboards to leverage data stored in Azure SQL Data Warehouse

Prerequisites

• Workshop content presumes 300-level of architectural expertise of infrastructure and solutions design.
• We suggest students take a Microsoft Azure Essentials course prior to attending this workshop.

Workshop Outline

Module 1: Whiteboard Design Session - Migrate EDW to Azure SQL Data Warehouse

• Review the customer case study
• Design a proof of concept solution
• Present the solution

Module 2: Hands-on Lab - Migrate EDW to Azure SQL Data Warehouse

• Configure Azure services
• Data and schema preparation
• Migrate the data to Azure SQL Data Warehouse
• Integrate Azure SQL Data Warehouse and On-Premises Data Sources with Azure Data Factory and Power BI