a ; "
\n
\n

Product categories

\n

The segments the catalogue is organised into — beverages, condiments, produce and the rest.\n Open one to see the products it holds.

\n
\n
"^^ . a ; ; "produce.jpg"; "produce.jpg"; "7c70989e58855ffd8628e0a7d5144a10fd70a1ee" . a ; ; "confections.jpg"; "confections.jpg"; "e781b6c8e83be3f23aa241416f92447a66dc35e4" . a ; ; "cereals.jpg"; "cereals.jpg"; "8a3112b3c6691588d47028fd3907f45d24f47784" . a ; "All categories"; ; . a ; ; "beverages.jpg"; "beverages.jpg"; "ec56b79671b30ecb98316d9b766fba198286b3b6" . a ; "Revenue by category"; ; "categoryName"; ; "revenue" . a ; "
\n
\n

Where the money is

\n

Each category is a market segment with its own performance. Revenue first, then the spread of\n products behind it.

\n
\n
"^^ . a ; ; "categories.rq"; "categories.rq"; "f9d9158c1eca2812af56d0c72d1cbc978b95c8a8" . a ; ; "seafood.jpg"; "seafood.jpg"; "778dd323b4e1923b8e0c0166b64913fb255b97a8" . a ; "Products per category"; "PREFIX schema: \n\nSELECT ?categoryName (COUNT(DISTINCT ?product) AS ?productCount)\nWHERE {\n GRAPH ?productGraph {\n ?product a schema:Product ;\n schema:category ?category .\n }\n GRAPH ?categoryGraph {\n ?category schema:name ?categoryName .\n }\n}\nGROUP BY ?category ?categoryName\nORDER BY DESC(?productCount)" . a ; "Select categories"; "PREFIX schema: \n\n SELECT DISTINCT ?category\n WHERE\n { GRAPH ?doc\n { ?category a schema:ProductGroup ;\n schema:name ?categoryName\n }\n }\n ORDER BY ?categoryName" . a ; ; "Products per category" . a ; "Categories"; ; "2026-10-25T16:42:45.409Z"^^; "2026-10-25T16:42:42.498Z"^^; ","; . a ; ; "condiments.jpg"; "condiments.jpg"; "7e9f535a3bf693ec856702856fffd3be5a3df4f1" . a ; "Products per category"; ; "categoryName"; ; "productCount" . a ; "Category revenue"; "PREFIX schema: \n\nSELECT ?categoryName (SUM(?sale) AS ?revenue)\nWHERE {\n GRAPH ?orderGraph {\n ?order schema:orderedItem ?orderItem .\n ?orderItem schema:orderedItem ?product ;\n schema:price ?sale .\n }\n GRAPH ?productGraph {\n ?product schema:category ?category .\n }\n GRAPH ?categoryGraph {\n ?category schema:name ?categoryName .\n }\n}\nGROUP BY ?category ?categoryName\nORDER BY DESC(?revenue)" . a ; ; "Revenue by category" . a ; ; ; ; ; ; ; "2026-10-25T16:42:18.239Z"^^; ; "2026-10-25T16:42:42.351Z"^^; "Categories"; ; . a ; "Categories"; "PREFIX foaf: \nPREFIX dct: \nPREFIX schema: \n\nCONSTRUCT\n{\n GRAPH ?graph\n {\n ?graph dct:title ?categoryName ;\n foaf:primaryTopic ?category .\n\n ?category a schema:ProductGroup ;\n schema:name ?categoryName ;\n schema:identifier ?categoryID ;\n schema:description ?description ;\n foaf:depiction ?picture .\n }\n}\nWHERE\n{\n ?category_row <#categoryID> ?categoryID ;\n <#description> ?description ;\n <#categoryName> ?categoryName ;\n <#pictureHash> ?pictureHash .\n\n BIND(uri(concat(str($base), \"categories/\")) AS ?container)\n BIND(uri(concat(str(?container), encode_for_uri(?categoryID), \"/\")) AS ?graph)\n BIND(uri(concat(str(?graph), \"#this\")) AS ?category)\n BIND(uri(concat(str($base), \"uploads/\", encode_for_uri(?pictureHash))) AS ?picture)\n}\n" . a ; "8"^^; "32"^^; . a ; "
\n
\n

Portfolio balance

\n

Revenue and range don't always line up. A category can earn well on few lines, or spread wide\n and earn little — the gap between the two charts is where the portfolio questions are.

\n
\n
"^^ . a ; ; "Categories"; "categories.csv"; "58ee67ce53cfb3ad73368eda24a089314bb0bf41" . a ; ; "All categories" . a ; ; "meat.jpg"; "meat.jpg"; "11885d9b63b4fdac96dad23d4974df0d28bb8b26" . a ; ; "diary.jpg"; "diary.jpg"; "ee14378aa9de087150576af322146ba26552d2e1" .