Skip to content

An Excel-based sales dashboard and insights report for FashionKart, built using pivot tables, charts, and slicers to analyze 2022 e-commerce performance.

Notifications You must be signed in to change notification settings

atulraj-data/Fashionkart-sales-dashboard

Repository files navigation

FashionKart Sales Dashboard (2022)

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

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

Files Included

  • FashionKart_Excel_Sales_Analysis.xlsx – Complete Excel dashboard
  • FashionKart_Sales_Insights_Report_2022.pdf – Business insights report
  • screenshot.png – Dashboard preview image

Tools Used

  • Microsoft Excel (Pivot Tables, Charts, Slicers)

πŸ“Œ Download the full report here:
FashionKart_Sales_Insights_Report_2022.pdf

πŸ“Š Preview the dashboard below:

Dashboard Preview


Thanks for viewing this project! πŸ™‚

About

An Excel-based sales dashboard and insights report for FashionKart, built using pivot tables, charts, and slicers to analyze 2022 e-commerce performance.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published