Top variance drivers across the network

Nexus Financial Services · SQL · advanced

The brief

David:

For the board narrative, I want to understand WHAT specifically drove the YoY changes. Pull the top 10 industry-region combinations with the largest changes in active customer count from 2023 to 2024.

Show: industry, region, 2023 active count, 2024 active count, absolute change, percentage change. Order by absolute decline (negative changes first).

This tells the board exactly where to focus 2025 retention work.

Independent grading

62/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