Sales Dashboard – Electronic Shop (Excel)

This Excel dashboard provides a comprehensive analysis of total sales worth ₹8,464,606, segmented by product, category, city, month, and salesperson. It is designed to offer quick insights into business performance and support data-driven decisions.

 

✅ Key Highlights:

• Top Product: Dell XPS 13 generated the highest revenue – ₹2,363,181

• Best Category: Laptops lead with ₹3,505,821, followed by Phones and Headphones

• Top City: Mumbai and Hyderabad contributed over ₹1.7 million each

• Strongest Month: December topped with ₹847,373 in sales

• Top Performer: Amar led all salespersons with ₹1,141,490

 

📊 Dashboard Features:

• Interactive filters for category, month, and region

• Comparative visuals for sales trends and individual contributions

• Summary KPIs and charts for easy performance tracking.

 

This dashboard enables clear visibility into sales trends, regional performance, product demand, and team output—helping guide strategic decisions and sales planning.