Performance Overview
220 records · 12 cols · Sales Analytics
Filter:
Revenue
10.04M
▼ -24% vs Nov
Total Orders
220
Profit
5.02M
▼ -22% vs Nov
Margin
50%
Regions
8
Suez
Monthly Trend
Discount Impact by Region
Suez leads revenue with 17% of total
Safety Helmet Pro is top seller with 23% of total
Order Status
Channel / Product Performance
| Product | # | Revenue | Share | Status |
|---|---|---|---|---|
| 1Safety Helmet Pro | 28 | 1.47M | 100% | ✓ Good |
| 2Laptop Pro X1 | 31 | 1.32M | 90% | ✓ Good |
| 3Welding Machine | 26 | 1.3M | 89% | ✓ Good |
| 4Generator 5KVA | 23 | 1.25M | 85% | ✓ Good |
| 5Water Pump 3HP | 25 | 979.3K | 67% | ✓ Good |
| 6Steel Cable 20m | 20 | 918.9K | 63% | ✓ Good |
| 7Compressor 50L | 20 | 892.7K | 61% | ✓ Good |
| 8Scaffolding Set | 13 | 743K | 51% | ✓ Good |
| 9Industrial Drill Set | 17 | 611.2K | 42% | ✓ Good |
| 10Concrete Mixer | 17 | 558K | 38% | ✓ Good |
Expert Recommendations
✦
Expert Analysis
220 Orders · Revenue 10.04M · Profit 50% · Top: Suez / Safety Helmet Pro
🎯
Top Revenue Product
"Safety Helmet Pro" generated 1,465,886 — allocate 70% marketing budget here.
📍
Top Region
"Suez" generated 1,667,273 — expand presence here.
⚠️
Cancelled/Rejected Orders
140 orders (64%) cancelled or rejected — identify root cause.
Loss & Risk Analysis
220 records · 12 cols · Sales Analytics
Filter:
Returned
23
Pending
43
Avg Disc
3%
At Risk
6.39M
▼ -35% vs Nov
Revenue vs Profit by Channel
Suez most profitable with 17% of total
Order Status
Regional Revenue Trend
Safety Helmet Pro most profitable with 14% of total
Expert Recommendations
✦
Expert Analysis
23 (10%) returned. 43 pending. Avg disc: 3%.
📊
Revenue Concentration
Top 3 products account for 41% of revenue — diversifying the portfolio reduces risk.
🧾
Average Order Value
Average order value is 45,625 across 220 orders.
🌍
Regional Performance Gap
"Mansoura" averages 53,286 vs "Alexandria" at 31,956.
Opportunity Mapping
220 records · 12 cols · Sales Analytics
Filter:
Top Region
1.67M
Suez
▼ -35% vs Nov
Top Product
1.47M
Safety Helmet Pro
▼ -35% vs Nov
Completed
37
Quantity
9,134
Open
43
Unit Price (EGP)
1,128
Records
220
Claude is generating data-driven recommendations…
Expert Recommendations
✦
Expert Analysis
Expand top products to weak regions — highest-leverage growth move.
🔎
Largest Single Order
The largest order is worth 146,484 — 4.1x the median order.
⏳
Pending Orders
43 orders (20%) are still pending — needs follow-up.
📦
Product Diversity
10 distinct products/categories across 220 records.
Raw Data
220 records · 12 cols
Full Dataset
| TOrder ID ↕ | TProduct ↕ | TRegion ↕ | TChannel ↕ | TMonth ↕ | #Quantity ↕ | #Unit Price (EGP) ↕ | #Discount % ↕ | #Revenue (EGP) ↕ | #Cost (EGP) ↕ | #Profit (EGP) ↕ | TStatus ↕ |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ORD-2024-0001 | Welding Machine | Aswan | Direct | Jun | 64 | 1,120 | 14 | 61,645 | 30,833 | 30,812 | Cancelled |
| ORD-2024-0002 | Safety Helmet Pro | Suez | Referral | Mar | 1 | 1,785 | 0 | 1,785 | 1,034 | 751 | Completed |
| ORD-2024-0003 | Welding Machine | Luxor | Referral | Nov | 57 | 1,891 | 0 | 107,787 | 47,194 | 60,593 | Cancelled |
| ORD-2024-0004 | Water Pump 3HP | Asyut | Tender | Jul | 47 | 1,091 | 0 | 51,277 | 22,457 | 28,820 | Cancelled |
| ORD-2024-0005 | Laptop Pro X1 | Port Said | Distributor | Jul | 71 | 203 | 0 | 14,413 | 8,070 | 6,343 | Cancelled |
| ORD-2024-0006 | Scaffolding Set | Port Said | Online | Feb | 64 | 479 | 1 | 30,349 | 16,316 | 14,033 | Completed |
| ORD-2024-0007 | Steel Cable 20m | Cairo | Direct | Nov | 76 | 902 | 0 | 68,552 | 36,774 | 31,778 | Cancelled |
| ORD-2024-0008 | Industrial Drill Set | Mansoura | Online | Jun | 18 | 1,104 | 0 | 19,872 | 10,307 | 9,565 | Cancelled |
| ORD-2024-0009 | Water Pump 3HP | Suez | Distributor | Apr | 50 | 888 | 0 | 44,400 | 19,113 | 25,287 | Pending |
| ORD-2024-0010 | Water Pump 3HP | Luxor | Referral | Jan | 78 | 1,084 | 0 | 84,552 | 37,521 | 47,031 | Cancelled |
| ORD-2024-0011 | Steel Cable 20m | Luxor | Online | Jan | 40 | 783 | 0 | 31,320 | 15,904 | 15,416 | Pending |
| ORD-2024-0012 | Water Pump 3HP | Port Said | Referral | Sep | 20 | 367 | 0 | 7,340 | 3,638 | 3,702 | Cancelled |
| ORD-2024-0013 | Compressor 50L | Aswan | Distributor | Mar | 74 | 1,420 | 8 | 96,674 | 48,011 | 48,663 | Pending |
| ORD-2024-0014 | Safety Helmet Pro | Luxor | Online | Sep | 5 | 1,720 | 20 | 6,880 | 3,383 | 3,497 | Cancelled |
| ORD-2024-0015 | Industrial Drill Set | Luxor | Referral | May | 6 | 719 | 0 | 4,314 | 2,089 | 2,225 | Cancelled |
| ORD-2024-0016 | Industrial Drill Set | Alexandria | Direct | Aug | 66 | 1,197 | 0 | 79,002 | 44,156 | 34,846 | Pending |
| ORD-2024-0017 | Laptop Pro X1 | Asyut | Direct | Aug | 76 | 1,762 | 0 | 133,912 | 61,619 | 72,293 | Cancelled |
| ORD-2024-0018 | Generator 5KVA | Mansoura | Distributor | Nov | 28 | 843 | 0 | 23,604 | 13,767 | 9,837 | Cancelled |
| ORD-2024-0019 | Concrete Mixer | Port Said | Direct | Jun | 14 | 1,747 | 0 | 24,458 | 11,910 | 12,548 | Cancelled |
| ORD-2024-0020 | Industrial Drill Set | Alexandria | Direct | Mar | 14 | 1,756 | 3 | 23,846 | 12,097 | 11,749 | Cancelled |
| ORD-2024-0021 | Laptop Pro X1 | Port Said | Referral | Feb | 24 | 696 | 5 | 15,869 | 8,072 | 7,797 | Completed |
| ORD-2024-0022 | Industrial Drill Set | Port Said | Referral | Jun | 48 | 1,001 | 0 | 48,048 | 26,648 | 21,400 | Pending |
| ORD-2024-0023 | Laptop Pro X1 | Aswan | Direct | Jun | 10 | 1,587 | 0 | 15,870 | 7,025 | 8,845 | Pending |
| ORD-2024-0024 | Laptop Pro X1 | Luxor | Tender | May | 40 | 1,465 | 0 | 58,600 | 25,335 | 33,265 | Completed |
| ORD-2024-0025 | Compressor 50L | Asyut | Online | Jul | 21 | 1,867 | 0 | 39,207 | 20,550 | 18,657 | Cancelled |
| ORD-2024-0026 | Laptop Pro X1 | Mansoura | Tender | Nov | 38 | 798 | 21 | 23,956 | 14,242 | 9,714 | Cancelled |
| ORD-2024-0027 | Compressor 50L | Alexandria | Tender | Jan | 68 | 756 | 0 | 51,408 | 23,081 | 28,327 | Returned |
| ORD-2024-0028 | Steel Cable 20m | Alexandria | Referral | Mar | 34 | 724 | 4 | 23,631 | 10,404 | 13,227 | Cancelled |
| ORD-2024-0029 | Laptop Pro X1 | Luxor | Online | Oct | 16 | 615 | 1 | 9,742 | 4,993 | 4,749 | Returned |
| ORD-2024-0030 | Laptop Pro X1 | Aswan | Distributor | Jun | 16 | 528 | 0 | 8,448 | 4,255 | 4,193 | Completed |
| ORD-2024-0031 | Industrial Drill Set | Luxor | Distributor | May | 73 | 964 | 9 | 64,039 | 32,962 | 31,077 | Pending |
| ORD-2024-0032 | Industrial Drill Set | Port Said | Referral | Jul | 55 | 1,099 | 0 | 60,445 | 25,610 | 34,835 | Returned |
| ORD-2024-0033 | Generator 5KVA | Mansoura | Distributor | Oct | 20 | 1,996 | 0 | 39,920 | 23,761 | 16,159 | Cancelled |
| ORD-2024-0034 | Concrete Mixer | Luxor | Direct | Jul | 7 | 1,484 | 0 | 10,388 | 5,113 | 5,275 | Completed |
| ORD-2024-0035 | Compressor 50L | Suez | Tender | Jan | 14 | 1,377 | 0 | 19,278 | 9,205 | 10,073 | Cancelled |
| ORD-2024-0036 | Generator 5KVA | Mansoura | Tender | Feb | 28 | 1,373 | 0 | 38,444 | 18,323 | 20,121 | Cancelled |
| ORD-2024-0037 | Safety Helmet Pro | Cairo | Online | Jun | 41 | 1,736 | 0 | 71,176 | 33,705 | 37,471 | Completed |
| ORD-2024-0038 | Safety Helmet Pro | Alexandria | Referral | Mar | 47 | 1,232 | 5 | 55,009 | 32,019 | 22,990 | Pending |
| ORD-2024-0039 | Safety Helmet Pro | Cairo | Online | Aug | 66 | 493 | 0 | 32,538 | 15,184 | 17,354 | Cancelled |
| ORD-2024-0040 | Safety Helmet Pro | Suez | Direct | Feb | 78 | 756 | 5 | 56,020 | 26,823 | 29,197 | Pending |
| ORD-2024-0041 | Generator 5KVA | Suez | Distributor | Oct | 74 | 1,810 | 0 | 133,940 | 65,517 | 68,423 | Cancelled |
| ORD-2024-0042 | Steel Cable 20m | Suez | Direct | Dec | 52 | 1,626 | 0 | 84,552 | 38,115 | 46,437 | Completed |
| ORD-2024-0043 | Laptop Pro X1 | Asyut | Referral | Mar | 6 | 1,926 | 0 | 11,556 | 6,625 | 4,931 | Cancelled |
| ORD-2024-0044 | Safety Helmet Pro | Aswan | Distributor | Feb | 19 | 628 | 13 | 10,381 | 4,800 | 5,581 | Cancelled |
| ORD-2024-0045 | Water Pump 3HP | Cairo | Online | Sep | 18 | 1,929 | 0 | 34,722 | 20,175 | 14,547 | Cancelled |
| ORD-2024-0046 | Steel Cable 20m | Cairo | Distributor | Nov | 47 | 634 | 0 | 29,798 | 13,300 | 16,498 | Returned |
| ORD-2024-0047 | Welding Machine | Port Said | Tender | Sep | 72 | 1,707 | 9 | 111,843 | 63,210 | 48,633 | Cancelled |
| ORD-2024-0048 | Compressor 50L | Cairo | Tender | Dec | 17 | 622 | 0 | 10,574 | 5,143 | 5,431 | Cancelled |
| ORD-2024-0049 | Concrete Mixer | Cairo | Referral | Sep | 80 | 1,344 | 18 | 88,166 | 43,199 | 44,967 | Completed |
| ORD-2024-0050 | Water Pump 3HP | Cairo | Referral | Feb | 49 | 1,384 | 0 | 67,816 | 40,067 | 27,749 | Returned |
…1–50 / 220