PL-300 Exam Dumps - Microsoft Power BI Data Analyst

"The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data" => one dataset and two separate workspaces Reason: All data can be imported into one dataset also if these are two logical models. Shared dimensions can be reconsumed in both models. Reports and additional materials can be shared to the board with an app. The "profit and loss" data model needs RLS for the analysts and the analysts must have just read access to the original workspace. In a separate workspace with contributer (or more rights) they can create new reports (with live connection to the dataset). It is also stated that the new reports mustn't be shared so therefore no need to include them into the app. Import vs. DirectQuery: Due to RLS requirements an imported dataset is needed. It is not possible with file sources and Sharepoint lists.

Box 1: many-to-one

Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.

The Suppliers table has a Region column.

Box 2: Suppliers table

Use Power Query to calculate calendar quarter and calendar month.

Scenario:

A single dataset must support all three reports:

- The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

- The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category.

The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.

Box 1: Yes

The Related function returns a related value from another table.

The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship.

Box 2: Yes

Box 3: No

TX only occurs in the Sales table, but not in the CityData table.

Box 1: CALCULATE

CALCULATE evaluates an expression in a modified filter context.

Syntax: CALCULATE([, [, [, …]]])

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(