(Online Delivery) Microsoft Copilot in Power BI and Fabric Training

Description

Overview:

Microsoft Copilot is an AI-powered tool that enhances productivity by simplifying report creation, data analysis, and automation in Power BI and Fabric. This 1 day training will teach you how to leverage Copilot’s capabilities to generate DAX formulas, create dashboards, analyze data, and optimize performance.
In this course, you will use Copilot to streamline reporting, automate analytics, and maximize the potential of AI-driven insights in Power BI and Fabric. You will:

  • Understand the integration of Copilot with Power BI and Fabric
  • Enable and configure Fabric capacity and Copilot features
  • Utilize AI-powered prompts for data exploration, modeling, and optimization

Target Student:

This course is designed for Power BI users, data analysts, and business professionals who want to enhance their data analytics and reporting workflows using Copilot’s AI-driven capabilities. Basic familiarity with Power BI is recommended.


Course Content

Lesson 1: Introduction to Power BI, Fabric, and Copilot

Topic A: Overview of Power BI, Fabric, and Copilot
Topic B: Understanding the AI capabilities of Copilot

Lesson 2: Setting Up Fabric and Copilot

Topic A: Pricing and purchasing Fabric F64 capacity in Azure
Topic B: Creating a Fabric capacity in Azure
Topic C: Pausing or deleting a Fabric capacity to manage costs
Topic D: Enabling Fabric in the Power BI Admin Portal
Topic E: Enabling Copilot in Power BI Desktop

Lesson 3: Copilot’s Capabilities in Power BI

Topic A: Exploring Copilot’s core features
Topic B: Using exploratory prompts to analyze data
Topic C: Understanding Copilot’s role in data modeling and preparation
Topic D: Generating DAX formulas and queries with Copilot
Topic E: Creating and refining reports and dashboards
Topic F: Leveraging AI-driven predictive analytics
Topic G: Enhancing performance using optimization techniques

Lesson 4: Using Copilot in Power BI Desktop

Topic A: Using prompts in Power BI Desktop
Topic B: Asking questions about data using natural language
Topic C: Using Copilot to suggest synonyms in Q&A
Topic D: Generating and refining DAX queries

Lesson 5: Using Copilot in Fabric

Topic A: Exploring the best prompts for Copilot in Fabric
Topic B: Using AI-powered insights for data analysis
Topic C: Forecasting and predictive analytics with Copilot
Topic D: Using Copilot to Extract, Transform, Load (ETL) Pipelines in Dataflows in Power Query M Language
Topic E: Performance optimization for reports and datasets
Topic F: Enhancing sharing and collaboration

Lesson 6: Prompt Engineering for Best Results

Topic A: Designing effective prompts for Copilot
Topic B: Using structured queries for better AI-driven insights
Topic C: Refining prompts for improved Power BI responses

Similar courses

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course is best for students with high PC skills and are experienced/comfortable with technology - if that isn't you, our one or two day Power BI classes might be a better fit for you.

More Information

This is a great class for an overview of Power BI/if Power BI isn't a central part of your job role.

More Information

Doing data analysis work is about more than learning a software program (Excel, Power BI, Tableau, etc.) - you need to understand the concepts and theory too. This one day course gets you up to speed (and can be useful either before or after your software classes).

More Information

Understanding DAX is critical for Power BI users. It is required that you are familiar with Power BI and (if attending virtually) that you have Power BI on the PC to be used for this training event in order to take this class

More Information

This is a great class for an overview of Power BI/if Power BI isn't a central part of your job role.

More Information

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course is best for students with high PC skills and are experienced/comfortable with technology - if that isn't you, our one or two day Power BI classes might be a better fit for you.

More Information

This class is designed for people new to using AI tools, such as ChatGPT - Gemini - or Copilot, in the workplace. People with experience using these tools for their job functions may find some of the content covered to be beginner or overview level. PLEASE NOTE - students in this class will create ChatGPT, Gemini, and/or Copilot accounts - and should have access to an email account and cell phone in order to move through the various vendors' multi-factor authentication processes during account set-up.

More Information

This class is designed for people new to using AI tools, such as ChatGPT - Gemini - or Copilot, in the workplace. People with experience using these tools for their job functions may find some of the content covered to be beginner or overview level. PLEASE NOTE - students in this class will create ChatGPT, Gemini, and/or Copilot accounts - and should have access to an email account and cell phone in order to move through the various vendors' multi-factor authentication processes during account set-up.

More Information

Understanding DAX is critical for Power BI users. It is required that you are familiar with Power BI and (if attending virtually) that you have Power BI on the PC to be used for this training event in order to take this class.

More Information

This class is designed for people new to using AI tools, such as ChatGPT - Gemini - or Copilot, in the workplace. People with experience using these tools for their job functions may find some of the content covered to be beginner or overview level. PLEASE NOTE - students in this class will create ChatGPT, Gemini, and/or Copilot accounts - and should have access to an email account and cell phone in order to move through the various vendors' multi-factor authentication processes during account set-up.

More Information

Students registering for class will need to let Logical Operations know whether they are using Windows 10 or Windows 11.

More Information

Students registering for class will need to let Logical Operations know whether they are using Windows 10 or Windows 11.

More Information

No previous experience of Copilot required; however, the student will require an existing Copilot for Microsoft 365 license to participate in hands on exercises, as there is currently no trial license available to Microsoft partners for this product.

More Information

This class is designed for people new to using AI tools, such as ChatGPT - Gemini - or Copilot, in the workplace. People with experience using these tools for their job functions may find some of the content covered to be beginner or overview level. PLEASE NOTE - students in this class will create ChatGPT, Gemini, and/or Copilot accounts - and should have access to an email account and cell phone in order to move through the various vendors' multi-factor authentication processes during account set-up.

More Information

This class is designed for people new to using AI tools, such as ChatGPT - Gemini - or Copilot, in the workplace. People with experience using these tools for their job functions may find some of the content covered to be beginner or overview level. PLEASE NOTE - students in this class will create ChatGPT, Gemini, and/or Copilot accounts - and should have access to an email account and cell phone in order to move through the various vendors' multi-factor authentication processes during account set-up.

More Information

This class is a follow-up to the more basic/entry level AI classes offered at Logical Operations. Students in this class should have prior experience in an AI course offered by Logical Operations. It is recommended that students have previously taken either one of our "How to Create and Use a Prompt" classes or one of our "Getting the Most out of your Spreadsheets/Documents/Presentations with GenAI" classes.

More Information

Explore the power of this robust toolset that enables advanced distributed search, analytics, logging, and visualization of data, enabled by new features in Elastic Stack 7.0.

More Information