All courses available in-class or remotely. To attend remotely, select "Remote East" or "Remote West" as your location on book now.
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.
Upon completion of this course you will be able to:
No formal prerequisites, but intermediate Excel skills are recommended. Power Query knowledge is helpful for those working with data preparation in Power BI.
Take this course as part of the PL-300 Power BI Certification and save:
PL-300 Power BI Certification
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 BI?
Power BI is Microsoft’s business intelligence and data visualisation platform. It helps users connect to data, clean and transform datasets, build reports, create dashboards and share insights across an organisation.
What Power BI courses does Nexacu offer?
Nexacu offers Power BI Beginner, Power BI Intermediate, Power BI Advanced, Power BI DAX, Data Transformation with Power Query, Power BI Desktop Advanced Reporting, Data Visualisation with Power BI Desktop and PL-300 Power BI Certification.
Which Power BI course should I start with?
If you are new to Power BI, start with Power BI Beginner. If you already understand the basics, Power BI Intermediate is a suitable next step. More experienced users may choose Power BI Advanced, Power BI DAX, Data Transformation with Power Query or Power BI Desktop Advanced Reporting, depending on their goals.
Are Power BI courses suitable for beginners?
Yes. Power BI Beginner is designed for people who are new to Power BI and want to learn how to create reports, dashboards and visualisations. Basic confidence working with data, especially in Excel, is helpful.
What will I learn in Power BI training?
Depending on the course level, you may learn how to connect to data, transform data with Power Query, create data models, build visualisations, design dashboards, write DAX measures, manage filters, publish reports and share insights through the Power BI service.
Is Power BI training relevant for workplace reporting?
Yes. Nexacu’s Power BI courses are designed around practical workplace reporting and business intelligence tasks, including interactive dashboards, data models, automated reporting, DAX calculations, Power Query transformations and shared reports.
How difficult is Power BI to learn?
Power BI is accessible for beginners, but the difficulty depends on your experience with data, Excel, reporting and business intelligence concepts. Most learners start with the basics, then progress into data modelling, Power Query, DAX and advanced reporting as their needs grow.
Do I need Excel experience before learning Power BI?
Excel experience is helpful, especially if you work with spreadsheets, tables, PivotTables, charts or business data. It is not always required, but basic data confidence will help you get more from Power BI training.
Does Power BI training include DAX?
Yes. DAX is introduced in some Power BI courses and covered in more depth in Power BI Advanced and Power BI DAX. Learners who need stronger calculation, measure and modelling skills should consider the dedicated Power BI DAX course.
Does Power BI training include Power Query?
Yes. Power Query is included in relevant Power BI courses and covered in detail in Data Transformation with Power Query. This course is useful for learners who need to clean, reshape, combine and prepare data before reporting.
Can I attend Power BI training online?
Yes. Nexacu offers live online Power BI training through Remote East and Remote West sessions. Remote courses are instructor-led, so participants can ask questions, join discussions, complete exercises and receive trainer support during the class.
Where are face-to-face Power BI courses available?
Nexacu offers face-to-face Power BI courses in major Australian cities where scheduled, including Sydney, Melbourne, Brisbane, Canberra, Adelaide and Perth. Live online attendance is also available for remote learners.
Is Power BI training available for corporate teams?
Yes. Nexacu provides Power BI corporate training for teams and organisations that need consistent skills in reporting, dashboards, data modelling, DAX, Power Query and business intelligence workflows.
Is PL-300 Power BI Certification available?
Yes. Nexacu offers PL-300 Power BI Certification as part of its Power BI course pathway. This pathway is suitable for learners who want to develop broader Power BI capability and prepare for Microsoft Power BI certification.
How many students are typically in a Power BI course?
Class sizes vary by session, but Nexacu generally keeps Power BI classes small so participants can ask questions, take part in discussion and receive trainer support throughout the course.
Will I receive a certificate after completing Power BI training?
Yes. Participants receive a certificate of completion, which can be added to a resumé or LinkedIn profile to acknowledge their Power BI training.
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 across 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
Learn with expert instructors, wherever you are
Valued by Individuals
