📊 Large-Scale Transaction & Sales Data Cleaning

I recently completed a data cleaning project involving 533,643 transaction & sales records.

The dataset required standardization and quality checks across multiple fields.

Work performed: • Transaction number cleaning and standardization • Customer number standardization • Product name cleanup and spelling consistency • Customer name formatting • Country field cleanup • Quantity validation and outlier review • Missing-value identification • Correction of invalid negative quantity values • Transaction date validation

The final objective was to produce a more consistent, structured, and analysis-ready dataset.

This project strengthened my practical experience in handling large datasets and performing systematic data quality checks using Excel.

Skills: Data Cleaning | Data Quality | Excel | Data Analysis | Data Standardization