Course Information
Course Name
DP-3029-A: Work smarter with Copilot in Microsoft Fabric
Duration
1 Day
Overview
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. Learners taking this course should already have a basic understanding of Microsoft Fabric and Power BI.
Prerequisities
You should be familiar with data analytics and engineering concepts and terminology.
At Course Completion
Course Outline
Module 1: 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.
Lessons
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
Module 2: 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
Explore and transform data in a lakehouse
Exercise – Create a Microsoft Fabric lakehouse
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
Module 3: 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
Module 4: 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
Module 5: 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 Microsoft Foundry
Use Microsoft Fabric data agents within Power BI
Exercise – Chat with your data using Microsoft Fabric data agents
Module assessment
Module 6: 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
All Microsoft certification courses are conducted by certified trainers from Iverson.
Digital Methods acts as the official training partner and assists with program consultation, registration, coordination, scheduling, and administrative arrangements to ensure a seamless and professionally managed training experience.