Sales Report

This dashboard presents a detailed analysis of overall business performance, highlighting total sales, order volumes, product categories, employee contributions, and regional distribution. It provides key insights into sales trends, order types, and top-performing products and employees.

Key Performance Indicators

Total Sales: 647K

Total Orders: 44K

Total Products: 41

Total Quantity Sold: 154K

Average Price: 4.2

These figures reflect strong overall performance and steady customer engagement across multiple regions and product categories.

Monthly Sales Performance

The “Total Sales by Month” chart indicates steady performance throughout the year, with significant peaks observed in March, August, and December. This suggests increased customer demand during these periods, likely driven by seasonal or promotional campaigns.

Sales by Order Type

Dine In: 69.86%

Take Away: 30.14%

Dine-in orders account for the majority of sales, emphasizing the continued importance of in-store customer experience and service quality.

Sales by Product Category

Hot Drinks: 60.14%

Cold Drinks: 24.99%

Desserts: 14.87%

Hot Drinks remain the leading revenue contributor, indicating strong customer preference and consistent demand across locations.

Top-Performing Sub-Categories

The top-selling sub-categories include Espresso (155K), Frappe (73K), and Cappuccino (66K), followed by Mocha, Cake, and Tea. These products represent the core drivers of sales revenue.

Top Employees by Sales Performance

The leading sales performers are Adel Morsy (38K), Marina Morsy (27K), and Amr Mohamed (26K), demonstrating strong individual contributions to overall revenue. The remaining top performers also show consistent productivity across multiple reporting periods.

Sales by Country and Order Type

The UAE recorded the highest sales (199K combined dine-in and takeaway), followed by Egypt (167K) and Saudi Arabia (148K). This regional performance highlights strong brand presence and customer loyalty in the Middle East market.

Sales by City

Cities such as Dubai (132K) and Cairo (126K) lead in total sales, followed by Hurghada, Abu Dhabi, and Jeddah, reinforcing the importance of these urban centers as primary business hubs.

Product-Level Insights

Top-performing individual products include Cappuccino (49K), Single Espresso (47K), and Macchiato (42K). These results emphasize consistent consumer demand for premium coffee beverages.