Work smarter with Copilot in Microsoft Fabric Training

This course introduces learners to the practical use of Copilot across Microsoft Fabric and Power BI, demonstrating how AI can streamline data engineering and analytical workflows.
It focuses on enhancing productivity rather than teaching data concepts from scratch.

Participants explore how Copilot:

• Transforms data in Dataflow Gen2,

• Automates repetitive data pipeline tasks,

• Assists in notebook analytics and code generation,

• Generates queries in SQL-based data warehouse environments,

• Builds reports and insights in Power BI,

• Enables conversational data interaction using Fabric Data Agents.

No formal prerequisites required.
However, learners will benefit from:

• Basic understanding of data concepts and Microsoft Fabric architecture

• Experience in data preparation, transformation, and modeling with Power BI

• Awareness of business-oriented analytical problem solving

By the end of this course, learners will be able to:

• Explain how Copilot enhances productivity across Microsoft Fabric

• Use Copilot in Dataflow Gen2 for data transformation

• Apply Copilot in Notebooks for analysis and code generation

• Generate SQL queries and analyse data using Copilot

• Build reports and visuals in Power BI with AI assistance

• Interact with organisational data using Fabric Data Agents

• Manage Copilot features and settings across Fabric

• Adapt to evolving AI model outputs and UI changes

Introduction to Copilot in Fabric

• Overview of Copilot capabilities

• How Copilot supports common data engineering and analytics tasks

• The focus on productivity, not fundamentals

Using Copilot for Data Engineering

• Working with Dataflow Gen2 for transformations

• Automating repetitive data preparation tasks

• Guided productivity examples

Lab: Smart data preparation using Copilot in Dataflow Gen2
Lab: Data analysis with Apache Spark and Copilot in Fabric Notebooks

Using Copilot for Data Warehouse Tasks

• Applying Copilot to support SQL-based data exploration

• Generating queries and analysing warehouse data

• Understanding Copilot as a supportive assistant, not a replacement

Lab: Using Copilot in Microsoft Fabric Data Warehouse

Using Copilot in Power BI

• Leveraging Copilot to build reports, visuals, and insights

• Accelerating data-to-insight workflows

Using Fabric Data Agents

• Introduction to Conversational Analytics

• Chatting with data using AI

• Combining prompts with structured queries

Lab: Chat with data using Microsoft Fabric Data Agents

Managing Copilot in Fabric

• Managing and monitoring Copilot features

• Administrative considerations and governance

• Preparing for UI and model variability

Hands-On Learning

This course provides lab-based, guided practice within Microsoft Fabric, enabling learners to apply AI tools in real-world scenarios:

• Dataflow automation

• Notebook analysis

• SQL query generation

• Power BI reporting

• Conversational data exploration