Power BI instructor-led training

These workshops and classes are available to our partners and community leads for free to help them train their customers and communities on Power BI.

Power BI courses

Every class will include all materials—presenter deck, demo scripts, step-by-step hands-on lab, dataset, and other content.

Dashboard in a Day (DIAD)
Dashboard in a Day (DIAD) Advanced Visualization with Power BI Advanced Data Modeling and Shaping DAX in a Day Administrator in a Day Paginated Reports in a Day Developer in a Day Modern Excel Analyst in a Day Leap into Power BI Analytics in a Day (AID)

Dashboard in a Day (DIAD)

Last updated—April 2021

DIAD is a one-day, hands-on workshop for business analysts, covering the breadth of Power BI capabilities.

At the end of the day, attendees will better understand how to:

  • Connect and transform data from a variety of data sources.

  • Define business rules and KPIs.

  • Explore data with powerful interactive visuals.

  • Build stunning reports.

  • Share their dashboards with their team business partners and publish them to the web.

Content is offered in nine languages—Brazilian Portuguese, Chinese-Simplified (Mandarin), English, French, German, Italian, Japanese, Korean, and Spanish.

The workshop assets are split into two parts:

  1. Instructor content includes presentation decks, demo scripts, and instructor training material. To access this content, please ensure your Microsoft account is tied to your Microsoft Partner Network (MPN) ID. Instructor content is available to MPN members and MVPs only.

  2. Attendee content includes the lab manual and datasets.

Advanced Visualization with Power BI

Last updated—April 2021

Prerequisites—DIAD training or equivalent working experience

This one-day course will cover Power BI report layouts and structure the agile process to creating Power BI data visualizations. It will help attendees to understand the art behind visualizations, the implications behind choosing the right charts, the impact of color, shape, and size, and finally the use of Power BI custom visuals. The course includes various design patterns of dashboards and reports, as well as best practices for authoring great reports and dashboards for business users.

Content is offered in nine languages—Brazilian Portuguese, Chinese-Simplified (Mandarin), English, French, German, Italian, Japanese, Korean, and Spanish.

The workshop assets are split into two parts:

Advanced Data Modeling and Shaping with Power BI

Last updated—March 2021

Prerequisites—DIAD training or equivalent working experience

This one-day course will cover using Power BI Desktop to import and shape data from a variety of sources. It will also walk through Power BI capabilities you can use to enhance the data model for your business users. The course covers key aspects of how to create a great data model to meet your business needs, various features in Power BI used to enhance data models so you can build great reports, and an introduction to DAX to create calculations.

After completing this training, the attendees should be able to import data from a variety of data sources into Power BI, shape the data, create the data model, and write DAX functions to the Power BI model.

This content is offered in English.

The workshop assets are split into two parts:

DAX in a Day

Beta version is being tested and will be available soon – planned release date August 2021.

Content is offered in nine languages—Brazilian Portuguese, Chinese-Simplified (Mandarin), English, French, German, Italian, Japanese, Korean, and Spanish.

Administrator in a Day

Last updated—March 2021

Prerequisites—DIAD training or equivalent working experience

This one-day course will walk attendees through the Microsoft Power BI administration and the management of a Power BI tenant, including the configuration of tenant settings, usage monitoring, and provisioning of licenses, as well as other organizational resources.

It covers the typical admin tasks and tools, such as Power BI admin portal and Office 365 admin center, and how to automate them by using administrative APIs and PowerShell cmdlets. Specific hands-on labs will focus on using Premium capacity in Power BI, safely sharing Power BI assets, and using the Power BI audit log to optimize Power BI usage.

Content is offered in nine languages—Brazilian Portuguese, Chinese-Simplified (Mandarin), English, French, German, Italian, Japanese, Korean, and Spanish.

The workshop assets are split into two parts:

Paginated Reports in a Day

Last updated—January 2021

The Power BI Paginated Reports in a Day will walk attendees through the technical knowledge required to create, publish, and distribute Power BI paginated reports. The training can be conducted virtually or in a classroom. Access the self-paced online training.

The course covers these topics:

  • Design report layouts.
  • Connect to data sources to retrieve report data.
  • Work with parameters.
  • Visualize report data.
  • Add interactive features.
  • Publish, consume, deliver, and embed paginated reports.

Content is offered in nine languages—Brazilian Portuguese, Chinese-Simplified (Mandarin), English, French, German, Italian, Japanese, Korean, and Spanish.

The workshop assets are split into two parts:

Developer in a Day

Last updated—September 2020

Prerequisites—Software Development fundamentals, DIAD or equivalent working experience

The Power BI Developer in a Day course will empower attendees with the technical knowledge required to embed Power BI content. This course is designed specifically for experienced app developers and being familiar with front-end coding is an advantage. Access the full online training.

The course covers these topics:

  • Acquire access using Azure Active Directory (Azure AD) apps and tokens.
  • Work with the Power BI REST API.
  • Embed Power BI content in your apps.
  • Integrate Power BI content in your apps using the Power BI JavaScript API.
  • Enforce row-level security (RLS) to ensure app users see the right data.
  • Choose the right license to suit your requirements.

Content is offered in nine languages—Brazilian Portuguese, Chinese-Simplified (Mandarin), English, French, German, Italian, Japanese, Korean, and Spanish.

The workshop assets are split into two parts:

Modern Excel Analyst in a Day

Last updated—January 2021

Modern Excel Analyst in a Day is a one-day workshop for analysts. It demonstrates the advanced capabilities available in Excel, explores how Excel and Power BI are best used together, and shows how to successfully work with them in Microsoft Teams and SharePoint online.

At the end of the day, attendees will better understand:

  • Analytics in Excel.
  • Mapping analytics in Excel to Power BI—Compare Excel and Power BI desktop.
  • Power BI additional capabilities.
  • Power BI and Excel better together.
  • Power BI and Microsoft Teams.

Content is offered in nine languages—Brazilian Portuguese, Chinese-Simplified (Mandarin), English, French, German, Italian, Japanese, Korean, and Spanish.

The workshop assets are split into two parts:

Leap into Power BI

Last updated—August 2020

Prerequisites—One year of Tableau experience.

Leap into Power BI is a one-day introduction for data analysts, developers, and engineers currently using Tableau, showing them how to achieve the same functionality in Power BI. The course contains presentation and labs.

At the end of the day attendees will better understand:

  • What is Power BI?
  • Data Connectivity and Transformation in Power BI.
  • How to perform calculations in Power BI.
  • Organizing and simplifying the data.
  • Visualization.
  • Analytics.
  • Performance optimization.

Content is offered in nine languages—Brazilian Portuguese, Chinese-Simplified (Mandarin), English, French, German, Italian, Japanese, Korean, and Spanish.

The workshop assets are split into two parts:

Analytics in a Day (AID)—Synapse and Power BI

Last updated—January 2021

Prerequisites—DIAD and basic experience working with Azure

This oneday training is designed to empower data architects and BI developers with the technical knowledge required to design an enterprise BI solution that uses Azure Synapse Analytics and Power BI. The labs will focus on how to work with Azure Synapse and Power BI, developing and optimizing a Power BI model, creating a model using Direct Query, and Authoring a Power BI report.

Content is currently available for Microsoft Partner Network members only

The workshop assets are split into two parts:

  • Instructor content includes presentation decks, demo scripts, and train-the-trainer material.

Please submit your detailed feedback

Your feedback helps us to enhance our content and assist the entire Power BI community.

Guidance for using this content

  1. You cannot make any changes to the dataset.
  2. If any changes are made to the course content, then they should not be branded as per the above brands.
  3. The person presenting should be very familiar with Power BI and be able to answer any customer questions related to the workshop or Power BI in general.
  4. Please make sure the attendees complete a survey after your training. The survey allows us to maintain and improve the existing training content. If you need assistance with the survey, please contact us.