Fashion Returns and RTO Cost Leak

The problem

Management does not know how much the return rate and RTO rate have risen, which categories, brands, sellers, couriers, cities and customers drive them, whether the return policy is being followed, or how much each problem costs. The analytics team must answer this from orders placed between 1 June and 15 October 2026, using returns extracted on 5 November 2026 after every return window had closed.

How it works

1. Start the project — the 4-day timer begins and the workspace opens with every table loaded.
2. Solve 50 tasks in SQL or Python (30 basic, 15 intermediate, 5 hard). Each is checked instantly.
3. Write the final report in the workspace and add charts from your notebook.
4. 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.