An introduction to Azure Synapse Analytics!
summary
Azure Synapse Analytics combines Data Lake storage and MPP data warehouse into one workspace with integrated Data Factory pipelines, Spark pools and T-SQL pools, Power BI and Azure ML. Demo runs a complex query over 30 billion rows returning results in seconds then instantaneous thanks to result set cache and materialized views. Data ingestion uses UI-driven mapping data flows and 90+ connectors (example: SAP HANA → ADLS pipeline). Also shows Spark notebooks with AutoML model training, workload isolation, scale-out clusters and in-place data sharing.
AI-written summary · about
chapters (26)
- 0:00Introduction
- 1:27Welcome
- 1:55Analytics and AI
- 2:40Data lakes
- 4:04Azure Synapse Analytics
- 4:28Quick definition
- 5:33What is Azure Synapse Analytics
- 6:19What is Modern Data Warehouse
- 9:02Power BI
- 10:44Azure Synapse Analytics overview
- 15:32Key innovations
- 17:28Synapse Analytics Studio
- 18:57Azure Data Factory
- 23:41Apache Spark
- 25:34Spark in Synapse Analytics
- 26:36Analytics Runtime
- 27:25Result Set Cache
- 30:14Workload Management
- 35:56Azure Advisor Recommendations
- 36:42Developer Tools
- 37:24PowerBI
- 38:13Data Share
- 42:01Demo
- 44:08Synapse Workspace
- 45:16Data Hub
- 48:29Data Flows
related talks
24mSynapse Analytics
51mSupercharge Power BI with Azure Synapse Analytics
46mThe Ultimate Jigsaw - Architecting Azure Synapse Analytics
49mHow to start with Azure Synapse Analytics - Power BI Developer Edition
50mPower BI + Azure Synapse Analytics: Beginning your journey
40mData Lake House in the Cloud: The Azure Solutions
55mAzure SQL database, Azure Synapse Analytics, Azure Databricks?
52mConnect your data artifacts with Azure Synapse Analytics and Azure Purview