Course Overview:

This course will demonstrate how Copilot can enhance your productivity across various tasks in Microsoft Fabric and Power BI. You’ll learn how to use Copilot for data transformation with Dataflow Gen2, building data pipelines, working with notebooks, querying data from data warehouses or SQL databases, creating visuals and reports in Power BI, and interacting with your data through a data agent. The course will also cover how to effectively manage Copilot within Microsoft Fabric. It’s important to understand that this course is not designed to train you as a data engineer or data analyst. Instead, its focus is on helping you become more efficient in your current role by leveraging Copilot. If you’re looking to build foundational skills in data engineering or analysis, consider exploring courses like DP-600 or PL-300

After completing this course, participants will be able to:

  • Leverage Copilot across Microsoft Fabric workloads – apply Copilot in Data Factory, Data Engineering, Data Warehouse, Power BI, SQL, and Real-Time Intelligence.
  • Streamline data engineering tasks – use Copilot with Dataflow Gen2, pipelines, and notebooks to ingest, transform, and analyze data more efficiently.
  • Enhance analytics and reporting – create AI-assisted reports and prepare data models in Power BI, making datasets ready for advanced insights.
  • Implement intelligent data agents – design and integrate Microsoft Fabric data agents to enable natural language interaction with organizational data.
  • Manage and scale Copilot in Fabric – configure, monitor, and optimize Copilot features for performance, governance, and secure enterprise adoption.

Upcoming Batches

Loading Dates...

Key Features:

  • Comprehensive Coverage: Master how Copilot integrates across Microsoft Fabric workloads—including Data Factory, Data Engineering, Data Warehouse, Power BI, Real-Time Intelligence, and SQL Database workloads.

  • Hands-on Practical Exercises: Build real-world skills through guided labs in dataflows, pipelines, notebooks, warehouses, and Power BI—gaining practical experience with AI-powered assistance.

  • AI-Enhanced Data Engineering & Analytics: Accelerate data preparation, transformation, reporting, and analysis with Copilot’s AI-driven suggestions, quick actions, and natural language interaction.

  • Focus on Skill Based Learning: Designed for data engineers, BI developers, analysts, and cloud professionals, this course mirrors real-world job tasks and prepares learners for applied AI data roles.

  • Career Advancement: Gain future-ready skills in Microsoft Fabric and Copilot, enhancing productivity and enabling enterprise-scale adoption of AI-driven data and analytics solutions.

Who should Attend?

  • The audience for this course is data engineers and data analysts who want to learn how to work smarter with Copilot in Microsoft Fabric.
  • This course is also targeted at those individuals who develop reports but want to get to the insights faster using Copilot in Power BI

Prerequisites:

While there are no required prerequisites for taking this course, it is recommended that students have:
  • A foundational knowledge of core data concepts and how they’re implemented using Microsoft Fabric. For more information see DP-600 Microsoft Fabric Analytics Engineer
  • Experience designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value using Microsoft Power BI. For more information see PL-300 Design and manage analytics solutions using Power BI.

    • Why choose CloudThat as your training partner?

    • Expert Instructors – Learn from certified, experienced trainers with deep expertise in Microsoft Fabric and data solutions.
    • Comprehensive Course Content – Structured modules covering Copilot across Fabric workloads, ensuring holistic learning.
    • Hands-on Labs – Gain practical experience through guided labs that simulate real-world business data challenges.
    • Flexibility – Choose between online and in-person learning options to suit your schedule.
    • Proven Track Record – CloudThat has successfully trained thousands of professionals for cloud and data certifications, ensuring impactful learning outcomes.

    Learning objectives of the course

    • Leverage Copilot across Microsoft Fabric workloads – including Data Factory, Data Engineering, Data Warehouse, Power BI, SQL, and Real-Time Intelligence.
    • Build and optimize data workflows – use Copilot with Dataflow Gen2, pipelines, and notebooks to ingest, transform, and analyze data efficiently.
    • Enhance data warehouse operations – apply Copilot for code completion, interactive chat, quick actions, and best practices in query optimization and governance.
    • Create AI-driven insights in Power BI – prepare data, build reports, and make datasets AI-ready using Copilot’s advanced capabilities.
    • Implement and manage intelligent solutions – design data agents for conversational data interactions, and configure, monitor, and scale Copilot in Microsoft Fabric.

    Course Outline: Download Course Outline

    • 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

    • Use Copilot with Microsoft Fabric Dataflow Gen2
    • Lab - Work smarter with Copilot in Microsoft Fabric Dataflow Gen2
    • Use Copilot with Microsoft Fabric data pipelines
    • Use Copilot in Microsoft Fabric notebooks

    Hands-on Analyze data with Apache Spark and Copilot in Microsoft Fabric notebooks

    • 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

    Hands-on: Use Copilot in Microsoft Fabric data warehouse

    • 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

    • Understand Microsoft Fabric data agent capabilities
    • Implement an end-to-end Microsoft Fabric data agent
    • Integrate Microsoft Fabric data agents with Azure AI Foundry
    • Use Microsoft Fabric data agents within Power BI

    Hands-on: Chat with your data using Microsoft Fabric data agents

    • How Copilot in Microsoft Fabric works
    • Enable Copilot in Microsoft Fabric
    • Understand Copilot in Microsoft Fabric consumption
    • Scale Copilot in Microsoft Fabric

    Certification Details:

    • Earning the Microsoft DP-3029 Applied Skill Credential validates your expertise in working smarter with Copilot in Microsoft Fabric across data engineering, analytics, and visualization tasks.
    • In the DP-3029 Applied Skills course, you will learn how to use Copilot for data ingestion, transformation, and orchestration; analyze data with notebooks; optimize data warehouse queries; build interactive Power BI reports; and implement Fabric data agents.
    • This course is a 1-day instructor-led training designed to teach working with Copilot in Microsoft Fabric. It includes demonstrations, hands-on labs, and skill-building across real-world scenarios. It is not an official Microsoft certification exam; there is no proctored exam required for credentialing as part of DP-3029.

    Click to Zoom

    Select Course date

    Loading Dates...
    Add to Wishlist

    Course ID: 26163

    Course Price at

    Loading price info...
    Enroll Now

    FAQs:

    The DP-3029 course teaches how to work smarter with Copilot in Microsoft Fabric. You’ll learn how Copilot can help you with dataflows, pipelines, notebooks, SQL queries, data warehouses, Power BI, and Fabric data agents to boost productivity.

    This course is ideal for data engineers, data analysts, BI developers, and technical professionals who want to leverage Copilot in Microsoft Fabric to speed up data engineering and analytics tasks.

    There are no mandatory prerequisites. However, having a foundational understanding of data concepts, SQL, Power BI, or Microsoft Fabric basics (as covered in DP-600 or PL-300) will be helpful.

    Yes. The course includes multiple hands-on labs where you’ll use Copilot for dataflows, pipelines, notebooks, data warehouses, and data agents in a live Microsoft Fabric environment

    Yes. Upon completion, you will earn a DP-3029 Applied Skills credential from Microsoft. This credential validates your ability to use Copilot in Microsoft Fabric effectively.

    Unlike traditional exams, Applied Skills assessments are lab-based and scenario-driven, testing your ability to perform real-world tasks in Microsoft Fabric instead of answering only multiple-choice questions.

    DP-3029 is a 1-day instructor-led course, combining presentations, demos, discussions, and labs. Delivery options may include virtual classrooms or in-person training.

    Enquire Now