Instiq
Chapter 4 · Analytics Workloads on Azure·v2.1.0·Updated 6/28/2026·~8 min

What's changed: Added §4.4 "Microsoft Fabric (Unified Analytics Platform)" to fix the drift from the 2026 refresh that centers the analytics domain on Fabric/OneLake/lakehouse/Real-Time Intelligence/Data Activator. Adds Fabric alongside the existing Synapse-centric content

4.2Azure Analytics Services

Key points

Understand the Azure services behind the analytics pipeline—Azure Data Factory, Azure Synapse Analytics, Azure Databricks, and Azure Stream Analytics—and their roles.

Azure services cover stages of the analytics pipeline. Learning which stage each handles makes them easier to remember.

4.2.1Key services

Diagram of Azure analytics services: Azure Data Factory (ingest & orchestrate/ETL), Azure Synapse Analytics (large-scale warehousing), Azure Databricks (Spark-based processing), Stream Analytics (real-time streaming), and Microsoft Power BI (visualize & report).
Azure analytics services
  • Azure Data Factory: ingest, transform, and orchestrate data (ETL/ELT pipelines).
  • Azure Synapse Analytics: an integrated platform for large-scale warehousing and analytics.
  • Azure Databricks: an Apache Spark-based platform for big data processing and ML.
  • Azure Stream Analytics: processes real-time streaming data.
ServicePipeline stageRole
Azure Data FactoryIngest / processBuild/run ETL/ELT pipelines
Azure Synapse AnalyticsStore / analyzeLarge-scale warehousing + analytics
Azure DatabricksProcess / analyzeSpark big-data processing & ML
Azure Stream AnalyticsProcess (real time)Streaming data processing
Microsoft Power BIVisualizeReports & dashboards

Continue reading — free sign-up

You're reading the free preview. Sign up free to read this section in full, plus every chapter (including 4+) and all questions.