Power BI Exercises

Power BI assessment test practice

Got a Power BI test before your interview? See what these tests look like, try sample questions with explanations, and practice every skill hands-on in your browser.

Online multiple-choice test: A timed quiz sent before or after the first call. Expect questions on DAX, relationships, Power Query and choosing the right visual, often with a short formula or a model diagram to read.

Take-home case study: You get a dataset and a request from a "manager": clean the data, build the model and a one- or two-page dashboard, then present what you found. This is where hands-on skill shows the most.

Live technical interview: Someone asks you to explain or write a measure, sketch a star schema or fix a report on a shared screen. They want to hear how you think, so practice saying your steps out loud.

Skills the test checks: Pick and build the right visual: cards, tables, matrices, bar and line charts; Filter exactly what was asked: visual filters, Top N and slicers; Clean messy files in Power Query: types, blanks, duplicates, unpivot, merge; Build a star schema with one-to-many relationships that filter the right way; Write basic measures: SUM, COUNTROWS, DIVIDE and iterators like SUMX; Explain filter context and use CALCULATE, ALL and KEEPFILTERS; Year-to-date, same period last year and month-over-month growth; Make a report people can use: drillthrough, bookmarks, tooltips, sync slicers.

Question 1: You need a "Total Sales" number that changes when the user clicks a slicer. What should you create? Answer: A measure. Measures are evaluated when the visual is drawn, in the current filter context, so they respond to slicers. Calculated columns are computed once at refresh and stored row by row.

Question 2: A matrix shows Product[Color] on rows. Which value appears in the "Blue" row for this measure? Red Sales = CALCULATE ( [Total Sales], Product[Color] = "Red" ) Answer: The sales of red products. A filter argument on a column replaces the existing filter on that same column. The row says Blue, CALCULATE overrides it with Red. Wrap the filter in KEEPFILTERS to get blank instead.

Question 3: Which measure returns each category's share of total sales, so the categories add up to 100%? Answer: DIVIDE ( [Total Sales], CALCULATE ( [Total Sales], ALL ( Product[Category] ) ) ). ALL removes the category filter in the denominator, so it returns the total for every category while the numerator keeps the current one.

Question 4: Why use DIVIDE ( [Profit], [Sales] ) instead of [Profit] / [Sales]? Answer: It returns blank (or an alternate value) instead of an error when Sales is zero. DIVIDE handles division by zero safely. You can pass a third argument, such as 0, to show instead of blank.

Question 5: What is the difference between SUM ( Sales[Amount] ) and SUMX ( Sales, Sales[Quantity] * Sales[Price] )? Answer: SUMX evaluates an expression row by row and then adds the results; SUM adds one column. SUMX is an iterator: it walks the table, computes the expression for each row, then sums. SUM can only add the values of a single column.

Question 6: In a star schema, what sits in the middle? Answer: A fact table with numbers to aggregate, like Sales. The fact table (sales, orders, transactions) is in the center. Dimension tables like Product, Customer and Date surround it with one-to-many relationships.

Question 7: Product[ProductKey] 1 → * Sales[ProductKey], with single cross-filter direction. Which statement is true? Answer: A slicer on Product[Category] filters the Sales rows. Filters flow from the one side to the many side. Product filters Sales, but Sales does not filter Product unless you change the direction or use CROSSFILTER in a measure.

Question 8: TOTALYTD ( [Total Sales], 'Date'[Date] ) returns wrong totals. What is the most likely cause? Answer: The date column is not from a proper date table with one row for every day. Time intelligence functions need a date table with continuous dates (no gaps) related to the fact table, ideally marked as a date table.

Question 9: A CSV has duplicate rows and a "Name, City" column that should be two columns. Where should you fix this? Answer: In Power Query, before loading. Shape data as early as possible: Remove Duplicates and Split Column in Power Query. The model stays clean and every report benefits.

Question 10: Each sales manager should only see the rows for their own region in the published report. What do you use? Answer: Row-level security (RLS) roles with a DAX filter. RLS filters the data itself for each user, for example with USERPRINCIPALNAME() matched to a region table. Filters and slicers can be changed by the viewer.

Day 1: Visuals and filters: build cards, matrices and charts, then filter them exactly as asked.

Day 2: Power Query: clean a messy file from start to finish.

Day 3: Data modeling: connect tables into a star schema and fix wrong relationships.

Day 4: DAX basics: SUM, COUNTROWS, DIVIDE and SUMX.

Day 5: CALCULATE and filter context, the topic interviewers ask about most.

Day 6: Time intelligence: year-to-date, last year and growth.

Day 7: Do a full project as if it were a take-home task, then take a timed practice test.

What is a Power BI assessment test? A test employers use to check Power BI skills before or during interviews for analyst roles. It can be an online quiz, a take-home dashboard task or a live exercise with an interviewer.

What topics come up most? DAX measures and CALCULATE, filter context, relationships and star schemas, Power Query cleaning, time intelligence and choosing the right visual. Security (RLS) and import vs DirectQuery come up for more senior roles.

How long does it take? It depends on the employer. Online quizzes are usually short and timed, while take-home tasks can give you a few hours or a few days. Ask the recruiter what format to expect.

Do I need the PL-300 certification? Usually not, but it helps on a CV, and preparing for it covers most of what assessment tests ask. Our PL-300 practice tests are a good timed warm-up.

Can I practice without Power BI Desktop? Yes. Every exercise here runs in your browser, on Windows, Mac or a Chromebook, and checks your answer against the data.

Practice for your assessment