Northwind Intelligence
Executive Overview
Real-time pulse on revenue, demand, and operational efficiency.
Total Revenue
$1,265,793
Gross sales after discounts
Orders
830
Distinct order volume
Avg Order Value
$1,525
Revenue divided by orders
Customers
91
Active accounts in CRM
Products
77
Live SKUs across categories
Employees
9
Sales + operational staff
Revenue Momentum
Monthly net sales and order velocity
Category Contribution
Sales share by product category
Category Revenue Share
Market share snapshot by category
Shipper Revenue Share
Revenue distribution by shipping partner
Top Shipping Cities
Cities with highest shipped revenue
Top Customers
Accounts generating the most revenue
Customer IRRVL
Germany
$110,277
28 orders
Customer THHDP
Austria
$104,875
30 orders
Customer LCOUJ
USA
$104,362
31 orders
Customer NYUHS
USA
$51,098
18 orders
Customer FRXZL
Ireland
$49,980
19 orders
Customer IBVRG
Brazil
$32,841
14 orders
Customer GLLAG
Germany
$30,908
14 orders
Customer CYZTN
Sweden
$29,568
19 orders
Relationship Highlights
Key joins powering the analytics model
- SalesOrder ➜ OrderDetail ➜ Product ➜ Category drives revenue segmentation.
- Customer and Employee tables connect to SalesOrder for performance and loyalty analysis.
- Supplier joins with Product to reveal vendor concentration risk.
- Shipping partners (Shipper) capture fulfillment efficiency and lead-time trends.