Previous

Next

Check your knowledge

Completed

Answer the following questions to see what you've learned.

1.

How do you get Power BI Desktop to find relationships in data after it has been imported?

Open the Power Query Editor

Select Manage Relationships and then Autodetect

Select the New Parameter button to map the relationship

Use the Performance Manager

2.

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

Click 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 is 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 is no relationship between the Sales and Country fields.

Because the column is sorted incorrectly

You must answer all questions before checking your work.

Continue