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
What you'll learn
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).