A customer may purchase 1 or many products. So the relationship between the customer table and the products table will be_________________
One to Many
Well Done. Your Answer is Correct Keep it Up!
Many to Many
Many to One
One to One
Author: administrator
The topic of discussion of Power BI Session 4 is_________
The topic of discussion of Power BI Session 4 is_________
Introduction to DAX
Well Done. Your Answer is Correct Keep it Up!
Data Collection
Data Preparation
Overview
What is the SQL expression used to count the values in a table?
What is the SQL expression used to count the values in a table?
COUNT
Well Done. Your Answer is Correct Keep it Up!
SUM
DISTINCT
AVERAGE
Which of the following tools let you shape data sources?
Which of the following tools let you shape data sources?
Power Query Editor in either Power BI Desktop or Power BI Service
Well Done. Your Answer is Correct Keep it Up!
The Power BI Gateway
The Power BI admin portal
The Relationships view in Power BI Desktop
Which of the following statements is true about shaping data with Power BI Desktop_________
Which of the following statements is true about shaping data with Power BI Desktop_________
When shaping or transforming data in Power BI Desktop, the source data remains unchanged
Well Done. Your Answer is Correct Keep it Up!
When shaping or transforming data in Power BI Desktop, the source data is also shaped and transformed
The order in which you shape or transform data doesn’t matter, it all comes out the same
None of the Option is Correct
The following are examples of the AGGREGATION function except__________
The following are examples of the AGGREGATION function except__________
Semua benar
Well Done. Your Answer is Correct Keep it Up!
Date Functions
Aggregation Functions
Logical Functions
Which of the following illustrates a Many to One relationship?
Which of the following illustrates a Many to One relationship?
Many banana trees planted in more than 1 garden
Well Done. Your Answer is Correct Keep it Up!
1 banana tree having many bananas on the tree
Many gardens having no banana trees
Many banana trees planted in a garden
A collection of software services, apps, and connectors to turn unrelated sources of data into coherent insights__________
A collection of software services, apps, and connectors to turn unrelated sources of data into coherent insights__________
Power BI
Well Done. Your Answer is Correct Keep it Up!
Power Service
Query Editor
Visual Market Place
Creates the connection between Power BI cloud-based data and the data source located on-premises_________
Creates the connection between Power BI cloud-based data and the data source located on-premises_________
Gateway
Well Done. Your Answer is Correct Keep it Up!
Power BI service
Query editor
Report view
Calculate a result from an expression formula and the result can only be viewed in the visualization________
Calculate a result from an expression formula and the result can only be viewed in the visualization________
Measures
Well Done. Your Answer is Correct Keep it Up!
Calculated column
Function
Filter