Finance Data Analyst Path · Mission 25 of 30Expert

Board-ready P&L capstone

Combine CTE, conditional aggregation, windows, and LEFT JOIN in one query

Unlock with Pro→Back to Finance Data Analyst

The Brief

You'll practice

Multi-CTE pipelinePivotCapstone
← Previous
Mission 24
Next →
Mission 26
All 30 missions in Finance Data Analyst Path ↓
  1. 1. Peek at the chart of accounts
  2. 2. Cost-center ownership map
  3. 3. Account-type inventory
  4. 4. 2025 SaaS spend total
  5. 5. March 2025 expense rollup
  6. 6. Vendor duplicates audit
  7. 7. Top 10 vendors — YTD spend
  8. 8. Un-posted journal audit
  9. 9. Departmental spend by month
  10. 10. Quarterly gross-margin rollup
  11. 11. March budget-variance check
  12. 12. Overspend flags — actuals vs budget
  13. 13. Revenue seasonality by month
  14. 14. Refund leakage — net revenue impact
  15. 15. Running cash burn
  16. 16. Duplicate payment sweep
  17. 17. Revenue concentration — customer Pareto
  18. 18. YoY revenue growth by month
  19. 19. Cost center rank by 2025 OpEx
  20. 20. Budget-attainment heat map
  21. 21. Late-posting lag audit
  22. 22. Vendor spend — new vs. recurring
  23. 23. Vendor onboarding cohorts
  24. 24. Cost-center percentile ranking
  25. 25. Board-ready P&L capstone
  26. 26. Variance bridge with allocation overlay
  27. 27. Cash burn waterfall — monthly net + cumulative runway
  28. 28. Vendor concentration drift YoY
  29. 29. Late-posting impact on monthly totals
  30. 30. Year-end FP&A capstone — board KPI panel