What the data says
Each finding is recomputed from the same views that power the dashboard, so it always matches the numbers shown elsewhere.
derived
Loading analytics…
Business rules behind every number
The exact assumptions carried over from the original SQL analysis.
source of truth
- Revenue counts Delivered orders only — Pending and Cancelled orders are excluded everywhere.
- Paid revenue uses payments.amount; sales value uses order_items.quantity × products.price. They are reported separately, never merged.
- Top products per category are ranked with ROW_NUMBER() OVER (PARTITION BY category ORDER BY SUM(quantity) DESC), keeping ranks 1-3.
- Average order value is the average delivered payment amount, not sales value divided by orders.
- Low stock means products.stock < 50; never-ordered products come from a LEFT JOIN with a NULL order_items match.
- Order status shares are computed over all 0 orders in the dataset.