Sales Data Analysis - Excel

Project Overview

The Sales Data Analysis project focuses on extracting meaningful insights and optimizing business strategies through a comprehensive analysis of sales data. By leveraging advanced analytics and visualization techniques.

Tools Used ?

Excel

Data Cleaning ?

Remove Duplicates: Eliminated duplicate values from the dataset.

Format Modification: Adjusted data formats for numbers and dates.

Fill Missing Data: Populated empty cells in the "adjustment_reason" column based on the available data.

Fill Missing Data: Populated empty cells in the "simplified_return_reason" column based on the available data.

Data Analysis

Total Profit: $10,247,457

Total Products: 3,000

Total Sales: $160,073.913