Data profiling features
Microsoft Power BI has data profiling features that offer simple ways to examine and analyze the data in the Power Query Editor. These are found under the View tab on the ribbon, as shown in Figure 5.22:
Figure 5.22 – Data profiling tools in the View tab
In the next subsections, we will cover the data profiling features of column quality, column distribution, and column profile.
Column quality
This feature indicates what the column quality of the data is in five categories as shown in Figure 5.23:
Figure 5.23 – Column quality indicators
The colors reflect the quality of the data in the columns and make it easier to analyze and examine.
Figure 5.24 shows where the column quality is found in the Power Query Editor:
Figure 5.24 – Column quality
We can see from the indicators that the first five columns are valid, while the last three are empty...