Microsoft Fabric - A Deeper Dive

Name: Microsoft Fabric - A Deeper Dive
Rating: 4.5 (598 reviews)

A deeper dive into data engineering, data science, real-time analytics, Power BI, Spark, Data Warehousing and more

Created byRandy Minder

Last updated 7/2025

English

What you'll learn

Power BI with DirectLake. A 170 million row fact table is used to demonstrate we don't need import mode any more!
Apache Spark Integration into Microsoft Fabric
Data science in Microsoft Fabric attempting to predict how long a taxi ride in New York City might take
Ingesting data using the power and flexibility of data pipelines with DataFlows Gen2 and Data Factory
Building a data warehouse in Microsoft Fabric
Building a real-time analytics solution using New York City taxi data and Event Streams with KQL
Semantic Link for Power BI

Course content

9 sections • 76 lectures • 13h 4m total length

Introduction2:25
An Introduction to the course
Exercises and Quizzes in this Course - Please Watch!1:38
A brief discussion of why there are no exercises or quizzes in this course, and what we offer in exchange.
Getting Started with Microsoft Fabric3:08
If you have never used Microsoft Fabric, this brief lecture will show you how to get started, for free.

Overview - Part 114:16
Part 1 of our discussion on Power BI and Direct Lake
Overview - Part 217:33
Part 2 of our discussion of Power BI and Direct Lake
XMLA-Write Support10:06
In this lecture we talk about XMLA-Write support for Direct Lake datasets
Putting Direct Lake to the Test - Part 114:26
In this lecture we put Direct Lake to the test with a 170 million row fact table
Putting Direct Lake to the Test - Part 211:34
In this lecture we put Direct Lake to the test with a 170 million row fact table
Power BI Desktop and Direct Lake8:58
In this lecture we discuss how to access a Direct Lake dataset from Power BI Desktop
On-Demand Loading7:23
In this lecture we talk about On-Demand Loading and using DAX Studio to inspect the cache
Default Semantic Model vs. Custom Model13:30
Comparing the default semantic model to creating a custom model

Introduction to Data Science13:31
In this lecture we introduce the topic of data science
Data Science in Microsoft Fabric12:14
A discussion of how Microsoft Fabric incorporates data science
Notebooks11:24
In this lecture we do a high level overview of notebooks, experiments and models
Experiments5:47
In this lecture we do a high level overview of experiments
Models11:27
In this lecture we do a high level overview of machine learning models
Preparing Data - Data Wrangling16:40
In this lecture we cover data wrangling in Fabric. Note, this is the same data wrangling lecture I gave in our Microsoft Fabric course. If you went through that lecture, feel free to skip this lecture. Or, go through it again to reinforce your knowledge.
End-to-End Project: Getting Set Up12:23
End-to-end project: Getting set up
End-to-End Project: Ingesting Data9:55
End-to-end project: Ingesting data
End-to-End Project: Exploring the Data Part 115:09
End-to-end project: Exploring the data Part 1
End-to-End Project: Exploring the Data Part 29:27
End-to-End Project: Exploring the Data Part 2
End-to-End Project: Exploring the Data Part 311:03
End-to-End Project: Exploring the Data Part 1
End-to-End Project: Exploring the Data Part 410:28
End-to-End Project: Exploring the Data Part 4
End-to-End Project: Train and Evaluate the Data Part 111:27
End-to-End Project: Train and Evaluate the Data Part 1
End-to-End Project: Train and Evaluate the Data Part 213:16
End-to-End Project: Train and Evaluate the Data Part 2
End-to-End Project: Train and Evaluate the Data Part 312:26
End-to-End Project: Train and Evaluate the Data Part 3
End-to-End Project: Train and Evaluate the Data Part 47:20
End-to-End Project: Train and Evaluate the Data Part 4
End-to-End Project: Reporting Part 18:55
End-to-End Project: Reporting Part 28:54
End-to-End Project: Reporting Part 2

Introduction to Real-Time Analytics in Microsoft Fabric9:41
Introduction to real-time analytics in Fabric
Event Stream3:03
A brief introduction to event streams in Fabric
Creating a KQL Database3:13
In this lecture we create a KQL database
Creating an Event Stream6:50
In this lecture we create a Fabric event stream
Getting Location Data2:59
In this lecture we retrieve some latitude and longitude location data
Adding the Data to the Lakehouse5:49
In this lecture we 'add' the data to our Lakehouse
Exploring the Data14:38
In this lecture we explore the data using KQL and SQL
More Data Exploration14:51
In this lecture we do more, advanced, querying of data
Real-Time Analytics becomes Real-Time Intelligence15:38
Real-Time Analytics becomes Real-Time Intelligence

Introduction to Data Factory in Microsoft Fabric11:25
An introduction into the parts and pieces of Data Factory in Microsoft Fabric
Building a Pipeline - Part 18:41
Part 1 of an end-to-end data factory process
Building a Pipeline - Part 29:04
Part 2 of an end-to-end data factory process
Building a Pipeline - Part 324:17
Part 3 of an end-to-end data factory process
Building a Pipeline - Part 410:01
Part 4 of an end-to-end data factory process
Building a Pipeline - Part 56:35
Part 5 of an end-to-end data factory process

Introduction to the Microsoft Fabric Data Warehouse8:05
An introduction to the Microsoft Fabric data warehouse
Building a Data Warehouse - Part 110:42
Part 1 of an end-to-end exercise in building a data warehouse
Building a Data Warehouse - Part 27:17
Part 2 of an end-to-end exercise in building a data warehouse
Building a Data Warehouse - Part 312:08
Part 3 of an end-to-end exercise in building a data warehouse
Building a Data Warehouse - Visual Query Builder13:13
In this lecture we explore the Visual Query Builder in Fabric
Using Shortcuts to Analyze Data in a Lakehouse9:11
In this lecture we explore creating shortcuts in a Lakehouse in preparation for data analysis
Modeling the Data and Auto-Generating a Power BI Report5:51
In this lecture we do some simple data modeling and auto-generate a report

Introduction to Apache Spark in Fabric9:22
An introduction to Apache Spark in Fabric
Spark Libraries3:46
In this lecture we discuss the four major components or libraries that make up Spark
Dataframe Basics - Part 19:47
Part 1 of a discussion on Spark dataframes
Dataframe Basics - Part 219:20
Part 2 of a discussion on Spark dataframes
Dataframe Basics - Part 310:39
Part 3 of a discussion on Spark dataframes
Common Operations with Dataframes15:16
Common operations when using dataframes
Filtering Data22:21
In this lecture we discuss various ways to filter data in Spark
Aggregating Data15:20
In this lecture we talk about ways to aggregate data in Spark.
Joining Dataframes8:33
In this lecture we talk about how to join Spark dataframes
Working with Dates11:38
In this lecture we demonstrate how Spark can deal with dates
SQL Statements and Spark8:56
In this lecture we talk about using the spark sql function and its interaction with other Spark functions.
Machine Learning2:51
In this lecture we just highlight the capabilities of machine learning in Spark
Microsoft Fabric 1.1. / Spark Runtime5:54
In this lecture we talk about the Microsoft Fabric / Spark runtime
Spark Configuration10:43
In this lecture we talk about configuring Spark
Spark Autotuning4:25
In this lecture we talk a bit about Spark autotuning

Semantic Link for Power BI - Part 16:36
Part 1 of our discussion on Semantic Link for Power BI
Semantic Link for Power BI - Part 29:42
Part 2 of our discussion on Semantic Link for Power BI
Semantic Link for Power BI - Part 315:06
Part 3 of our discussion on Semantic Link for Power BI
Data Activator - Part 19:58
A discussion of Data Activator Part 1
Data Activator - Part 217:59
A discussion of Data Activator Part 2
Microsoft Fabric Licensing and Pricing18:05
Microsoft Fabric licensing and pricing
Microsoft Fabric Licensing and Pricing July 2024 Update6:02
Some things have changed as of July 2024 with regards to Fabric pricing and options

Requirements

There are no prerequisites for this course other than having some working knowledge of Microsoft Fabric. This is an intermediate level course.

Description

A deeper dive into what you might ask? A deeper dive than what our initial Microsoft Fabric course covers. We go more deeply into data engineering, data science, data warehousing, Spark, Power BI with DirectLake, Power BI with Semantic Link with end-to-end examples and studies.

If you are a Power BI developer, you will love our deep dive into DirectLake where we use a 170 million row fact table to show that DirectLake is every bit as fast as tabular import mode. Hard to believe but true. We also cover Semantic Link with Power BI allowing Spark notebooks to interact with Power BI datasets.

If data engineering is your specialty we go through and end-to-end project demonstrating how to use Dataflows Gen2 and Data Factory Copy Activity, with pipelines to build an ingestion process.

If your interest is data science we go through an end-to-end machine learning project to demonstrate how Fabric and notebooks can be used or predict how long a taxi ride might take in New York City.

If you have a need to learn more about real-time analytics and KQL, we go through a project where we simulate taxi data being ingested using event streams and KQL.

If you are interested in building a data warehouse, we have an end-to-end data warehouse project showing how this can be done in Microsoft Fabric.

Interested in Apache Spark? We cover the important areas of Spark and how it integrates into Microsoft Fabric.

By the time you complete this 10+ hour course you will feel completely comfortable using all the most commonly used experiences in Microsoft Fabric.

Who this course is for:

This is an intermediate level course on Microsoft Fabric. Some Fabric experience, or having taken another Microsoft Fabric introductory course, might be helpful

Microsoft Fabric - A Deeper Dive

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 7min

Direct Lake and Power BI8 lectures • 1hr 38min

Data Science in Microsoft Fabric18 lectures • 3hr 22min

Real-Time Analytics in Microsoft Fabric9 lectures • 1hr 17min

Data Factory in Microsoft Fabric6 lectures • 1hr 10min

Data Warehouse in Microsoft Fabric7 lectures • 1hr 6min

Apache Spark in Microsoft Fabric15 lectures • 2hr 39min

Miscellaneous Topics7 lectures • 1hr 23min

Microsoft Fabric Updates3 lectures • 23min

Requirements

Description

Who this course is for: