BeginnerFree 2 days · 50 tasks

Gold Loan LTV Breach Early Warning

Gold prices have fallen sharply. Find which active gold loans now breach the regulatory LTV cap, how much money is at risk, and where.

Suvarna Finance Ltd · SQL · Python (pandas, seaborn) · solved in your browser

Ready to start?

Create a free account to open the workspace, check your answers and earn a certificate.

The problem

Management does not know how many active gold loans currently breach the 75% LTV cap, how much outstanding principal is exposed, or which schemes, states and branches are driving the problem. The risk team needs a reliable, reproducible assessment as of 15 October 2026 to plan margin calls before the next risk committee.

How it works

Start the project — the 2-day timer begins and the workspace opens with every table loaded.
Solve 50 tasks in SQL or Python (30 basic, 15 intermediate, 5 hard). Each is checked instantly.
Write the final report in the workspace and add charts from your notebook.
Score = 70% tasks + 30% report review. 60 or more earns a certificate.

What you will deliver

Answers to the 50 analysis tasks (30 basic, 15 intermediate, 5 hard), solved with SQL or Python in the JobPrax workspace.
A final report written in the workspace: executive summary, data quality, findings and recommendations.
Two to four charts from your Python notebook, added to the report.