Backlinks
The order book
Every order links a customer, the sales rep who booked it, the shipper that delivered it and the products it contains. Orders are listed newest first with their status — sort any column or filter with the facets. Open one for its full master–detail view: line items with their quantities and line totals, the catalogue price each was struck against, the delivery and its address, and the people and companies involved.
- Title
-
All orders
- Value
Backlinks
Order analytics
Beyond the individual records, how has order volume developed over time?
- Title
-
Orders per month
- Value
Backlinks
From order to doorstep
Every order records three dates: the day it was placed, the day the customer needed it by, and — once the parcel actually leaves the warehouse — the day it was dispatched. Two questions fall out of those. How quickly does Northwind get an order out of the door, and how often does it beat the date it promised? Orders still waiting to ship are left out of the second chart, since they have no outcome yet.
- Title
-
Days to ship
- Value
- Title
-
Shipped on time
- Value
Backlinks
Who carries the freight
Three carriers deliver every order, which makes them worth comparing on two axes. How often does a carrier miss the date the customer was promised, and how much revenue does each one move month to month? The first is a question about reliability, the second about how the shipping mix has shifted.
- Title
-
Late shipments by carrier
- Title
-
Revenue by carrier
- Value