Sales Analysis Report

This is a Sales Dashboard Report summarizing order distribution across cities, states, and product categories. Here’s a breakdown of the key insights:

1. Total Orders and Cities Covered
- Total Orders: 110,547
- Number of Cities: 110,547 (likely representing total order records rather than unique cities)

2. Top 4 Products by Order
- T-shirts: 40%
- Shirts: 39%
- Blazers: 13%
- Trousers: 8%
- T-shirts and shirts dominate sales, accounting for nearly 80% of total orders.

3. Top 10 Cities by Order
- Bengaluru leads with 10,296 orders
- Hyderabad (7,728) and Mumbai (6,123) follow
- The least orders among the top 10 are in Lucknow (1,413)
- Southern cities like Bengaluru, Hyderabad, and Chennai show high demand

4. Top 7 States by Order
- Maharashtra has the highest number of orders (19,214), followed by Karnataka (14,944)
- Kerala has the lowest number among the top states (5,620)
- Northern states like Delhi and Uttar Pradesh have relatively lower orders compared to Maharashtra and Karnataka

Insights and Decision Making
- The high number of orders in Bengaluru, Hyderabad, and Mumbai suggests a strong market for expansion in these cities
- T-shirts and shirts contribute the most to sales, indicating they should remain a priority for promotions and inventory management
- Maharashtra and Karnataka are the strongest states for sales, meaning targeted marketing and logistics optimization in these areas could boost performance further
- Cities like Gurugram, Thane, and Lucknow have lower orders, which might require marketing efforts to increase demand