EDW to Azure SQL Data Migration: 1-Day Workshop

Dynamics Edge

In this workshop, you will migrate an existing data warehouse from an on-premises SQL Server into Azure SQL Data Warehouse.

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
https://store-images.s-microsoft.com/image/apps.60630.91a73b79-9587-4f12-8197-4c306aec6213.dc12b0b0-b91e-46db-9142-b1955b95d818.eb558b10-02ff-443b-a548-5513ea66afc5
https://store-images.s-microsoft.com/image/apps.60630.91a73b79-9587-4f12-8197-4c306aec6213.dc12b0b0-b91e-46db-9142-b1955b95d818.eb558b10-02ff-443b-a548-5513ea66afc5