Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
Big Data & Data Engineering

Power BI + Synapse: Leverage the best of both for scale

Description

When you think of scale of data, you think about Azure Synapse Analytics. What about Power BI? Or course it scales! But to get that scale, you need to leverage the best features from both pieces instead of just looking at them in individual silos. In this training day, we will go through just that!

- SQL Dedicated Pool vs Serverless
- Data ingestion strategies
- Caching strategy with Aggregations
- Hybrid Tables
- Best practices
- Security and governance
- More…

Learning Objectives

Attendees will leave with an understanding of the key features to leverage between Power BI and Synapse to achieve the best performance and scale. They will understand best practices to achieve those goals.

Previous Experience

Ideal attendees have spent some time in Power BI and at least SQL Server / Azure SQL Database - not necessarily Azure Synapse Analytics.

Tech Covered

Azure, Synapse Analytics, Power BI, Modelling, Optimising, Big Data & Data Engineering, Data Visualistion & Modelling