Guided learning path

Microsoft Fabric

Learn Microsoft Fabric by building

Practical Microsoft Fabric tutorials, architecture guides and production patterns for data engineering with Lakehouses, Warehouses, pipelines, notebooks, semantic models and Power BI—from governance and monitoring to CI/CD.

Core path · 12 steps

Start Here

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

New to Fabric? Follow the steps in order. Already working with Fabric? Jump directly to the phase you need.

  1. Phase 1

    Build the foundation

    Create the workspace, storage and notebook foundation you need to start working with Fabric.

    1. Step 01Getting StartedWorkspaceCreate the Fabric workspace that will hold the rest of the learning path.
    2. Step 02Lakehouse & OneLakeLakehouseCreate a Lakehouse and understand how files and Delta tables live in OneLake.
    3. Step 03NotebooksNotebookCreate and run your first Fabric notebook.
    4. Step 04PySparkExplore dataRead, filter, group and inspect Lakehouse data with PySpark.
  2. Phase 2

    Build the data platform

    Create reliable data structures, SQL serving and orchestration.

    1. Step 05Delta LakeDelta tablesLearn how Delta adds transactions, history and reliable table behavior.
    2. Step 06SQL & WarehouseWarehouseUse T-SQL and understand when a Warehouse is a better fit than a Lakehouse.
    3. Step 07PipelinesPipelinesBuild a hands-on ingestion and orchestration workflow.
  3. Phase 3

    Ship safely

    Version your work and move changes safely through environments.

    1. Step 08GitGitConnect Fabric workspaces to Git and understand what is version controlled.
    2. Step 09CI/CDCI/CDMove Fabric changes through DEV, TEST and PROD safely.
  4. Phase 4

    Operate in production

    Observe, troubleshoot and tune workloads after they reach production.

    1. Step 10ObservabilityLoggingDesign execution logging that lets you trace production runs end to end.
    2. Step 11TroubleshootingDebuggingTroubleshoot failed pipelines and notebooks using a repeatable workflow.
    3. Step 12PerformancePerformanceDiagnose slow Fabric workloads and separate data, code and capacity problems.

Interview prep

Microsoft Fabric Interview Questions

Test your Fabric knowledge with practical questions from fundamentals to production architecture.

20 questions available

Start practicing →

Tutorials by topic

Microsoft Fabric Tutorials

Each group collects the tutorials for one part of the platform, published and planned. Open a group to see every step.

Getting Started3 tutorials
Lakehouse & Notebooks4 tutorials
Medallion Architecture2 tutorials

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

Warehouse2 tutorials
Pipelines4 tutorials
Git & CI/CD4 tutorials
Production Engineering4 tutorials
Performance & Scale7 tutorials
Governance & Security1 tutorial

Design ownership, access, lineage, trust and platform controls for a growing Fabric platform.

Semantic Models1 tutorial

Understand how Gold data becomes a governed analytical model: measures, relationships, Direct Lake and reusable business metrics.

Reporting layer

Power BI Visualization

Turn trusted Fabric data into clear, interactive analytical experiences with Power BI.

Power BI now has its own hub: semantic models, report design, performance and how Power BI fits on Fabric.

Explore Power BI & Data Visualization →↑ Start with the foundation: Semantic Models

Hands-on labs

Build a real Fabric solution, step by step

Guided projects with real screenshots. Start with Lab 01: an end-to-end sales analytics build, from an empty workspace to an orchestrated Gold layer.

Explore the labs →
  1. Lab 01AvailableEnd-to-End Sales Analytics in Microsoft Fabric
  2. Lab 02Coming SoonParameterized Pipelines and Incremental Processing
  3. Lab 03Coming SoonData Quality, Quarantine, and Error Handling
  4. Lab 04Coming SoonMonitoring and Execution Logging

Keep exploring

Related published articles

  • Microsoft FabricTroubleshootingIntermediate

    Debug Fabric Pipelines

    Troubleshoot Microsoft Fabric pipeline failures by isolating the failed activity, separating transient from deterministic errors, validating parameters and identities, and using retries, logging, and controlled reruns safely.

  • Microsoft FabricData EngineeringIntermediate

    Delta Lake Read and Write Patterns

    Read and write Delta tables in Microsoft Fabric safely using append, overwrite, MERGE, partitioning, schema controls, concurrency-aware patterns, and table maintenance.

  • Microsoft FabricArchitectureIntermediate

    Fabric Medallion Architecture

    Design a practical Bronze, Silver, and Gold architecture in Microsoft Fabric with clear data contracts, replayability, incremental processing, quality gates, and serving responsibilities.

  • Microsoft FabricPerformanceIntermediate

    Fabric Notebook Performance

    Troubleshoot and improve Microsoft Fabric notebook performance by separating Spark session startup, data scan, shuffle, skew, driver pressure, concurrency, and write-path bottlenecks.

  • Microsoft FabricPerformanceIntermediate

    Fabric Session Tags

    Use Microsoft Fabric session tags to reuse compatible Spark sessions across notebook activities, reduce startup overhead, and avoid unnecessary session fragmentation.

  • Microsoft FabricQuery LanguageIntermediate

    KQL for Microsoft Fabric Cheat Sheet

    The Kusto Query Language (KQL) a Microsoft Fabric data engineer uses most in Eventhouse and KQL querysets: filter, shape, sort, summarize, time windows with bin(), joins, nulls and dynamic fields, with a SQL-to-KQL mapping and seven practice exercises.

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 →

Microsoft Fabric FAQ

Short answers to common questions, with deeper guides when you are ready.

What is Microsoft Fabric?

Microsoft Fabric is an integrated analytics platform that brings data engineering, data warehousing, data science, real-time analytics and Power BI together over OneLake. Start with the guided learning path →

Is Microsoft Fabric the same as Power BI?

No. Power BI is Fabric’s analytics and reporting experience; Fabric also includes engineering, integration, storage, warehousing, governance and operational capabilities. Explore Power BI in Microsoft Fabric →

What is a Microsoft Fabric Lakehouse?

A Lakehouse combines open file-based storage in OneLake with table and SQL experiences for engineering and analytics workloads. Learn Lakehouse and notebook patterns →

What is Direct Lake?

Direct Lake is a semantic-model storage mode designed to query OneLake data without a traditional import copy while retaining Power BI semantics. Learn about semantic models and Direct Lake →

What is the difference between a Fabric Lakehouse and Warehouse?

A Lakehouse emphasizes open files, Spark and flexible engineering; a Warehouse emphasizes a relational SQL experience. The right choice depends on workload and team needs. Compare the serving patterns →

How should I learn Microsoft Fabric?

Begin with a workspace and notebook, build a small end-to-end flow, then add modeling, governance, monitoring and deployment practices. Build a hands-on Fabric lab →

How does Microsoft Purview work with Fabric?

Fabric supplies native workspace, lineage and protection controls, while Microsoft Purview extends discovery, catalog, classification and compliance across the wider data estate. Explore Fabric governance and Purview →