Bike Sales Cleaning

This dataset was cleaned and transformed in Power Query to prepare it for analysis. Several steps were applied, including promoting headers, changing data types, splitting and inserting text within columns, and renaming columns for clarity. Errors and inconsistencies were handled, such as correcting the spelling of “Decmber” to “December” using a Replace Values step. Columns were also reordered, unnecessary fields removed, and conditional columns created to categorize data (e.g., grouping customer ages). These transformations ensured that the dataset became consistent, structured, and ready for visualization and deeper analysis in Power BI.