What this life looks like
You turn numbers into answers. Data Analysts gather, clean, and interpret data to help organisations understand what is happening in their business, what their customers want, and where the opportunities lie. It is one of the most accessible entry points into the data-driven world.
What she actually does
You pull data from databases using SQL, clean and organise it in Excel or Python, analyse trends and patterns, build dashboards and visualisations using tools such as Tableau or Power BI, and present findings to business teams who use your insights to make decisions. You might analyse sales performance, customer behaviour, or public health outcomes.
Where you can work
| Sector | Places in Africa |
|---|---|
| Banks & Financial Services | GTBank, Access Bank, Equity Bank, Standard Bank — customer and risk analytics |
| FMCG & Retail | Unilever Nigeria, Nestlé Africa, Shoprite, Spar — sales and supply chain analytics |
| NGOs & Development | USAID, GIZ, Oxfam Africa — programme monitoring and impact measurement |
| Telecoms | MTN, Airtel, Safaricom — subscriber analytics and churn prediction teams |
Why it matters in Africa
Every organisation in Africa — from banks to hospitals to government agencies — is sitting on data they do not fully understand. Data analysts who can extract actionable insights from that data are in very high demand, especially as African companies compete with data-driven global businesses.
Your pathway in
- Develop strong Mathematics and Statistics foundations at school
- Learn Excel deeply — it remains the most widely used data analysis tool in African organisations
- Learn SQL for querying databases — free resources include SQLZoo and Mode Analytics
- Study Statistics, Economics, or any quantitative degree at university
- Learn a visualisation tool such as Power BI or Tableau and build sample dashboards
Skills you will need
- Excel and Google Sheets (advanced)
- SQL
- Python or R basics
- Data visualisation (Power BI, Tableau)
- Statistical thinking
- Clear business communication
A woman in this field
Tina Okonkwo
Nigeria
Tina is a data analyst at FanBants whose expertise in data-driven decision-making has advanced how the company understands its users and grows its business. She is part of a growing community of Nigerian women in data analytics who are changing how organisations use evidence to make decisions, and she mentors other women entering the data field.
Take your first step
- Master Excel pivot tables and VLOOKUP — these are the minimum for any data analyst role
- Complete the free Google Data Analytics Certificate on Coursera
- Learn SQL basics on SQLZoo.net or Khan Academy
- Build a simple dashboard in Power BI (free desktop version) using a public dataset
Careers close to this one
- Data Scientist
- Business Intelligence Developer
- Statistician
- Financial Analyst
- Market Research Analyst