Power BI

Improve insights and decision-making with interactive visualizations and advanced BI tools that make the most of your data.


  • Dashboards and Visualizations
  • Online Service and Data Connections
  • The Query Editor and DAX
  • Power BI Case Study


The Query Editor and DAX

Learn the more technical side of Power BI. The Query Editor lets you transform and load data, while DAX lets you add functions and formulas to your data models.

Query editor 1

1. The Query Editor

The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we’ll import files from a folder, combine them into one query, and transform the data using the Query Editor.

15 Lessons
72 minutes
Created with Sketch. Intermediate
CPD Credits
Introduction to dax

2. Introduction to DAX

Power BI’s formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.

12 Lessons
53 minutes
Created with Sketch. Intermediate
CPD Credits
Advanced dax functions concepts

3. Advanced DAX Functions and Concepts

This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel’s, such as row and filter contexts.

13 Lessons
64 minutes
Created with Sketch. Advanced
CPD Credits
Practical applications dax

4. Practical Applications of DAX

Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.

9 Lessons
49 minutes
Created with Sketch. Advanced
CPD Credits