This course explores how to work smarter with Copilot in Microsoft Fabric. Learn how to integrate, transform, store data, and create insightful reports using Copilot in Microsoft Fabric.

Audience Profile

This course is for data analysts and data engineers who are familiar with basic data concepts and terminology. People taking this course should already have a basic understanding of Microsoft Fabric and Power BI.

Course Modules

Introduction to Copilot in Microsoft Fabric

Accelerate analytics with Copilot in Microsoft Fabric—learn how AI-assisted experiences streamline integration, engineering, warehousing, BI, real-time intelligence, SQL, and data agents to turn data into insights.

• Introduction
• Understand Copilot for Microsoft Fabric Data Factory
• Understand Copilot for Data Engineering and Data Science
• Understand Copilot for Data Warehouse
• Understand Copilot in Power BI
• Understand Copilot for Real-Time Intelligence
• Understand Copilot for SQL Database Workload
• Understand Microsoft Fabric data agents
• Module assessment
• Summary

Get started with Copilot in Microsoft Fabric for data engineering

Accelerate data engineering in Fabric with Copilot—apply AI prompts to ingest, transform, orchestrate, and explain dataflows, pipelines, and Spark code.

• Introduction
• Use Copilot with Microsoft Fabric Dataflow Gen2
• Exercise - Work smarter with Copilot in Microsoft Fabric Dataflow Gen2
• Use Copilot with Microsoft Fabric data pipelines
• Use Copilot in Microsoft Fabric notebooks
• Exercise - Analyze data with Apache Spark and Copilot in Microsoft Fabric notebooks
• Module assessment
• Summary

Get started with Copilot in Microsoft Fabric for Data Warehouse

Accelerate warehouse analytics with Copilot in Fabric—use AI chat, inline completions, and quick actions to generate, refine, explain, and fix T-SQL while applying best-practice prompting.

• Introduction
• Use Copilot code completion in Microsoft Fabric's Data Warehouse
• Use Copilot chat in Microsoft Fabric's Data Warehouse
• Use Copilot quick actions in Microsoft Fabric's Data Warehouse
• Review best practices using Copilot in Microsoft Fabric's Data Warehouse
• Exercise - Use Copilot in Microsoft Fabric data warehouse
• Module assessment
• Summary

Get started with Copilot in Power BI

Copilot in Power BI increases productivity when developing semantic models and reports using Power BI. Copilot also allows you to interact with your data using natural language to gain insights.

• Introduction
• Use Copilot in Power BI to prepare and model data
• Create reports with Copilot in Power BI
• Get your data ready for AI usage in Power BI
• Module assessment
• Summary

Implement Microsoft Fabric Data Agents (chat with your data)

Enable secure conversational access to enterprise data with Fabric data agents—design, configure, govern, and integrate AI-powered Q&A experiences across OneLake sources.

• Introduction
• Understand Microsoft Fabric data agent capabilities
• Implement an end-to-end Microsoft Fabric data agent
• Integrate Microsoft Fabric data agents with Azure AI Foundry
• Use Microsoft Fabric data agents within Power BI
• Exercise - Chat with your data using Microsoft Fabric data agents
• Module assessment
• Summary

Manage Copilot in Microsoft Fabric

This module covers the fundamentals of Copilot in Microsoft Fabric, including its architecture and governance model, configuration of tenant and capacity settings, monitoring of consumption with token-based costing, and strategies for scalable, cost-effective rollout.

• Introduction
• How Copilot in Microsoft Fabric works
• Enable Copilot in Microsoft Fabric
• Understand Copilot in Microsoft Fabric consumption
• Scale Copilot in Microsoft Fabric
• Module assessment
• Summary