Power BI Quiz

What is the primary purpose of data cleaning in Power BI?

• To remove duplicate rows and columns

• To ensure data accuracy and consistency

• To increase data size

• To change the data format

Which of the following tools in Power BI helps you apply filters and transformations to your data?

• Power Query

• Power Automate

• Power Apps

• Power Map

Which visualisation is best suited to show the composition of categories within a dataset, such as sales by region?

• Line Chart

• Scatter Plot

• Pie Chart

• Histogram

What is the benefit of using slicers in Power BI dashboards?

• To create new data columns

• To control data refresh rate

• To filter data dynamically within a visualisation

• To delete rows of data from the dataset

Which DAX function in Power BI would you use to calculate the total of a column?

• SUM

• COUNT

• AVERAGE

• DISTINCT

Which visualisation would you use in Power BI to display data over time, such as monthly sales growth?

• Bar Chart

• Pie Chart

• Line Chart

• Scatter Plot

To make dashboards more interactive for users, you should:

• Limit visuals to one per dashboard

• Enable cross-filtering between visuals

• Avoid using slicers and filters

• Use only static images

Which visualisation would you use in Power BI to compare the sales performance of different products?

• Bar Chart

• Line Chart

• Pie Chart

• Area Chart

Which type of visualisation is most effective for displaying the distribution of a dataset, such as customer ages?

• Box Plot

• Pie Chart

• Line Chart

• Bar Chart