In this session, we will take a 132 billion-row dataset of real-world anonymized marketing data and look at how to build a complete end-to-end analytical storage and data storytelling solution using Azure Synapse and Power BI.

We will cover everything from designing an ELT process using Synapse Pipelines, building a data model optimised for big data in SQL Dedicated Pool as well as how to manage dual connection mode and aggregations Power BI!

We will show:

- How to harness large data volumes using Azure Synapse
- How this approach can break down data silos in your company
- Combining Import and Direct Query modes within the same Power BI data model
- How to create a Power BI dashboard that responds in seconds when working with Big Data in Azure Synapse