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:

  • 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

Prerequisite:

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

Course Details

Download Course PDF
Price
Rp 6.420K
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
N/A

Upcoming Courses

Remote JKT

Remote JKT

We currently have no public courses scheduled. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Power BI Training Courses

Course Icon Power BI Beginner

Learn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.

download course pdf
Price: Rp 4.077K
Course Icon Power BI Intermediate

Learn to build data models and calculations to produce intelligent dashboards. In-class and remote training.

download course pdf
Price: Rp 6.142K
Course Icon Power BI Advanced

Advance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.

download course pdf
Price: Rp 6.142K
Course Icon Power BI DAX

Learn Power BI DAX from our experienced trainers. Login remotely or attend our CBD locations nationwide.

download course pdf
Price: Rp 6.142K
Course Icon Power BI Desktop Advanced Reporting

Master advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.

download course pdf
Price: Rp 6.420K
Course Icon Data Visualisation with Power BI Desktop

Learn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.

download course pdf
Price: Rp 6.420K
DA-100 Power BI Certification

Achieve your Power BI certification with Nexacu. Join remotely from Jakarta while you attend training courses and prepare to sit the DA-100 exam.

Price: 

RP 25.200K

Data Transformation using Power Query Editor, Power BI Desktop Course Content

Expand All | Collapse All

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

Common questions

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.

Course Details

Download Course PDF
Price
Rp 6.420K
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
N/A

skills test nexacu

Skills Test

Try our short skills test and find out which course is right for you.

 skills test

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Related Training Courses

Course Icon Power BI Beginner

Learn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.

download course pdf
Price: Rp 4.077K
Course Icon Power BI Intermediate

Learn to build data models and calculations to produce intelligent dashboards. In-class and remote training.

download course pdf
Price: Rp 6.142K
Course Icon Power BI Advanced

Advance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.

download course pdf
Price: Rp 6.142K
Course Icon Power BI DAX

Learn Power BI DAX from our experienced trainers. Login remotely or attend our CBD locations nationwide.

download course pdf
Price: Rp 6.142K
Course Icon Power BI Desktop Advanced Reporting

Master advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.

download course pdf
Price: Rp 6.420K
Course Icon Data Visualisation with Power BI Desktop

Learn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.

download course pdf
Price: Rp 6.420K
DA-100 Power BI Certification

Achieve your Power BI certification with Nexacu. Join remotely from Jakarta while you attend training courses and prepare to sit the DA-100 exam.

Price: 

RP 25.200K

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Trusted Globally by Leading Organisations

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.

  • 400+ companies rely on Nexacu for workforce development
  • Trusted by government agencies at all levels
  • Delivering training across 9 countries and growing

Why Nexacu? 

step by step courseware

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Interactive real time training

Interactive, Real-Time Training

Learn with expert instructors, wherever you are

Trusted by Business

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals