Intermediate 5 days · 50 tasks

Commercial Premium Receivables & Renewals

A commercial insurer's overdue premium has piled up and fewer clients are renewing. Reconcile bank receipts to invoices, find the VAT errors, age the debt by broker and show how unpaid premium is costing renewals.

Dunecrest General Insurance PJSC · 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

The receivables ledger shows a large and growing overdue balance, on-time payment has dropped, and fewer policies are renewing in 2026. The CFO does not know how much of the overdue balance is real debt and how much is cash that has arrived but was never allocated, which brokers are behind, and whether the collection problems are also costing renewals. The Finance Operations Centre needs a data-backed analysis of all policies, invoices and receipts from January 2024 to 30 September 2026 to plan a clean-up and a collections drive.

How it works

Start the project — the 5-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 for the CFO written in the workspace: executive summary, data quality, findings and recommendations.
Two to four charts from your Python notebook, added to the report (for example ageing buckets, days to pay by broker, unreferenced receipts by month, retention by quarter).

Commercial Premium Receivables & Renewals

Dunecrest General Insurance PJSC · SQL · Python (pandas, seaborn) · solved in your browser

The problem

How it works

Start the project — the 5-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 for the CFO written in the workspace: executive summary, data quality, findings and recommendations.

Two to four charts from your Python notebook, added to the report (for example ageing buckets, days to pay by broker, unreferenced receipts by month, retention by quarter).