Sales Analysis -Excle

I will start by working with the raw dataset and documenting its initial state before making any changes.

First, I will clean and prepare the data by:

- Removing duplicate rows.

- Handling missing and blank values.

- Correcting data types for dates, numbers, and other fields.

- Standardizing the data to make it accurate and ready for analysis.

After cleaning the data, I will use Pivot Tables to explore the dataset, identify relationships and patterns, and extract meaningful results and insights.

Finally, I can create an interactive dashboard in Excel to present the key findings in a clear and easy-to-understand way. If you prefer, I can also build the dashboard using Power BI.