HOTSPOT 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...
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might...
DRAG DROP You are building a dataset from a JSON file that contains an array of documents. You need to import attributes as columns from all the documents in the JSON file. The solution...
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the following format:...
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that...
HOTSPOT You are creating a Microsoft Power BI data model that has the tables shown in the following table. The Products table is related to the ProductCategory table through the ProductCategoryID column. You need...
You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point....
You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium...
You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine 1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column . What will the value be when the...
HOTSPOT You are creating a column chart visualization. You configure groups as shown in the Groups exhibit. {Click the Groups tab.) The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)...
