The Query Editor - check


The Query Editor is Power BI Desktop’s tool for importing, processing and cleaning data. In this course you’ll learn how to transform data into the right format for analysis in Power BI, in just a few clicks. You’ll apply key concepts through case-study style learning, with concise lessons and applied assessments.   This course was created & customized for Chartered Accountants Ireland by

Venue details:  
Online EU, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2022 00:00
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00 Training Tickets accepted
CPD hours:  
Speaker details
No speakers have been associated with this event.


Product type:  
CPD online course
Technology and data

Who Should Attend?

This is a course for advanced learners. You should be familiar with importing data into Power BI Desktop, but you don’t need experience of the Query Editor. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to clean and transform data in the Power BI environment.

Course Overview

This Kubicle course contains 13 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Connecting to Multiple Files
  • Pivoting and Unpivoting
  • Assigning Data Types
  • Merging and Appending Queries
  • Filtering Queriess
  • Custom and Conditional Columns
  • Overview of M Formulas
  • Editing Queries and Loading to Power BI
  • Updating and Refreshing the Query

Key Outcomes

Once you’ve completed this course, you’ll understand how to transform a data set using Power Query. You’ll understand what format your data should be in, and you’ll be able to perform various useful actions that will transform your data to that format. The skills you’ll learn in this course will enable you to work with any kind of data and help you automate tedious data transformation tasks.