Copyright (c) 2026 MindMesh Academy. All rights reserved. This content is proprietary and may not be reproduced or distributed without permission.
5.2.2. Fabric Workloads (Experiences)
Microsoft Fabric provides specialized "experiences" for different personas and tasks:
| Workload | Purpose | Persona |
|---|---|---|
| Data Factory | Data integration, ETL/ELT pipelines, dataflows | Data Engineer |
| Data Engineering | Spark notebooks, Lakehouse tables | Data Engineer |
| Data Warehouse | T-SQL analytics, star schema modeling | Data Engineer, Analyst |
| Data Science | ML experiments, model training | Data Scientist |
| Real-Time Intelligence | Streaming data, KQL queries, eventstreams | Data Engineer, Analyst |
| Data Activator | No-code monitoring that triggers actions when data hits a condition | Analyst, Business User |
| Power BI | Reports, dashboards, semantic models | Data Analyst, Business User |
Note: the workload formerly called Real-Time Analytics is now Real-Time Intelligence, and Data Activator brings the count to seven. All seven read from and write to the same OneLake storage, which is what makes Fabric a single product rather than a bundle.
Enroll to unlock the 5 practice questions written for this section, so you can test what you just read while it is fresh.
Enroll to unlock the 2 flashcards for this section and review them on a spaced-repetition schedule.
Written byAlvin Varughese
Founder•20 professional certifications