Power BI Online Test
About the test
The Power BI online test assesses knowledge of creating reports using Power BI.
The assessment includes work-sample tasks such as:
- Using DAX to create reports.
- Transforming and preparing data with Power Queries.
- Configuring charts to summarize and visualize data.
A good Power BI developer needs to know how to correctly configure charts and use Power Query to clean the data, as well as use DAX to create advanced reports.
Sample public questions
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 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
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, Net Adds, Grocery Sales, Beverage Sales, Book Sales, Marketing Performance Report, Device Purchases.
Skills and topics tested
- Power BI
- Power Query
- Matrix Visualization
- Chart Configuration
- Data Cleaning
- Data Aggregation
- Data Modeling
- Bug Fixing
- Row-Level Security
- Performance Tuning
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