Complete Guide to Managing Data with Microsoft Fabric: From Beginner to Advanced

Course details

Microsoft Fabric combines key Azure services—Power BI, Azure Synapse Analytics, and Data Factory—with OneLake, a single, logical data lake that centralizes storage and governance. In this comprehensive course, Deepak Goyal—CEO of Azurelib Academy and LinkedIn Influencer with 250K+ followers—guides data scientists and analysts from foundational Fabric concepts to advanced techniques in data engineering and analytics. The course covers workspaces, lakehouses, and data pipelines, along with best practices for secure access and permissions. It also includes Power BI reporting and visualization for impactful insights. Hands-on challenges reinforce learning, and a capstone project allows you to demonstrate your ability to design and optimize real-world data workflows in Microsoft Fabric. Plus, explore how AI-powered features like Copilot streamline tasks and accelerate insights.

Learning objectives
Create, manage, and monitor pipelines in Microsoft Fabric.
Control access management and permissions in Microsoft Fabric.
Create and manage lakehouses in Microsoft Fabric.
Create Power BI reports in Microsoft Fabric.

Concepts

Introduction

Master Microsoft Fabric

Introduction to Microsoft Fabric

Create your first workspace
Setting up a Fabric lakehouse
Upload data to the lakehouse
Upload folder into the lakehouse
SQL analytics endpoint in lakehouse
Visual query in SQL endpoint
Understanding the default semantic model
Create shortcuts in files of lakehouse
Create shortcuts in tables of a lakehouse

Working with Microsoft Fabric Workspaces

All about Microsoft Fabric
Key benefits and use cases
Fabric architecture
Fabric UI and navigation
Fabric licensing and pricing
All about Microsoft Fabric workspaces

Microsoft Fabric Data Factory

Explore Fabric Data Factory UI
Create an ADLS in Azure
Create your first pipeline
Understand lookup activity
Understand if activity
Understand for each activity
Schedule the pipeline
Explore the gateway in Fabric
Creating a Dataflow Gen2
Monitor pipelines
Compare ADF vs. Fabric Data Factory

Spark in Microsoft Fabric

Spark pool in Fabric
Creating custom spark pools
Understand Fabric Notebook UI
Run your first notebook
Apply filter and order by in Fabric Notebook
Apply aggregation in Fabric Notebook
MSSparkUtils - Mount
MSSparkUtils - Additional utilities
Create a managed and external table
Call one notebook from another

Microsoft Fabric Data Warehouse

What is a data warehouse in Fabric
Create your first data warehouse
Create tables in data warehouse
Load data into table
Zero copy clone
Time travel in warehouse

Permissions and Access Control in Fabric

Capacity and workspace items level permission

Building Power BI Reports in Fabric

Create reports from the semantic model

Capstone Project

Project requirements
Project solution - Product information tables
Project solution - Semantic model
Project solution - Report

Conclusion

Next steps