a ; ; ; ; ; ; ; ; ; ; ; "Knowledge Graph representation of the Northwind Traders sample database"; "2026-09-29T23:29:09.924Z"^^; "Northwind Traders" . a ; "Discount rate by month"; "PREFIX schema: \n\nSELECT ?month (ROUND(SUM(?discount) * 1000 / SUM(?gross)) / 10 AS ?discountPercent)\nWHERE {\n GRAPH ?orderGraph {\n ?order a schema:Order ;\n schema:orderDate ?orderDate ;\n schema:orderedItem ?orderItem .\n # the line's own price is net of discount; the catalogue price it was struck\n # against hangs off it as a ListPrice specification\n ?orderItem schema:orderQuantity ?quantity ;\n schema:price ?net ;\n schema:priceSpecification ?listPrice .\n ?listPrice schema:priceType schema:ListPrice ;\n schema:price ?unitPrice .\n BIND(SUBSTR(STR(?orderDate), 1, 7) AS ?month)\n BIND(?quantity * ?unitPrice AS ?gross)\n BIND(?gross - ?net AS ?discount)\n }\n # The order book stops part-way through its final month, which would render as a\n # cliff rather than a trend. Drop that month — derived from the data, not pinned\n # to a date, so it stays correct if the dataset grows.\n {\n SELECT (SUBSTR(STR(MAX(?anyDate)), 1, 7) AS ?partialMonth)\n WHERE {\n GRAPH ?g { ?anyOrder a schema:Order ; schema:orderDate ?anyDate }\n }\n }\n FILTER (?month < ?partialMonth)\n}\nGROUP BY ?month\nORDER BY ?month" . a ; "Monthly sales trend"; ; "month"; ; "revenue" . a ; ; "Revenue by country" . a ; "Revenue by country"; ; "country"; ; "revenue" . a ; ; "Vice President, Sales" . a ; ; "Top selling products" . a ; "
\n
\n

Browse the business

\n

Open Orders for the order book and its master–detail line items, or go straight to products, customers, employees and the reference data behind them.

\n
\n
"^^ . a ; ; "Monthly sales trend" . a ; "Revenue by country"; "PREFIX schema: \n\nSELECT ?country (SUM(?sale) AS ?revenue)\nWHERE {\n GRAPH ?orderGraph {\n ?order schema:orderedItem ?orderItem ;\n schema:orderDelivery ?delivery .\n ?orderItem schema:price ?sale .\n ?delivery schema:deliveryAddress ?address .\n ?address schema:addressCountry ?country .\n }\n}\nGROUP BY ?country\nORDER BY DESC(?revenue)\nLIMIT 10" . a ; "Discount rate"; ; "month"; ; "discountPercent" . a ; ; "Discount rate" . a ; "
\n
\n

Executive dashboard

\n

Sales performance at a glance — how revenue is trending, what the discounting costs,\n where the markets are and which products carry the mix.

\n
\n
"^^ . a ; ; "Sections" . a ; "
\n
\n

Sales leadership

\n

The Vice President of Sales, with the territories, reports and order history attached to the role.

\n
\n
"^^ . a ; "
\n
\n

What the deals cost

\n

Revenue is what was billed, not what was listed. Every order line keeps the catalogue\n price it started from alongside the price it actually went out at, so the gap between\n them is what the sales rep gave away to win the deal. Measured against gross, that gap\n swings between roughly 4% and 11% month to month — a commercial lever in its own\n right, and one that never shows up in a revenue chart.

\n
\n
"^^ . a ; "Sales by month"; "PREFIX schema: \n\nSELECT ?month (SUM(?sale) AS ?revenue)\nWHERE {\n GRAPH ?orderGraph {\n ?order a schema:Order ;\n schema:orderDate ?orderDate ;\n schema:orderedItem ?orderItem .\n ?orderItem schema:price ?sale .\n BIND(SUBSTR(STR(?orderDate), 1, 7) AS ?month)\n }\n # The order book stops part-way through its final month, which would render as a\n # cliff rather than a trend. Drop that month — derived from the data, not pinned\n # to a date, so it stays correct if the dataset grows.\n {\n SELECT (SUBSTR(STR(MAX(?anyDate)), 1, 7) AS ?partialMonth)\n WHERE {\n GRAPH ?g { ?anyOrder a schema:Order ; schema:orderDate ?anyDate }\n }\n }\n FILTER (?month < ?partialMonth)\n}\nGROUP BY ?month\nORDER BY ?month" .