You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

• A.In the Sales table, add a measure for sum(sales_amount).
• B.Change the data type of sales[sales_id] to Text.
• C.Change the data type of Sales[region_id] to Whole Number.
• D.Change the data type of sales [region_id] to Decimal Number.

Comment: *

Name: *

Email: *

Verification: *

Drag and Drop Question
You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:
- Identify months that have order counts above the mean.
- Display the mean monthly order count.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You import a large dataset to Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point

• A.Monospaced
• B.Show whitespace
• C.Column distribution
• D.Column quality
• E.Column profile

Comment: *

Name: *

Email: *

Verification: *

You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

1 - Pin items from report to Dashboard.
2 - Open Dashboard.
3 - Change the dashboard view to Phone view.
4 - Rearrange, resize the visuals.

Comment: *

Name: *

Email: *

Verification: *

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:

Comment: *

Name: *

Email: *

Verification: *