āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

Power BI test for hiring

Check practical Power BI knowledge across data preparation, models, DAX, the service, and report visuals.

  • 10 āĻŽāĻŋāύāĻŋāϟ
  • 15āϟāĻŋ āĻĒā§āϰāĻļā§āύ
  • āĻŽāĻžāĻāĻžāϰāĻŋ
  • āĻŦāĻšā§āύāĻŋāĻ°ā§āĻŦāĻžāϚāύ⧀
  • āχāĻ‚āϰ⧇āϜāĻŋ āĻ­āĻžāώāĻžāϝāĻŧ āĻĒā§āϰāĻļā§āύ
  • āĻļ⧁āϧ⧁ āĻĄā§‡āĻ¸ā§āĻ•āϟāĻĒ⧇

āϏāĻ‚āĻ•ā§āώāĻŋāĻĒā§āϤ āωāĻ¤ā§āϤāϰ

The Power BI test is a 10-minute, 15-question hiring assessment of everyday Microsoft Power BI work at an intermediate level. It covers sharing and refreshing content in the service, shaping data in Power Query, relationships and DAX measures, and report visuals. It is designed for analysts, BI developers, reporting specialists, consultants, and IT staff who support self-service analytics.

āĻāϟāĻŋ āϕ⧀ āĻĒāϰāĻŋāĻŽāĻžāĻĒ āĻ•āϰ⧇

Working knowledge of Power BI: the service, Power Query, data models and DAX, and report visuals.

Power BI service

Covers sharing and refreshing content in the Power BI service.

Data preparation in Power Query

Covers shaping data through steps in Power Query.

Modeling and DAX

Covers building relationships between data and writing DAX measures.

Visuals and reports

Covers choosing and reading visuals in reports.

āĻĒā§āϰāĻļā§āύ⧇āϰ āϧāϰāύ

āĻŦāĻšā§āύāĻŋāĻ°ā§āĻŦāĻžāϚāύ⧀

āĻĒā§āϰāĻžāĻ°ā§āĻĨā§€: āĻāĻ•āϟāĻŋ āϏāĻ‚āĻ•ā§āώāĻŋāĻĒā§āϤ āĻĒāϰāĻŋāĻ¸ā§āĻĨāĻŋāϤāĻŋ, āϏāĻžāϰāĻŖāĻŋ āĻŦāĻž āĻŦāĻŋāĻŦ⧃āϤāĻŋ āĻĒāĻĄāĻŧ⧇ āϏāĻ āĻŋāĻ• āωāĻ¤ā§āϤāϰāϟāĻŋ, āĻ…āĻĨāĻŦāĻž āϏāĻŦ āϏāĻ āĻŋāĻ• āωāĻ¤ā§āϤāϰ āĻŦ⧇āϛ⧇ āύ⧇āϝāĻŧāĨ¤

āφāĻĒāύāĻŋ āĻĻ⧇āϖ⧇āύ: āĻĒā§āϰāĻžāĻ°ā§āĻĨā§€ āĻŦāĻŋāώāϝāĻŧāϟāĻŋ āĻļ⧁āϧ⧁ āϚāĻŋāύāϤ⧇ āĻĒāĻžāϰ⧇āύ āĻ•āĻŋ āύāĻž āύāϝāĻŧ, āĻ•āĻžāĻœā§‡ āϞāĻžāĻ—āĻžāύ⧋āϰ āĻŽāϤ⧋ āϝāĻĨ⧇āĻˇā§āϟ āĻ­āĻžāϞ⧋āĻ­āĻžāĻŦ⧇ āϜāĻžāύ⧇āύ āĻ•āĻŋ āύāĻžāĨ¤

10 āĻŽāĻŋāύāĻŋāĻŸā§‡ 15āϟāĻŋ āĻĒā§āϰāĻļā§āύ, āĻāĻ•āĻŦāĻžāϰ⧇ āĻāĻ•āϟāĻŋ āĻ•āϰ⧇ āĻĻ⧇āĻ–āĻžāύ⧋ āĻšāϝāĻŧāĨ¤

āĻāχ āĻĒāϰ⧀āĻ•ā§āώāĻžāϰ āωāĻĒāϝ⧋āĻ—ā§€ āĻĒāĻĻ

Roles that build or maintain Power BI reports: data, business, marketing and financial analysts, BI developers and consultants, reporting specialists and IT staff who support self-service analytics.

What this test can show

  1. Look beyond a resume

    See how a candidate reasons about query steps, relationships, DAX measures, and report visuals, rather than relying only on a list of tools.

  2. Focus the follow-up

    Use responses to guide a work sample or interview on the areas relevant to your reporting work, from refreshes to interpreting a chart.

  3. Keep the screen concise

    The 10-minute assessment gives a focused signal across four areas of Power BI work without asking the candidate to build a report.

āĻĒā§āϰāϤāĻŋāϟāĻŋ āĻĒā§āϰāĻžāĻ°ā§āĻĨā§€āϰ āϜāĻ¨ā§āϝ āφāĻĒāύāĻŋ āϝāĻž āĻĒāĻžāĻŦ⧇āύ

āωāĻĻāĻžāĻšāϰāĻŖ āϰāĻŋāĻĒā§‹āĻ°ā§āϟ (āĻ•āĻžāĻ˛ā§āĻĒāύāĻŋāĻ• āϤāĻĨā§āϝ)Power BI
ā§­ā§­%āĻĒāĻžāĻ°ā§āϏ⧇āĻ¨ā§āϟāĻžāχāϞ 59āĨ¤ āϤ⧁āϞāύāĻžāĻŽāĻžāύ: HireValid-āĻāϰ āĻĒā§āϰāĻžāĻ°ā§āĻĨā§€, n = ā§§,ā§¨ā§Žā§Ž
Power BI serviceā§Ŧā§Ž%
Data preparation in Power Queryā§Žā§§%
Modeling and DAX⧝ā§Ļ%
Visuals and reportsā§Ŧā§­%
Integrity ScoreāωāĻšā§āϚ āφāĻ¸ā§āĻĨāĻž
  • āĻĒ⧁āϰ⧋ āϏāĻŽāϝāĻŧ āĻĒāϰ⧀āĻ•ā§āώāĻžāϰ āĻŸā§āϝāĻžāĻŦ⧇āχ āĻ›āĻŋāϞ⧇āύ
  • āĻ•āĻĒāĻŋ-āĻĒ⧇āĻ¸ā§āϟ āĻ•āϰāĻž āωāĻ¤ā§āϤāϰ āύ⧇āχ
  • āĻāĻ•āϟāĻžāύāĻž āĻ—āϤāĻŋāϤ⧇ āωāĻ¤ā§āϤāϰ āĻĻāĻŋāϝāĻŧ⧇āϛ⧇āύ

āĻ¸ā§āϕ⧋āϰ, āĻĒā§āϰ⧋āĻĢāĻžāχāϞ āĻ“ āϏāϤāϤāĻžāϰ āϏāĻ‚āϕ⧇āϤāϗ⧁āϞāĻŋ āϏāĻžāĻ•ā§āώāĻžā§ŽāĻ•āĻžāϰ⧇āϰ āĻĒāĻžāĻļāĻžāĻĒāĻžāĻļāĻŋ āφāĻĒāύāĻžāϰ āĻĒāĻ°ā§āϝāĻžāϞ⧋āϚāύāĻžāϰ āϜāĻ¨ā§āϝ āĻĒā§āϰāĻŽāĻžāĻŖ, āĻ•āĻ–āύāĻ“ āĻ¸ā§āĻŦāϝāĻŧāĻ‚āĻ•ā§āϰāĻŋāϝāĻŧ āϏāĻŋāĻĻā§āϧāĻžāĻ¨ā§āϤ⧇āϰ āĻ­āĻŋāĻ¤ā§āϤāĻŋ āύāϝāĻŧāĨ¤

āĻāχ āĻŸā§‡āĻ¸ā§āϟāϟāĻŋ āĻŦāĻŋāύāĻžāĻŽā§‚āĻ˛ā§āϝ⧇ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰ⧁āύ

Assessment integrity signals

Each candidate receives a different set of questions, with question order and answer options shuffled. The browser shows one question at a time, and answer keys stay on HireValid’s servers. The 10-minute timer runs on the server; reloading restores the same question with only the remaining time, and candidates cannot go back. Question text cannot be copied or selected, and a blocked copy attempt is recorded in the timeline. HireValid can summarize signals such as time away from the test tab or pastes into answers in an Integrity Score and evidence timeline for you to review. It does not decide on its own.

Use the score as evidence

Review the score alongside a job-relevant work sample and a structured interview, never as the sole basis for a hiring decision. Ask the candidate to explain how they would shape data, reason through relationships and measures, or make a report easier to read. For roles that also call for adjacent tools, see the Microsoft Excel Intermediate test, Snowflake test, or ETL test.

Structured interview questions

  1. Walk me through how you would investigate a report that changed after a refresh.

    Listen for a clear approach to checking refresh behavior and tracing relevant data preparation steps.

  2. Tell me how you would model a new set of business data for a report.

    Listen for how the candidate thinks about relationships and the measures the report needs.

  3. How would you choose and review a visual for a business question?

    Listen for attention to the chart’s values and labels and how they help answer the question.

āĻ¨ā§āϝāĻžāĻ¯ā§āϝāϤāĻž āĻ“ āĻĒā§āϰāϝāĻŧā§‹āϜāύ⧀āϝāĻŧ āϏ⧁āĻŦāĻŋāϧāĻž

Questions use everyday business data such as units, orders, hours and regions, with no money symbols, dates written with the month as a word, and product behavior as it works in the current Power BI Desktop and service with US settings. Licensing, pricing and preview features are left out. Every table, query step and chart a question needs is shown in the question, so nothing depends on remembering a particular screen or menu path, and charts are asked about by their values and labels, never by color. The test asks for a computer so tables and charts are large enough to read.

āϝ⧁āĻ•ā§āϤāĻŋāϏāĻ™ā§āĻ—āϤ āϏ⧁āĻŦāĻŋāϧāĻž āĻšāĻŋāϏ⧇āĻŦ⧇ āφāĻĒāύāĻŋ āϝ⧇āϕ⧋āύ⧋ āĻĒā§āϰāĻžāĻ°ā§āĻĨā§€āϕ⧇ āĻ…āϤāĻŋāϰāĻŋāĻ•ā§āϤ āϏāĻŽāϝāĻŧ āĻĻāĻŋāϤ⧇ āĻĒāĻžāϰ⧇āύāĨ¤ āĻĢāϞāĻžāĻĢāϞ āĻāĻ•āϜāύ āĻŦā§āϝāĻ•ā§āϤāĻŋāϰ āĻĒāĻ°ā§āϝāĻžāϞ⧋āϚāύāĻžāϰ āϜāĻ¨ā§āϝ āĻĒā§āϰāĻŽāĻžāĻŖ, āĻ•āĻ–āύāĻ“ āĻ¸ā§āĻŦāϝāĻŧāĻ‚āĻ•ā§āϰāĻŋāϝāĻŧ āϏāĻŋāĻĻā§āϧāĻžāĻ¨ā§āϤ āύāϝāĻŧāĨ¤

Provisional: reliability is reported once 200 candidates have completed it.

āĻ¨ā§āϝāĻžāĻ¯ā§āϝāϤāĻž āĻŦāĻŋāώāϝāĻŧ⧇ āφāĻŽāĻžāĻĻ⧇āϰ āĻĻ⧃āĻˇā§āϟāĻŋāĻ­āĻ™ā§āĻ—āĻŋ āĻĒāĻĄāĻŧ⧁āύ

āĻĒāϰ⧀āĻ•ā§āώāĻžāϰ āĻŦāĻŋāĻŦāϰāĻŖ

Short, timed questions on everyday Microsoft Power BI work at an intermediate level. They cover sharing and refreshing content in the Power BI service, shaping data in Power Query, building relationships and writing DAX measures, and choosing and reading visuals. Many questions show a small table, a list of query steps or a chart and ask what a step, measure or setting produces.

  • āĻĒā§āϰāĻļā§āύāϗ⧁āϞāĻŋ āχāĻ‚āϰ⧇āϜāĻŋāϤ⧇āĨ¤
  • āϕ⧋āύ⧋ āϏāĻšāĻžāϝāĻŧāĻ• āωāĻĒāĻ•āϰāϪ⧇āϰ āĻĒā§āϰāϝāĻŧā§‹āϜāύ āύ⧇āχāĨ¤
  • āĻĒā§āϰāϤāĻŋāϟāĻŋ āĻĒā§āϰāĻļā§āύ āĻ•ā§āϰāĻŽāĻžāύ⧁āϏāĻžāϰ⧇ āĻāĻ•āĻŦāĻžāϰ āĻ•āϰ⧇ āωāĻ¤ā§āϤāϰ āĻĻāĻŋāϤ⧇ āĻšāϝāĻŧāĨ¤ āφāϗ⧇āϰ āĻĒā§āϰāĻļā§āύ⧇ āĻĢāĻŋāϰ⧇ āϝāĻžāĻ“āϝāĻŧāĻžāϰ āϏ⧁āϝ⧋āĻ— āύ⧇āχāĨ¤
  • āϏāĻŽāϝāĻŧāĻŦāĻĻā§āϧ āĻĒāϰ⧀āĻ•ā§āώāĻžāϰ āφāϗ⧇ 4 āĻŽāĻŋāύāĻŋāĻŸā§‡ 4āϟāĻŋ āĻ…āύ⧁āĻļā§€āϞāύ⧇āϰ āĻĒā§āϰāĻļā§āύāĨ¤
  • āĻĄā§‡āĻ¸ā§āĻ•āϟāĻĒ āĻŦāĻž āĻ˛ā§āϝāĻžāĻĒāϟāĻĒ āĻ•āĻŽā§āĻĒāĻŋāωāϟāĻžāϰ⧇ āĻĻ⧇āĻ“āϝāĻŧāĻž āĻšāϝāĻŧāĨ¤

Microsoft Power BI, Power Query āϤāĻžāĻĻ⧇āϰ āĻŽāĻžāϞāĻŋāĻ•āĻĻ⧇āϰ āĻŸā§āϰ⧇āĻĄāĻŽāĻžāĻ°ā§āĻ•āĨ¤ HireValid āϤāĻžāĻĻ⧇āϰ āϏāĻ™ā§āϗ⧇ āϝ⧁āĻ•ā§āϤ āύāϝāĻŧ āĻŦāĻž āϤāĻžāĻĻ⧇āϰ āĻĻā§āĻŦāĻžāϰāĻž āϏāĻŽāĻ°ā§āĻĨāĻŋāϤ āύāϝāĻŧāĨ¤

āĻĒā§āϰāĻžāϝāĻŧāĻļāχ āϜāĻŋāĻœā§āĻžāĻžāϏāĻŋāϤ āĻĒā§āϰāĻļā§āύ

What does the Power BI test measure?+

It measures working knowledge of the Power BI service, data preparation in Power Query, relationships and DAX measures, and report visuals. Questions may show a small table, query steps, or a chart and ask what a step, measure, or setting produces.

Which roles is the Power BI test for?+

Use it when hiring people who build or maintain Power BI reports, including data, business, marketing, or financial analysts, BI developers and consultants, reporting specialists, and IT staff supporting self-service analytics.

What is the Power BI test format?+

The intermediate test has 15 multiple-choice questions and takes 10 minutes. It is desktop-only, with no aids allowed and no back navigation. A separate practice set has 4 questions and takes 4 minutes.

How are charts and tables presented in the Power BI test?+

The question includes the table, query steps, or chart needed to answer it. Everyday business data uses units, orders, hours, and regions; charts are discussed through values and labels, not color. A computer is needed to read them comfortably.

āĻ āϏāĻŽā§āĻĒāĻ°ā§āĻ•āĻŋāϤ āĻĒāϰ⧀āĻ•ā§āώāĻž

āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

Tableau

10 āĻŽāĻŋāύāĻŋāϟ, āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

āĻĻ⧇āϖ⧇ āύāĻŋāύ
āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

Snowflake

10 āĻŽāĻŋāύāĻŋāϟ, āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

āĻĻ⧇āϖ⧇ āύāĻŋāύ
āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

Excel-āĻ āĻĄā§‡āϟāĻž āĻ…ā§āϝāĻžāύāĻžāϞāĻŋāϟāĻŋāĻ•ā§āϏ

10 āĻŽāĻŋāύāĻŋāϟ, āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

āĻĻ⧇āϖ⧇ āύāĻŋāύ
āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

Amazon Web Services (AWS)-āĻ āĻĄā§‡āϟāĻž āĻ…ā§āϝāĻžāύāĻžāϞāĻŋāϟāĻŋāĻ•ā§āϏ

10 āĻŽāĻŋāύāĻŋāϟ, āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

āĻĻ⧇āϖ⧇ āύāĻŋāύ
āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

Google Cloud Platform (GCP)-āĻ āĻĄā§‡āϟāĻž āĻ…ā§āϝāĻžāύāĻžāϞāĻŋāϟāĻŋāĻ•ā§āϏ

10 āĻŽāĻŋāύāĻŋāϟ, āϏāĻĢāϟāĻ“āϝāĻŧā§āϝāĻžāϰ-āϏāĻ‚āĻ•ā§āϰāĻžāĻ¨ā§āϤ āĻĻāĻ•ā§āώāϤāĻž

āĻĻ⧇āϖ⧇ āύāĻŋāύ
āĻ­ā§‚āĻŽāĻŋāĻ•āĻž-āύāĻŋāĻ°ā§āĻĻāĻŋāĻˇā§āϟ āĻĻāĻ•ā§āώāϤāĻž

āĻĄā§‡āϟāĻž āϏāĻžāϝāĻŧ⧇āĻ¨ā§āϏ

10 āĻŽāĻŋāύāĻŋāϟ, āĻ­ā§‚āĻŽāĻŋāĻ•āĻž-āύāĻŋāĻ°ā§āĻĻāĻŋāĻˇā§āϟ āĻĻāĻ•ā§āώāϤāĻž

āĻĻ⧇āϖ⧇ āύāĻŋāύ

āĻĒāϰāĻŦāĻ°ā§āϤ⧀ āύāĻŋāϝāĻŧā§‹āϗ⧇ Power BI āĻŸā§‡āĻ¸ā§āϟāϟāĻŋ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰ⧁āύ

Free-āϏāĻš āĻĒā§āϰāϤāĻŋāϟāĻŋ āĻĒā§āĻ˛ā§āϝāĻžāύ⧇āχ āϏāĻŽā§āĻĒā§‚āĻ°ā§āĻŖ āĻŸā§‡āĻ¸ā§āϟ āϞāĻžāχāĻŦā§āϰ⧇āϰāĻŋ āϰāϝāĻŧ⧇āϛ⧇āĨ¤

āĻāχ āĻŸā§‡āĻ¸ā§āϟāϟāĻŋ āĻŦāĻŋāύāĻžāĻŽā§‚āĻ˛ā§āϝ⧇ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰ⧁āύFree āĻĒā§āĻ˛ā§āϝāĻžāύāĨ¤ āĻ•ā§āϰ⧇āĻĄāĻŋāϟ āĻ•āĻžāĻ°ā§āĻĄ āϞāĻžāĻ—āĻŦ⧇ āύāĻžāĨ¤
Free āĻĒā§āĻ˛ā§āϝāĻžāύāĨ¤ āĻ•ā§āϰ⧇āĻĄāĻŋāϟ āĻ•āĻžāĻ°ā§āĻĄ āϞāĻžāĻ—āĻŦ⧇ āύāĻžāĨ¤āĻāχ āĻŸā§‡āĻ¸ā§āϟāϟāĻŋ āĻŦāĻŋāύāĻžāĻŽā§‚āĻ˛ā§āϝ⧇ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰ⧁āύ

āϏāĻŽā§āĻĒāĻžāĻĻāϕ⧀āϝāĻŧ āĻĻāϞ āϏāĻŽā§āĻĒāĻ°ā§āϕ⧇

HireValid-āĻāϰ āϏāĻŽā§āĻĒāĻžāĻĻāϕ⧀āϝāĻŧ āĻĻāϞ⧇āϰ āϞ⧇āĻ–āĻž āĻ“ āϤāĻĨā§āϝ āϝāĻžāϚāĻžāχ āĻ•āϰāĻžāĨ¤ āϝāĻžāϚāĻžāχ āĻ•āϰāĻž āϏ⧂āĻ¤ā§āϰ . āϏāĻŽā§āĻĒāĻžāĻĻāϕ⧀āϝāĻŧ āύ⧀āϤāĻŋāϟāĻŋ āĻĒāĻĄāĻŧ⧁āύāĨ¤