IntermediateFree 5 days · 60 tasks

Health Insurance Claims Ratio Spike

The retail health claims ratio jumped from about 73% to over 90% in six months. Find out why — new product, suspicious hospitals, claims leakage or the monsoon — and what it is costing.

Suraksha General Insurance 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 why the retail health ICR rose so sharply in H1 FY2026-27. Different teams blame different causes: the new digital product, a surge of dengue and fever claims during the monsoon, unusual billing at some network hospitals, and claims being paid that should not have been (claims leakage). The Chief Underwriting Officer needs a reliable, reproducible analysis of claims admitted from 1 April 2025 to 30 September 2026 (extract taken on 15 October 2026) that sizes each cause in ICR points, so that the right corrective actions can be taken before the board meeting.

How it works

Start the project — the 5-day timer begins and the workspace opens with every table loaded.
Solve 60 tasks in SQL or Python (35 basic, 18 intermediate, 7 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 60 analysis tasks (35 basic, 18 intermediate, 7 hard), solved with SQL or Python in the JobPrax workspace.
A final report written in the workspace for the Chief Underwriting Officer: executive summary, data quality, findings and recommendations.
Two to four charts from your Python notebook, added to the report (for example ICR by product, monthly incurred, and the hospital watch list).

The problem

How it works

Start the project — the 5-day timer begins and the workspace opens with every table loaded.

Solve 60 tasks in SQL or Python (35 basic, 18 intermediate, 7 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 60 analysis tasks (35 basic, 18 intermediate, 7 hard), solved with SQL or Python in the JobPrax workspace.

A final report written in the workspace for the Chief Underwriting Officer: executive summary, data quality, findings and recommendations.

Two to four charts from your Python notebook, added to the report (for example ICR by product, monthly incurred, and the hospital watch list).