Sales Performance

This dashboard provides a comprehensive overview of sales and quantity performance across multiple locations and product categories, displaying the following key insights:

KPI Summary (Top Section)

Number of Sellers: 69 active sales representatives

Number of Products: 25 distinct products

Number of Places: 7 geographic locations

Total Sales: 529,276,283

Charts & Visualizations

1. Total Sales for Category in Places (Grouped Bar Chart)

Sales are broken down across 7 locations — Alex, Cairo, Canal, Delta, Giza, Sainai, and Upper — for four categories: Accessories, Bikes, Clothing, and Components. Alex and Delta show the highest overall sales, with Bikes and Components being the dominant revenue-generating categories across most locations.

2. Quantity Product in Places (Grouped Bar Chart)

Components consistently records the highest quantity sold across all locations, particularly in Cairo, Alex, Giza, and Delta, each reaching close to 80,000 units. Accessories show the lowest quantity in all regions.

3. Total Sales for Places (Bar Chart)

Giza leads all locations in total sales (~2.2M), followed closely by Cairo, Alex, and Delta. Sainai, Upper, and Canal show relatively lower but comparable performance.

4. Relation Between Quantity and Total Sales (Bar Chart)

Bikes generate the highest total sales after discount at $7,204,694 despite having only 53,411 units sold, indicating a very high price per unit. In contrast, Components has 543,095 units sold but generates only $2,064,356 in revenue, reflecting a low unit price with high volume strategy.

5. Filters Panel (Middle)

The dashboard includes interactive filters for Quarter (Qtr1–Qtr4) and Year (2011–2018), currently filtered to show Qtr1 and 2014 data.