Question 1

What are the 3 busiest months for store number 3 based on the data presented in the video?

Accepted Answer

January, February, November

Answer

March, April, May

Answer

June, July, August

Answer

September, October, December

Question 2

Which formula is used in the video to derive the day of the week from the date?

Accepted Answer

WEEKDAY

Answer

DATE

Answer

YEAR

Answer

MONTH

Question 3

What is the purpose of conditional formatting applied in the video?

Accepted Answer

To highlight the highest and lowest values in the matrix

Answer

To change the font size of the table

Answer

To hide certain rows and columns

Answer

To add borders to the table

Question 4

In the video, what is the name of the measure created to calculate the average quantity sold?

Accepted Answer

Average Quantity

Answer

Monthly Sales

Answer

Daily Sales

Answer

Total Quantity

Question 5

Which of the following visualizations is NOT used in the final report created in the video?

Accepted Answer

Pie Chart

Answer

Horizontal Bar Chart

Answer

Vertical Bar Chart

Answer

Matrix

Question 6

How does the slicer functionality work in Power BI according to the video?

Accepted Answer

It allows users to filter data based on a selected category

Answer

It changes the formatting of the entire report

Answer

It adds additional data points to the visualizations

Answer

It removes unnecessary data points from the visualizations

Question 7

What is the benefit of sorting the day of the week by day of the week number in the matrix visualization?

Accepted Answer

To ensure the days are displayed in chronological order (Monday to Sunday)

Answer

To hide irrelevant data from the view

Answer

To calculate the total sales for each day of the week

Answer

To change the data type of the day of the week column

Question 8

In the video, how is the interaction between the charts modified to improve the report?

Accepted Answer

By setting the interaction to filter instead of highlight

Answer

By changing the color scheme of the charts

Answer

By adding titles to each chart

Answer

By increasing the size of the charts

Question 9

What alternative did the video suggest for swapping day and month with hours and weeks for analysis?

Accepted Answer

The options are endless, all up to you

Answer

A specific formula needs to be applied

Answer

Additional data sources are required

Answer

This functionality is not available in Power BI

Question 10

What is the recommended way to change the overall color theme of the report in Power BI according to the video?

Accepted Answer

By selecting a different theme from the View menu

Answer

By adding a slicer to filter the color scheme

Answer

By using conditional formatting to change the colors

Answer

By manually editing the color of each chart element

Related quizzes

Related quizzes