Skip to content
Zubair Jalal
Back to Projects

Birmingham City Council Expenditure Analysis

Sep 2025 – Dec 2025

MSc individual project, Distinction, ranked #1 in module

Screenshot from Birmingham City Council Expenditure Analysis

Analysis of a nine-figure annual public spend across 16 directorates. Built interactive KPI dashboards with advanced PivotTables and slicers to visualise temporal trends and supplier payment distributions. Surfaced expenditure concentration and quarterly volatility as headline KPIs, plus financial anomalies and beneficiary dependencies in the payment data. Delivered as a business report and an executive PowerPoint briefing.

ExcelPivotTablespublic financeKPI reporting