In this chapter, we will explore what Fabric is, why it exists, and how it is organized into workloads, workspaces, and items. You will also learn how workspace settings, roles, and endorsement help teams collaborate and govern their data.

Getting started with Microsoft Fabric

Exploring the Fabric workspace

What problem does Fabric solve?

Identify Fabric building blocks

How workloads map to user job functions

Choose an item for an analytics task

Classify workloads and items

Create a warehouse item

Data governance basics

Getting familiar with workspace settings

Read workspace permissions

Choosing the right endorsement status

Introduction to Fabric

In this chapter, we will look at how data in Fabric is managed. You will get familiar with OneLake as Fabric's storage foundation, use shortcuts to access data without copying it, discover trusted data assets with OneLake catalog, and compare ways to bring data into Fabric, including pipelines, Dataflow Gen2, and Eventstreams.

OneLake as the Fabric data foundation

Files or tables?

Why use a shortcut?

OneLake in the architecture

Discovering data with OneLake catalog

Filter the catalog for a named item

Read catalog metadata

Using catalog search for governance

Adding and accessing data in Fabric

Building a batch ingestion pipeline

Inspect data access and ingestion outputs

Which method would you use?

Data Management in Fabric

In this chapter, we will look at how big data is managed in Fabric via lakehouses and warehouses. We will also learn how to query that data with SQL and the visual query editor.

Lakehouse vs. warehouse for big data

Lakehouse or warehouse?

Compare item details

Choose a downstream path

Lakehouse basics

Explore the Files area

Explore the Tables area

What belongs in a lakehouse?

Querying data with SQL

Run your first SQL query

Filter results

Querying data visually

Select columns visually

Add a filter visually

SQL or visual query?

Fabric and Big Data

In this chapter, we will look at how Fabric data is consumed and extended. You will use notebooks for code-based analysis, learn how semantic models, storage modes, and Copilot support reporting, and capture and query streaming data with Eventstreams, Eventhouses, and KQL.

Introduction to notebooks in Fabric

Identify the default kernel

Adding a lakehouse attachment

What are notebooks good for?

Business insights with semantic models

Options

Relationship

Measure

Report

Classify semantic model elements

Choose a storage mode

Real-Time Intelligence with Eventhouse and KQL

Choose an Eventstream destination

Create and publish an Eventstream

Complete a simple KQL query

Congratulations!

Data Analytics and Real-Time Intelligence

Company data

Marketing data

Welcome to the world of Microsoft Fabric! In this course, you will explore the core Fabric workloads, including Data Engineering, Data Factory, Data Warehouse, Real-Time Intelligence, and Power BI, and learn how workspaces, roles, and endorsement keep data governed. Discover how data engineers, data analysts, data scientists, and BI developers use OneLake, the OneLake catalog, pipelines, lakehouses, warehouses, notebooks, semantic models, Eventstreams, and Eventhouses to achieve their business goals, and query data with SQL, the visual query editor, and KQL. This course was built as a starting point for preparing for Microsoft's Fabric Analytics Engineer Associate certification (DP-600).

<h2>Welcome to Microsoft Fabric</h2>Take your first steps with Microsoft Fabric, an all-in-one platform unifying data engineering, data science, and business intelligence. This course offers hands-on experience with Fabric’s key features, helping you manage data across teams, automate pipelines, and create insightful dashboards.<br><br>
<h2>Explore Fabric’s Seven Experiences</h2> Understand the core functions of Fabric’s seven experiences: Data Factory, Data Engineering, Data Warehouse, Data Science, Real-Time Intelligence, Power BI, and Data Activator.<br><br>
<h2>Master Data Ingestion & Transformation</h2> Learn to use Data Pipelines, Dataflow Gen 2, and Shortcuts to ingest, clean, and transform data in Fabric.<br><br>
<h2>Choose the Right Storage Solution</h2>Discover the differences between Lakehouses and Warehouses, and when to use each for your data storage needs.<br><br>
<h2>Business Intelligence with Power BI</h2> Create interactive dashboards and reports using data from your Fabric Lakehouses and Warehouses, fully integrated with Power BI.<br><br>
<h2>Certification Preparation</h2> This course is your first step toward earning Microsoft’s Fabric Analytics Engineer Associate certification (DP-600), covering key exam topics and skills.


To understand Fabric’s main use cases, you will explore various tools in the seven Fabric experiences.

Introduction to Microsoft Fabric

Connects Sales to Customers using CustomerID

Average order value calculated from sales data

Charts and filters that a business user opens

A page of visuals showing sales by product category

Classify semantic model elements

Introduction to Microsoft Fabric

Hands-on interactive exercise