Data Analytics Archives - Page 6 of 6

Breakdown of Nigeria's budget expenditure

14 Nov 19

Breaking Down and Analysing Nigeria’s 2020 Executive Budget Proposal in Power BI – Part 2

Splitting the budget document into separate MDAs In the first article in this series, we covered some important aspects of understanding the budget document, available in PDF. This project will attempt to create an objective source of truth of how funds are allocated to the ministries, departments, and agencies (MDAs) in the Federal Government of […]

13 Nov 19

Breaking Down and Analysing Nigeria’s 2020 Executive Budget Proposal in Power BI – Part 1

Introduction On the 8th of October, 2019, President Muhammadu Buhari presented to the National Assembly, the proposed budget for the year 2020. Details of the speech can be reviewed here. By consensus, Nigeria’s revenue of N8.15tn is inadequate to fund the N10.33tn proposed expenditure, leaving a deficit of N2.18tn. According to Budgit analysis, a simple breakdown of […]

16 Oct 19

Are Prices of Food in Nigeria Decreasing?

Overview Following the peaks in 2017 particularly between June and July 2017, the average prices of food items in Nigeria across the selected categories have been on the decline according to data released by the National Bureau of Statistics (NBS). The NBS monitors prices of 43 food items ranging from wheat flour to raw chicken […]

10 Oct 19

Upward Trend in Diesel Pump Price in Nigeria – NBS

While it may not sound like much, the average price of diesel (AGO) per litre has increased by 1.7% from N225.09/L in January 2019 to N229.08/L in August 2019. Compared to August 2018, there has been a year-on-year increase of over 10% in diesel price. Data released in August by the National Bureau of Statistics […]

09 Oct 19

How to Format Dates into X-Axis for a Line Chart

A question was asked by a newbie in the Power BI community. To paraphrase, “How do I convert this table to a line chart with the date on the x-axis?” This task requires only a few transformations in order to generate the line chart. Before beginning any analytics exercise, it’s important to understand the underlying […]