This project presents the Chitra Collections Annual Report 2024 through an interactive Excel dashboard using Pivot Tables, Charts, and Slicers. It provides key business insights for smarter, data-driven decisions.
- 📈 Sales & Orders: Tracks monthly trends and peak periods.
- 🚚 Order Status: Visualizes completed, refunded, and cancelled orders.
- 🗺 Top States: Maharashtra, Karnataka, and UP lead in revenue (~35%).
- 👥 Customer Demographics: Adults (~50%) and women (~65%) dominate purchases.
- 🛍 Sales Platforms: Amazon, Flipkart & Myntra account for ~80% of sales.
- 6 Pivot Charts for sales, orders, regions, demographics, and platforms
- 3 Slicers: Month, Category, Channel for dynamic filtering
- Clear visuals for quick and informed decision-making
The dashboard shows a noticeable peak in sales and orders during March, making it the strongest month of the year. Amazon (35%), Flipkart (22%), and Myntra (23%) dominate the sales channels, together contributing to 80% of total orders. The top-performing states were Maharashtra (3.0M), Karnataka (2.6M), and Uttar Pradesh (2.1M), indicating strong regional demand. Women accounted for 64% of total orders, with the highest purchases from adult women (~44%). Operationally, the brand maintained excellent service quality, with 92% of orders successfully delivered and minimal returns or cancellations.
📁 Tools: Microsoft Excel
📅 Scope: Full Year 2024
🎯 Goal: Visualize key metrics, understand trends, and support business strategy
This dashboard turns raw data into actionable insights, making it easier to track performance, spot trends, and make informed business decisions — all within the familiar environment of Excel.