Sales Dashboard provides a comprehensive visualization of company sales performance across multiple dimensions including product categories, customer segments, time periods, and geographical distribution.
This interactive Sales Dashboard provides a comprehensive overview of the company’s sales performance from 2014 to 2017, helping stakeholders visualize key business metrics — including sales by category, profit trends, customer insights, and regional performance.
It is designed for quick decision-making and actionable business insights.
-
Top Performing Categories:
- 📱 Phones: $330,007.10
- 💺 Chairs: $328,167.76
-
Moderate Performance:
- Storage, Tables, and Binders — between $200K to $220K
-
Low Performing Categories:
- Labels and Fasteners show minimal sales, suggesting low demand or poor visibility.
- Furniture and Technology profits grew steadily year over year.
- Office Supplies remained relatively stable.
- Both Furniture and Technology peaked in 2017, showing strong product diversification and improved margins.
- The U.S. sales map reveals California as the highest revenue-generating state (≈ $457,687.68).
- Other regions contribute moderately.
| Year | Customer Count (Approx.) |
|---|---|
| 2014 | 600 |
| 2015 | 650 |
| 2016 | 700 |
| 2017 | 800 |
| Rank | Customer Name |
|---|---|
| 1️⃣ | Tamara Chand |
| 2️⃣ | Raymond Buch |
| 3️⃣ | Sanjit Chand |
| 4️⃣ | Hunter Lopez |
| 5️⃣ | Adrian Barton |
- Noticeable spikes in months 9 and 11 (September & November).
- Likely linked to seasonal promotions or year-end corporate purchasing.
- 📈 Steady Sales Growth — consistent improvement from 2014–2017.
- 💰 Profit Leaders — Furniture & Technology drive most profits.
- 🧭 Regional Focus — Western U.S. outperforms others.
- 👥 Customer Growth — steady expansion each year.
- 🧾 Low-performing Items — opportunity to improve sales for stationery and small accessories.
- Phones and Chairs dominate sales, reflecting strong B2B demand. Consider targeted marketing for underperforming product lines.
- Profitability growth highlights success in scaling technology products while maintaining leadership in the furniture segment.
- Sales are geographically concentrated. Expanding to central and eastern U.S. markets could boost overall revenue.
- Customer base steadily increased over four years, indicating higher brand awareness and retention rates.
- A few key clients contribute a major share of profits — a “Key Account Management” approach can sustain and grow these relationships.
- Forecast demand surges to optimize stock levels and campaign timing.
The Sales Dashboard serves as a complete business intelligence tool, revealing strong product performance, key regional markets, and loyal customer growth.
It empowers management with data-driven insights for future planning, marketing, and strategic investment.
Sales are geographically concentrated. Expanding to central and eastern U.S. markets could boost overall revenue.
For further insights download Sales Dashboard.xlsx and apply filters for more insights.
- Tool Used: Microsoft Excel
- Features: Interactive Slicers for Category & Year
- Visuals: Funnel Chart, Line Chart, Pie Chart, Map Chart, and Area Chart
- Data Source: Sample Sales Dataset (2014–2017)
- Purpose: Sales trend analysis and business performance reporting
Created by: Paramesh Mandapaka
📧 [email protected]
⭐ If you find this project helpful, give it a star on GitHub!