<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Intermediate Power BI

Build upon Power BI Beginner concepts with an in-depth exploration of Power Query, M language, data modeling, DAX, advanced visuals, interactive reports, and utilizing the full potential of the Power BI Service.

  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

This class builds on the concepts taught in the Power BI Beginner class. This class follows a similar process of walking through the Power BI Lifecycle. We start with Power Query and go more indepth on the M language. Next, we move into the desktop for data modeling and DAX before going into more advanced visuals and interactive report setup. We then cover aspects of using the Power BI Service that were not covered in the Beginner Power BI class.

Course Outline ( Free Preview)

What you need to get started - Intermediate Power BI

Module 01 - Getting Started 4 min.

Module 02A - Transforming Data (Appending Queries) 26 min.

Module 02B - Transforming Data (Combine Files) 25 min.

Module 02C - Transforming Data (Merging Queries) 32 min.

Module 02D - Transforming Data (Writing Basic M) 30 min.

Module 02E - Transforming Data (Parameters and Templates) 36 min.

Module 02G - Transforming Data (Usability Features) 10 min.

Module 02H - Transforming Data (Direct Query) 21 min.

Module 03 - Creating the Data Model 61 min.

Module 04A - Creating Calculated Columns and Tables (Navigation Functions) 21 min.

Module 04B - Creating Calculated Columns and Tables (Calculated Tables) 18 min.

Module 04C - Creating Calculated Measures (Time intelligence Functions) 25 min.

Module 05 - Additional Model Enhancements 30 min.

Module 06 - Advanced Visual Options 28 min.

Module 07A - Creating Interactive Reports (Power BI AI Capabilities) 16 min.

Module 07B - Creating Interactive Reports (Data Storytelling) 28 min.

Module 08A - Using the Power BI Service (Subscriptions and Alerts) 9 min.

Module 08B - Using the Power BI Service (Excel Integration) 8 min.

Module 08C - Using the Power BI Service (Export and Embed Options) 13 min.

Module 08D - Using the Power BI Service (Dataflows and Datamarts) 18 min.

Module 08E - Using the Power BI Service (Paginated Reports) 9 min.

Module 08F - Using the Power BI Service (Data Modeling in the Service) 15 min.

Module 09 - Refreshing the Data 11 min.

Module 10 - Class Outro 2 min.

This course includes:

  • 8+ hours of training
  • 25 Modules
  • * Access on mobile and browser
  • Certificate of Completion