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 & 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 extract, load 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. 


biGENiUS-Azure-SQL-Data-WarehouseThis 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 Azure SQL DW automation partner, biGENiUS accelerates and streamlines not only the initial buildup, but also the development of new requirements and enhancements in Azure SQL data warehouses 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.  



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 DW solution
14:00 - 15:00 Lab 4: Let numbers tell
a story using PowerBI
15:00 - 15:30 Wrap-up and closing remarks



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


Microsoft Schweiz GmbH
Richtistrasse 3
8304 Wallisellen, Zurich


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



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 you 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 is offered free of charge in a cooperation with our partner Microsoft SwitzerlandFood and refreshments will be provided. 

Register now for our Azure SQL DW Automation Hands-on Lab