DP-3029-A: Work smarter with Copilot in Microsoft Fabric

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.