Which two actions should you perform?

You have a prospective customer list that contains 1,500 rows of data.

The list contains the following fields:

✑ First name

✑ Last name

✑ Email address

✑ State/Region

✑ Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A . Open the Advanced Editor.
B . Select Column quality.
C . Enable Column profiling based on entire dataset.
D . Select Column distribution.
E . Select Column profile.

View Answer

Answer: D,E

Explanation:

Data Profiling, Quality & Distribution in Power BI / Power Query features

To enable these features, you need to go to the View tab à Data Preview Group à Check the following:

✑ Column quality

✑ Column profile

✑ Column distribution

✑ Column profile

Turn on the Column Profiling feature.

Column distribution

Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts.

Reference: https://www.poweredsolutions.co/2019/08/13/data-profiling-quality-distribution-in-power-bi-power-query/

https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/