DP-3029: Work smarter with Copilot in Microsoft Fabric

This course empowers learners to harness the full potential of Copilot in Microsoft Fabric to streamline data workflows and generate insights faster. Learn how to integrate, transform, store data, and create insightful reports using Copilot in Microsoft Fabric.

This course is aimed at data analysts and data engineers.

Attendees should have:

• Basic understanding of Microsoft Fabric and Power BI
• Familiarity with basic data concepts and terminology, including data engineering, modeling, and analysis.

After completing this course, students will be able to:

• Identify high‑value productivity scenarios across data integration, engineering, warehousing, BI, real-time intelligence, SQL, and data agents
• Explain how natural language and AI-assisted features reduce complexity, improve quality, and foster collaboration
• Recognise prerequisites, licencing, and governance considerations for enabling Copilot responsibly
• Apply Copilot across Microsoft Fabric to accelerate end‑to‑end data engineering tasks from ingestion to transformation and exploration
• Prompt Copilot to create and configure dataflows and pipelines with natural language instead of manual UI steps
• Generate, refine, and explain data transformation logic and Spark code safely and efficiently
• Use effective prompting strategies and best practices to improve quality, performance, and governance when using Copilot in Fabric
• Apply Copilot across Fabric Data Warehouse experiences to accelerate querying, authoring, and troubleshooting
• Generate, refine, explain, and fix T-SQL using chat, inline code completions, and quick actions
• Incorporate effective prompting, naming, and schema design practices that improve Copilot accuracy
• Use Copilot capabilities responsibly to enhance productivity while maintaining data quality and governance
• Use Copilot in Power BI during report development
• Prepare semantic models for use with AI
• Interact with data using natural language in Copilot Chat
• Design and configure Fabric data agents that enable secure conversational access to enterprise data
• Curate and optimise data sources, instructions, and example queries for accurate and relevant responses
• Publish, operationalise, and integrate Fabric data agents with downstream experiences like Azure AI Foundry, Power BI, and custom apps
• Apply governance, permission, and prompting best practices that improve reliability and safeguard data
• Explain the core architecture and governance model of Copilot in Microsoft Fabric
• Enable and configure Copilot tenant and capacity settings aligned with regional, security, and compliance requirements
• Monitor and interpret Copilot capacity consumption using metrics and token-based costing to inform optimisation
• Plan scalable rollout strategies (controlled access, capacity designation, isolation) that balance performance and cost

Work smarter with Copilot in Microsoft Fabric

• Introduction to Copilot in Microsoft Fabric
• Get started with Copilot in Microsoft Fabric for data engineering
• Get started with Copilot in Microsoft Fabric for Data Warehouse
• Get started with Copilot in Power BI
• Implement Microsoft Fabric Data Agents (chat with your data)
• Manage Copilot in Microsoft Fabric