Machine Breakdowns and Spare-Part Delays

The problem

The Plant Head needs to know how much breakdowns and repair times have grown from June to October 2026, how much is explained by skipped PM, the spare-part policy, old machines and night-shift response, and what the breakdowns cost in availability and OEE, using the downtime log, production records, the PM schedule and spare-part requests.

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.