Delivering the MDW with Azure SQL Data Warehouse, Azure Databricks, Azure Data Factory and PBI

Microsoft Ignite 2019 | Delivering the MDW with Azure SQL Data Warehouse, Azure Databricks, Azure Data Factory and PBI | Chris Testa-O'Neill
Course info
Level
Advanced
Updated
Feb 13, 2020
Duration
46m
Table of contents
Delivering the MDW with Azure SQL Data Warehouse, Azure Databricks, Azure Data Factory and PBI
Description
Course info
Level
Advanced
Updated
Feb 13, 2020
Duration
46m
Description

In this experience, see how Azure Data Factory (ADF), Azure Databricks, and Azure SQL Data Warehouse (SQL DW) can be used together to build a modern data warehouse. Start by using Azure Data Factory (ADF) to automate the movement of data in various formats gathered from various sources, including Azure Cosmos DB, into a centralized repository, Azure Data Lake Storage Gen2 (ADLS Gen2) in this case. Then, use Azure Databricks to prepare and analyze those data, and finally write the aggregations to Azure SQL Data Warehouse (SQL DW).

About the author