State Budget Resources and Expenditure, 2011 to 2019
A macro-budgetary datamart and dashboards on nine years of official Ivorian budget data.
- Role
- Data analyst
- Period
- Feb 2025
- Status
- Delivered
- Context
- Official, collected and verified State budget data
Engineering figures
- 9fiscal years modelled
- 50.34 %share of tax revenue in resources
- 27.65 %share of market borrowing in resources
- 29.98 %share of public debt service in expenditure
Engineering figures describe the system, not its business findings, which remain confidential.
01Executive summary
A study of how the Ivorian State's budget resources and expenditure evolved over nine years, built on officially published data that I collected and cross-checked.
The datamart separates resources (tax revenue, borrowing) from expenditure (ordinary spending, debt) so trends can be read over time and by category.
02Technology stack
- Power BI
- DAX
- Power Query
- Excel
03Results and deliverables
- Tax revenue makes up about half of resources; ordinary expenditure 43.6 % and public debt 29.98 % of spending.
- Continuous growth until 2017, a decline in 2018 associated with the fall in cocoa prices, and a recovery in 2019.
- A datamart and interactive dashboards on trends and outlook.
04Limitations
- Descriptive analysis: the 2018 explanation is an interpretation of the trend, not a causal estimate.