SELECT region, year,
AVG(value) AS trend
FROM clean_public_data
GROUP BY region, year;From public data to a useful insight
Investigate a specific question using a UK public dataset. Clean the data, document assumptions and explain the findings.
What the work should include
- Reproducible notebook and SQL queries
- Data-quality notes and a clear README
- Concise insight summary with limitations
The review question
Can another person reproduce your analysis, and can you explain the decisions?