Notifications
Clear all
Topic starter
06/08/2022 5:34 pm
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.
Suggested Answer: C,E
Explanation:
In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set. https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/
Explanation:
In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set. https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/