Microsoft Fabric - Advanced Concepts and Patterns

3 days
UFABD
3 days

Upcoming Sessions

Date:

Format:

Price:

Location:

Book now

Date:

Format:

Price:

Location:

Book now

Date:

Format:

Price:

Location:

Book now

Date:

Format:

Price:

Book now

Need a private training for your team?  Request a private training

Not ready to book yet?   Request an offer

Loading and Cleansing Data

Incremental Data Ingestion with Pipelines

Microsoft Fabric Pipelines support efficient incremental data ingestion. Learn how to detect data changes, process only new or modified data, and build scalable ingestion patterns.

  • Incremental ingestion concepts and use cases
  • Using watermarks and high-water-mark patterns
  • Change detection strategies (timestamps, keys, CDC)
  • Implementing incremental logic in Fabric pipelines
  • Handling late-arriving and updated data
  • LAB: Building an incremental ingestion pipeline

Declarative ETL with Materialized Lake Views

Materialized Lake Views precompute and store complex query results over OneLake data, eliminating the need to re-run expensive transformations on every access. They refresh automatically when the underlying data changes, making curated datasets instantly queryable without extra processing.

  • Materialized Lake Views architecture and storage model
  • Authoring Materialized Lake Views with SQL and Spark
  • Performance and optimization
  • Enforcing data quality
  • Consuming Materialized Lake Views across Fabric workloads
  • Refresh behavior and incremental processing
  • LAB: Setup an ELT with Materialized Lake Views

Syncing Data using Microsoft Fabric Mirroring

Fabric Mirroring enables near real-time replication of data from operational systems into OneLake, allowing analytics workloads to run directly on continuously updated source data without complex ingestion pipelines.

  • What Fabric Mirroring is and when to use it
  • Supported source systems and prerequisites
  • Setting up a mirrored database in Fabric
  • Understanding change data capture (CDC) and latency
  • Accessing mirrored data through Lakehouse and Warehouse endpoints
  • Ingesting external data into OneLake with Open Mirroring

Update your Data from within Power BI

Fabric User Data Functions enable you to encapsulate reusable business logic directly within Microsoft Fabric, supporting translytical task flows that seamlessly combine analytical insights with operational actions across notebooks, pipelines, and Power BI.

  • Overview of User Data Functions and Translytical task flow concepts
  • Creating User Data Functions in Microsoft Fabric
  • Invoking User Data Functions from notebooks and pipelines
  • Using User Data Functions in Power BI to drive translytical actions
  • Triggering User Data Functions with Fabric Activator
  • Invoking User Data Functions via REST services
  • LAB: Building and executing a translytical task flow with User Data Functions

Real-Time Data

Real-Time Analytics in Fabric

Real-Time Analytics is a fully managed big data analytics platform optimized for streaming time-series data. It contains a dedicated query language and engine for searching structured, semi-structured, and unstructured data in close to real-time.

  • Creating an Eventhouse and KQL database
  • Ingesting data into tables
  • Azure Event Hub
  • Working with eventstreams
  • Quering data using Kusto Query Language (KQL)
  • LAB: Working with Real-Time Analytics

Respond to Events with Data Activator

Data Activator in Microsoft Fabric takes action based on what's happening in your data. Learn how to set up conditions against your data and trigger actions like run a Power Automate Flow or send an email when the conditions are met.

  • Creating Objects, Properties and Rules to act on Events
  • Ingesting data from Eventstreams
  • Acting on Power BI Reports

Using DevOps in Fabric

Fabric DevOps: Git Integration

Microsoft Fabric supports seamless Git-based source control through both GitHub and Azure DevOps. Linking a workspace to a repository enables versioning, collaboration, branching strategies, and controlled change management across development teams.

  • Basic concepts in Git integration
  • Connecting workspace to Git repository
  • Committing and pulling changes
  • Working with Git branches in Fabric
  • Managing pull requests

Fabric DevOps: Deployment Pipelines

Microsoft Fabric offers built-in deployment pipelines that streamline the promotion of content across development, test, and production environments. Variable Libraries further simplify configuration management during deployments.

  • Options for deploying resources
  • Setting up deployment pipelines
  • Using deployment rules
  • Working with variable libraries

AI in Microsoft Fabric

Improve AI with Fabric IQ

Fabric IQ brings AI-powered intelligence into Microsoft Fabric by grounding generative AI experiences in your data. Ontologies provide the semantic layer that helps Fabric IQ understand business concepts, relationships, and context, enabling more accurate insights, queries, and Copilot experiences.

  • Overview of Fabric IQ
  • Graph database concepts and query patterns
  • Creating and querying graphs in Microsoft Fabric
  • Ontologies in Fabric IQ
  • Defining business entities, relationships, and metadata
  • Connecting ontologies to Lakehouse and Eventhouse data
  • Using ontologies to improve Copilot queries and insights
  • Best practices for modeling semantic knowledge in Fabric
  • LAB: Creating an ontology and using Fabric IQ to explore data

Fabric Data Agents: Chat with your Data

With a Fabric data agent, your team can ask plain English questions about data stored in Microsoft Fabric. This way, even people without technical expertise in AI or a deep understanding of the data structures can receive precise and context-rich answers.

  • The Purpose of the Fabric Data Agents
  • Creating and Publishing a Fabric Data Agent
  • Interacting with a Fabric Data Agent
  • Fine-tuning the Fabric Data Agent with Instructions and Examples
  • LAB: Data agents in action

As organizations mature in their use of Microsoft Fabric, the challenge shifts. This requires not only technical knowledge, but also the ability to make the right architectural and engineering decisions.

In this advanced course, you will learn how to evolve your Fabric solutions by applying proven patterns for performance, maintainability and reuse. You'll explore more advanced topics and understand how to combine these capabilities into robust end-to-end architectures.

This course is intended for data engineers and analytics professionals who already have hands-on experience with Microsoft Fabric or have completed the Data Engineering with Microsoft Fabric course.

Contact Us
  • Address:
    U2U
    Z.1 Researchpark 110
    1731 Zellik (Brussels)
    BELGIUM
  • Phone: +32 2 466 00 16
  • Email: info@u2u.be
  • Monday - Friday: 9:00 - 17:00
    Saturday - Sunday: Closed
Say Hi
© 2026 U2U All rights reserved.