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: DE

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/