Work smarter with Copilot in Microsoft Fabric (DP-3029)

Course Objectives:

• Explain Copilot’s architecture, governance model, and tenant/capacity configuration in Microsoft Fabric.
• Monitor and optimize consumption using token-based costing, budgets, and guardrails.
• Streamline integration, engineering, warehousing, BI, real-time intelligence, and SQL with AI-assisted experiences.
• Use Copilot prompts to ingest, transform, orchestrate, and document dataflows, pipelines, and Spark code.
• Generate, refine, explain, and fix T-SQL with AI chat, inline completions, and best-practice prompting.
• Accelerate Power BI development of semantic models and reports; query data using natural language.
• Design, configure, and govern Fabric data agents for secure conversational access to OneLake data.
• Plan a scalable, cost-effective Copilot rollout with operational and governance best practices.

Target Audience

• Data Scientist
• Data Analyst
• Data Engineer

Prerequisites

• Familiarity with basic data concepts and terminology
• Learner should already have a basic understanding of Microsoft Fabric and Power BI 

Course Outline

1) Work smarter with Copilot in Microsoft Fabric

Introduction to Copilot in Microsoft Fabric
• Describe the role of Copilot in accelerating end-to-end analytics workflows in Microsoft Fabric
• 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
• Recognize prerequisites, licensing, and governance considerations for enabling Copilot responsibly

Get started with Copilot in Microsoft Fabric for data engineering
• 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

Get started with Copilot in Microsoft Fabric for Data Warehouse
• 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

Get started with Copilot in Power BI
• Use Copilot in Power BI during report development
• Prepare semantic models for use with AI
• Interact with data using natural language in Copilot Chat

Interact with data using natural language in Copilot Chat.EndFragment

Implement Microsoft Fabric Data Agents (chat with your data)
• Design and configure Fabric data agents that enable secure conversational access to enterprise data
• Curate and optimize data sources, instructions, and example queries for accurate and relevant responses
• Publish, operationalize, 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

Manage Copilot in Microsoft Fabric
• 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 optimization
• Plan scalable rollout strategies (controlled access, capacity designation, isolation) that balance performance and cost