Power BI interviews

Work in the tool while you explain your decisions.

Choose a role and level. Each interview has a new task, follow-up questions and a report that checks your work and your explanation.

Take the assessment Choose an interview

Speak or type. Sign in to save your results across devices.

Timed assessment

12 practical questions
60 minutes
Mid level

Questions are drawn from a bank of 36. Your report includes a skill breakdown and lessons to practice next.

Start assessment

Practice interviews

Junior tasks cover the fundamentals. Mid and senior tasks add debugging, changing requirements and review decisions.

Position

10 interviews

Data analyst
Junior
20 min

Revenue per unit after handling

Review the fictional outdoor retailer's model. Calculate realized revenue per unit after a fictional handling cost of 6 per transaction row. The denominator is units, not rows. Name the corrected measure Review Metric 101. Keep unrelated model objects unchanged.

Start interview

Skills and rubricWeighted business metric

Produces the requested work using the stated source facts.
Explains the direct effect on a visible result or entry.
Names one concrete check of the completed work.

BI developer
Junior
20 min

A repeated total in every category

Review the fictional outdoor retailer's model. Repair the missing ProductKey relationship, then calculate contribution as revenue less Cost and 7 per transaction row. Categories must filter the result. Name the corrected measure Review Metric 102. Keep unrelated model objects unchanged.

Start interview

Skills and rubricRelationship debugging

Produces the requested work using the stated source facts.
Explains the direct effect on a visible result or entry.
Names one concrete check of the completed work.

Financial analyst
Junior
20 min

An unsent order exception queue

Review the fictional outdoor retailer's model. Calculate contribution from unshipped rows only. A missing Ship Date means waiting to ship, not zero revenue. Deduct Cost and 8 handling on each included row. Name the corrected measure Review Metric 103. Keep unrelated model objects unchanged.

Start interview

Skills and rubricBlank date handling

Produces the requested work using the stated source facts.
Explains the direct effect on a visible result or entry.
Names one concrete check of the completed work.

Data analyst
Mid
27 min

A channel contribution request

Review the fictional outdoor retailer's model. Report Online contribution to total revenue after 9 of handling per transaction row. Override Channel for Online in the numerator, remove only Channel from the denominator, and retain region, product and date filters. Name the corrected measure Review Metric 104. Keep unrelated model objects unchanged.

Start interview

Skills and rubricFilter context

Explains the grain or cutoff behind the business definition.
Checks a boundary and reconciles the result to source evidence.
Describes what changes when the stakeholder revises the requirement.

BI developer
Mid
27 min

A high-volume transaction rule

Review the fictional outdoor retailer's model. Calculate contribution only from transaction rows with Quantity at least 2. Deduct Cost and a 3 handling charge on each qualifying row. Name the corrected measure Review Metric 105. Keep unrelated model objects unchanged.

Start interview

Skills and rubricRow and filter context

Explains the grain or cutoff behind the business definition.
Checks a boundary and reconciles the result to source evidence.
Describes what changes when the stakeholder revises the requirement.

Financial analyst
Mid
27 min

Order dates and shipping dates

Review the fictional outdoor retailer's model. Assign net revenue after 4 per transaction row to the month of shipment using the inactive ShipDateKey relationship. Name the corrected measure Review Metric 106. Keep unrelated model objects unchanged.

Start interview

Skills and rubricRole-playing date dimensions

Explains the grain or cutoff behind the business definition.
Checks a boundary and reconciles the result to source evidence.
Describes what changes when the stakeholder revises the requirement.

Data analyst
Mid
27 min

A running close contribution

Review the fictional outdoor retailer's model. Mark Date[Date] as the date table and compute year-to-date contribution after 5 handling per transaction row. Name the corrected measure Review Metric 107. Keep unrelated model objects unchanged.

Start interview

Skills and rubricTime intelligence

Explains the grain or cutoff behind the business definition.
Checks a boundary and reconciles the result to source evidence.
Describes what changes when the stakeholder revises the requirement.

BI developer
Senior
35 min

A weighted margin review

Review the fictional outdoor retailer's model. Replace the draft average of row margins with portfolio contribution margin. Contribution is revenue less Cost and 6 of handling per row. Use current-context revenue as the denominator. Name the corrected measure Review Metric 108. Keep unrelated model objects unchanged.

Start interview

Skills and rubricAggregate ratios and totals

Defends the definition while identifying its explicit limits.
Traces changed facts through the model, entry or downstream report.
Proposes a review control and a reproducible regression check.

Financial analyst
Senior
35 min

An aggregated report at scale

Review the fictional outdoor retailer's model. This aggregated report never uses Store[Manager]. Exclude it from load, preserve the relationship keys, correct contribution after 7 handling per row, then record and refresh Performance Analyzer. Simulator timings are estimates. Name the corrected measure Review Metric 109. Keep unrelated model objects unchanged.

Start interview

Skills and rubricPerformance and model review

Defends the definition while identifying its explicit limits.
Traces changed facts through the model, entry or downstream report.
Proposes a review control and a reproducible regression check.

Data analyst
Senior
35 min

A regional access handoff

Review the fictional outdoor retailer's model. Create a static role Review South 110 restricting Store[Region] to South. Test it with View as and correct net revenue after 8 per transaction row. Name the corrected measure Review Metric 110. Keep unrelated model objects unchanged.

Start interview

Skills and rubricRow-level security

Defends the definition while identifying its explicit limits.
Traces changed facts through the model, entry or downstream report.
Proposes a review control and a reproducible regression check.

Choose your character

Power BI interviews

Timed assessment

Practice interviews

Revenue per unit after handling

A repeated total in every category

An unsent order exception queue

A channel contribution request

A high-volume transaction rule

Order dates and shipping dates

A running close contribution

A weighted margin review

An aggregated report at scale

A regional access handoff

Interview Hub access

Your Work Gym account