Guided learning path

Microsoft Fabric

Learn Microsoft Fabric by building

Start with a workspace and your first notebook, then progress through Lakehouses, Delta tables, Warehouses, Git, CI/CD and production-scale engineering.

01—12

Start Here

Follow the core path from an empty workspace to a production-ready data workflow.

  1. 01Workspace
  2. 02Lakehouse
  3. 03Notebook
  4. 04Explore data
  5. 05Delta tables
  6. 06Warehouse
  7. 07Pipelines
  8. 08Git
  9. 09CI/CD
  10. 10Logging
  11. 11Debugging
  12. 12Performance
Getting Started2 tutorials
  1. Getting Started

    What Is Microsoft Fabric? A Practical Overview

    Understand how OneLake, workspaces, Lakehouses, Warehouses, notebooks, pipelines, SQL endpoints and semantic models fit together.

    BeginnerFabric Foundations

    Planned · View in editorial roadmap →
  2. Getting Started

    Create Your First Microsoft Fabric Workspace

    Create a development workspace with sensible capacity, access and ownership decisions from the start.

    BeginnerFabric Start Here

    Planned · View in editorial roadmap →
Lakehouse & Notebooks5 tutorials
  1. Your First Data

    Create Your First Fabric Lakehouse

    Build a Lakehouse and understand its Files, Tables and SQL analytics endpoint surfaces.

    BeginnerFabric Lakehouse

    Planned · View in editorial roadmap →
  2. Play with Data

    Explore Data with PySpark in Microsoft Fabric

    Practice the DataFrame operations used to explore and shape data in Fabric notebooks.

    BeginnerFabric Notebooks

    Planned · View in editorial roadmap →
Medallion Architecture10 tutorials

Learn how to structure raw, conformed and serving data layers without over-engineering the platform.

  1. Foundations

    Medallion Architecture Explained: Bronze, Silver and Gold

    What the Bronze, Silver and Gold layers are for, how data quality and incremental processing work across them in Microsoft Fabric, and when fewer layers are the better design.

    BeginnerFabric Medallion Architecture11 min read

    Read tutorial →
  2. Foundations

    When You Should NOT Use All Three Medallion Layers

    A critical look at the Medallion pattern: when two layers or a single curated model are enough, and the cost that each unnecessary layer adds.

    IntermediateFabric Medallion Architecture

    Planned · View in editorial roadmap →
  3. Layer design

    Designing a Bronze Layer in Microsoft Fabric

    How to design a Bronze layer that preserves source fidelity: landing formats, ingestion metadata, schema drift, retention and replay.

    IntermediateFabric Medallion Architecture

    Planned · View in editorial roadmap →
  4. Layer design

    Designing a Silver Layer for Clean and Conformed Data

    How to turn source-shaped Bronze data into clean, validated, conformed Silver entities that several consumers can share.

    IntermediateFabric Medallion Architecture

    Planned · View in editorial roadmap →
  5. Layer design

    Designing a Gold Layer for Reporting and APIs

    How to design the Gold layer that reports, semantic models and APIs consume: modelling choices, stable contracts, serving engines and how to change it without breaking consumers.

    IntermediateFabric Medallion Architecture

    Planned · View in editorial roadmap →
  6. Engineering patterns

    Incremental Processing Across Bronze, Silver and Gold

    How changes propagate from Bronze to Silver to Gold without full reloads: change detection between layers, affected keys and recomputing only impacted aggregates.

    AdvancedFabric Medallion Architecture

    Planned · View in editorial roadmap →
  7. Engineering patterns

    Delta MERGE Patterns in a Medallion Architecture

    Which write pattern belongs in which layer: append in Bronze, MERGE for Silver entities and history, and targeted overwrite or MERGE for Gold.

    AdvancedFabric Medallion Architecture

    Planned · View in editorial roadmap →
  8. Engineering patterns

    Partitioning Strategies Across Medallion Layers

    Why the right partitioning often differs by layer, from load-date partitions in Bronze to unpartitioned Gold tables, and how to decide.

    AdvancedFabric Medallion Architecture

    Planned · View in editorial roadmap →
  9. Engineering patterns

    Small Files and Compaction in Medallion Architectures

    Where small files come from in each layer and how to plan OPTIMIZE, V-Order and VACUUM per layer instead of applying one schedule everywhere.

    IntermediateFabric Medallion Architecture

    Planned · View in editorial roadmap →
  10. Capstone

    Building an End-to-End Fabric Medallion Pipeline

    A complete, production-minded Medallion pipeline in Fabric: incremental ingestion, quality gates, MERGE, maintenance, logging and deployment. It builds on the first end-to-end pipeline tutorial.

    AdvancedFabric Medallion Architecture

    Planned · View in editorial roadmap →
Warehouse1 tutorials
  1. Lakehouse & Warehouse

    Lakehouse vs Warehouse in Microsoft Fabric: How I Decide

    The criteria I use to choose between a Fabric Lakehouse and a Fabric Warehouse: team skills, write patterns, T-SQL needs and governance.

    IntermediateFabric Warehouse

    Planned · View in editorial roadmap →
Pipelines2 tutorials
  1. Build with Data

    Build Your First End-to-End Fabric Pipeline

    Move CSV or Parquet through a notebook-driven Bronze, Silver and Gold flow into a queryable serving layer.

    IntermediateFabric Pipelines

    Planned · View in editorial roadmap →
  2. Parameterized Notebooks

    Make Your Fabric Notebook Reusable with Parameters

    Pass dates and business identifiers from a pipeline into one reusable Fabric notebook.

    IntermediateFabric Pipelines

    Planned · View in editorial roadmap →
Git & CI/CD5 tutorials
  1. Getting Started

    Connect Microsoft Fabric to Git

    Connect a Fabric workspace to a repository and understand branches, synchronization, versioned artifacts and current limitations.

    BeginnerFabric Start Here

    Planned · View in editorial roadmap →
  2. Git & CI/CD

    Git Integration in Microsoft Fabric

    Use Fabric Git integration deliberately across branches, workspace artifacts and team workflows.

    IntermediateFabric Git & CI/CD

    Planned · View in editorial roadmap →
  3. Git & CI/CD

    Designing Dev, Test and Production Deployments for Fabric

    How to promote Fabric items between environments: configuration per environment, data separation, approvals and rollback.

    IntermediateFabric Git & CI/CD

    Planned · View in editorial roadmap →
  4. Git & CI/CD

    CI/CD for Microsoft Fabric: A Practical Deployment Strategy

    A practical deployment approach for Fabric items using Git integration, deployment pipelines and automation, including what still needs manual steps.

    IntermediateFabric Git & CI/CD

    Planned · View in editorial roadmap →
  5. Git & CI/CD

    What Actually Gets Deployed in Fabric?

    Separate deployable workspace artifacts from data, connections and environment-specific configuration.

    IntermediateFabric Git & CI/CD

    Planned · View in editorial roadmap →
Production Engineering3 tutorials
  1. Production Engineering

    Logging Your Fabric Notebooks Properly

    Design an execution log that makes notebook and pipeline runs traceable in production.

    IntermediateFabric Production Engineering

    Planned · View in editorial roadmap →
  2. Production Engineering

    Debugging Fabric Notebooks and Pipelines

    Use a repeatable workflow to diagnose Spark, schema, parameter, dependency and pipeline failures.

    IntermediateFabric Production Engineering

    Planned · View in editorial roadmap →
  3. Performance & Scale

    Incremental Loads in Microsoft Fabric Without Reprocessing Everything

    Patterns for loading only new and changed data into Fabric, with watermarks, change tracking and Delta MERGE, and how to handle late or corrected data.

    IntermediateFabric Production Engineering

    Planned · View in editorial roadmap →
Performance & Scale7 tutorials
  1. Performance & Scale

    Working with Millions of Rows in Microsoft Fabric

    Build a practical baseline for file layout, Spark execution and Delta writes at multi-million-row scale.

    IntermediateFabric Performance at Scale

    Planned · View in editorial roadmap →
  2. Performance & Scale

    Working with Billions of Rows in Microsoft Fabric

    Plan storage, partitioning, incremental processing and capacity for billion-row Fabric workloads.

    AdvancedFabric Performance at Scale

    Planned · View in editorial roadmap →
  3. Performance & Scale

    Choosing a Good Partition Column for Delta Lake

    Criteria for choosing a partition column: cardinality, query filters, write patterns and data volume per partition.

    IntermediateFabric Performance at Scale

    Planned · View in editorial roadmap →
  4. Performance & Scale

    Choosing the Right Parquet File Size

    How file size affects read parallelism, metadata overhead and write cost, and how to pick a target size for your engines.

    IntermediateFabric Performance at Scale

    Planned · View in editorial roadmap →
  5. Performance & Scale

    MERGE into Delta Tables: Performance Patterns That Matter

    How Delta MERGE works internally and the patterns that keep it fast: narrowing the target, partition and file pruning, and source deduplication.

    AdvancedFabric Performance at Scale

    Planned · View in editorial roadmap →
  6. Performance & Scale

    Small Files in Delta Lake: Why They Hurt Performance

    Where small files come from in Delta tables, how they slow down reads, writes and the transaction log, and how to measure the problem.

    IntermediateFabric Performance at Scale

    Planned · View in editorial roadmap →
  7. Performance & Scale

    Fabric Performance Troubleshooting: A Practical Workflow

    A step-by-step workflow for slow Fabric workloads: deciding whether the problem is capacity, Spark, SQL, storage layout or the query itself.

    AdvancedFabric Performance at Scale

    Planned · View in editorial roadmap →

Certification

Prepare for Microsoft Fabric certification

Connect the official DP-600 or DP-700 skills outline to hands-on Fabric projects, troubleshooting, and production practice.

Explore certifications →

Related planned learning →