Free online assessment

Assess your Microsoft Power BI skills for free

45-question technical assessment drawn from a 72-question bank to place a learner in Microsoft Power BI and recommend the most useful training modules.

This assessment measures knowledge and produces a practical diagnostic. Modules are recommended after the test; they are not an offer of paid courses.

Start for free How does the test work?

What is assessed

Questions about practical workplace skills

The test covers different areas of the software, including beginner, intermediate and advanced questions. The score and skill-area breakdown help reveal strengths and topics to revisit.

This is not an official certification and should not be the sole factor in an employment decision.

Who can use it

analysts, managers and data teams

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.

Topic M01

Power BI ecosystem and workflow

Practical 3-hour module covering Power BI Desktop, Power BI Service, Semantic model, and Report.

build queries, semantic models, and reports on the desktop
publish, share, and consume analytics content in the cloud
organize tables, relationships, and calculations used by reports
present multiple pages of interactive visuals based on a model

3 h

Topic M02

Connecting and preparing with Power Query

Practical 3-hour module covering Data connector, Power Query, Data type, and Query folding.

connect to a source such as Excel, SQL, or an online service
clean, transform, and combine data before the model
correctly define text, number, date, or other types for transformations and calculations
push eligible transformations back to the source when possible

3 h

Topic M03

Modeling and star schema

Practical 3-hour module covering Fact table, Dimension table, Relationship, and Cardinality.

store events or measurements at the defined process grain
describe analysis dimensions such as date, product, or customer
connect tables so filters propagate correctly
define relationship type such as one-to-many based on key uniqueness

3 h

Topic M04

DAX, measures and contexts

Practical 3-hour module covering Measure, Calculated column, Filter context, and CALCULATE.

dynamically calculate a value according to report context
calculate a row-by-row value stored in the model
determine which rows contribute to a DAX calculation
modify filter context in a DAX expression

3 h

Topic M05

Visuals and report design

Practical 3-hour module covering Slicer, Drill-through, Report tooltip, and Conditional formatting.

let the user interactively filter visuals
navigate to a detail page while carrying selection context
show additional context when hovering over a data point
vary a value s appearance according to rules or measures

3 h

Topic M06

Analytics, time and indicators

Practical 3-hour module covering Time intelligence, KPI, What-if parameter, and Decomposition tree.

compare periods using a date table and suitable measures
compare a measure with a target or expected state
let the user test a numeric assumption in the report
explore contributors to a measure across multiple dimensions

3 h

Topic M07

Publishing, workspaces and refresh

Practical 3-hour module covering Workspace, Power BI app, Scheduled refresh, and Gateway.

collaborate on Power BI models, reports, and other content
distribute an organized package of content to consumers
automatically update data on a schedule
allow the cloud service to reach certain on-premises sources

3 h

Topic M08

Security and performance

Practical 3-hour module covering Row-level security, Performance Analyzer, Incremental refresh, and DAX optimization.

limit visible rows based on user identity or role
measure the time taken by report visuals and queries
refresh mainly recent partitions instead of reloading everything
reduce expensive calculations and improve the model for more efficient queries

3 h

Topic M09

Governance, deployment and reliability

Practical 3-hour module covering Lineage view, Content endorsement, Deployment pipeline, and Sensitivity label.

visualize dependencies among sources, models, and reports
mark content as promoted or certified under governance
move content across development, test, and production environments
classify and protect analytics data according to policy

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 skills?

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

Take the free test