a ; "
\n

Category analysis

\n

Product categories represent different market segments with distinct characteristics and performance.\n Analyzing category-level metrics helps identify portfolio strengths, diversification opportunities, and inventory priorities.

\n
"^^ . a ; ; "confections.gif"; "confections.gif"; "c158852927adca461b57d6a1db332eaa38ff35e6" . a ; ; "meat.gif"; "meat.gif"; "7e12f6c6f5202018e380c58262b654b800e1b250" . a ; ; "diary.gif"; "diary.gif"; "3e612531a9a160b12c3db6565a2b03c0e8617ed3" . a ; "8"^^; "32"^^; . a ; ; . a ; ; "produce.gif"; "produce.gif"; "1474abcca6dc8c27c20edc2d5f70a14db8c7513d" . a ; ; "beverages.gif"; "beverages.gif"; "5e1be0328ca2c694d1de6f5b1b3d3b1ce90cb41f" . a ; "Revenue by category"; ; "categoryName"; ; "revenue" . a ; ; "condiments.gif"; "condiments.gif"; "6e5d9df213a6c46b4f75e9ba2e321436f80d8bed" . 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 ; . 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:orderQuantity ?quantity ;\n schema:price ?price .\n BIND(?quantity * ?price AS ?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 ; "Categories"; ; "2026-06-16T19:04:23.284Z"^^; "2026-06-16T19:04:15.605Z"^^; ","; . a ; . a ; ; ; ; ; ; "2026-06-16T19:03:26.29Z"^^; ; "2026-06-16T19:04:15.505Z"^^; "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 dct:title ?categoryName ;\n dct:description ?description ;\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}" . a ; ; "seafood.gif"; "seafood.gif"; "ff84beb4a82d5186fa3b80ce84ce095721093e69" . a ; ; "categories.rq"; "categories.rq"; "c13db934bbc8b4d651e674332adfd932d1ddd8c0" . a ; ; "categories.csv"; "categories.csv"; "41049b79a4a6e8407a0e878c6e4943ea824a7f1f" . a ; "
\n

Product distribution

\n

Understanding how products are distributed across categories reveals portfolio balance and potential gaps.\n Categories with more products may indicate core competencies or simply broader product lines.

\n
"^^ . a ; ; "cereals.gif"; "cereals.gif"; "68ccbb7d6dbd511b9d5faf1f0d1c09c2872d8081" . a ; .