Superstore-Data-Analysis-Project

?️ Superstore Sales Data Analysis Project ? Project Overview This project involves a comprehensive Data Cleaning and Analysis process of the "US Superstore 2019" dataset. The goal was to transform raw sales data into actionable insights using Excel and Power Query.

?️ Tools Used Microsoft Excel: For data visualization and reporting.

Power Query: Used for data cleaning, handling missing values, and data transformation.

Pivot Tables & Charts: To summarize data and create a dynamic dashboard.

? Data Cleaning Steps Removing Duplicates: Ensured each order record is unique.

Formatting: Standardized dates and currency formats.

Data Transformation: Merged tables (Orders, People, Returns) to create a unified dataset for analysis.

? Key Insights (Examples) Total Sales: $668,675.46

Total Profit: $204,045.83

Best Performing Category: Technology & Office Supplies.