Azure SQL DW Automation Hands-on Lab

The Azure SQL DW Automation hands-on lab explores technologies available on Microsoft’s cloud data warehouse platform in combination with the advanced Data Warehouse and Big Data Automation provided by biGENiUS®.

Microsoft’s cloud data warehouse, Azure SQL Data Warehouse, provides enterprises with significant advantages like high performance analytics, scalability and reduced costs. Leveraging massively parallel processing (MPP) to quickly run complex queries across petabytes of data, data warehousing on Azure easily outperforms traditional on-premises data warehouse platforms.

But an enterprise data warehouse doesn’t exist in isolation. It is part of a complete analytics solution including often many disparate data sources, ELT pipelines to load, extract and transform the data as well as staging and reporting layers. Relying on “good old” manual coding to build and maintain such solutions is not only expensive and time-consuming, but long-term also risky for the flexibility of your solution. 

Smarp Pics (8)This is where biGENiUS can bring value both to developers and to business users. Keeping DW metadata clean, biGENiUS provides automation and standardization across the entire lifecycle of your data analytics solution. As a result, DWH teams can benefit from improved agility, and business – from radically shorter times to delivery. 

As a certified automation partner, biGENiUS accelerates and streamlines the not only the initial buildup, but also the development of new requirements and enhancements in SQL data warehouses virtually out-of-the-box.

During this lab day, you will have the opportunity build an entire and fully functional data warehouse in the cloud from scratch within hours. 

The lab addresses data engineers, data warehouse practitioners and business intelligence developers. 



Time Session
08:30 – 09:00 Arrival and registration
09:00 – 09:30 Coffee, instructions and technical setup
09:30 – 10:00 Introduction to the Azure Data Analytics platform
10:00 – 10:30 Introduction to biGENiUS for Big Data & Data Warehouse Automation
10:30 – 11:30 Lab 1: Model your data warehouse with biGENiUS
11:30 – 12:30 Lab 2: Generate, deploy and load your data warehouse on Azure
12:30 – 13:15  Lunch break
13:15 – 14:00 Lab 3: Enhance your data warehouse solution
14:00 – 15:00 Lab 4: Let number tell a story using PowerBI
15:00 – 15:30 Wrap-up and closing remarks


Thursday, 11.04.2019
From 8:30 a.m. to 3:30 p.m.


Microsoft Schweiz GmbH
Richtistrasse 3
8304 Wallisellen, ZH


Skills: Basic SQL and knowledge of SQL server databases. 

Technical: Participants are kindly asked to bring their own laptop with a running Windows OS and access to an Azure Subscription or Resource Group with rights to provision and delete the following Azure services:


Please mind, that a free trial subscription may not include all the services you need for your lab data warehouse solution. You are encouraged to use the existing Azure subscription of your organization and “take away” the lab and perfect your skills on your own.


This hands-on lab offered free of charge in a cooperation with our partner Microsoft Switzerland.