This project demonstrates my approach

This project demonstrates my approach to preparing reliable data for analysis using Microsoft Excel.

I worked on identifying duplicate order IDs, checking missing values, correcting data formats, and validating calculated profit metrics. These quality checks helped improve data consistency and prepare the dataset for further analysis.

Key activities

Identified duplicate order IDs.

Reviewed missing values in important columns.

Standardized data formats, including discount percentages.

Validated calculated profit and profit variance.

Prepared the dataset for accurate reporting and analysis.