Column
Orders Per Country
| Orders by Country | |
| Northwind – Count of orders | |
| Country | Orders |
|---|---|
| Germany | 122 |
| USA | 122 |
| Brazil | 83 |
| France | 77 |
| UK | 56 |
| Venezuela | 46 |
| Austria | 40 |
| Sweden | 37 |
| Canada | 30 |
| Mexico | 28 |
| Italy | 28 |
| Spain | 23 |
| Finland | 22 |
| Belgium | 19 |
| Ireland | 19 |
| Switzerland | 18 |
| Denmark | 18 |
| Argentina | 16 |
| Portugal | 13 |
| Poland | 7 |
| Norway | 6 |
Column
Companys Returned Within 3 Months
| Customers Returned Within 3 Months | |
| Alphabetical | |
| # | Company |
|---|---|
| 1 | Customer AHPOP |
| 2 | Customer AHXHT |
| 3 | Customer AZJED |
| 4 | Customer CQRAA |
| 5 | Customer CYZTN |
| 6 | Customer EEALV |
| 7 | Customer EFFTC |
| 8 | Customer ENQZT |
| 9 | Customer HFBZG |
| 10 | Customer IRRVL |
| 11 | Customer JMIKW |
| 12 | Customer JYPSC |
| 13 | Customer KIdPX |
| 14 | Customer KZQZT |
| 15 | Customer ZRNDE |
KPIS
| KPIs | |
| Orders | 467 |
| Net Sales | $724,255 |
| Average Order Value | $1,550.87 |
| Items Sold | 27,920 |
Column
Shippers Analysis
| Shipper Efficiency | ||||
| Lower is better | ||||
| Rank | Shipper | Avg Ship Time (days) | Late Shipments | Score |
|---|---|---|---|---|
| 1 | 3 | 7 | 9 | 2 |
| 2 | 1 | 9 | 12 | 4 |
| 2 | 2 | 9 | 16 | 5 |
| Legend: Avg Ship Time lower → higher   |  Late Shipments lower → higher | ||||
New VS Returning Customers
Column
Top Customers (By Net Sales)
Top Categories (By Net Sales)
