Infrastructure delay and cost overrun analysis

The brief

Public infrastructure projects often finish late and over budget. Using public project data and reports, build a database of projects and find which sectors, sizes and regions overrun most, and by how much. Good looks like: a clean project table, reconciled SQL queries, and a short briefing on the patterns.

What you will build

1. Collect project data from public reports
2. Clean and load it into a database
3. Calculate time and cost overruns in SQL
4. Compare sectors, sizes and regions
5. Write a short briefing

Free, open data to build it with

• Open Government Data Platform India ↗ Government of India
• Ministry of Housing and Urban Affairs ↗ Government of India

Check each dataset's licence before you publish your work. Your mentor gives your team its own version of the brief (data, scope or region), so every team's project is its own.