Intermediate 4 days · 50 tasks

UPI Payment Failures and Refund Delays

UPI failures have jumped since September and customers complain that money was debited but never reached the payee. Find what is failing, why, and how much the late refunds will cost the bank.

Kaveri Commercial Bank · SQL · Python (pandas, seaborn) · solved in your browser

Locked for now

This project opens soon. Start with the free project in Banking & Finance meanwhile.

See Banking & Finance projects

The problem

The Head of Digital Banking needs to know how much UPI failures have really increased, whether the increase is the customers' doing (business declines) or the bank's and its partners' (technical declines), which systems, apps, banks or hours are behind it, and how many debited customers were refunded late or not at all, with the compensation the bank now owes, as of 31 October 2026.

How it works

Start the project — the 4-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.