Architecting Intelligence: Fabric IQ, Data Agents, and MCP
Published by O'Reilly Media, Inc.
Build, govern, and automate your data platform
What you’ll learn and how you can apply it
- Develop AI-accelerated data pipelines, data transformations, and Power BI reports using Copilot in Microsoft Fabric
- Operationalize models and workflows by integrating a Fabric data agent into organizational data flows for automated decision-making and continuous analytics
- Design and implement a governed semantic layer using Fabric IQ and ontology to ensure data concepts are consistent and machine-readable across the organization
- Use Model Context Protocol (MCP) servers to configure and manage various Fabric workloads, including Power BI semantic models
Course description
Tired of complex, custom coding and juggling siloed tools just to build an AI-powered data product? This intensive, beginner-level course unlocks the power of Microsoft Fabric's integrated intelligence, showing you how to build a unified, automated, and conversationally driven data platform. Nikola Ilic cuts through the complexity, focusing on features like Copilot and Fabric data agents, demonstrating how to transition from traditional pipelines to a workflow where AI assists development, accelerates analysis, and governs data semantics.
You’ll learn how to define the semantic backbone of your organization using Fabric IQ and ontology, ensuring that every AI response and dashboard speaks the same governed business language. Plus, you’ll examine MCP and its role in streamlining the process of semantic model creation simply by asking the system what you need. Become an AI-first professional and lead your organization's transition to a truly future-proof, self-optimizing data platform.
This live event is for you because...
- You’re a data analyst, data engineer, or data architect who needs to accelerate your insights by using natural language queries to interact with data.
- You work with Microsoft Fabric on a regular basis.
- You want to become a successful AI practitioner and leverage the latest Fabric features and capabilities to build future-proof analytics solutions.
Prerequisites
- Intermediate familiarity with Power BI and data modeling concepts (star schemas, DAX basics, and the process of connecting Power BI Desktop to various data sources)
- Ability to read and write simple SQL queries (e.g., SELECT, WHERE, JOIN)
- Basic experience with Microsoft Fabric components (lakehouse, warehouse, Real-Time Intelligence, etc.)
Recommended follow-up:
- Take How to Create AI Agents Like a Pro (live online course with Tim Warner)
- Take AI Agents A-Z (live online course with Sinan Ozdemir)
- Take AI Agents at Work (live online course with Shaun Wassell)
Schedule
The time frames are only estimates and may vary according to how the class is progressing.
Introduction and Fabric vision (10 minutes)
- Presentation: Introduction to Microsoft Fabric as a unified platform for data and AI
Copilot—the AI-accelerated developer (40 minutes)
- Presentation: Introduction to Fabric Copilot; understanding Copilot for Data Factory, data engineering, Power BI, and DAX
- Demo: Using Copilots to accomplish various tasks
- Q&A
Fabric data agent—the AI orchestrator (45 minutes)
- Presentation: Defining the data agent as a reusable, execution layer for models and custom logic; core use cases (automated scoring, anomaly detection, and real-time intervention in data streams); creating and deploying an agent; configuring data agents; consuming Fabric data agents
- Demo: Building and configuring Fabric data agent
- Q&A
- Break
Fabric IQ and ontology—the AI brain (45 minutes)
- Presentation: Introduction to Fabric IQ; introduction to ontology
- Demo: Building an ontology from Power BI semantic model
- Q&A
- Break
Integrating MCP workloads (30 minutes)
- Presentation: Introduction to Model Context Protocol; integrating MCP in Fabric workloads; understanding Fabric MCP server and Power BI Modeling MCP server
- Demo: Connecting and using Power BI Modeling MCP server
Wrap-up and Q&A (10 minutes)
Your Instructor
Nikola Ilic
Nikola Ilic is known as “Data Mozart,” because he’s making music from the data! He works as an independent data platform consultant and trainer focusing on Microsoft technologies. For his exceptional contributions to the tech community, Nikola was awarded a Microsoft Data Platform MVP. He’s also a Microsoft Certified Trainer, blogger, public speaker, mentor, and author of many online courses. He’s interested in everything related to data and is always eager to extract valuable info from raw data most effectively.