Data set cleaning and preprocessing using power bi

The dataset underwent a comprehensive data cleaning process using Power BI to ensure its accuracy, consistency, and readiness for insightful analysis. Duplicate records were identified and removed to maintain data integrity, while missing values were carefully handled based on the context and relevance of each column, ensuring that no critical information was lost. New calculated columns were added to enhance the dataset’s analytical potential and to simplify the creation of meaningful visualizations in the subsequent stages. Errors and invalid entries were identified, corrected, or transformed into valid formats to make the data both reliable and actionable. This entire process was guided by a thorough understanding of the dataset and a clear assessment of the significance of each column, ensuring that the cleaned data would provide valuable insights and support informed decision-making.