Build practical Power Query data transformation skills in one day.
Nexacu’s Data Transformation with Power Query course helps Power BI users clean, shape and prepare data more efficiently using Power Query Editor.
This instructor-led course covers data sources, data models, table transformations, custom columns, query management, M functions, Advanced Editor, M code and parameterised custom functions.
Quick Answer
Data Transformation with Power Query is a one-day course for Power BI users who want to clean, transform and prepare data more effectively. The course covers Power Query Editor, importing data from multiple sources, table transformations, query management, M functions, Advanced Editor, M code and parameterised custom functions. Intermediate Excel skills are recommended.
Who should attend?
Power BI users, Excel users, analysts, reporting teams, finance teams and data professionals who need to clean, combine and transform data before building reports.
What will you learn?
Learn how to import data, perform table transformations, merge and append queries, create custom columns, use M functions and edit queries in Advanced Editor.
Prerequisite: No formal prerequisites are required, but intermediate Excel skills are recommended. Power Query knowledge is helpful for those working with data preparation in Power BI.
This course can also be taken as part of the PL-300 Power BI Certification pathway.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. In-class and remote training.
Power BI AdvancedAdvance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.
Power BI DAXLearn Power BI DAX from our experienced trainers. Login remotely or attend our CBD locations nationwide.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Data Visualisation with Power BI DesktopLearn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
PL-300 Power BI Certification
Become a Microsoft Power BI certified expert. Attend our Nexacu Power BI courses, sit the PL-300 exam and become a Power BI Data Analyst Associate.
$2,170 inc GST
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
What is Power Query?
Power Query is a Microsoft data transformation tool used in Power BI and Excel. It helps users connect to data, clean it, reshape it, combine tables and prepare datasets for reporting and analysis.
What will I learn in the Data Transformation with Power Query course?
You will learn how to use Power Query Editor to import data, perform table transformations, add custom columns, sort and filter data, replace values, merge and append queries, group data, use M functions and edit queries in Advanced Editor.
Who should attend this Power Query course?
This course is suitable for Power BI users, Excel users, analysts, reporting teams, finance teams and data professionals who need to clean, combine and transform data before creating reports or dashboards.
Do I need Power Query experience before attending?
No formal Power Query experience is required. Intermediate Excel skills are recommended, and prior exposure to Power Query is helpful for people working with data preparation in Power BI.
Is this course suitable for Power BI users?
Yes. This course is designed for people who use Power BI and need stronger data preparation skills. It focuses on Power Query Editor and the transformation steps used before building reports and dashboards.
Does this course cover Power Query Editor?
Yes. The course covers Power Query Editor, including its interface, common transformation tools, custom columns, query management and editing queries in Advanced Editor.
Does this course cover M code?
Yes. Participants learn Power Query Formula Language, also known as M, including M functions, syntax, Advanced Editor and practical M code editing for more complex transformations.
Will I learn how to merge and append queries?
Yes. The course covers query management techniques including merging, renaming and appending queries, as well as grouping and organising multiple queries for analysis.
Does this course cover custom functions?
Yes. The course covers creating and using parameterised custom functions, including turning a query into a parameter-based custom function and invoking custom functions within Power Query Editor.
Can I take this Power Query course online?
Yes. Nexacu offers this course as instructor-led live online training, with face-to-face options also available where scheduled. Remote participants can ask questions, complete exercises and receive trainer support during the session.
What is remote Power BI training?
Remote Power BI training is delivered live online by an instructor. Participants attend via video conferencing, ask questions, join discussions, complete exercises and interact with the trainer throughout the course.
Is Data Transformation with Power Query part of the PL-300 certification pathway?
Yes. This course can be taken as part of Nexacu’s PL-300 Power BI Certification pathway for learners who want to build a broader Power BI skill set.
What Power BI course should I take after this course?
After Data Transformation with Power Query, many learners progress to Power BI Intermediate, Power BI Advanced, Power BI DAX, Power BI Desktop Advanced Reporting or PL-300 Power BI Certification, depending on their current skill level and goals.
Will I receive a certificate after completing this course?
Yes. Participants receive a certificate of completion, which can be added to a resumé or LinkedIn profile to acknowledge their Power Query and Power BI training.
Ready to improve your Power Query skills?
Choose an upcoming Data Transformation with Power Query course date and learn how to clean, combine and transform data more effectively for Power BI reporting.
Power BI Training in Brisbane
View Dates
Power BI Training in Melbourne
View Dates
Power BI Training in Sydney
View Dates
Power BI Training in Adelaide
View Dates
Power BI Training in Perth
View Dates
Power BI Training in Canberra
View Dates
Power BI Training in Remote Online
View Dates Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. In-class and remote training.
Power BI AdvancedAdvance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.
Power BI DAXLearn Power BI DAX from our experienced trainers. Login remotely or attend our CBD locations nationwide.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Data Visualisation with Power BI DesktopLearn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
PL-300 Power BI Certification
Become a Microsoft Power BI certified expert. Attend our Nexacu Power BI courses, sit the PL-300 exam and become a Power BI Data Analyst Associate.
$2,170 inc GST
Power BI Training in Brisbane
View Dates
Power BI Training in Melbourne
View Dates
Power BI Training in Sydney
View Dates
Power BI Training in Adelaide
View Dates
Power BI Training in Perth
View Dates
Power BI Training in Canberra
View Dates
Power BI Training in Remote Online
View Datesat Nexacu, we're proud to be the trusted training partner for hundreds of leading organisations accross Australia and New Zealand. From government departments to top corporates, we help teams upskill and succeed everyday
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Resit your course for free within 6 Months
Valued by Individuals
