Power BI Online Test
Practice your skills and earn a certificate of achievement when you score in the top 25%.Take a Practice Test
Test candidates with real-world problems and interview the best ones.Sign Up to Offer this Test
About the test
The Power BI developer online test assesses candidates' knowledge of creating Power BI reports.
It’s an ideal test for pre-employment screening. A good Power BI developer needs to be able to not only know how to correctly configure charts, but also know how to use Power Query to clean the data and use DAX for creating advanced reports.
This online test requires candidates to answer multiple-choice and fill the blanks questions about Power BI.
Sample public questions
A business owner needs a Power BI report which shows the projected quantity for each item. The "quantity" column is in the "items" table.
Fill in the blank of the following DAX expression for a new column that will compute the projected quantity, which is the current quantity plus 12%:
Projected Quantity = ______________ * 1.12
A Power BI report has a measure declared as:
Profit percentage = SUM(financials[Profit]) / CALCULATE(SUM(financials[Profit]), ALL(financials))
Select all the true statements if the "Profit percentage" is used as a value in a bar chart where Country is the axis.
As an entry-level financial analyst, your manager asked you to analyze the prices of a new stock and make a buy-sell recommendation. Daily price trends seems to fluctuate as can be seen below:
You need to create a new measure which will create a rolling average for 7-day periods, as below, because an increasing trend in a rolling average may signal an increase in the price of the stock.
How should you configure the quick measure, shown below, for the rolling average for the last 7 days?
A Power BI report for a model which has the Country, Sales, and Product fields should show the following bar chart:
Select all the things that need to be done to recreate the chart above.
For jobseekers: get certified
Earn a free certificate by achieving top 25% on the Power BI test with public questions.Take a Certification Test
Sample silver certificate
Sunshine CaprioJava and SQL TestDome
For companies: premium questions
Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.
13 more premium Power BI questions
Query Join, Sales per Product, Sale Discount, Modifying Profit, Average Sales, Profit Chart, Regional Report, Device Purchases, Net Adds, Grocery Sales, Book Sales, Beverage Sales, Marketing Performance Report.
Skills and topics tested
- Power BI
- Power Query
- Matrix Visualization
- Chart Configuration
- Data Modeling
- Performance Tuning
- Data Cleaning
- Data Aggregation
- Bug Fixing
- Row-Level Security
For job roles
- Data Analyst
- Power BI Analyst
- Power BI Developer
Sample candidate report
What others say
Simple, straight-forward technical testing
TestDome is simple, provides a reasonable (though not extensive) battery of tests to choose from, and doesn't take the candidate an inordinate amount of time. It also simulates working pressure with the time limits.
Jan Opperman, Grindrod Bank
Solve all your skill testing needs
150+ Pre-made tests
From web development and database administration to project management and customer support. See all pre-made tests.
Mix questions for different skills or even custom questions in one test. See an example.
How TestDome works
Choose a pre-made test
or create a custom test
Invite candidates via
email, URL, or your ATS
a test remotely
Sort candidates and
get individual reports