Who is this training for?
This course is for data analysts and data engineers who are proficient in basic data concepts and terminology.
Training objectives
- Understand and use Copilot features in the Microsoft Fabric ecosystem
- Accelerate data engineering and preparation
- Optimize the use of the Data Warehouse with Copilot
- Design Power BI models and reports with Copilot
- Use Microsoft Fabric Data Agents
- Manage the activation, scale, and consumption of Copilot in Fabric
Summary
This course explores how to work more efficiently with Copilot in Microsoft Fabric. You'll learn how to integrate, transform, and store data, as well as create relevant reports, using Copilot's capabilities in Microsoft Fabric.
Course outline
Course Content
- Introduction to Copilot in Microsoft Fabric
- Understanding Copilot for Microsoft Fabric Data Factory
- Understanding Copilot for Engineering and Data Science
- Understanding Copilot for Data Warehouse
- Understanding Copilot in Power BI
- Understanding Copilot for Real-Time Intelligence
- Understanding Copilot for SQL Database Workloads
- Understanding Microsoft Fabric Data Agents
- Data Engineering Module Assessment
- Getting Started Copilot in Microsoft Fabric for Data Engineering
- Using Copilot with Microsoft Fabric Dataflow Gen2
- Exercise - Working Smarter with Copilot in Dataflow Gen2
- Using Copilot with Data Pipelines
- Using Copilot in Fabric Notebooks
- Exercise - Analyzing Data with Apache Spark and Copilot
- Evaluating the Data Warehouse Module
- Getting Started with Copilot in the Data Warehouse Fabric
- Using Code Completion in the Data Warehouse
- Use Chat Copilot in the Data Warehouse
- Use Copilot Quick Actions
- Best Practices Review
- Exercise - Use Copilot in the Data Warehouse
- Power BI Module Assessment
- Get Started with Copilot in Power BI
- Prepare and Model Data with Copilot
- Create Reports with Copilot
- Prepare Data for AI Scenarios in Power BI
- Data Agents Module Assessment
- Implement Microsoft Fabric Data Agents
- Understand their capabilities
- Build a complete agent
- Integrate agents with Microsoft Foundry
- Use agents in Power BI
- Exercise - Converse with your data
- Admin module assessment
- Manage Copilot in Microsoft Fabric
- Understand how Copilot works
- Enable Copilot
- Understand consumption
- Manage scale
- Module assessment
Approach and methodology
Hands-on, interactive approach combining demonstrations, guided exercises, and business scenarios. Participants discover the capabilities of Copilot in Microsoft Fabric through concrete cases related to data analysis, promoting an immediate application of learning. They learn how to formulate effective queries, leverage AI-generated suggestions, and automate certain analytical tasks (queries, visualizations, data interpretation). The training emphasizes experimentation, exchange, and direct application to enable effective use of Copilot to accelerate analysis, improve data understanding, and support decision-making.
Prerequisites
Prior knowledge of Microsoft Fabric and Power BI or equivalent content
Recommendations
- Basics in Microsoft Fabric / Power BI or data analysis
- Understanding of data concepts (tables, queries, visualization)
- Fluency with Microsoft 365 tools and analytical interfaces
- Interest in generative AI applied to data
- Openness to experimentation and automation of analytical tasks
