Sales Analytics Dashboard

-- Aggregate monthly sales by category with YoY growth SELECT s.category, SUM(s.revenue) AS total_revenue, COUNT(s.order_id) AS total_orders, AVG(s.revenue) AS avg_order_value, ROUND(((SUM(s.revenue) - LAG(SUM(s.revenue)) OVER ( PARTITION BY s.category ORDER BY s.month )) / LAG(SUM(s.revenue)) OVER ( PARTITION BY s.category ORDER BY s.month )) * 100, 2) AS growth_pct FROM sales s JOIN products p ON s.product_id = p.id WHERE s.month BETWEEN '2024-01' AND '2024-12' GROUP BY s.category, s.month ORDER BY total_revenue DESC;