Zum Hauptinhalt wechseln

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://gallery.azure.com/artifact/20151001/dynamicsedge.de40517-migrate-edw-azure-sql-data-warehouse.1.0.2/Artifacts/SampleImage/5e22a48a-f937-409d-936b-10cbccd274ba.png
https://gallery.azure.com/artifact/20151001/dynamicsedge.de40517-migrate-edw-azure-sql-data-warehouse.1.0.2/Artifacts/SampleImage/5e22a48a-f937-409d-936b-10cbccd274ba.png