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.
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 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.
|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
|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|
Microsoft Schweiz GmbH
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 Switzerland. Food and refreshments will be provided.