You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

Comment: *

Name: *

Email: *

Verification: *

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

• A.Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
• B.Duplicate the Date query in Power Query and use active relationships between both Date tables.
• C.On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
• D.Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Comment: *

Name: *

Email: *

Verification: *

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?

• A.Viewer
• B.Contributor
• C.Member
• D.Admin

Correct Answer: C

A Member can add members or others with lower permissions.
Note:

Comment: *

Name: *

Email: *

Verification: *

You need to create the dataset. Which dataset mode should you use?

• A.Composite
• B.Live connection
• C.DirectQuery
• D.Import

Comment: *

Name: *

Email: *

Verification: *

You have a query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

• A.=Table.ExpandListColum(Table.TransformColunins(Source, {{"classes". Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")
• B.= Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
• C.= Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None), {"classes.1"})
• D.= Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

Correct Answer: B

Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.

Note:
Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.
Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column
https://docs.microsoft.com/en-us/powerquery-m/table-unpivot

Comment: *

Name: *

Email: *

Verification: *