Work smarter with Copilot in Microsoft Fabric DP-3029 Training Plan: Detailed Modules
Module 1: Introduction to Copilot in Microsoft Fabric
- 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 2: Get started with Copilot in Microsoft Fabric for data engineering
- 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 3: Get started with Copilot in Microsoft Fabric for Data Warehouse
- 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 4: Get started with Copilot in Power BI
- 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 5: Implement Microsoft Fabric Data Agents (chat with your data)
- 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 6: Manage Copilot in Microsoft Fabric
- How Copilot in Microsoft Fabric works
- Enable Copilot in Microsoft Fabric
- Understand Copilot in Microsoft Fabric consumption
- Scale Copilot in Microsoft Fabric
Recommended prerequisite knowledge
- Familiarity with basic data concepts and terminology (data engineering, modeling, analysis)
- General understanding of ETL/ELT workflows and data pipelines
- Understanding of data modeling and consumption (datasets, semantic models, reports)
- Basic knowledge of SQL and data manipulation (recommended)
- Experience with Power BI and/or analytics environments is an asset
- Understanding of cloud concepts (identities, access, resources) is a plus
Copilot in Microsoft Fabric training
The DP-3029 course is designed for data analysts, data engineers, data scientists, and IT professionals who want to accelerate analytics using Copilot in Microsoft Fabric. This course focuses on using Copilot to integrate, transform, and store data, and then more quickly generate reports and insights across various Fabric experiences.
Participants will develop practical skills to improve productivity in real-world scenarios: assisting with the creation of data flows and pipelines, working with SQL and the data warehouse, accelerating BI in Power BI, and learning about data agents for conversational interaction with enterprise data, while considering governance and consumption.
Why Choose This Training?
Copilot in Microsoft Fabric transforms how teams ingest, prepare, and analyze data by bringing AI assistance directly into Fabric experiences. In this course, you’ll learn how to use Copilot to accelerate key tasks: creating and understanding data flows, transforming and orchestrating pipelines, generating and improving SQL queries, and producing faster reports and summaries in Power BI.
This course helps you address today’s analytics challenges—volume, complexity, deadlines, and quality—by improving productivity and deliverable consistency, while introducing best practices for governing, consuming, and scaling Copilot in Microsoft Fabric.
Key Skills Developed in the Training
Accelerate Data Integration and Transformation with Copilot
Learn how to use Copilot to understand, generate, and improve integration and transformation flows (Data Factory, Dataflow Gen2, pipelines).Data Engineering and Data Science Productivity in Fabric
Discover how Copilot can assist in orchestrating, explaining, and improving workflows, including in data-driven notebooks and scenarios.Optimize Data Warehouse (SQL) Work with Copilot
Generate, refine, explain, and correct T-SQL queries faster, while applying best practices.Enhance BI with Copilot in Power BI
Accelerate the creation of semantic models, reports, and summaries, and gain insights through natural language interactions.Setting up conversational experiences with Fabric Data Agents
Understand how to design and implement Data Agents to securely “talk to your data” using OneLake.Governance, consumption, and scaling of Copilot in Microsoft Fabric
Learn the fundamentals of the architecture and governance model, tenant/capacity-level activation, consumption monitoring, and scalable deployment strategies.
A practical training, led by experts
This training is delivered by Microsoft/Azure certified instructors who combine theoretical instruction with hands-on exercises. Participants will work on real-world scenarios to learn how to use Copilot within Microsoft Fabric to accelerate data integration, transformation, and analysis, as well as the creation of reports and insights.
The approach is field-oriented: you will apply best practices to improve productivity across different Fabric experiences (data engineering, data warehouse/SQL, Power BI), while also covering key concepts of governance, consumption, and scaling.
Who is this training for?
- Data analysts who want to accelerate data preparation and report/insight creation with Copilot in Microsoft Fabric.
- Data engineers responsible for integrating, transforming, and orchestrating pipelines (Data Factory, Dataflow Gen2, notebooks, SQL).
- Data scientists who want to increase productivity in Microsoft Fabric to explore, understand, and leverage data faster.
- BI/Power BI professionals looking to improve modeling, reporting, and summarization with Copilot.
- Data/platform architects and managers who need to guide Copilot adoption in Fabric (governance, consumption, scaling).
Accelerate analytics with Copilot in Microsoft Fabric
The DP-3029 course – Work Smarter with Copilot in Microsoft Fabric – helps you leverage Copilot to integrate, transform, and store data, and then create reports and insights faster within Microsoft Fabric. Register today to boost the productivity of your data and BI teams and accelerate your organization’s analytical transformation.
Frequently Asked Questions – DP-3029 Training (FAQ)
DP-3029 focuses on using Copilot in Microsoft Fabric to work more efficiently across the entire analytical cycle: data integration, transformation and storage, and then report and insight creation.
Yes. The training combines key concepts and exercises to apply Copilot to concrete scenarios in Microsoft Fabric (pipelines, SQL/warehouse, Power BI, data agents).
For data analysts, data engineers, data scientists and BI/Power BI profiles who want to accelerate their daily tasks and improve the quality of deliverables using Copilot in Fabric.
Depending on the scenarios, the training covers Copilot in experiences such as Data Factory, Data Engineering / notebooks, Data Warehouse (SQL), Power BI, as well as an introduction to data agents and governance concepts.
Data Agents enable the creation of a conversational experience to “talk with your data” securely, based on the company’s data sources (OneLake) and governance rules.
Yes, in terms of essential principles: activation, tenant/capacity parameters, consumption monitoring and best practices for a scalable and controlled adoption.