The Query Editor

Summary

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 kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00
CPD hours:  
3.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

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.