This is an Excel-based sales analysis project created for FashionKart, an online fashion store. The goal was to understand customer behavior, top-performing platforms, and regional trends based on 2022 order data.
The project includes:
- Cleaned raw sales data
- Pivot tables and charts
- An interactive dashboard with slicers
- A summary report with key insights
- 65% of orders were placed by women
- Maharashtra, Karnataka, and Uttar Pradesh were the top states by revenue
- Adults aged 30β49 placed the most orders
- Amazon, Flipkart, and Myntra were the most effective channels
- Most orders were successfully delivered
- FashionKart_Excel_Sales_Analysis.xlsx β Complete Excel dashboard
- FashionKart_Sales_Insights_Report_2022.pdf β Business insights report
- screenshot.png β Dashboard preview image
- Microsoft Excel (Pivot Tables, Charts, Slicers)
π Download the full report here:
FashionKart_Sales_Insights_Report_2022.pdf
π Preview the dashboard below:
Thanks for viewing this project! π
