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.
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 Microsoft 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
As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.
Data Analysts
Data Engineers
Basic understanding of Microsoft Fabric and Power BI
Familiarity with basic data concepts and terminology, including data engineering, modeling, and analysis.
The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.
