Microsoft Fabric Deep Dive: Fabric Guide

Name: Microsoft Fabric Deep Dive: Fabric Guide
Rating: 4.5 (19 reviews)

Master Microsoft Fabric: A Practical Guide to Data Integration, Analytics, and Governance from Basics to Advanced Techni

Created byMallaiah Somula

Last updated 5/2026

English

English [Auto],

What you'll learn

Master Data Integration Techniques
Develop Proficient Data Analytics Skills
Implement and Manage Data Governance
Optimize Data Workflows for Efficiency

Course content

6 sections • 31 lectures • 24h 48m total length

Introduction to Microsoft Fabric || Getting Started with Microsoft Fabric53:34
Learn how Microsoft Fabric unifies data movement, transformation, real-time analytics, and reporting in a single SaaS platform built around a single data lake and delta parquet format, with Copilot assistance.
Hands-On : Create Your First Workspace in Fabric | General Terminology | Roles1:04:56
Explore how to create your first workspace in Microsoft Fabric, manage access with admin, member, contributor, and viewer roles, and organize data using domains, lake storage, and experiences.
Hands-On : Create your First Lakehouse | Install OneLake Explorer &Data Studio58:46
Hands-On : Create Your First warehouse in Fabric | | Lakehouse vs Warehouse48:09
Hands-On : Create your First Shortcuts to Lakehouse | Warehouse | Data Lake46:01
Create shortcuts in Microsoft Fabric to access lake house folders, warehouse tables, and data lake storage, pulling live data without copying.

Hands-On : Introduction to Data Factory Experience | Pipelines & Dataflows53:05
Discover the data factory experience in Fabric, focusing on pipelines and data flows, comparing Azure and Fabric, and using copy assistant to load lakehouse data.
Hands-On : End-to-End Scenario with Data Factory Pipelines and Dataflows Gen21:08:05
Create an end-to-end fabric workflow: copy blob data into a lake house via a data factory pipeline, then transform with data flow gen2 into bronze and silver tables.
Hands-On : End-to-End Mini Project : Data Factory Pipelines and Dataflows Gen250:43
Explore end-to-end data factory pipelines and dataflows Gen2: copy New York City taxi data into a lake house, transform to a silver warehouse table, configure notifications, and schedule daily runs.
Hands-On :Copy data from Azure SQL DB to Lakehouse Table | Query | Stored proc41:08
Learn to copy data from Azure SQL database to the Lakehouse using Fabric pipelines, with copy data activity, stored procedures, and parameterized queries.
Hands-On :Copy Multiple tables from Azure SQL DB to Lakehouse dynamically46:11
Learn to copy multiple azure sql db tables to lakehouse with dynamic audit columns—ingestion date, ingestion month/day, source name—using a metadata-driven, lookup and for-each pipeline in fabric.
Hands-On : Moving Multiple Folders from Data Lake Storage Gen2 to Lakehouse40:29
Master moving multiple folders from data lake storage gen2 to lakehouse with source cleanup, using copy, get metadata, for each, and warehouse-stored table config to manage dynamic partitions.
Hands-On : Copy data from REST API to Lakehouse in Fabric using Bearer Token31:04
Copy data from a rest api to the lake house in Microsoft Fabric using dynamically generated bearer token via a web activity, feeding the token to the copy activity.

Hands-On : Ingest Data From On Premise SQL Server to Lakehouse| Data Gateway42:17
Ingest on premise SQL Server data into Microsoft Fabric warehouse with data gateway and Data Flow Gen2. Join employees with departments and add ingestion date, month, day, and source name.
Hands-On : Ingest data from On premise server to fabric| Install Data Gateway48:47
Install and configure the on premise data gateway to load data into the lake house and warehouse, deriving an employee level from salary and joining with department to enrich details.

Hands-On : Ingest data from On premise SQL server to Warehouse Incrementally41:00
Learn incremental ingestion from on-premise SQL Server to a Fabric warehouse using Data Flow Gen2 and a data gateway. Use max transaction date as watermark and schedule daily pipelines.
Hands-On : Copy data from Azure SQL DB to Warehouse using table, query & SP55:29
Learn how to copy data from Azure SQL Database to a warehouse using table, a query, or a stored procedure, then fetch pipeline logs and implement incremental load with pipelines.
Hands-On : Logging Fabric Pipeline Logs to Warehouse table using stored proc52:47
Learn to log fabric pipeline runs to a warehouse table by using a stored procedure that captures run id, execution times, records read/written, and status.
Hands-On Incremental data ingestion from Azure SQL DB to Warehouse in Fabric1:00:29
Learn incremental data ingestion from Azure SQL DB to Fabric warehouse, using a watermark configuration table and a stored procedure to update watermarks, with full vs delta load.
Hands-On : Microsoft Fabric: Multiple table Incremental data load from Azure SQL1:08:47
Learn to implement incremental data ingestion from multiple Azure SQL tables to a Fabric warehouse using a watermark-driven configuration table, for each loops, copy activities, and stored procedures.
20. Hands-On: Filter file using data pipelines in Fabric || Filter Activity47:32
Learn to filter files in Fabric data pipelines by listing source files with get metadata, excluding Australia, and copying the rest to the lake house.

Hands-On: How to run pipeline when dependency job is completed || Event Based41:49
Learn to run a pipeline when two source jobs complete, using an event-based trigger and trigger files to copy data from warehouse to the lake house in Microsoft Fabric.
Hands-On :Combining Excel Files from different data providers 2 Unified Table57:34
Combine Excel files from providers into a unified table using fabric pipelines. Dynamically detect providers and iterate with for each, adding source name, file name, and load date.
Hands-On: Copy data from AWS S3 Storage to Lakehouse using Data Pipelines39:29
Copy data from AWS S3 to a lake house using a dynamic data pipeline that uses get metadata and for each to load folders daily.
Hands-On: Multiple tables Dynamic mapping in Copy Activity using config table45:30
Learn to standardize and load multiple azure sql database tables into a warehouse with fabric pipeline, using dynamic mapping, config table with is_active, and for each loop to apply mappings.
Hands-On: Merge Different Excel data of different sheets to unified table41:07
Merge data from multiple Excel files with different sheet names into a single table in Microsoft Fabric lake house, using index-based sheet selection, dynamic mapping, and for each data provider.

Hands-On: How to handle data pipeline concurrency issue in Microsoft Fabric40:41
Learn how to manage data pipeline concurrency in Microsoft Fabric by using a pipeline process monitor table, run IDs, lookup checks, and conditional script steps to skip overlapping executions.
Hands-On: How to Implement custom pipeline template for reusability |Template46:04
Learn to build a reusable pipeline template in the data ingestion framework for multiple scenarios, like data lake to lake house and ADLs to lake house, using lookup and switch.
Hands-On: Copy data from On premise SQL Server to Lakehouse using pipelines37:38
Copy data from on premise SQL Server to the lakehouse using data pipelines and copy activities. Configure the data gateway, connect to SQL Server, and ingest single and multiple tables.
Hands-On: Copy data from On premise File System to Lakehouse using pipelines38:05
Copy data from on premise file system to the Lakehouse using a data pipeline in Microsoft Fabric, with a data gateway and get metadata to drive for each folder.
Hands-On: Copy data from snowflake to Lakehouse |Snowflake Free Trail Account39:24
Learn to copy data from Snowflake to Lake House and back using Microsoft Fabric's data pipeline and copy activity, including creating a Snowflake free trial and connecting to Lake House.
Fabric Summary and Components41:59
Explore real-world uses of Microsoft Fabric for ingestion, orchestration, and delta lake concepts, with interview-ready guidance on pipelines, notebooks, data flows, and the medallion architecture (bronze, silver, gold).

Requirements

No coding is required, simple UI based learning, you will learn whatever you need here

Description

"This course offers a comprehensive journey through Microsoft Fabric, guiding you from foundational concepts to advanced techniques. You’ll learn how to integrate diverse data sources, leverage powerful analytics tools, and implement robust data governance practices. Through practical exercises and real-world case studies, you’ll gain hands-on experience to optimize data workflows and apply Microsoft Fabric's capabilities effectively in your projects."
"Dive deep into Microsoft Fabric with this practical course designed to take you from basics to mastery. Explore essential data integration methods, advanced analytics techniques, and effective data governance strategies. Engage with real-world scenarios and hands-on exercises to enhance your skills and optimize data workflows, preparing you to leverage Microsoft Fabric’s full potential in your data management and analytics tasks."
"Master Microsoft Fabric with our in-depth course that covers everything from foundational principles to advanced applications. This guide will teach you how to seamlessly integrate data, perform advanced analytics, and manage data governance within Microsoft Fabric. Through practical exercises and real-life case studies, you will develop the skills needed to design efficient data workflows and apply Microsoft Fabric's tools to solve complex data challenges."
"This course provides a practical and thorough exploration of Microsoft Fabric, moving from fundamental concepts to advanced mastery. You will learn how to integrate various data sources, utilize analytics tools for actionable insights, and enforce effective data governance. Hands-on practice and real-world examples will equip you with the skills to optimize data workflows and apply Microsoft Fabric's features to enhance your data management and analytics capabilities."

Who this course is for:

Data Engineers, Data Architects, Data Science and Data Analyst,Anybody who wants to become Data Architect

Microsoft Fabric Deep Dive: Fabric Guide

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 4hr 31min

Development of Data Pipeline and Dataflow Gen27 lectures • 5hr 31min

Data Pipelines which ingest data from On Premise to Cloud2 lectures • 1hr 31min

Incremental data pipelines and pipeline logging and scheduling6 lectures • 5hr 26min

Advanced pipelines like dependency pipelines and dynamic schema and cross cloud5 lectures • 3hr 45min

Pipeline concurrency and Pipeline templates development6 lectures • 4hr 4min

Requirements

Description

Who this course is for: