Course Overview of DP-3029:

This course equips data professionals from data engineers to analysts, BI developers to data scientists with the skills to harness Copilot within Microsoft Fabric to design, build, and deploy end-to-end data analytics and AI-first workflows. You will explore how Copilot can dramatically simplify data ingestion, transformation, warehousing, reporting, and real-time analytics by turning natural-language prompts into code, queries, visualizations, and insights.

Throughout the course, learners gain a deep understanding of how to integrate and operate across various Fabric workloads Data Factory / Data Engineering, Data Warehouse, Real-Time Intelligence, SQL databases, Notebooks, and Power BI all while leveraging Copilot’s generative AI capabilities.

After completing DP-3029 course, participants will be able to:

  • Understand how Microsoft Fabric and Copilot work together across all core workloads and the OneLake architecture.
  • Build ETL/ELT pipelines using natural-language prompts with Copilot in Data Engineering and Data Factory.
  • Generate SQL/KQL queries and transformations automatically using Copilot from business questions.
  • Create dashboards, visuals, and insights in Power BI and Real-Time Intelligence using Copilot assistance.
  • Use Copilot in Notebooks to clean, explore, and analyze data through AI-generated code.
  • Automate repetitive data tasks, pipelines, and transformations with Copilot-driven AI workflows.
  • Apply responsible governance, compliance, and organizational controls when using Copilot in Fabric.

Upcoming Batches

Loading Dates...

Key Features of DP-3029:

  • Comprehensive Coverage: Covers all major Fabric workloads (Data Engineering, Data Warehouse, SQL, Real-Time Analytics, Notebooks, Power BI) and shows how Copilot fits into each.

  • Hands-on Practical Exercises: Each module includes immersive labs such as:

    Building ETL pipelines from raw data using Copilot prompts

    Generating SQL / KQL queries via natural language and running them on Fabric warehouse or databases

    Creating dashboards and reports in Power BI with Copilot-assisted visuals, summaries and Q&A

    Analyzing datasets in Notebooks (Spark / pandas / Fabric dataframes) using Copilot-generated code

    Automating routine data workflows, data cleansing, transformation, and schema migrations

    Exploring real-time analytics setup using Real-Time Intelligence workload + Copilot

     

  • Focus on Role-Based Learning: Designed for Data Engineers, Data Analysts, BI Developers, Data Scientists but also useful for Solution Architects, Technical Leads, and anyone interested in building AI-augmented data solutions

  • Career Advancement: Builds applied skills needed to lead modern, AI-augmented data engineering, analytics and BI projects using Fabric + Copilot; valuable for roles requiring rapid analytics delivery, data ops, BI automation, or real-time business intelligence.

Who should Attend DP-3029?

  • Data Engineers
  • Data Analysts / BI Developers
  • Data Scientists
  • Solution Architects / Technical Architects working with enterprise data platforms
  • Anyone building data-driven analytics, reporting, real-time data solutions, or ETL/ELT data pipelines using Microsoft Fabric and interested in leveraging Copilot to accelerate work

Prerequisites of DP-3029:

Participants should have:
  • Basic understanding of data analytics, ETL/ELT pipelines, data warehousing, and BI concepts
  • Familiarity with SQL and/or data transformation concepts
  • Some prior experience with data tools/analytics platforms is helpful but not mandatory - Copilot GUI + natural-language driven approach lowers the barrier
  • Awareness of data governance, compliance and security practices (recommended)

    • Why choose CloudThat as your training partner for DP-3029?

    • Expert Instructors: Certified experts with deep real-world experience in Azure Databricks, Machine Learning, and GenAI.
    • Comprehensive Course Content: Up-to-date curriculum aligned with Microsoft Applied Skills standards.
    • Hands-on Lab: Practical learning with real datasets, enterprise scenarios, and guided labs.
    • Flexible Training Options: Both online and classroom options designed for working professionals.
    • Proven Track Record: successfully trained thousands of professionals for Azure and Databricks certifications.

    Course Outline of DP-3029: 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

    Lab - 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

    Lab - 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 Microsoft Foundry

    Use Microsoft Fabric data agents within Power BI

    Lab - 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 of DP-3029:

    • Completing this course helps earn the Microsoft DP-3029 Applied Skills credential
    • Validates your ability to use Copilot in Microsoft Fabric to build AI-assisted data analytics workflows
    • Demonstrates proficiency across Fabric workloads using natural-language automation and AI-driven insights
    • Strengthens your readiness for other Microsoft Data & AI certifications

    Click to Zoom

    Select Course date

    Loading Dates...
    Add to Wishlist

    Course ID: 26673

    Course Price at

    Loading price info...
    Enroll Now

    FAQs of DP-3029:

    A practical course focused on using Microsoft Copilot in Microsoft Fabric to streamline data engineering, analytics, and BI workflows through AI-assisted automation.

    Data engineers, data analysts, BI developers, data scientists, solution architects, and technical professionals working with Microsoft Fabric and enterprise data systems.

    Basic understanding of data analytics, SQL, and Fabric workloads is recommended, though Copilot lowers the barrier for beginners.

    Yes, each module includes hands-on labs using Copilot across Fabric workloads such as Data Engineering, Warehousing, Notebooks, and Power BI.

    Yes, it aligns directly with the Microsoft DP-3029 Applied Skills credential.

    Enquire Now