Infrastructure Activity Radar
A multi-source view combining municipal capital activity with procurement pipeline signals to identify where roads, stormwater and water infrastructure activity is strengthening or weakening.
- Decision
- Identify infrastructure activity using multiple independent signals instead of ranking municipalities on one headline number.
- Source
- National Treasury Municipal Finance Data + eTender OCDS
- Period
- Municipal v2 from 2019/20 onward + OCDS from May 2021
- Created by
- Nyashadzashe Munyati
The analytical result is shown before the technical method.
What I did in this project
Defined the question.
Prepared the data.
Built the analysis.
Validated and documented the result.
Identify infrastructure activity using multiple independent signals instead of ranking municipalities on one headline number.
A large budget is not the same as delivered work, and a tender pipeline alone does not prove spending capacity. The useful decision is identifying places where investment intent, delivery history and live procurement activity reinforce each other.
Source data
National Treasury Municipal Finance Data + eTender OCDS
What I changed before calculating anything
Worked calculations — not black-box KPIs
What the drill-down adds
The headline chart gives the decision signal. These additional views show whether the same conclusion survives when the data is sliced another way.
The question and method are documented, but unfinished results are not presented as completed analysis.
What I would say in the management meeting
What I would do next
Municipal reporting completeness varies. Procurement data coverage is incomplete.