Power BI + Azure Synapse Analytics: Beginning your journey
summary
Covers concrete setups: use serverless SQL querying parquet files from ADLS for on‑the‑fly reads, or spin up dedicated SQL pools with materialized views to cut cross‑node shuffles; build ETL in Spark notebooks, add them to pipelines for schedulable automation, and secure access via credentials so users query external tables without storage rights. Demonstrations show aggregations shrinking trillions of rows to a 255‑million‑row AG table with sub‑second queries while detail takes ~15–20s; auto‑aggregation needs Premium.
AI-written summary · about
chapters (9)
- 0:00Introduction and overview
- 4:56Azure Synapse Studio tour
- 11:40Serverless vs dedicated SQL pools
- 21:33Access control and security
- 27:51Materialized views for performance
- 31:03Power BI direct query basics
- 38:25Composite models and dual storage
- 43:20Aggregations for scale
- 49:20Q&A and closing
related talks
54mAn introduction to Azure Synapse Analytics!
49mAzure Synapse Analytics
49mHow to start with Azure Synapse Analytics - Power BI Developer Edition
53mAzure Synapse Analytics: Evolving Azure SQL Data Warehouse
58mAzure Data Lake & Synapse Server less Architecture
52mConnect your data artifacts with Azure Synapse Analytics and Azure Purview
46mThe Ultimate Jigsaw - Architecting Azure Synapse Analytics
55mBuilding Modern Data Warehouse with Azure Synapse Analytics!