This lab provides an introduction to Azure SQL Data Warehouse, an elastic data warehouse as a service. SQL Data Warehouse has a “massively parallel” architecture but appears as one database to users. In addition, this lab explores visualizing data with Power BI, another key component of the Cortana Intelligence Suite.
In this lab, you will create a SQL Data Warehouse, load it with sample data, and explore some of its key features including the ability to quickly scale and pause as needed. You will also explore how to load data into your SQL Data Warehouse using T-SQL with PolyBase, then build a report with the data in Power BI.
Download the lab and you’ll learn about:
BlueGranite developed this material in conjuction with Microsoft, and the lab and its contents are property of Microsoft. Microsoft holds no legal obligations on quality or performance of the lab material. Fill out the form below to get access to the step-by-step lab document. Click here for additional hands-on labs.