Microsoft Cloud Workshop: Migrate EDW to Azure SQL Data Warehouse (40517G)

Microsoft Cloud Workshop: Migrate EDW to Azure SQL Data Warehouse (40517G)

Overview

Duration : 1 Day

Migrate a retail chain to from an existing data warehouse from 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.

Objectives

At the end of this workshop, you will be better able to plan and implement a migration of your existing on-premises enterprise data warehouse to Azure SQL Data Warehouse and integrating it with both cloud-based and on-premises services and data sources.

Course Outline

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

Lessons

  • 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

Lessons

  • Configure Azure Services
  • Data and schema preparation
  • Migrate the data to Azure SQL Data Warehouse
  • Investigate table distribution in Azure SQL Data Warehouse
  • Create an Analysis Services Model
  • Visualize data with Power BI Desktop
None
Course ID:
40517G


Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.