Summary  
This chapter covers data profiling and exploration techniques using column profiling to examine value distributions, identify missing or duplicate values, and compute summary statistics to guide data cleaning transformations.

General domain of usage  
Data cleaning and quality assessment

Use the **Column Profiler** in Power Query to assess the bicycle dataset and identify potential errors, required transformations, and overall data quality issues. The Column Profiler offers detailed insights such as **value distribution, data quality, and summary statistics**.

By reviewing these metrics, you can detect problems like duplicate or missing values, better understand data distribution, and determine which transformations are needed to clean and prepare the dataset for analysis.


Data Profiling and Exploration