Question 1

What is the first step to take before carrying out a calculation in Power BI?

Accepted Answer

Ensure the granularity of the tables matches the calculation requirement.

Answer

Clean the data.

Answer

Choose the right chart type.

Answer

Start summarizing the data.

Question 2

In the video, how did the instructor calculate the average units sold per day?

Accepted Answer

Daily average units = Total units (SUM of units column in the sales table) / Distinct count of the sales table date column

Answer

None of the above

Answer

Average units sold per day (incorrect calculation) = Average of the sales table and the units column

Answer

Daily units sold (incorrect calculation) = SUM of units column in the sales table

Question 3

The instructor mentioned a way to find the sales of the best-selling day of a period. Which of the following is the MOST INCORRECT way to do this?

Accepted Answer

Calculate the maximum sales in the sales table.

Answer

Summarize the table up to the day level and then find the maximum sales.

Answer

Write a measure that calculates the total sales for each date and then find the maximum value.

Answer

Create a new calculated column in the calendar table that references total sales.

Question 4

How can you find the bestselling product according to the video?

Accepted Answer

Directly calculate the max sales value in the sales table.

Answer

Create a measure that calculates the total sales for each product and then find the maximum value.

Answer

None of the above

Answer

Summarize the table by product and then find the maximum sales.

Question 5

The instructor created a virtual table to find the sales of the best channel. Which option is NOT required to create a virtual table?

Accepted Answer

The values function to remove duplicates from the channel column.

Answer

A dimension table for the channel.

Answer

None of the above. Creating a virtual table does not require a dimension table.

Answer

A measure that calculates the sales for each channel.

Question 6

How to calculate the average units sold per day?

Accepted Answer

Daily average units = Total units (SUM of units column in the sales table) / Distinct count of the sales table date column

Answer

Average units sold per day (incorrect calculation) = Average of the sales table and the units column

Answer

Daily units sold (incorrect calculation) = SUM of units column in the sales table

Answer

None of the above

Question 7

How to find the sales of the best-selling day of the period?

Accepted Answer

Summarize the table up to the day level, then find the maximum sales. Alternatively, create a calculated column in the calendar table referencing total sales.

Answer

Write a measure that calculates the total sales for each date and then find the maximum value.

Answer

Create a new measure in the calendar table that references total sales.

Answer

Calculate the maximum sales in the sales table.

Question 8

How to find the bestselling product according to the video?

Accepted Answer

Create a measure that calculates the total sales for each product and then find the maximum value.

Answer

Summarize the table by product but don't calculate sales

Answer

Directly calculate the max sales value in the sales table.

Answer

None of the above

Question 9

How to find the sales of the best channel?

Accepted Answer

Summarize the data by channel and create a virtual table to calculate sales for each channel, then find the maximum value.

Answer

Summarize the data by channel and use the existing dimension table (if it exists) to find the maximum value.

Answer

Don't summarize the data, directly calculate the maximum sales in the channel column.

Answer

Summarize the data by channel but don't calculate sales

Question 10

How to find the channel-wise band-wise maximum sales value?

Accepted Answer

Create a custom summarized table that includes both channel and band, then calculate total sales for each row and find the maximum value.

Answer

Summarize the data by channel and band and identify the maximum sales value visually.

Answer

Find the maximum sales value for each channel and for each band independently (not combined).

Answer

Create a separate measure for each channel-band combination and find the maximum value.

Related quizzes

Related quizzes