Reviewing column quality, distribution, and profile
As mentioned earlier, Column distribution, Column quality, and Column profile views are the fundamental features of Power BI and Power Query, and they provide comprehensive insights into your dataset. These views are essential for EDA and help you understand the characteristics of individual columns in your data.
In the following sections, we will explore each view and how they report information.
Column distribution
The Column distribution view in Power BI and Power Query allows you to explore the distribution of values within a specific column. It provides visualization and statistics that help you understand how data is spread across different ranges or categories.
Let’s see an example from the dataset provided in this book’s GitHub repository. Here, we have only selected Column distribution and have then zoomed in on a particular value called OrderQuantity.
Figure 8.2 –...
