Last updated June 15, 2026 by Errin O'Connor, Founder & Chief AI Architect, EPC Group
Published 2026-06-15
Five Microsoft Fabric Learning Paths by Role
A defined path for every role on a Fabric team — from Power BI analyst moving into Direct Lake, through Spark engineer building the OneLake medallion, to the tenant admin operating capacity and governance. Each path lists the outcome, the steps, and the time budget so a learner can self-place.
Data Analyst
Power BI analyst · Finance analyst · BI report writer moving into Fabric
Move from Power BI Pro to Fabric-native analytics — Direct Lake semantic models on OneLake, Datamarts, and DP-600 readiness — without re-learning the report-design fundamentals.
5-step analyst track · ~25 hours
- Power BI in Fabric: workspace experiences, OneLake integration, the unified item catalog, and what changes vs Power BI Pro / Premium.
- Direct Lake mode: query Parquet/Delta in OneLake without import or DirectQuery — when Direct Lake wins, when to fall back to import.
- Datamarts and shortcuts: self-service relational stores backed by OneLake, shortcuts to lakehouse/warehouse data, no duplicate ETL per workspace.
- Semantic models on Fabric: shared semantic models, certified vs promoted, RLS / OLS, calculation groups, sensitivity-label inheritance.
- Reports + DP-600 prep: pixel-perfect reports, paginated reports, scorecards, and the Microsoft DP-600 Fabric Analytics Engineer exam outline.
Data Engineer
ETL / ELT engineer · Lakehouse builder · Spark developer
Build a production lakehouse on OneLake — medallion zoning, notebooks, data pipelines, Spark performance tuning — defensible to a regulator and an FP&A analyst on the same day.
Engineer track · ~45 hours
- OneLake + Lakehouse fundamentals: Delta on Parquet, V-Order, shortcuts vs copies, the bronze/silver/gold medallion pattern in Fabric.
- Notebooks and Spark: PySpark, Spark SQL, environments, library management, session vs job, the Fabric runtime release cadence.
- Data Pipelines (ADF-style) and Dataflows Gen2: orchestration, parameterization, copy activity, incremental refresh, scheduling.
- Spark performance: V-Order, partition pruning, Z-Order, autotune, the Spark history server, and capacity-unit accounting per job.
- CI/CD + ALM: Fabric Git integration, deployment pipelines, environment promotion, schema evolution, and rollback patterns.
Data Scientist
ML engineer · Notebook practitioner · Synapse Data Science user
Train, track, and ship ML models inside Fabric — MLflow experiments, registered models, batch + real-time scoring, and the Direct Lake handoff back to analytics.
Data-science track · ~35 hours
- Fabric Data Science experience: notebooks, SemPy, Data Wrangler, and where Synapse Data Science fits inside Fabric workspaces.
- Model training with MLflow: experiments, runs, parameters, metrics, artifacts — and how Fabric auto-logs scikit-learn / PyTorch / TensorFlow.
- Registered models + AutoML: model registry, versioning, staging vs production, AutoML for tabular classification / regression / forecasting.
- Batch + real-time scoring: PREDICT() T-SQL function, batch scoring notebooks, real-time endpoints, and OneLake feature tables.
- Responsible AI + Direct Lake handoff: Responsible AI scorecard, model explainability, lineage back through OneLake to the certified semantic model.
Data Architect
Solution architect · Enterprise data architect · Fabric platform owner
Design a Fabric tenant that survives five years — OneLake medallion topology, domain decomposition, capacity sizing, Snowflake coexistence, and Purview-anchored governance.
Architect track · ~60 hours
- OneLake medallion architecture: bronze / silver / gold zoning, domain-aligned workspaces, shortcuts to ADLS Gen2 / S3 / GCS / Dataverse.
- Domain decomposition: Fabric Domains, domain workspaces, certified items, federated stewardship, and the data-mesh-on-Fabric pattern.
- Capacity sizing: F-SKU vs Premium capacity, smoothing and bursting, capacity-unit accounting, autoscale rules, multi-capacity topology.
- Snowflake coexistence: OneLake shortcuts to Snowflake (or Iceberg), reverse shortcuts, the decision framework for what to migrate vs federate.
- Governance with Purview: Purview Data Map on Fabric, sensitivity labels that travel with lake-data, lineage, and the AI-grounding readiness checklist.
Admin & Governance
Tenant admin · Fabric admin · CoE lead · CISO partner
Operate Fabric as a governed analytics platform — capacity, workspaces, domains, DLP, sensitivity labels, audit logs, and a CoE that scales without sprawl.
Admin track · ~35 hours
- Capacity + admin portal: Fabric admin portal, capacity admins, monitor app, throttling, autoscale, and per-capacity tenant settings.
- Workspace + domain governance: workspace roles, item ownership, certified items, domain admins, the workspace certification gate.
- Sensitivity labels + DLP: Microsoft Purview Information Protection on OneLake, label inheritance, DLP policies for Fabric, export-block on Confidential.
- Audit logs + monitoring: M365 audit log, Fabric Activity Log, capacity metrics, gateway clustering, and the Fabric monitoring hub.
- CoE operating model: 30 / 60 / 90 adoption plan, certification gate, citizen-developer guard-rails, escalation runbooks, value-tracking scorecard.
Free Microsoft Fabric Training Resources (Microsoft + Community)
The free resources EPC Group recommends to clients before any paid training engagement — authored by Microsoft, by the community (Guy in a Cube), or by the Microsoft Reactor program. Curate, don't reinvent.
Microsoft Learn
Microsoft Learn — Microsoft Fabric training modulesFree, structured Microsoft-authored learning paths covering OneLake, Lakehouse, Data Engineering, Data Science, Real-Time Analytics, Data Factory in Fabric, and the DP-600 Fabric Analytics Engineer Associate certification.
Microsoft Docs
Microsoft Fabric official documentationThe canonical Fabric documentation set — architecture, OneLake, Direct Lake, capacity SKUs, security, governance, and per-experience deep dives (Lakehouse, Warehouse, Real-Time, Data Science, Data Factory, Power BI in Fabric).
Microsoft YouTube
Microsoft Fabric official YouTube channel + playlistOfficial Microsoft Fabric YouTube channel — feature launches, FabCon recordings, OneLake / Direct Lake / Real-Time deep dives, and the Microsoft Fabric Reactor live workshops.
Community
Microsoft Fabric Community forumMicrosoft's official community for Fabric (and Power BI) — Q&A, monthly Fabric Update threads, the Ideas portal for feature requests, and the Fabric User Groups directory.
Microsoft Certification
DP-600: Fabric Analytics Engineer Associate certification pathThe flagship Fabric certification — DP-600 — covers OneLake, Lakehouse + Warehouse, semantic models, optimization, security, and the analytics engineer's end-to-end workflow. Free Microsoft Learn study path plus a paid practice assessment.
Microsoft Certification
DP-700: Fabric Data Engineer Associate certification pathThe Fabric Data Engineer companion certification — DP-700 — covers Lakehouse engineering, notebooks, Spark, pipelines, real-time analytics, and the engineer's side of the OneLake medallion architecture.
Community YouTube
Guy in a Cube YouTube channel (Fabric playlists)Adam Saxton and Patrick LeBlanc (Microsoft) publish weekly Fabric + Power BI tips — Direct Lake, OneLake shortcuts, capacity sizing, Copilot in Fabric, and live Q&A. The most-watched Microsoft analytics channel.
Live workshops
Microsoft Reactor — Fabric live workshopsFree live Microsoft-instructor workshops on Fabric, OneLake, Copilot in Fabric, and the Power Platform — hands-on labs included, replays available on the Reactor YouTube channel.
EPC Group's Microsoft Fabric Training Delivery Options
Four formats — picked to match the team size, the timeline, and whether the training is standalone or tied to a Fabric CoE rollout. Every format includes senior-architect feedback.
Self-Paced Certified Fabric Curriculum
On-demand video + lab notebooks + reference lakehouse
Analysts, engineers, and architects ramping into your Fabric tenant · Six modules · ~30 hours
EPC Group's certified self-paced Fabric curriculum mirrors the Microsoft DP-600 (Fabric Analytics Engineer) and DP-700 (Fabric Data Engineer) objectives, layered with our Fortune 100 production patterns — OneLake medallion design, Direct Lake semantic-model tuning, Spark V-Order and capacity-unit accounting, deployment pipelines, and tenant-admin guardrails. Includes a downloadable reference lakehouse, a starter set of notebooks, and a 30-day Q&A channel with a senior Fabric architect.
Learn moreCustom Enterprise Workshops (1-3 day)
On-site or virtual instructor-led, custom-built to your OneLake tenant
Data teams, analyst guilds, CoE cohorts · One to three days · cohort of 8-30
A senior EPC Group architect partners with your team to design a workshop around your real data sources and your real backlog — not a generic AdventureWorksLH walk-through. Outcomes include a working production-grade lakehouse + semantic model, a notebook + pipeline patterns library tuned to your sources, and a recorded session your team keeps. Common variants: OneLake medallion deep dive, Direct Lake performance workshop, Fabric Data Factory at scale, Copilot-in-Fabric grounding readiness, Snowflake → Fabric coexistence workshop.
Learn moreFabric Architecture Certification
Architect-led certification of your highest-value Fabric workloads
Data architects, platform owners, certified-item stewards · Six-week sprint per certified workload
EPC Group's Fabric Architecture Certification is the curriculum + assessment that turns a promoted Fabric workload (lakehouse + semantic model + downstream reports) into a certified one that survives audit, regulator review, and Copilot grounding. Curriculum covers OneLake zoning, shortcut hygiene, Direct Lake fallbacks, RLS / OLS, sensitivity-label inheritance, capacity-unit budgeting, and the certification scorecard. Output: a certification badge in the tenant + a defensible review trail.
Learn moreCenter-of-Excellence Rollout (12-week)
Co-delivered Fabric CoE stand-up program
CIOs, CDOs, Chief Data Architects, CoE Leads · Twelve weeks · executive + practitioner tracks
The 12-week Fabric Center-of-Excellence rollout combines training (for the practitioners) with operating-model design (for the leaders). Practitioner track covers the five role-based learning paths above; leadership track covers tenant + capacity topology, domain decomposition, certification gate, ownership accountability, and the value-tracking scorecard. Capped with a documented CoE operating model, a 30 / 60 / 90 adoption playbook, and the AI-grounding readiness checklist that lets Copilot in Fabric ship safely.
Learn moreMicrosoft Fabric Training Providers Compared — EPC Group vs Catalog Platforms
Where catalog platforms (Pragmatic Works, Coursera, DataCamp) win, and where a senior-architect-led Fabric program is the right call. Honest about each provider's strengths.
| Dimension | EPC Group | Pragmatic Works | Microsoft Learn | Coursera | DataCamp |
|---|---|---|---|---|---|
| Enterprise-customized to your OneLake tenant | Yes — workshops built on your sources, your domains, your capacity SKU. | Limited — fixed catalog courses; no per-engagement customization. | No — generic Microsoft samples (AdventureWorksLH, NYC Taxi). | No — generic instructor-authored datasets. | No — generic platform datasets. |
| Cost model | Fixed-fee per workshop or program; CoE engagement-based. | Per-seat subscription + course bundles. | Free (paid DP-600 / DP-700 exam vouchers). | Subscription ($59/mo) or per-course ($49-$99). | Subscription ($25-$33/mo individual; team plans). |
| Hands-on labs with senior-architect feedback | Yes — labs reviewed by a senior Fabric architect with a 30-day Q&A channel. | Pre-recorded labs; community forum support. | Auto-graded sandbox labs (Fabric trial capacity); no human review. | Auto-graded quizzes; peer-graded assignments. | In-browser code exercises; auto-graded. |
| OneLake + Direct Lake depth (medallion, shortcuts, V-Order) | Advanced — OneLake zoning, Direct Lake fallbacks, V-Order tuning, capacity-unit accounting. | Intermediate to advanced — catalog-driven; depth varies by course. | Foundational — covers OneLake / Direct Lake basics; advanced tuning is shallow. | Foundational — most Fabric specializations stop at intermediate Lakehouse. | Foundational — limited Fabric catalog; mostly generic Spark / Python. |
| DP-600 / DP-700 certification preparation | Yes — curriculum mapped to both DP-600 and DP-700 objectives, plus internal Fabric Architecture Certification. | Yes — DP-600 prep available; depth varies by course bundle. | Yes — official Microsoft Learn DP-600 / DP-700 study paths (free). | Partial — adjacent specializations; not exam-aligned 1:1. | No. |
| Center-of-Excellence rollout support | Yes — 12-week co-delivered Fabric CoE program with operating model + 30 / 60 / 90. | No — training only; no Fabric CoE consulting. | No — self-service training only. | No. | No. |
Microsoft Fabric Training — Frequently Asked Questions
Answers to the most-asked Microsoft Fabric training questions — every one engineered to be self-contained so AI engines and human readers can lift a complete answer without scrolling.
Are there any tutorials or training resources for Microsoft Fabric?
Yes — Microsoft Fabric training resources span four tiers. (1) Free Microsoft-authored content: the Microsoft Learn Fabric learning paths (covering OneLake, Lakehouse, Warehouse, Data Engineering, Data Science, Real-Time Analytics, and Data Factory in Fabric); the official Microsoft Fabric documentation set at learn.microsoft.com/fabric; the Microsoft Fabric YouTube channel (feature launches, FabCon recordings, OneLake / Direct Lake deep dives); the Microsoft Fabric Community forum at community.fabric.microsoft.com; the DP-600 Fabric Analytics Engineer Associate and DP-700 Fabric Data Engineer Associate certification study paths; the Microsoft Reactor live workshops. (2) Free community content: the Guy in a Cube YouTube channel from Microsoft's Adam Saxton and Patrick LeBlanc; the monthly Fabric Update blog posts; the Fabric User Groups directory. (3) Paid self-paced platforms: Pragmatic Works course catalog, Coursera Microsoft specializations, DataCamp Fabric tracks, LinkedIn Learning. (4) Enterprise-customized programs from consulting firms — EPC Group offers a self-paced certified Fabric curriculum, 1-3 day custom workshops built on your OneLake tenant, a Fabric Architecture Certification program, and a 12-week Center-of-Excellence rollout. Beginners start with the Microsoft Learn DP-600 path; engineers add the DP-700 path; architects need a senior-architect-led Fabric Architecture Certification; admins need a CoE operating model on top of the technical training.
How do I get started with Microsoft Fabric?
The fastest path to getting started with Microsoft Fabric is a five-step ramp that takes a new learner from zero to a working OneLake-backed report in roughly one working day. Step 1: sign up for the free Microsoft Fabric trial capacity (60 days) at app.fabric.microsoft.com — no credit card, no Azure tenant required for the trial. Step 2: complete the Microsoft Learn "Get started with Microsoft Fabric" learning path (about three hours) to understand the unified item catalog, workspaces, and OneLake. Step 3: build your first lakehouse — ingest a sample CSV (NYC Taxi is the canonical training dataset), use Dataflows Gen2 or a notebook to land it as Delta into the silver zone. Step 4: create a Direct Lake semantic model on top of the lakehouse, write three or four starter DAX measures, and publish a single-page Power BI report. Step 5: enable Fabric Git integration on the workspace, push the items to a repo, and walk through one promotion via a deployment pipeline. By the end you have a working medallion lakehouse, a Direct Lake semantic model, a report, and a CI/CD path — the same shape you will repeat for production workloads. The best free walkthroughs are the Microsoft Learn Fabric "Get started" path and the Guy in a Cube Fabric playlist on YouTube.
What is the DP-600 certification?
DP-600 is the "Implementing Analytics Solutions Using Microsoft Fabric" exam, which earns the Microsoft Certified: Fabric Analytics Engineer Associate credential. It is Microsoft's flagship Fabric certification and the canonical proof point for analysts and analytics engineers working on the Fabric platform. The exam covers four objective domains: (1) plan, implement, and manage a solution for data analytics (workspaces, capacities, lifecycle management, security); (2) prepare and serve data (ingest into the Lakehouse and Warehouse, transform with notebooks / dataflows / pipelines, optimize for Direct Lake); (3) implement and manage semantic models (modeling, DAX, optimization, RLS / OLS); (4) explore and analyze data (Power BI reports, paginated reports, exploration). The Microsoft Learn study path is free, the practice assessment is paid, and the exam itself is $165 USD. Companion exam: DP-700 (Fabric Data Engineer Associate) — covers the engineer's side of the same platform (Spark, pipelines, real-time analytics). EPC Group's self-paced Fabric curriculum is mapped to both exams and is the most common ramp our enterprise clients use to certify a whole analytics team in a single quarter.
Is Microsoft Fabric replacing Synapse?
Functionally yes for new analytics workloads, but with a managed coexistence period rather than a hard cutover. Microsoft Fabric is the successor platform that unifies what used to be Azure Synapse Analytics, Power BI Premium, Azure Data Factory, and Azure Data Explorer under one SaaS surface with OneLake as the shared storage layer. As of mid-2026, Microsoft is actively guiding new builds to Fabric — Synapse Dedicated SQL Pools remain available for existing customers, Synapse Serverless SQL is folded into the Fabric Warehouse experience, Synapse Spark pools are replaced by Fabric Spark runtimes, and Azure Data Factory pipelines have a Fabric equivalent (Data Factory in Fabric). Existing Synapse workspaces continue to run; new Synapse workspace creation is being phased out in favor of Fabric. The right migration pattern for most enterprises is incremental: leave production Synapse workloads in place, build all new analytics on Fabric, use OneLake shortcuts to federate against Synapse SQL Pool / ADLS Gen2, and migrate workload-by-workload as natural refresh cycles allow. EPC Group publishes the Synapse-to-Fabric coexistence playbook and the per-workload decision framework — what to migrate, what to federate, what to retire.
What is OneLake?
OneLake is the single, tenant-wide data lake built into Microsoft Fabric — Microsoft's answer to "OneDrive for data." Every Fabric tenant gets exactly one OneLake; every Fabric item (lakehouse, warehouse, KQL database, semantic model, ML model) stores its data in OneLake under a hierarchical workspace + item namespace. OneLake is built on Azure Data Lake Storage Gen2, uses Delta-Parquet as the canonical storage format, and exposes data via three access patterns: (1) native Fabric experiences (Lakehouse, Warehouse, Power BI Direct Lake, notebooks); (2) OneLake shortcuts — virtualized pointers to data living in ADLS Gen2, Amazon S3, Google Cloud Storage, Dataverse, or another OneLake; (3) external readers — any tool that speaks ADLS Gen2 or the Delta protocol (Databricks, Snowflake via Iceberg, Trino) can read OneLake without copying. The defining design property: OneLake eliminates duplicate copies of the same dataset for analytics, BI, ML, and real-time use cases. EPC Group's OneLake medallion reference architecture — bronze / silver / gold zoning, domain-aligned workspaces, shortcut hygiene, and sensitivity-label inheritance — is the most-used pattern in our Fabric engagements.
How long does Fabric training take?
Fabric training time depends on the target role and the starting point. A Power BI analyst moving to the Fabric Analytics Engineer role typically needs 25 to 40 hours of study to be DP-600 ready (Microsoft Learn study path + practice labs + a mock exam). A data engineer ramping into Fabric (assuming existing Spark / ADF experience) typically needs 35 to 50 hours for DP-700 readiness — Lakehouse engineering, Fabric Spark runtimes, Data Factory in Fabric, real-time analytics. A data architect designing a Fabric tenant typically needs 60 to 80 hours including OneLake medallion design, capacity sizing, Snowflake coexistence, and Purview-anchored governance. A tenant admin / CoE lead typically needs 30 to 40 hours for the admin track plus separate operating-model design work. EPC Group's typical enterprise rollout calendarizes this as: self-paced curriculum kickoff (week 1), DP-600 readiness milestone (week 4), DP-700 readiness milestone (week 6), 1-3 day custom workshop (week 8), Fabric Architecture Certification sprint (weeks 9-14). The 12-week Fabric CoE rollout overlays training onto operating-model design so the team can ship governed workloads on the other side, not just pass exams.
Can EPC Group train our team on Fabric?
Yes — Fabric training is one of EPC Group's core delivery formats. We offer four formats, mapped to team size and outcome. (1) Self-paced certified Fabric curriculum (~30 hours over six modules) mapped to DP-600 and DP-700, delivered as on-demand video plus a downloadable reference lakehouse and a 30-day senior-architect Q&A channel — best for individual analysts and small teams. (2) Custom enterprise workshops (1-3 days, cohort of 8-30) designed around your actual OneLake tenant, your sources, and your backlog — common variants are OneLake medallion deep dive, Direct Lake performance workshop, Fabric Data Factory at scale, Copilot-in-Fabric grounding readiness, and Snowflake → Fabric coexistence. (3) Fabric Architecture Certification — a six-week per-workload sprint that certifies a Fabric workload (lakehouse + semantic model + downstream reports) for audit and Copilot grounding, output is a certification badge in the tenant plus a defensible review trail. (4) 12-week Center-of-Excellence rollout — combines all of the above with operating-model design for CIOs, CDOs, and Chief Data Architects. Every format includes senior-architect feedback (no junior delivery), and every format ties to a measurable outcome — certified workload, capped capacity, audited tenant — not just attendance hours.
How much does Fabric consulting + training cost?
Fabric consulting and training pricing has four typical tiers. (1) Self-paced certified Fabric curriculum: fixed per-seat fee covering ~30 hours of video, the reference lakehouse, and a 30-day senior-architect Q&A channel — the cheapest option and the one most clients start with for the analyst guild. (2) Custom enterprise workshops (1-3 days): fixed-fee per workshop based on duration and cohort size, includes pre-engagement scoping, a working production-grade lakehouse + semantic model built during the workshop, and recorded sessions. (3) Fabric Architecture Certification: fixed-fee per certified workload (six-week sprint), priced by workload complexity (single-domain vs multi-domain, single-capacity vs multi-capacity, regulated vs non-regulated). (4) 12-week Center-of-Excellence rollout: fixed-fee engagement priced by tenant footprint and number of practitioner cohorts, includes operating-model design, the 30 / 60 / 90 adoption playbook, and the AI-grounding readiness checklist. EPC Group publishes pricing on a per-engagement scoping call rather than a public rate card because real Fabric pricing depends on tenant footprint, capacity SKU mix, and regulatory posture — the same engagement scoped at $50K for a non-regulated mid-market client may scope at $250K for a HIPAA-regulated multi-domain Fortune 500 build. Book a scoping call for a fixed-fee proposal in five business days.
Continue in the EPC Group Microsoft Fabric Knowledge Base
Adjacent hubs, frameworks, and reference pages on the canonical Microsoft Fabric consulting practice.
Talk to a senior Microsoft Fabric architect about your training program.
Multiple models. One truth.
