The Seven Fabric Workloads (Part 1)

Introduction to Microsoft Fabric

Alex Kuntz

Technical Instructional Designer

Fabric Workloads

• Each workload contains tools relevant for certain jobs
• For example, Data Factory is used for data ingestion and transformation
• This video will cover Data Factory, Data Warehouse, and Data Engineering.

¹ https://azure.microsoft.com/en-us/blog/introducing-microsoft-fabric-data-analytics-for-the-era-of-ai/

Data Factory

Data Factory

• Ingests data from a variety of sources (e.g. Excel sheets, other databases, other cloud servises)
• Loads data into a Fabric's OneLake
• Interface resembles Power Query in Excel or Power BI

Data Factory

• Ingests data from a variety of sources (e.g. Excel sheets, other databases, other cloud servises)
• Loads data into a Fabric's OneLake
• Interface resembles Power Query in Excel or Power BI

• Complex, rule-based data workflows
• Can chain together a series of logic-based steps to process data as it is being ingested
• Built for data engineers and other technical personas

Data Warehouse

• Databases for structured data

Data Warehouse

• Databases for structured data
• Created using Dataflow or a Data Pipeline

Data Warehouse

• Databases for structured data
• Created using Dataflow or a Data Pipeline
• Fully transactional SQL (both read and write)

Data Warehouse

• Databases for structured data
• Created using Dataflow or a Data Pipeline
• Fully transactional SQL (both read and write)
• Stored using the Delta-Parquet format in OneLake

Data Engineering

• Structured and unstructured data

Data Engineering

• Structured and unstructured data
• Usually accessed via Notebooks using Python

Data Engineering

• Structured and unstructured data
• Usually accessed via Notebooks using Python
• Can read Lakehouse data using SQL, but can not edit data with SQL
• Use Notebooks with Python/Spark code to modify lakehouse data

Data Engineering

• Structured and unstructured data
• Usually accessed via Notebooks using Python
• Can read Lakehouse data using SQL, but can not edit data with SQL
• Use Notebooks with Python/Spark code to modify lakehouse data
• Uses the Delta-Parquet format in OneLake

Let's practice!

Introduction to Microsoft Fabric