How to start with Azure Synapse Analytics - Power BI Developer Edition

on YouTube ↗49m

" summary

Demo-first overview of Azure Synapse shows a single workspace that combines Azure Data Factory pipelines, Spark pools, dedicated and serverless SQL pool query engines, and an Azure Data Lake storage account as the central store. Development happens in Synapse Studio with notebooks with mixed languages and integrated pipeline monitoring; a workflow demo creates a serverless view, downloads a PBIDS, connects Power BI via DirectQuery, and publishes a dataset. Limits shown: one Power BI workspace mapping today. Upcoming performance accelerator/materialized views promise automated caching to speed heavy Power BI queries.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 1:22Data warehousing vs data lakes
3. 4:23Data engineering challenges
4. 10:49Cloud architecture overview
5. 14:38Introducing Azure Synapse
6. 21:22Synapse studio demo
7. 34:40Integration with Power BI
8. 46:30Recap and future outlook

" related talks

• 53mAzure Synapse Analytics: Evolving Azure SQL Data WarehouseMark Pryce-Maher, Artur Vieira · SQLBits 2020
• 54mAn introduction to Azure Synapse Analytics!Mahesh Balija · SQLBits 2020
• 51mSupercharge Power BI with Azure Synapse AnalyticsMathias Halkjaer · SQLBits 2023
• 50mPower BI + Azure Synapse Analytics: Beginning your journeyPatrick LeBlanc, Adam Saxton · SQLBits 2023
• 24mSynapse AnalyticsCharles Feddersen · DataEngBytes 2020
• 52mConnect your data artifacts with Azure Synapse Analytics and Azure PurviewWolfgang Strasser · Global Azure Austria 2021
• 58mAzure Data Lake & Synapse Server less ArchitecturePrince Kher · Global Azure Virtual 2021
• 46mThe Ultimate Jigsaw - Architecting Azure Synapse AnalyticsHeini Ilmarinen · Women Data Summit 2021