VNode ITeSBook

Enterprise Program Brief

Microsoft Fabric Engineering Foundations

Build an operational analytics foundation in Microsoft Fabric. Proposed instructor-led duration; delivery subject to environment and lab validation.

VNode ITeSFoundation
Download Program Brief (PDF)

Program Snapshot

Engagement scoped to cohort

Duration40 hours
FormatPrivate cohort
LevelFoundation
Course CodeF06
  • MCT-led delivery
  • Private cohort / virtual ILT
  • Typical response: 1 business day
Scoping call typically scheduled within one business day

VNode ITeS delivers Microsoft Fabric Engineering Foundations as an MCT-led VNode ITeS program for Data engineers, Analytics engineers. Typical duration is 40 hours (Private cohort). Delivery stays scoped to how your teams will actually use the platform after the room empties. Private cohorts can shift emphasis by role mix, workspace or repo constraints, and rollout timing.

Audience Profile

Built for these roles

Data engineers, Analytics engineers

  • Tailored Team Delivery

Overview

Executive overview

Build an operational analytics foundation in Microsoft Fabric.

Environment and licensing

Fabric capacity and isolated workspace Author and consumer personas Source files and notebook runtime Data-agent labs: paid F2+ or qualifying P1+ capacity, tenant AI settings and source access as documented; cohort capacity sized separately Delivery depends on environment and lab validation. This outline does not include step-by-step lab instructions.

Prerequisites

  • SQL and data engineering fundamentals
  • SQL and Data Engineering Foundations, or equivalent demonstrable experience

Program Outcomes

Capabilities your teams will gain

  • Demonstrate the source-to-semantic-model analytics workflow
  • Reconcile metrics and diagnose an injected refresh failure
  • Prove intended access for separate author and consumer personas
  • Document workspace design, refresh ownership and capacity assumptions

Enterprise Delivery

Private cohort delivery

VNode-designed, vendor-aligned instructor-led program. Scope role mix, delivery format, and rollout goals for your cohort.

Curriculum

Curriculum roadmap

Proposed instructor-led duration; delivery subject to environment and lab validation.

  • Fabric architecture and OneLake
  • Ingestion and orchestration
  • Transformation and quality
  • Consumption and security
  • Operations and integrated assessment
1

Module 1 · 8 hours

Fabric architecture and OneLake

+

Create a workspace design and load supplied data into the selected analytical store.

Capacity and workspaces

  • Explain capacity, workspace and item boundaries
  • Identify author and consumer responsibilities

Lakehouse versus warehouse

  • Choose lakehouse versus warehouse for a concrete workload
  • Compare SQL-first and notebook-oriented processing

OneLake

  • Explain OneLake storage and logical access
  • Distinguish shortcuts from copied data conceptually

Item ownership

  • Create a small analytical landing zone
  • Record source formats and ownership

Concept and design 4h · applied exercise 3h · review 1h. Included within module duration; no extra hours. Refine during delivery planning without silently changing published course hours.

Applied exercise: Fabric architecture and OneLake

Create a workspace design and load supplied data into the selected analytical store.

Expected output. Workspace architecture and first load

Acceptance. The selected storage design is justified and the first load is queryable.

2

Module 2 · 8 hours

Ingestion and orchestration

+

Create a parameterised data ingestion pipeline with error handling.

Pipelines

  • Select supported sources and connection authentication
  • Identify gateway or network dependencies

Supported connectors

  • Parameterise file paths, dates and destinations
  • Design reusable ingestion activities

Parameters

  • Track incremental progress and rerun conditions
  • Reconcile source and destination record counts

Incremental-load concepts

  • Capture errors without exposing credentials
  • Document retry and recovery decisions

Concept and design 4h · applied exercise 3h · review 1h. Included within module duration; no extra hours. Refine during delivery planning without silently changing published course hours.

Applied exercise: Ingestion and orchestration

Create a parameterised data ingestion pipeline with error handling.

Expected output. Repeatable ingestion pipeline

Acceptance. The pipeline reruns safely and identifies a deliberately failed source operation.

3

Module 3 · 8 hours

Transformation and quality

+

Transform raw data into validated analytical tables using SQL-first examples.

SQL transformations

  • Separate raw, validated and curated datasets
  • Use SQL transformations at an explicit grain

Notebook concepts

  • Explain where notebooks add value
  • Distinguish SQL and Spark execution responsibilities

Delta table concepts

  • Describe transactional table and schema behaviour
  • Prevent malformed rows from entering curated outputs

Quality and reconciliation

  • Measure completeness and reconciliation
  • Document quality exceptions and remediation ownership

Concept and design 4h · applied exercise 3h · review 1h. Included within module duration; no extra hours. Refine during delivery planning without silently changing published course hours.

Applied exercise: Transformation and quality

Transform raw data into validated analytical tables using SQL-first examples.

Expected output. Validated analytical tables

Acceptance. Curated outputs pass the agreed quality checks and reconcile to accepted source records.

4

Module 4 · 8 hours

Consumption and security

+

Build a small semantic model and test two consumer personas.

Semantic model fundamentals

  • Map business questions to semantic model entities
  • Define measures with clear aggregation meaning

Measures

  • Validate metrics against direct SQL reference queries
  • Identify ambiguous relationships and totals

Workspace and item permissions

  • Separate workspace roles from item/data permissions
  • Test consumer access through the actual query surface

Lineage

  • Inspect available source-to-consumption lineage
  • Assign ownership to the published analytical product

Concept and design 4h · applied exercise 3h · review 1h. Included within module duration; no extra hours. Refine during delivery planning without silently changing published course hours.

Applied exercise: Consumption and security

Build a small semantic model and test two consumer personas.

Expected output. Semantic model and access evidence

Acceptance. Two personas see the intended data and agreed metrics match reference queries.

5

Module 5 · 8 hours

Operations and integrated assessment

+

Demonstrate source-to-report processing and diagnose a failed refresh.

Refresh orchestration

  • Orchestrate ingestion, transformation and refresh dependencies
  • Identify failed and incomplete refreshes

Monitoring

  • Inspect run history and relevant diagnostic evidence
  • Differentiate data errors from capacity or connection failures

Capacity awareness

  • Identify concurrency and capacity pressure conceptually
  • Schedule cleanup and retention for training items

Cleanup and handover

  • Record deployment/configuration assumptions
  • Demonstrate a full run and operational handover

Concept and design 2h · applied exercise 4h · review 2h. Included within module duration; no extra hours. Refine during delivery planning without silently changing published course hours.

Capstone: Operations and integrated assessment

Demonstrate source-to-report processing and diagnose a failed refresh.

Expected output. Assessed Fabric analytics solution

Acceptance. A failed refresh is diagnosed and the complete source-to-report flow is demonstrated.

Capstone

Demonstrate source-to-report processing and diagnose a failed refresh. Assessed Fabric analytics solution Evidence of relevant access, quality and risk controls Demonstration and limitations record

Assessment

Scenario-based practical assessment Demonstrate the source-to-semantic-model analytics workflow 30% Reconcile metrics and diagnose an injected refresh failure 25% Prove intended access for separate author and consumer personas 25% Document workspace design, refresh ownership and capacity assumptions 20% Proposed VNode outline-level assessment; no vendor accreditation or completed lab validation implied.

Participant deliverables

  • Assessed Fabric analytics solution
  • Evidence of relevant access, quality and risk controls
  • Demonstration and limitations record

Scope boundaries

Step-by-step lab instructions; Runnable solution code; Packaged source datasets; Executed environment validation

Delivery options

Count teaching hours, not calendar days. Exclude breaks. Split into 4-hour or 8-hour teaching sessions; schedule complex project work in contiguous blocks.

Delivery Models

Delivery models

Virtual ILTOnsiteHybridExecutive WorkshopBootcampWeekend

Engagement Fit

Engagement fit

  • Private cohort delivery
  • Foundation practitioner depth
  • Business outcome alignment

Enterprise Customization

Enterprise customization

Tailor this program to your organization's priorities: Build an operational analytics foundation in Microsoft Fabric.

  • Private cohort scheduling
  • Equivalent-experience entry review

Resources

Program resources

Yes. Most enterprise clients prefer private delivery scoped to role mix, timezone, and rollout timeline. We align lab environments and scenarios to your tenant context where applicable.

Enterprise Proof

Trusted delivery outcomes

“The Microsoft Fabric implementation program gave our data engineering team a structured path from legacy pipelines to a modern lakehouse architecture.”

Head of Data Engineering

Global Financial Services Firm

Financial Services
“We needed a partner who understood both the technical depth of Azure OpenAI and the governance requirements of an enterprise.”

VP of Technology

Large Healthcare Organization

Healthcare

Delivery Capability

Enterprise-grade instruction

View delivery capability profile

MCT-led delivery

Programs led by Microsoft Certified Trainer practitioners

Enterprise program oversight

Founder-led specialist delivery with structured rollout planning

Global delivery

APAC · EMEA · Americas · Virtual & Onsite

Implementation-focused

Hands-on labs aligned to production scenarios

Kriya AI