Free online assessment

Assess your Microsoft Power Pivot skills for free

Bilingual Microsoft Power Pivot 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

Data model

3-hour applied workshop to bring multiple tables into a relational model, including workplace practice and a skills check.

  • Identify scenarios that require the team to bring multiple tables into a relational model.
  • Prepare the assets and settings for “Data model”.
  • Complete a hands-on task to bring multiple tables into a relational model.
  • Diagnose and correct a mistake involving “Data model”.
  • Quality-check and document the results produced with “Data model”.
3 h
02
Topic M02

Fact and dimension tables

3-hour applied workshop to separate business measures from analysis dimensions, including workplace practice and a skills check.

  • Identify scenarios that require the team to separate business measures from analysis dimensions.
  • Prepare the assets and settings for “Fact and dimension tables”.
  • Complete a hands-on task to separate business measures from analysis dimensions.
  • Diagnose and correct a mistake involving “Fact and dimension tables”.
  • Quality-check and document the results produced with “Fact and dimension tables”.
3 h
03
Topic M03

Table relationships

3-hour applied workshop to connect records through compatible keys, including workplace practice and a skills check.

  • Identify scenarios that require the team to connect records through compatible keys.
  • Prepare the assets and settings for “Table relationships”.
  • Complete a hands-on task to connect records through compatible keys.
  • Diagnose and correct a mistake involving “Table relationships”.
  • Quality-check and document the results produced with “Table relationships”.
3 h
04
Topic M04

Date tables

3-hour applied workshop to build a consistent calendar for analysis, including workplace practice and a skills check.

  • Identify scenarios that require the team to build a consistent calendar for analysis.
  • Prepare the assets and settings for “Date tables”.
  • Complete a hands-on task to build a consistent calendar for analysis.
  • Diagnose and correct a mistake involving “Date tables”.
  • Quality-check and document the results produced with “Date tables”.
3 h
05
Topic M05

DAX measures

3-hour applied workshop to calculate reusable metrics in the model, including workplace practice and a skills check.

  • Identify scenarios that require the team to calculate reusable metrics in the model.
  • Prepare the assets and settings for “DAX measures”.
  • Complete a hands-on task to calculate reusable metrics in the model.
  • Diagnose and correct a mistake involving “DAX measures”.
  • Quality-check and document the results produced with “DAX measures”.
3 h
06
Topic M06

Calculated columns

3-hour applied workshop to distinguish row-level calculations from measures, including workplace practice and a skills check.

  • Identify scenarios that require the team to distinguish row-level calculations from measures.
  • Prepare the assets and settings for “Calculated columns”.
  • Complete a hands-on task to distinguish row-level calculations from measures.
  • Diagnose and correct a mistake involving “Calculated columns”.
  • Quality-check and document the results produced with “Calculated columns”.
3 h
07
Topic M07

Filter context

3-hour applied workshop to interpret measures under active filters, including workplace practice and a skills check.

  • Identify scenarios that require the team to interpret measures under active filters.
  • Prepare the assets and settings for “Filter context”.
  • Complete a hands-on task to interpret measures under active filters.
  • Diagnose and correct a mistake involving “Filter context”.
  • Quality-check and document the results produced with “Filter context”.
3 h
08
Topic M08

Row context

3-hour applied workshop to understand evaluation on each row, including workplace practice and a skills check.

  • Identify scenarios that require the team to understand evaluation on each row.
  • Prepare the assets and settings for “Row context”.
  • Complete a hands-on task to understand evaluation on each row.
  • Diagnose and correct a mistake involving “Row context”.
  • Quality-check and document the results produced with “Row context”.
3 h
09
Topic M09

CALCULATE

3-hour applied workshop to modify the evaluation context of a measure, including workplace practice and a skills check.

  • Identify scenarios that require the team to modify the evaluation context of a measure.
  • Prepare the assets and settings for “CALCULATE”.
  • Complete a hands-on task to modify the evaluation context of a measure.
  • Diagnose and correct a mistake involving “CALCULATE”.
  • Quality-check and document the results produced with “CALCULATE”.
3 h
10
Topic M10

SUMX and iterators

3-hour applied workshop to sum expressions evaluated across rows, including workplace practice and a skills check.

  • Identify scenarios that require the team to sum expressions evaluated across rows.
  • Prepare the assets and settings for “SUMX and iterators”.
  • Complete a hands-on task to sum expressions evaluated across rows.
  • Diagnose and correct a mistake involving “SUMX and iterators”.
  • Quality-check and document the results produced with “SUMX and iterators”.
3 h
11
Topic M11

ALL and REMOVEFILTERS

3-hour applied workshop to selectively remove report filters, including workplace practice and a skills check.

  • Identify scenarios that require the team to selectively remove report filters.
  • Prepare the assets and settings for “ALL and REMOVEFILTERS”.
  • Complete a hands-on task to selectively remove report filters.
  • Diagnose and correct a mistake involving “ALL and REMOVEFILTERS”.
  • Quality-check and document the results produced with “ALL and REMOVEFILTERS”.
3 h
12
Topic M12

RELATED and RELATEDTABLE

3-hour applied workshop to retrieve values across related tables, including workplace practice and a skills check.

  • Identify scenarios that require the team to retrieve values across related tables.
  • Prepare the assets and settings for “RELATED and RELATEDTABLE”.
  • Complete a hands-on task to retrieve values across related tables.
  • Diagnose and correct a mistake involving “RELATED and RELATEDTABLE”.
  • Quality-check and document the results produced with “RELATED and RELATEDTABLE”.
3 h
13
Topic M13

DISTINCTCOUNT

3-hour applied workshop to count unique identifiers instead of rows, including workplace practice and a skills check.

  • Identify scenarios that require the team to count unique identifiers instead of rows.
  • Prepare the assets and settings for “DISTINCTCOUNT”.
  • Complete a hands-on task to count unique identifiers instead of rows.
  • Diagnose and correct a mistake involving “DISTINCTCOUNT”.
  • Quality-check and document the results produced with “DISTINCTCOUNT”.
3 h
14
Topic M14

Time intelligence

3-hour applied workshop to calculate running totals and period comparisons, including workplace practice and a skills check.

  • Identify scenarios that require the team to calculate running totals and period comparisons.
  • Prepare the assets and settings for “Time intelligence”.
  • Complete a hands-on task to calculate running totals and period comparisons.
  • Diagnose and correct a mistake involving “Time intelligence”.
  • Quality-check and document the results produced with “Time intelligence”.
3 h
15
Topic M15

Hierarchies

3-hour applied workshop to navigate between levels in a dimension, including workplace practice and a skills check.

  • Identify scenarios that require the team to navigate between levels in a dimension.
  • Prepare the assets and settings for “Hierarchies”.
  • Complete a hands-on task to navigate between levels in a dimension.
  • Diagnose and correct a mistake involving “Hierarchies”.
  • Quality-check and document the results produced with “Hierarchies”.
3 h
16
Topic M16

Key performance indicators

3-hour applied workshop to present targets and performance indicators, including workplace practice and a skills check.

  • Identify scenarios that require the team to present targets and performance indicators.
  • Prepare the assets and settings for “Key performance indicators”.
  • Complete a hands-on task to present targets and performance indicators.
  • Diagnose and correct a mistake involving “Key performance indicators”.
  • Quality-check and document the results produced with “Key performance indicators”.
3 h
17
Topic M17

Perspectives

3-hour applied workshop to define a model view suited to an audience, including workplace practice and a skills check.

  • Identify scenarios that require the team to define a model view suited to an audience.
  • Prepare the assets and settings for “Perspectives”.
  • Complete a hands-on task to define a model view suited to an audience.
  • Diagnose and correct a mistake involving “Perspectives”.
  • Quality-check and document the results produced with “Perspectives”.
3 h
18
Topic M18

Model optimization

3-hour applied workshop to reduce cardinality and unnecessary columns, including workplace practice and a skills check.

  • Identify scenarios that require the team to reduce cardinality and unnecessary columns.
  • Prepare the assets and settings for “Model optimization”.
  • Complete a hands-on task to reduce cardinality and unnecessary columns.
  • Diagnose and correct a mistake involving “Model optimization”.
  • Quality-check and document the results produced with “Model optimization”.
3 h
19
Topic M19

Grand total validation

3-hour applied workshop to explain discrepancies between totals and filtered rows, including workplace practice and a skills check.

  • Identify scenarios that require the team to explain discrepancies between totals and filtered rows.
  • Prepare the assets and settings for “Grand total validation”.
  • Complete a hands-on task to explain discrepancies between totals and filtered rows.
  • Diagnose and correct a mistake involving “Grand total validation”.
  • Quality-check and document the results produced with “Grand total validation”.
3 h
20
Topic M20

Measure maintenance

3-hour applied workshop to document and test metric definitions, including workplace practice and a skills check.

  • Identify scenarios that require the team to document and test metric definitions.
  • Prepare the assets and settings for “Measure maintenance”.
  • Complete a hands-on task to document and test metric definitions.
  • Diagnose and correct a mistake involving “Measure maintenance”.
  • Quality-check and document the results produced with “Measure maintenance”.
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 Pivot skills?

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

Take the free test