Business Intelligence Path · Mission 14 of 31Medium

Pivot revenue by category and year

Use CASE WHEN inside aggregates to pivot rows into columns

Unlock with Pro→Back to Business Intelligence

The Brief

You'll practice

CASE pivotCross-tab
← Previous
Mission 13
Next →
Mission 15
All 31 missions in Business Intelligence Path ↓
  1. 1. Board deck needs revenue by quarter
  2. 2. Who is hitting their sales targets?
  3. 3. Product mix is shifting
  4. 4. Which region should we expand next?
  5. 5. The dashboard numbers don't add up
  6. 6. Discount tiers need a reality check
  7. 7. Which categories are actually selling well?
  8. 8. Find reps outselling their department average
  9. 9. How many unique customers per region?
  10. 10. Tag every sale by size
  11. 11. Rank the sales team
  12. 12. Who reports to whom?
  13. 13. Monthly revenue trend with growth rate
  14. 14. Pivot revenue by category and year
  15. 15. Tenure and salary — any correlation?
  16. 16. Top 2 products per category
  17. 17. Find products with no sales last quarter
  18. 18. Three-table join: who sold what where?
  19. 19. Correlated check: reps beating their own average
  20. 20. Running revenue total by month
  21. 21. Year-over-year revenue by quarter
  22. 22. Three-month moving average
  23. 23. Hire cohort performance analysis
  24. 24. Percentile ranking across the sales force
  25. 25. The executive summary query
  26. 26. Why is our leaderboard off by 12x?
  27. 27. YoY revenue decomposition — price vs volume
  28. 28. Tenure-adjusted attainment scorecard
  29. 29. Dirty-dim audit — category casing reconciliation
  30. 30. Same-rep regional growth — apples-to-apples YoY
  31. 31. BI executive capstone — board KPI panel