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 |
| Fabric 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 Fabric Activator — named Data Activator until recently, and Reflex in preview — 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 2 flashcards for this section and review them on a spaced-repetition schedule.
Written byAlvin Varughese
Founder•20 professional certifications