Year-over-year financial summary

Nexus Financial Services · SQL · advanced

The brief

David:

For the board pack, I need a clean YoY comparison of our financial performance. Pull a single result set with: - 2023 vs 2024 comparison (full year) - Total deposits (point-in-time, end of year) - Total loan originations - Total transaction volume (dollar) - Total fraud loss - Total customer churn

Show absolute change and percentage change between years. Wide format — one row with all metrics.

Independent grading

68/100

Achieved 4 Nov 2026

Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.

What is DataSimHQ?

A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more