Which of these values would be matched using the syntax LIKE “%apple”
All Options are Correct
Well Done. Your Answer is Correct Keep it Up!
star apple
banapple
peach apple
Category: Big Data Technology
Contains transactional data or facts of a business process_______________
Contains transactional data or facts of a business process_______________
Fact table
Well Done. Your Answer is Correct Keep it Up!
Query table
Dimension table
Power BI table
A function that can only work on numeric fields is___________
A function that can only work on numeric fields is___________
AVERAGE
Well Done. Your Answer is Correct Keep it Up!
ISNUMBER
AND
CONCATENATE
Which is used to calculate the data in each row___________
Which is used to calculate the data in each row___________
Calculated Colum
Well Done. Your Answer is Correct Keep it Up!
Counting
Measure
Calculated Row
A customer may purchase 1 or many products. So the relationship between the customer table and the products table will be_________________
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
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