Verified by DataSimHQ

Analyst

Ajibola Enifeni

Senior Analyst

Project

Quantify the deposit base at risk

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