Product-wise Revenue
Delivered sales value per product (quantity × product price).
qty × price
Loading analytics…
Best-selling Products by Units
SUM(order_items.quantity) for delivered orders.
SUM(quantity)
Loading analytics…
Top 3 Products in Each Category
Ranked with ROW_NUMBER() OVER (PARTITION BY category ORDER BY SUM(quantity) DESC).
ROW_NUMBER()
Loading analytics…
Low-stock Products
Inventory risk: products with stock below 50 units, lowest first.
stock < 50
Loading analytics…
Products Never Ordered
LEFT JOIN order_items … WHERE order_items.product_id IS NULL — inventory sitting without demand.
LEFT JOIN
Loading analytics…
Category Performance
Units sold and delivered sales value (quantity × price) per category.
GROUP BY category
Loading analytics…