DP-3029: Work smarter with Copilot in Microsoft Fabric

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

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

Level: Intermediate - Roles: Data Analyst, Data Engineer - Subject: Data Engineering, Data Integration - Product: Microsoft Fabric, Microsoft Copilot

Course aimed at

This course is intended for data analysts and engineers familiar with basic data concepts and terminology. Participants should have a basic understanding of Microsoft Fabric and Power BI.

DP-3029 Training Objectives

• Understand the role of Copilot in Microsoft Fabric as an intelligent assistant for data engineering, analysis, and visualization tasks.
  
• Explore how Copilot improves productivity in data-driven work environments by automating tasks and generating insights.
  
• Use Copilot to create and modify artifacts such as notebooks, pipelines, dashboards, and queries.
  
• Apply Copilot in real-world data analysis, modeling, and reporting scenarios.
  
• Integrate Copilot with other Microsoft Fabric services, such as Power BI, Data Factory, and Synapse.
  
• Evaluate generative AI capabilities to accelerate collaborative and technical work on data platforms.

DP-3029 Course Content: Work Smarter with Copilot in Microsoft Fabric

Module 1: Introduction to Copilot in Microsoft Fabric

• Introduction
• Understanding Copilot for Microsoft Fabric Data Factory
• Understanding Copilot for Data Engineering and Data Science
• Understanding Copilot for the Data Warehouse
• Understanding Copilot in Power BI
• Understanding Copilot for Real-Time Intelligence
• Understanding Copilot for SQL Database Workloads
• Understanding Microsoft Fabric Data Brokers
  

Module 2: Get started with Copilot on Microsoft Fabric for data engineering

• 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
  
• Using Copilot in Microsoft Fabric Notebooks
  
• Exercise: Analyzing data with Apache Spark and Copilot in Microsoft Fabric notebooks

Module 3: Get started with Copilot on Microsoft Fabric for Data Warehouse

• Introduction
  
• Use Copilot code completion in the Microsoft Fabric datastore
  
• Use Copilot chat in the Microsoft Fabric datastore
  
• Use Copilot Quick Actions on the Microsoft Fabric Datastore
  
• Review best practices for using Copilot in the Microsoft Fabric datastore
  
• Exercise: Using Copilot on the Microsoft Fabric Datastore

Module 4: Get started with Copilot in Power BI

• Introduction
  
• Use Copilot in Power BI to prepare and model data
  
• Create reports with Copilot in Power BI
  
• Prepare your data for AI in Power BI

Module 5: Deploy Microsoft Fabric Data Brokers (Chat with Your Data)

• Introduction
  
• Understanding the capabilities of the Microsoft Fabric data broker
  
• Deploy an end-to-end Microsoft Fabric data broker
  
• Integrate Microsoft Fabric data brokers with Azure AI Foundry
  
• Use Microsoft Fabric data brokers in Power BI
  
• Exercise: Chat with your data using Microsoft Fabric data brokers

Module 6: Managing Copilot in Microsoft Fabric

• Introduction
  
• How Copilot works in Microsoft Fabric
  
• Enable Copilot in Microsoft Fabric
  
• Understanding Copilot consumption in Microsoft Fabric
  
• Scale Copilot in Microsoft Fabric

Prerequisites

You should be familiar with basic data concepts and terminology, including data engineering, modeling, and analysis.

Language

• Course: English / Spanish