Azure DW and Power BI, reporting at the speed of light!

on YouTube ↗45m

" summary

Hands-on demo shows Azure Synapse SQL pools (up to 60 nodes) serving 120M-row tables and the real gains: mismatched distributions cause shuffles that turn a 15–32s join into 32s, correct hash distribution halves it, a materialized views example cuts a 20s query to 0.3s, result set caching drops repeated queries from ~10s to 0.3s, and Power BI using aggregations + import/dual composite models brings a KPI from ~6s down to ~168ms. Tools used: SSMS, Azure Data Studio, DAX Studio, Synapse and Power BI; demos all work.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 2:01Azure Synapse
3. 12:26Materialized Views
4. 17:35Resultset Caching

" related talks

• 58mPower BI for the DeveloperPeter Myers, Chris Webb · NDC London 2023
• 57mBillions of records: the real success story using Microsoft Power BI EmbeddedIrina Dragunova · NDC Oslo 2020
• 51mPower BI Composite and Hybrid ModelsAlex Whittles · SQLBits 2023
• 01h 01mDiscover, Manage, Analyze, and Visualize Your Data with Power BIMiguel Martínez · PASS Business Analytics Conference 2015
• 48mPower BI for DevelopersPeter Meyers · NDC Sydney 2018
• 30mEmpower every BI professional to do more with FabricZoe Douglas, Christian Wade · Microsoft Build 2023
• 51mAggregations in Power BIMarco Russo · SQLBits 2024
• 01h 03mPower BI for the DeveloperPeter Myers · NDC Sydney 2016