Check your knowledge

Completed

Answer the following questions to see what you learned.

1.

How do you get Power BI Desktop to find relationships in data after importing?

Open the Power Query Editor

Select Manage Relationships and then Autodetect

To map the relationship, select the New Parameter button

Use the Performance Manager

2.

If your months were sorted alphabetically, how could you sort them by month order?

Select the Edit Queries button

Add a slicer to your visual

Change the visualization type

Apply the MonthNo category sort option

3.

How do you get Power BI to separate date data into year, quarter, month, and day?

Open the Query Editor

Select the New Parameter button

Select the New Measure button

You don't need to do anything, it's automatic.

4.

How do you create data tables that you want stored as part of the model rather than as part of a query?

Use a calculated table

Select the Enter Data button

Select the New Measure button

Select the New Parameter button

5.

Why would a table show the same value, like "Sales" for every country?

Because the Revenue data is corrupted

Because the column is assigned with the wrong data type

Because there's no relationship between the Sales and Country fields.

Because the column is sorted incorrectly

You must answer all questions before checking your work.