AI Workbench · Level 16 of 16
The downtime report: clean the export, answer in SQL
Level 16 of 16 in the AI Workbench: a free AI exercise at Intermediate level, which takes about 35 minutes. Clean a messy line-downtime export with steps you can run again next week, make the pivot, then answer the plant manager's five questions in SQL.
Free · no download · about 35 minutes. Your work is saved on this device. Updated 18 Oct 2026.
The brief
- Client
- Kessling Bottling (fictional, hosted by OFORO)
- Site
- OFORO data desk
- Work order
- OFR-WO-116
- Data set
- Line downtime export
- Task code
- AIW-16
- Difficulty
- Intermediate
- Type of work
- Data and SQL
Clean a messy line-downtime export with steps you can run again next week, make the pivot, then answer the plant manager's five questions in SQL.
Skills you practise
- Applied cleaning steps
- Pivot
- SQL SELECT
- Joins and grouping
What the test checks
The acceptance test marks the skills this level practises.
- Applied cleaning steps
- Pivot
- SQL SELECT
- Joins and grouping
In this lab
- Train models in your browser
- Vision inspection, prompts, RAG and safe agents
- Check the AI's work before you trust it
Levels in the AI Workbench
Previous: Check the AI's work: project management
- Data health check
- Train and evaluate without leakage
- Choose the metric and the threshold
- Overfitting: tune the tree
- Vision inspection on the conveyor
- Prompt to spec
- Answers with sources
- A safe agent
- Fairness check
- Privacy first
- Check the AI's work: finance
- Check the AI's work: HR
- Check the AI's work: marketing
- Check the AI's work: healthcare
- Check the AI's work: project management
- The downtime report: clean the export, answer in SQL
Part of the AI Workbench
Prepare data, train a model and check the AI's work against a brief.
Feeds these internships: AI and Machine Learning, Data Science and Analytics, Generative AI and Prompt Engineering, AI Agents and Automation, Computer Vision, AI for Finance and Accounting, AI for HR and Recruitment, AI for Digital Marketing and Content, AI in Healthcare and Pharma, AI for Project Management.