Microsoft Fabric Data Engineering-Lakehouse/Warehouse/ETL

Data doesn't move itself. Behind every dashboard, every report, and every business decision is a pipeline that extracts, transforms, and loads data reliably from source to destination. This course teaches you how to build one — end to end — using Microsoft Fabric's complete data engineering stack: Lakehouses, Data Warehouses, ETL pipelines, Mirroring, OneLake Shortcuts, and AI-powered Power BI reporting.

This is not a theory course. Every section is hands-on, and by the time you finish, you will have built a fully functional, production-ready analytics platform from scratch.

What you will build:

• A fully configured Microsoft Fabric workspace with Lakehouse and Data Warehouse

• A secure gateway connection between an on-premises SQL Server instance and Microsoft Fabric

• A Medallion Architecture pipeline — Bronze ingestion, Silver transformation via Dataflows Gen2, Gold dimensional warehouse

• T-SQL views and stored procedures powering a clean, query-ready Gold layer

• A live Power BI DirectQuery report connected directly to the Fabric Data Warehouse

• An automated Data Factory pipeline scheduling Gold layer refreshes

• A mirrored SQL Server 2022 database flowing live into Microsoft Fabric OneLake via Change Data Capture

• OneLake Shortcuts that expose external data inside the Lakehouse without copying or moving it

• A Power BI report enriched with AI visuals — Key Influencers, Decomposition Tree, and Smart Narrative

What makes this course different:

Most Fabric courses show you how to connect tools. This course shows you how to engineer solutions.

You will understand why Lakehouses exist alongside Data Warehouses, when to use each, and how to build reliable pipelines that move data between them at scale. You will implement idempotency — the property that makes a pipeline safe to run multiple times without duplicating or corrupting data — because that is what production environments actually require.

You will go beyond pipelines into Mirroring — one of Fabric's most powerful and underused features — replicating a live SQL Server database into OneLake using Change Data Capture, with no manual exports or scheduled loads required. You will then use OneLake Shortcuts to surface that mirrored data inside your Lakehouse without any duplication.

And you will finish by building Power BI AI visuals that give business users the ability to explore what drives their metrics — not just what the numbers are.

What you will learn:

You will start from the ground up — setting up your Azure account, configuring Microsoft Entra ID, installing SQL Server 2022 and 2025, and restoring real sample databases (AdventureWorks2022 and WideWorldImporters). You will then build ETL workflows that transform raw data through Lakehouse layers and load it into the Data Warehouse. You will work with Delta tables, Dataflows Gen2, OneLake storage, Mirroring, and Fabric's unified compute engine.

By the time you complete the course, your environment mirrors what a data engineering team would build and maintain in a professional setting.

Why Microsoft Fabric now?

Microsoft Fabric is one of the fastest-growing platforms in enterprise analytics. Organisations are actively migrating from legacy tools including Azure Synapse Analytics, and demand for professionals who can work with Fabric Lakehouses, Data Warehouses, Mirroring, and ETL pipelines is rising sharply. The skills you build in this course — from engineering production pipelines to configuring real-time data replication — are directly transferable to data engineering roles in the current job market.

No prior Fabric or data engineering experience is required. A basic understanding of databases — tables, rows, and columns — is all you need to get started. Everything else is built from the ground up inside the course