Data Profiling and Exploration

We will use the Column Profiler in Power Query to evaluate our bicycle dataset to identify errors, necessary transformations, and other data quality needs. The Column Profiler provides detailed insights into the data, including value distribution, data quality, and summary statistics. By analyzing these metrics, we can pinpoint issues such as duplicate or missing values, understand the distribution of our data, and decide on the necessary transformations to clean and prepare our dataset for analysis.