Australia
New Zealand
Hong Kong
Malaysia
Philippines
Thailand
Indonesia
Data Transformation using Power Query Editor, Power BI Desktop
Transform and manage data with Power Query in Excel and Power BI Desktop
This 1-day course comprehensively explores the use of Power Query for working with the Data Model in both Excel 2016+ and Power BI Desktop. Power Query is a powerful data transformation tool that allows you to create and edit queries from various data sources. Learn how to use the Power Query Editor to perform data transformations, manage queries, and develop advanced transformation processes using M code.
Data Transformation using Power Query Editor, Power BI Desktop
Learn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.
We are busy updating this schedule.
Book a course in any city and remote login details will be provided.
Data Transformation using Power Query Editor, Power BI Desktop Course Details
Power BI Course Outlines
-
-
-
-
-
-
-
-
DA-100 Power BI Certification
Skills Test
Contact Us
What do I need to know to attend?
There are no formal prerequisites, but this course is suitable for intermediate Excel users. Power Query knowledge is recommended for those heavily involved in data preparation or correction, especially when using Power BI Desktop.
Data Transformation using Power Query Editor, Power BI Desktop Learning Outcomes
Upon completion of this course you will be able to:
- Assess and manipulate data for use within the Data Model in Excel and Power BI Desktop
- Understand M syntax, definitions, and objects to develop advanced transformation processes
- Utilise a variety of operations and functions within M
- Create and invoke parameterised queries as custom functions
Data Transformation using Power Query Editor, Power BI Desktop Course Content
- The Data Model and Power Query Editor
- Understanding the Data Model in Excel 2016+ and Power BI Desktop
- Creating queries from different data sources: SQL databases, Web pages, Excel spreadsheets, and text files
- Overview of the Power Query Editor and its interface
- Beginning Operations in Power Query Formula Language
- Performing basic data and table transformations
- Adding and removing calculated custom columns
- Sorting, filtering, and replacing values within data
- Query Management Techniques
- Merging, renaming, and appending queries
- Grouping data within queries for analysis
- Managing and organising multiple queries
- Working with M Functions
- Introduction to M functions: Text, Date, Time, List Generators
- Using the Column from Examples feature for custom column creation
- Creating and managing custom column functions
- Using blank queries and List Generator functions for advanced transformations
- Learning Power Query Formula Language Syntax
- Navigating the Advanced Editor for M code editing
- Understanding and writing Power Query Formula Language (M)
- Practical exercises in editing M code for complex transformations
- Creating and Using Parameterised Custom Functions
- Turning a query into a parameter-based custom function
- Invoking custom functions within the Power Query Editor
- Practical applications of parameterised functions in data workflows
phone
email
enquiry
