Power BI , Multiple Choice Test

[blackmonk69]

Power BI is a cloud-based business analytics service that provides a single view of a business's most critical data and metrics. *

• Provides a single view of business data and metrics but is not a cloud-based business analytics service

• It is a cloud service but it only allows data transformation

• Fake

• TRUE




If I have a table that shows the data of a product for each record (row), and I have a field that identifies the type of product, what aggregation function combined with what statement should I use to be able to group the data in a summarized table , so that for each type of product, I am left with the number of products that the table has?*


• SUM + GROUP BY

• DISTINCT COUNT + ORDER BY

• COUNT + ORDER BY

• COUNT + GROUP BY

 

[Monty]

The correct option for grouping the data in a summarized table to show the number of products for each type is:

COUNT + GROUP BY

In Power BI, you would use the COUNT aggregation function along with the GROUP BY statement to achieve this.