Q.1.
The MAP chart is a useful visualization to show locations of cities and countries with bubbles to indicate the size of the data points.
Q.2.
Sometimes when analyzing data we may use our dimensions as a measure to understand values like no. of instances, average pricing or maximum price
Q.3.
The Power Query Editor does not save changes made to the data tables. It saves the applied steps separately so that the steps will need to be applied every time the table is loaded.
Q.4.
Creates the connection between Power BI cloud-based data and the data source located on-premises
Q.5.
A collection of software services, apps, and connectors to turn unrelated sources of data into coherent insights
Q.6.
The following are examples of the AGGREGATION function except:
Q.7.
A function that can only work on numeric fields is
Q.8.
Which of these values would be matched using the syntax LIKE "%apple"
Q.9.
What expression is used to indicate the table where the values would be searched from?
Q.10.
What is the SQL command to return the values from a table?
Q.11.
What is the SQL expression used to count the values in a table?
Q.12.
In any analytics report, it is not necessary to have measures.
Q.13.
To enable two tables to be joined. A unique key between the 2 tables is required. For example between the customer table and the sales table. The key would be customer ID.
Q.14.
Which of the following illustrates a Many to One relationship?
Q.15.
Fungsi yang termasuk di kategori TEXT FUNCTION:
Q.16.
Berikut contoh LOGICAL Functions di DAX, kecuali:
Q.17.
Berikut contoh fungsi COUNTING, kecuali:
Q.18.
Berikut contoh fungsi AGREGASI, kecuali:
Q.19.
What is the recommend method to share your reports?
Q.20.
Calculate a result from an expression formula and the result can only be viewed in the visualization