Building Modern Data Warehouse with Azure Synapse Analytics!
summary
Live demo builds a retail modern data warehouse on Azure Synapse that ingests SAP/Oracle/Blob/Cosmos/ADLS data, runs transformations with Spark notebooks, mapping data flows and Azure Data Factory pipelines, and serves a Power BI dashboard with streaming Twitter and sensor visuals. It claims interactive queries on 30 billion records at single‑digit latencies, shows column and row level security enforced, uses SQL on‑demand and provisioned SQL pools, and integrates Azure ML AutoML for product recommendations — all deployed and shown working end‑to‑end.
AI-written summary · about
chapters (10)
- 0:00Introduction to synapse
- 2:08Synapse analytics overview
- 5:00Modern architecture concepts
- 10:22Synapse workspace breakdown
- 16:02Retail demo context
- 21:45Dashboard and insights
- 27:21Synapse studio navigation
- 36:21Data analysis and security
- 44:41Spark and machine learning
- 49:02Wrap up and final thoughts
related talks
51mSupercharge Power BI with Azure Synapse Analytics
40mData Lake House in the Cloud: The Azure Solutions
50mPower BI + Azure Synapse Analytics: Beginning your journey
46mThe Ultimate Jigsaw - Architecting Azure Synapse Analytics
24mSynapse Analytics
28mArchitecture patterns of Azure Cosmos DB & Azure Synapse Analytics
12mModern Data Warehouse for Small and Medium Business
49mHow to start with Azure Synapse Analytics - Power BI Developer Edition