Analyst
Senior Analyst
Project
Nexus Financial Services · SQL · advanced
The brief
Elena Vasquez here, CFO.
We're heading into the final pass. Marcus, Dana, and David all want one thing now: the forward exposure picture. The board will ask, and I need answers.
Start here. Pull total deposits broken down by customer status: - Active customers — total deposits we currently hold - Recently churned (churned in last 90 days) — these are deposits that left - High-risk active customers (risk_tier = "high" AND active) — deposits that could leave next
For each cohort show: customer count, total deposits, average deposits per customer, and what percent of total deposits each represents.
This is the deposit base composition slide.
Independent grading
78/100
Achieved 10 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