Official Microsoft Cloud Workshop Template
Switch branches/tags
Nothing to show
Clone or download
Latest commit 0a74ecf Sep 6, 2018
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github/ISSUE_TEMPLATE Update issue templates May 17, 2018
Hands-on lab Update HOL unguided - Title xxx.md Jul 23, 2018
Media Delete header Jun 8, 2018
Whiteboard design session Update WDS trainer guide - Title xxx.md Aug 30, 2018
CONTRIBUTING.md Update CONTRIBUTING.md May 17, 2018
LICENSE Initial commit Mar 13, 2018
README.md Update README.md Jun 28, 2018

README.md

Microsoft Cloud Workshop template (replace with workshop name)

Please provide an introduction to the workshop. For example:

Trey Research Inc. looks at the old way of doing things in retail and introduces innovative experiences that delight customers and drive sales. Their latest initiative focuses on intelligent vending machines that support commerce, engagement analytics, and intelligent promotions.

Target audience

Please list the target audience for this workshop. For example:

  • Application developer
  • Infrastructure architect
  • Database administrator
  • AI developer
  • Data scientist

Abstract

Please provide descriptions of the overall workshop, the whiteboard design session and hands on lab. For example:

Workshop

In this workshop, you will look at the process of migrating an on-premises data warehouse to Azure SQL Data Warehouse. Throughout the whiteboard design session and hands-on lab, you will look at the planning process for data warehouse migration, identifying schema and data incompatibilities, efficiently migrating data from on-premises databases to the cloud, data distribution in Azure SQL Data Warehouse, migrating ETL jobs to Azure Data Factory, and supporting ad-hoc workloads in an Azure SQL Data Warehouse through Azure Analysis Services.

At the end of this workshop, you will be better able to [deliver, demonstrate, solve, present, migrate, build, design, architect, construct, modify] ….

Whiteboard design session (this will go in the readme and in the WDS document)

In this whiteboard design session, you will work in a group to look at the process of migrating an on-premises data warehouse to Azure SQL Data Warehouse. The design session will cover planning for a data warehouse migration, data and schema preparation, data loading, optimizing the data distribution, and building a solution to support ad-hoc queries.

At the end of this whiteboard design session, you will be better able to [deliver, demonstrate, solve, present, migrate, build, design, architect, construct, modify] ….

Hands-on lab (this will go in the readme and in the HOL document)

In this hands-on lab, you will migrate an existing on-premises enterprise data warehouse to the cloud. You will investigate the current data warehouse to identify any incompatibilities, you will export the data from the on-premises data warehouse and transfer it to Azure Blob Storage. Then you will load the data into the warehouse. Finally, you will integrate the warehouse by migrating ETL to Azure Data Factory and supporting ad-hoc access by implementing Azure Analysis Services.

At the end of this hands-on lab, you will be better able to [deliver, demonstrate, solve, present, migrate, build, design, architect, construct, modify] ….

Azure services and related products

Please list the services and products that are highlighted in the workshop. For example:

  • Azure SQL Data Warehouse
  • Azure Data Factory
  • Azure Analysis Services
  • Azure Storage

Azure solutions

This is an internal reference and will be updated by project PM.

Related references

This should be a list of and links to prereqs, architectural diagrams, supporting docs, or briefing decks related to the material.