Free online assessment

Assess your Microsoft Power Query skills for free

Bilingual Microsoft Power Query assessment: 45 randomized questions from a bank of 100, three skill levels and 20 gap-based training modules.

This assessment measures knowledge and produces a practical diagnostic. Recommended modules are learning suggestions, not paid courses.

What is assessed

Questions about practical workplace skills

The assessment covers various knowledge topics with beginner, intermediate and advanced questions. Your score and topic breakdown highlight areas for review.

This is not a certification, qualification or official driver exam. For driving, always follow official provincial rules and requirements.

Who can use it

digital solutions professional

  • Employees and applicants.
  • HR professionals.
  • Employers, managers and team leads.
Assessment learning framework

Modules that may appear in your recommended plan

The topics below form the recommendation framework associated with this assessment. The system selects priorities using individual answers and proposes a plan to use independently with a provider of your choice. We do not deliver these courses through this website.

01
Topic M01

Source import

3-hour applied workshop to import data from files and different systems, including workplace practice and a skills check.

  • Identify scenarios that require the team to import data from files and different systems.
  • Prepare the assets and settings for “Source import”.
  • Complete a hands-on task to import data from files and different systems.
  • Diagnose and correct a mistake involving “Source import”.
  • Quality-check and document the results produced with “Source import”.
3 h
02
Topic M02

Power Query Editor

3-hour applied workshop to prepare transformations before loading data, including workplace practice and a skills check.

  • Identify scenarios that require the team to prepare transformations before loading data.
  • Prepare the assets and settings for “Power Query Editor”.
  • Complete a hands-on task to prepare transformations before loading data.
  • Diagnose and correct a mistake involving “Power Query Editor”.
  • Quality-check and document the results produced with “Power Query Editor”.
3 h
03
Topic M03

Data types

3-hour applied workshop to assign appropriate types to each column, including workplace practice and a skills check.

  • Identify scenarios that require the team to assign appropriate types to each column.
  • Prepare the assets and settings for “Data types”.
  • Complete a hands-on task to assign appropriate types to each column.
  • Diagnose and correct a mistake involving “Data types”.
  • Quality-check and document the results produced with “Data types”.
3 h
04
Topic M04

Filtering and sorting

3-hour applied workshop to select the rows relevant to analysis, including workplace practice and a skills check.

  • Identify scenarios that require the team to select the rows relevant to analysis.
  • Prepare the assets and settings for “Filtering and sorting”.
  • Complete a hands-on task to select the rows relevant to analysis.
  • Diagnose and correct a mistake involving “Filtering and sorting”.
  • Quality-check and document the results produced with “Filtering and sorting”.
3 h
05
Topic M05

Text cleaning

3-hour applied workshop to remove unwanted whitespace and characters, including workplace practice and a skills check.

  • Identify scenarios that require the team to remove unwanted whitespace and characters.
  • Prepare the assets and settings for “Text cleaning”.
  • Complete a hands-on task to remove unwanted whitespace and characters.
  • Diagnose and correct a mistake involving “Text cleaning”.
  • Quality-check and document the results produced with “Text cleaning”.
3 h
06
Topic M06

Split and merge columns

3-hour applied workshop to reshape fields without changing the source, including workplace practice and a skills check.

  • Identify scenarios that require the team to reshape fields without changing the source.
  • Prepare the assets and settings for “Split and merge columns”.
  • Complete a hands-on task to reshape fields without changing the source.
  • Diagnose and correct a mistake involving “Split and merge columns”.
  • Quality-check and document the results produced with “Split and merge columns”.
3 h
07
Topic M07

Replace values

3-hour applied workshop to standardize inconsistent values or codes, including workplace practice and a skills check.

  • Identify scenarios that require the team to standardize inconsistent values or codes.
  • Prepare the assets and settings for “Replace values”.
  • Complete a hands-on task to standardize inconsistent values or codes.
  • Diagnose and correct a mistake involving “Replace values”.
  • Quality-check and document the results produced with “Replace values”.
3 h
08
Topic M08

Remove duplicates

3-hour applied workshop to identify duplicates using an appropriate key, including workplace practice and a skills check.

  • Identify scenarios that require the team to identify duplicates using an appropriate key.
  • Prepare the assets and settings for “Remove duplicates”.
  • Complete a hands-on task to identify duplicates using an appropriate key.
  • Diagnose and correct a mistake involving “Remove duplicates”.
  • Quality-check and document the results produced with “Remove duplicates”.
3 h
09
Topic M09

Error handling

3-hour applied workshop to detect and handle invalid values, including workplace practice and a skills check.

  • Identify scenarios that require the team to detect and handle invalid values.
  • Prepare the assets and settings for “Error handling”.
  • Complete a hands-on task to detect and handle invalid values.
  • Diagnose and correct a mistake involving “Error handling”.
  • Quality-check and document the results produced with “Error handling”.
3 h
10
Topic M10

Conditional columns

3-hour applied workshop to derive a classification from conditions, including workplace practice and a skills check.

  • Identify scenarios that require the team to derive a classification from conditions.
  • Prepare the assets and settings for “Conditional columns”.
  • Complete a hands-on task to derive a classification from conditions.
  • Diagnose and correct a mistake involving “Conditional columns”.
  • Quality-check and document the results produced with “Conditional columns”.
3 h
11
Topic M11

Merge queries

3-hour applied workshop to join two tables using a common key, including workplace practice and a skills check.

  • Identify scenarios that require the team to join two tables using a common key.
  • Prepare the assets and settings for “Merge queries”.
  • Complete a hands-on task to join two tables using a common key.
  • Diagnose and correct a mistake involving “Merge queries”.
  • Quality-check and document the results produced with “Merge queries”.
3 h
12
Topic M12

Append queries

3-hour applied workshop to stack tables with a compatible structure, including workplace practice and a skills check.

  • Identify scenarios that require the team to stack tables with a compatible structure.
  • Prepare the assets and settings for “Append queries”.
  • Complete a hands-on task to stack tables with a compatible structure.
  • Diagnose and correct a mistake involving “Append queries”.
  • Quality-check and document the results produced with “Append queries”.
3 h
13
Topic M13

Group By

3-hour applied workshop to aggregate records by category or identifier, including workplace practice and a skills check.

  • Identify scenarios that require the team to aggregate records by category or identifier.
  • Prepare the assets and settings for “Group By”.
  • Complete a hands-on task to aggregate records by category or identifier.
  • Diagnose and correct a mistake involving “Group By”.
  • Quality-check and document the results produced with “Group By”.
3 h
14
Topic M14

Pivot and Unpivot

3-hour applied workshop to reshape data between wide and long formats, including workplace practice and a skills check.

  • Identify scenarios that require the team to reshape data between wide and long formats.
  • Prepare the assets and settings for “Pivot and Unpivot”.
  • Complete a hands-on task to reshape data between wide and long formats.
  • Diagnose and correct a mistake involving “Pivot and Unpivot”.
  • Quality-check and document the results produced with “Pivot and Unpivot”.
3 h
15
Topic M15

Query parameters

3-hour applied workshop to make import settings reusable, including workplace practice and a skills check.

  • Identify scenarios that require the team to make import settings reusable.
  • Prepare the assets and settings for “Query parameters”.
  • Complete a hands-on task to make import settings reusable.
  • Diagnose and correct a mistake involving “Query parameters”.
  • Quality-check and document the results produced with “Query parameters”.
3 h
16
Topic M16

Custom M functions

3-hour applied workshop to reuse transformations through functions, including workplace practice and a skills check.

  • Identify scenarios that require the team to reuse transformations through functions.
  • Prepare the assets and settings for “Custom M functions”.
  • Complete a hands-on task to reuse transformations through functions.
  • Diagnose and correct a mistake involving “Custom M functions”.
  • Quality-check and document the results produced with “Custom M functions”.
3 h
17
Topic M17

Refresh and privacy

3-hour applied workshop to refresh sources with appropriate privacy levels, including workplace practice and a skills check.

  • Identify scenarios that require the team to refresh sources with appropriate privacy levels.
  • Prepare the assets and settings for “Refresh and privacy”.
  • Complete a hands-on task to refresh sources with appropriate privacy levels.
  • Diagnose and correct a mistake involving “Refresh and privacy”.
  • Quality-check and document the results produced with “Refresh and privacy”.
3 h
18
Topic M18

Query folding

3-hour applied workshop to push transformations back to a compatible data source, including workplace practice and a skills check.

  • Identify scenarios that require the team to push transformations back to a compatible data source.
  • Prepare the assets and settings for “Query folding”.
  • Complete a hands-on task to push transformations back to a compatible data source.
  • Diagnose and correct a mistake involving “Query folding”.
  • Quality-check and document the results produced with “Query folding”.
3 h
19
Topic M19

Performance and applied steps

3-hour applied workshop to reduce unnecessarily expensive transformations, including workplace practice and a skills check.

  • Identify scenarios that require the team to reduce unnecessarily expensive transformations.
  • Prepare the assets and settings for “Performance and applied steps”.
  • Complete a hands-on task to reduce unnecessarily expensive transformations.
  • Diagnose and correct a mistake involving “Performance and applied steps”.
  • Quality-check and document the results produced with “Performance and applied steps”.
3 h
20
Topic M20

Prepared-model validation

3-hour applied workshop to validate keys and data quality in the loaded model, including workplace practice and a skills check.

  • Identify scenarios that require the team to validate keys and data quality in the loaded model.
  • Prepare the assets and settings for “Prepared-model validation”.
  • Complete a hands-on task to validate keys and data quality in the loaded model.
  • Diagnose and correct a mistake involving “Prepared-model validation”.
  • Quality-check and document the results produced with “Prepared-model validation”.
3 h
Assessment output

Actionable insight, not a sales pitch

The report provides an overall score, category breakdown and recommended modules. Use it to inform development discussions, document progress or complement candidate assessment.

View business use cases →

Privacy and recipients

The participant provides their email and that of the manager or authorized report recipient. The tool emails the report to those recipients according to its current process. Do not enter a third party without permission.

Review privacy information
Free assessment

Ready to assess your Microsoft Power Query skills?

45 questions and a suggested development plan. No course enrollment.

Take the free test