Data Viz – The Diary of an Evaluator

When Dangote Refinery Starts Producing, Which Countries Stand to Lose Petroleum Export Revenue?

For years, Nigeria depended heavily on imported refined petroleum products from countries across Europe, Asia, and beyond. But once Dangote Petroleum Refinery began production, following its first crude delivery on December 12, 2023, the story was no longer only about what Nigeria could gain. It also became a story about who might lose. Using Nigeria’s 2022 refined petroleum import data as a baseline, my visualization shows that 63 countries had some level of petroleum export revenue exposure to Nigeria, meaning they could be affected if Nigeria increasingly meets domestic demand through local refining rather than imports.¹

The countries that appear most exposed are the ones that earned the most from petroleum exports to Nigeria before Dangote Refinery came on stream. In the data, the top five likely impacted countries are Belgium ($6,828.84m), Netherlands ($5,606.21m), India ($2,370.50m), Norway ($1,640.14m), and the United Kingdom ($923.24m). At the other end, the least likely impacted countries among those with recorded export value are Hong Kong ($0.01m), Burundi ($0.01m), Luxembourg ($0.01m), Denmark ($0.01m), and Rwanda ($0.01m), each with only a negligible share of Nigeria’s 2022 import market.

What makes this interesting is that one refinery in Lagos could quietly reshape revenue flows across dozens of countries. Some of the biggest losers may not even be the most obvious names in global oil conversations, while others may barely notice the change at all. That is why this map is worth more than a glance. It raises a bigger question: if Nigeria truly reduces dependence on imported refined products, which countries will feel the shift first, and by how much? I would really like to hear which country on the map surprises you most.

All datasets and code block used for this project can be found in my GitHub repository at https://github.com/dutchy313/dangote-refinery-impact-map ↩︎

The State With the Highest Cigarette Smokers in Nigeria

Only one out of every 100 men smoke a cigarette in Nigeria, while the number for the female smokers is so insignificant according to the Nigeria 2017 Multiple Indicator Cluster Survey. Nevertheless, Delta state is where you are likely to find most male smokers. As they say “Warri no dey carry last! Sokoto, Edo, Oyo and Imo state trail Delta state in that order.

In Cross River state, you are likely to see more teen smokers than any state in Nigeria. So, if you are planning to work on Tobacco use and abuse, Cross River and Delta State might be a good state to start your campaign.

If you are wondering where your state of residence falls on the list, you can visualize and download all dataset by CLICKING HERE

Which State in Nigeria do Women give birth at home (the most)?

According to the National Demographic and Health Survey (NDHS, 2013), 9 out of every 10 women in Sokoto and Zamfara deliver their child at home. Also, it is highly unlikely that a woman will deliver a child, in a private hospital in – Sokoto, Zamfara, Jigawa, Kebbi, Yobe, Katsina and Kano. Interact with the visualization here and found out the facility that is most used by women to deliver a child in your state.

The chart above shows the Percent distribution of live births between 2008 and 2012 delivered at home and in private hospital, according to the Nigeria Demographic and Health Survey (NDHS),2013.

It is highly likely that you will deliver your baby at home if you are from the North Western region of Nigeria, with Sokoto and Zamfara State having the highest percentage of home deliveries. Share on X

Twenty-three percent of deliveries occur in public sector facilities, and 13 percent occur in private sector facilities. Sixty-three percent of births are delivered at home in Nigeria. It is highly likely that you will deliver your baby at home if you are from the North Western region of Nigeria, with Sokoto and Zamfara State having the highest percentage of home deliveries. It is unlikely to give birth at home if you are from the South Eastern region of Nigeria with Imo State having the least percentage of home deliveries.

Get full visualization and data here

Which West African Government Spends the Most on her Citizen?

The Gambia, with a population of 203,850 spends the most per person – calculated at US$1,867 per person in 2016. In 2016, it had an estimated budget of US$380 million, just 128 million more than Guinea Bissau, which has the least budget of US$ 252 million.

Government spending in West Africa — Full Data available at https://public.tableau.com/shared/2FC9776MB?:display_count=yes

Guinea Bissau with US$1359 per person and Cape Verde with US$797 per person have the second and third position of country government spending the most on her citizens respectively. Does this mean when you have a country with fewer people, your expenditure per person will be high? Yes!

Let’s compare Ghana and Nigeria. Ghana is the second most populated country in West Africa with 28 million people, while Nigeria is the most populated with 185 million people. Nigeria’s budget (US$23 billion) is a double of what Ghana budgets (US$ 11 billion) for its people. Notwithstanding, Ghana with US$ 425 is the fourth country that her government spends, the most, on her citizen, while Nigeria hangs at the bottom, fourth from the last spending US$125 per person.

Ref: [ Click to download XLS version of data ]

Which Country has the Cheapest Broadband Internet in West Africa?

Cote d’Ivoire, with an estimated GDP growth of 8.5% in 2016, has the cheapest broadband internet in West Africa. The monthly average cost of internet is US$60.57 in this country that was rated as the fastest growing economy in Africa in 2016 (World Economic Outlook)

The Average monthly price of Broadband Internet in some West Africa Countries

However, in Sub-saharan Africa, Cote d’Ivoire internet price is ranked 5th cheapest behind Reunion, Mauritius, Mayotte, and South Africa. Comparing it to the world price, it is ranked 102nd cheapest. Cheaper than Norway, Australia, New Zealand and the United States!

Burkina Faso is the most expensive country to use the fast internet in West Africa and amongst 196 countries of the World. You will need to pay US$977.63 monthly to get a fast internet in the country, that’s more than the total amount you pay in a year if you are in Cote d’Ivoire.

Live Data Source provided by Cable.co.uk