Explain the power of SQL Window Functions (OVER, PARTITION BY, RANK, LEAD/LAG). Provide a complex query example that calculates the cumulative sales for each product category over time and compares each month to the previous one.