You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.

What should you do?

Reveal Solution Hide Solution

DRAG DROP

You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.

The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.

You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.

How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Divide, Calculate, AllSelected.

Reference: https://docs.microsoft.com/en-us/dax/allselected-function-dax

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region.

What should you do next to meet the reporting requirements of the executives?

Reveal Solution Hide Solution

You open a query in Power Query Editor.

You need to identify the percentage of empty values in each column as quickly as possible.

Which Data Preview option should you select?

Reveal Solution Hide Solution

HOTSPOT

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Using a workspace membership

Scenario:

The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.

Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of dashboards, reports, and datasets in it.

Box 2: A mail-enabled security group

Scenario: Security Requirements

The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.

HOTSPOT

You have a folder of monthly transaction extracts.

You plan to create a report to analyze the transaction data.

You receive the following email message: "Hi. I’ve put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions."

You get data from the folder and select Combine & Load.

The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Yes

The four columns used in the 2018 transactions are already displayed.

Box 2: Yes

The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected.

Box 3: Yes

Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types. You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.

HOTSPOT

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: CALCULATE

CALCULATE evaluates an expression in a modified filter context.

Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])

Expression – The expression to be evaluated.

filter1, filter2,… (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.

Box 2: FILTER

FILTER returns a table that represents a subset of another table or expression.

Syntax: FILTER(<table>, <filter>)

Table- The table to be filtered. The table can also be an expression that results in a table.

Filter – A Boolean expression that is to be evaluated for each row of the table. For example, [Amount]

> 0 or [Region] = "France"

Box 3: Orders [ShippedDate]> Orders [RequiredDate]

Northwind Traders defines late orders as those shipped after the required shipping date.

Reference:

https://docs.microsoft.com/en-us/dax/calculate-function-dax

https://docs.microsoft.com/en-us/dax/filter-function-dax

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.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: 9

9 distinct CSV files.

Box 2: 10

10 distinct dates.

https://pediaa.com/what-is-the-difference-between-unique-and-distinct-in-sql/#:~:text=Unique%20and%20Distinct%20are%20two%20SQL%20constraints.,the%20records%20fr om%20a%20table.

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?

Reveal Solution Hide Solution