In this chapter, we'll introduce you to the seven Fabric experiences and explain the main use cases of Fabric.

Welcome to Introduction to Microsoft Fabric

Logging Into Fabric

What is Fabric?

Fabric Personas: A Data Engineer

Fabric Personas: A Machine Learning Specialist

The Delta-Parquet Format

The Seven Fabric Workloads (Part 1)

Exploring A Warehouse

Adding Data To A Warehouse Using Dataflow

Exploring A Lakehouse

The Seven Fabric Experiences (Part 2)

Exploring A Notebook

Exploring An ML Model

Detecting Changes In Data

Introduction to Fabric

In this chapter, we'll look at how to add data to a Fabric Lakehouse and query that data.

Ingesting Data Into Lakehouses

Creating tables from raw files

Adding data using  a shortcut

Lakehouse Facts

The SQL Analytics Endpoint

Writing SQL Queries

The Visual Query Editor

More Visual Query Features

Editing Lakehouse Data

Errors in the SQL Analytics Endpoint

Editing Tables From A Notebook

Options

DML Statement

Non-DML Statement

DML Statements

Working with Lakehouses

In this chapter, we'll look at how to bring data into Power BI using semantic models.

Semantic Models

Getting Your Power BI License

Creating a Semantic Model

Power BI with Semantic Models

Fast Analysis with Direct Lake

The Default Semantic Model

Semantic Models’ Storage Mode

Storage Modes: Pros and Cons

Wrap-Up and Microsoft's Fabric Certification

Self Reflection Questions

Power BI In Fabric

Welcome to the world of Microsoft Fabric! In this course, you will explore a variety of tools found in the seven Fabric experiences to understand Fabric’s main use cases. Learn how data engineers, data scientists, database administrators, and BI analysts might use Fabric to achieve their business goals. 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

Adding data using a shortcut

Introduction to Microsoft Fabric

Hands-on interactive exercise