nigeria Archives - Resagratia

20 Jan 20

Summary: 9 Trends Shaping The Future of Data Analytics

The Data Analytics and AI space in Nigeria is still at its infancy and many companies are yet to embrace analytics in their workflows, let alone develop a data culture for a true digital transformation. IDG Connect conducted a quantitative survey among 200 U.S. based IT leaders at companies with over 500 employees, across all […]

Case study analysis of polythene company in Nigeria

13 Jan 20

Case Study: Analytics for a Polythene (Nylon) Manufacturing Company in Nigeria

Polythene manufacturing, which basically involves 3 steps – extruding, printing and cutting, has witnessed an increasing demand over the last couple of years. As retail shopping booms, the demand for nylon packaging has equally increased. With a population of over 185 million and a population growth rate of over 2.6% per annum, the demand for […]

07 Jan 20

Business Model for Egg Production from 1500 Poultry Chicken Layers

A business model, in the simplest terms, is a plan detailing how you intend to make money. It is a conceptual structure that contains a series of assumptions, revenue items, cost implications and a plan on selling to the customer. You can read HBR articles or follow our very own prof Ndubuisi Ekekwe on LinkedIn […]

03 Dec 19

Open Analytics – Nigeria 2020 Proposed Budget

Tons and tons of data remain largely unexploited. The key to unlocking and achieving innovative feats and designing the most ingenious solutions may lie in being able to extract insights from the data. With the availability of and accessibility to a wealth of tools and resources that can help us better understand ourselves, it’s time […]

16 Nov 19

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

Creating the automation function and combining files In the second article in this series, we covered how to extract the budget PDF document into manageable chunks. This is necessary because we want to leverage the combine files option in Power Query editor. We also explained how we aim to decipher the “sharing formula” if there […]

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 […]