Valid DA-100 Dumps shared by ExamDiscuss.com for Helping Passing DA-100 Exam! ExamDiscuss.com now offer the newest DA-100 exam dumps, the ExamDiscuss.com DA-100 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DA-100 dumps with Test Engine here:
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories. You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.) The related dimension tables are imported into the model. Sales contains the data shown in the following table.
Correct Answer:
Recent Comments (The most recent comments are at the top.)
David Webb - Jun 26, 2021
The goal of Basket analysis is to analyze relationships between events. A typical example is to analyze which products are frequently purchased together. This means they are in the same “basket”, hence the name of this pattern.
According to the definition of basket analysis, the answer should be. Yes - SalesRowId = SalesOrderNumber + SalesOrderLineNumber. So, it can be removed. AuditId does not contain order or purchase related information. So, it can be removed. Yes - OrderDateKey and OrderDate contains order related information which is needed for basket analysis. No - TaxAmt does not affect the basket analysis so it is not a must to retain.
Recent Comments (The most recent comments are at the top.)
The goal of Basket analysis is to analyze relationships between events. A typical example is to analyze which products are frequently purchased together. This means they are in the same “basket”, hence the name of this pattern.
According to the definition of basket analysis, the answer should be.
Yes - SalesRowId = SalesOrderNumber + SalesOrderLineNumber. So, it can be removed. AuditId does not contain order or purchase related information. So, it can be removed.
Yes - OrderDateKey and OrderDate contains order related information which is needed for basket analysis.
No - TaxAmt does not affect the basket analysis so it is not a must to retain.