Intermediate 4 days · 50 tasks

Motor Policy Renewals Slipping

A general insurer is losing more motor customers at renewal every month. Join expiring policies, renewal quotes, reminders and renewals to find how much a car price revision, failed WhatsApp reminders and departed agents are costing in retention and premium.

Abhay General Insurance Ltd · SQL · Python (pandas, seaborn) · solved in your browser

Locked for now

This project opens soon. Start with the free project in Insurance meanwhile.

See Insurance projects

The problem

The Head of Motor Business needs to know how renewal retention and retained premium have changed for policies expiring from April to September 2026, how much is explained by the July price revision, failed WhatsApp reminders, departed agents, claims and channels, and how much premium was lost, using policy, quote, reminder, renewal and agent data up to 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.