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.
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. Remote training in New Zealand.
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.
DA-100 Power BI Certification
Become a Microsoft Power BI certified expert in New Zealand. Attend our Nexacu Power BI courses, sit the DA-100 exam and become certified!
NZ $2,230
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 Remote Training?
Remote training at Nexacu, means our team of experienced trainers will deliver your training virtually. With remote learning students can access our usual classroom training courses via video conferencing, ask questions, participate in discussion and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.
Which courses are available remotely?
All of our Public Courses scheduled in across South East Asia and New Zealand are available to be delivered remotely. Book any course and you will receive login details to access our student portal. The Student portal contains all our your course information, instructions on getting set up for a remote class and free webinars.
What is Power BI?
Power BI is Microsoft's Data Visualization tool. The BI stands for Business Intelligence. Power BI enables users to connect with their data, cleanse it and build interactive dashboards to gain insights that drive actions.
Will the content in these Power BI Courses be relevant for the workplace?
Yes, our course writers and trainers have industry backgrounds. Our core principle is to deliver training that our students can not only use in the workplace but will actually drive increased efficiency and productivity gains. We teach the key elements of Power BI from Beginner to Advanced; starting with a focus on visualizations and quickly progressing to data manipulation and modelling. We also offer a DAX course.
How many students are typically in a Power BI Training Course?
While this varies from session to session, we typically have 5-8 students in our Power BI classes. We cap our classes at 10 students. This is to ensure the quality of training remains high and that all students can ask questions and engage in discussion.
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. Remote training in New Zealand.
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.
DA-100 Power BI Certification
Become a Microsoft Power BI certified expert in New Zealand. Attend our Nexacu Power BI courses, sit the DA-100 exam and become certified!
NZ $2,230
At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.
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
Australia
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Indonesia
