Free online assessment

Assess your Microsoft Power BI — data analysis skills for free

45 random questions from 100 to assess knowledge and recommend a tailored learning plan. Independent knowledge assessment to guide personal preparation. No official exam or credential is provided. May help identify topics to review during personal preparation for PL-300, without replicating or replacing its exam.

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

business intelligence analyst

  • 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

Power BI ecosystem and workflow

3-hour workshop on Power BI Desktop: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Power BI Desktop.
  • Apply “Power BI Desktop” in a focused Power BI ecosystem and workflow exercise.
  • Use “build queries, semantic models, and reports on the desktop” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Power BI Desktop.
  • Produce a quality-checked deliverable demonstrating Power BI Desktop.
3 h
02
Topic M02

Power BI Service

3-hour workshop on Power BI Service: guided practice, realistic scenarios and skills verification.

  • Publish, share, and consume analytics content in the cloud
  • Organize tables, relationships, and calculations used by reports
  • Use “publish, share, and consume analytics content in the cloud” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Power BI Service.
  • Produce a quality-checked deliverable demonstrating Power BI Service.
3 h
03
Topic M03

Semantic model and Report

3-hour workshop on Semantic model and Report: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Semantic model and Report.
  • Apply “Semantic model” in a focused Power BI ecosystem and workflow exercise.
  • Use “Report” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Semantic model and Report.
  • Produce a quality-checked deliverable demonstrating Semantic model and Report.
3 h
04
Topic M04

Connecting and preparing with Power Query

3-hour workshop on Data connector and Power Query: guided practice, realistic scenarios and skills verification.

  • Connect to a source such as Excel, SQL, or an online service
  • Clean, transform, and combine data before the model
  • Use “Power Query” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Data connector and Power Query.
  • Produce a quality-checked deliverable demonstrating Data connector and Power Query.
3 h
05
Topic M05

Data type and Query folding

3-hour workshop on Data type and Query folding: guided practice, realistic scenarios and skills verification.

  • Correctly define text, number, date, or other types for transformations and calculations
  • Push eligible transformations back to the source when possible
  • Use “Query folding” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Data type and Query folding.
  • Produce a quality-checked deliverable demonstrating Data type and Query folding.
3 h
06
Topic M06

Modeling and star schema

3-hour workshop on Fact table and Dimension table: guided practice, realistic scenarios and skills verification.

  • Store events or measurements at the defined process grain
  • Describe analysis dimensions such as date, product, or customer
  • Use “Dimension table” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Fact table and Dimension table.
  • Produce a quality-checked deliverable demonstrating Fact table and Dimension table.
3 h
07
Topic M07

Relationship and Cardinality

3-hour workshop on Relationship and Cardinality: guided practice, realistic scenarios and skills verification.

  • Connect tables so filters propagate correctly
  • Define relationship type such as one-to-many based on key uniqueness
  • Use “Cardinality” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Relationship and Cardinality.
  • Produce a quality-checked deliverable demonstrating Relationship and Cardinality.
3 h
08
Topic M08

DAX, measures and contexts

3-hour workshop on Measure: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Measure.
  • Apply “Measure” in a focused DAX, measures and contexts exercise.
  • Use “dynamically calculate a value according to report context” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Measure.
  • Produce a quality-checked deliverable demonstrating Measure.
3 h
09
Topic M09

Calculated column

3-hour workshop on Calculated column: guided practice, realistic scenarios and skills verification.

  • Calculate a row-by-row value stored in the model
  • Determine which rows contribute to a DAX calculation
  • Use “calculate a row-by-row value stored in the model” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Calculated column.
  • Produce a quality-checked deliverable demonstrating Calculated column.
3 h
10
Topic M10

Filter context and CALCULATE

3-hour workshop on Filter context and CALCULATE: guided practice, realistic scenarios and skills verification.

  • Identify the settings and tools required for Filter context and CALCULATE.
  • Apply “Filter context” in a focused DAX, measures and contexts exercise.
  • Use “CALCULATE” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Filter context and CALCULATE.
  • Produce a quality-checked deliverable demonstrating Filter context and CALCULATE.
3 h
11
Topic M11

Visuals and report design

3-hour workshop on Slicer and Drill-through: guided practice, realistic scenarios and skills verification.

  • Let the user interactively filter visuals
  • Navigate to a detail page while carrying selection context
  • Use “Drill-through” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Slicer and Drill-through.
  • Produce a quality-checked deliverable demonstrating Slicer and Drill-through.
3 h
12
Topic M12

Report tooltip and Conditional formatting

3-hour workshop on Report tooltip and Conditional formatting: guided practice, realistic scenarios and skills verification.

  • Show additional context when hovering over a data point
  • Vary a value s appearance according to rules or measures
  • Use “Conditional formatting” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Report tooltip and Conditional formatting.
  • Produce a quality-checked deliverable demonstrating Report tooltip and Conditional formatting.
3 h
13
Topic M13

Analytics, time and indicators

3-hour workshop on Time intelligence and KPI: guided practice, realistic scenarios and skills verification.

  • Compare periods using a date table and suitable measures
  • Compare a measure with a target or expected state
  • Use “KPI” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Time intelligence and KPI.
  • Produce a quality-checked deliverable demonstrating Time intelligence and KPI.
3 h
14
Topic M14

What-if parameter and Decomposition tree

3-hour workshop on What-if parameter and Decomposition tree: guided practice, realistic scenarios and skills verification.

  • Let the user test a numeric assumption in the report
  • Explore contributors to a measure across multiple dimensions
  • Use “Decomposition tree” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to What-if parameter and Decomposition tree.
  • Produce a quality-checked deliverable demonstrating What-if parameter and Decomposition tree.
3 h
15
Topic M15

Publishing, workspaces and refresh

3-hour workshop on Workspace and Power BI app: guided practice, realistic scenarios and skills verification.

  • Collaborate on Power BI models, reports, and other content
  • Distribute an organized package of content to consumers
  • Use “Power BI app” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Workspace and Power BI app.
  • Produce a quality-checked deliverable demonstrating Workspace and Power BI app.
3 h
16
Topic M16

Scheduled refresh and Gateway

3-hour workshop on Scheduled refresh and Gateway: guided practice, realistic scenarios and skills verification.

  • Automatically update data on a schedule
  • Allow the cloud service to reach certain on-premises sources
  • Use “Gateway” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Scheduled refresh and Gateway.
  • Produce a quality-checked deliverable demonstrating Scheduled refresh and Gateway.
3 h
17
Topic M17

Security and performance

3-hour workshop on Row-level security and Performance Analyzer: guided practice, realistic scenarios and skills verification.

  • Limit visible rows based on user identity or role
  • Measure the time taken by report visuals and queries
  • Use “Performance Analyzer” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Row-level security and Performance Analyzer.
  • Produce a quality-checked deliverable demonstrating Row-level security and Performance Analyzer.
3 h
18
Topic M18

Incremental refresh and DAX optimization

3-hour workshop on Incremental refresh and DAX optimization: guided practice, realistic scenarios and skills verification.

  • Refresh mainly recent partitions instead of reloading everything
  • Reduce expensive calculations and improve the model for more efficient queries
  • Use “DAX optimization” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Incremental refresh and DAX optimization.
  • Produce a quality-checked deliverable demonstrating Incremental refresh and DAX optimization.
3 h
19
Topic M19

Governance, deployment and reliability

3-hour workshop on Lineage view and Content endorsement: guided practice, realistic scenarios and skills verification.

  • Visualize dependencies among sources, models, and reports
  • Mark content as promoted or certified under governance
  • Use “Content endorsement” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Lineage view and Content endorsement.
  • Produce a quality-checked deliverable demonstrating Lineage view and Content endorsement.
3 h
20
Topic M20

Deployment pipeline and Sensitivity label

3-hour workshop on Deployment pipeline and Sensitivity label: guided practice, realistic scenarios and skills verification.

  • Move content across development, test, and production environments
  • Classify and protect analytics data according to policy
  • Use “Sensitivity label” in a workplace task and explain the approach.
  • Diagnose and correct a workflow error relating to Deployment pipeline and Sensitivity label.
  • Produce a quality-checked deliverable demonstrating Deployment pipeline and Sensitivity label.
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 BI — data analysis skills?

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

Take the free test