- All Exams Instant Download
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements
HOTSPOT You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements. For each of the following statement, select Yes if the statement is true, Otherwise, select No. NOTE: Each correct...
Which three actions should you perform in sequence?
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 must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports....
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
You plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?A . Create a horizontal line that has a fixed value of 24,000.B . Add a measure to the visual that...
How should you configure the relationships from Products to ProductCategory?
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 to ensure that you can analyze sales by product category. How should you configure the relationships...
What should you configure?
HOTSPOT You need to grant access to the business unit analysts. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: The Viewer role to the workspace The Viewer role gives a read-only...
Which three actions should you perform in sequence?
DRAG DROP You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table. Warehouse managers report that it is difficult to use the report because...
Which type of visualization should you create?
You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create?A . bar chartB . scatterplotC . pie chartView AnswerAnswer: A Explanation: Scenario: The On-Time Shipping report will show the following metrics for...
You have a report page that contains the visuals shown in the following exhibit
HOTSPOT You have a report page that contains the visuals shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: cross-filter...
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
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 and within sales territories. You import a fact table named Sales as shown in the exhibit....
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
You plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?A . Create a horizontal line that has a fixed value of 24,000.B . Add a measure to the visual that...
