You can become a data analyst in Nigeria without a tech degree. What employers want to see is that you can take messy data, clean it, analyse it, and explain what it means in plain language. Those skills can be learned with free resources, a laptop and steady practice, and you prove them with a portfolio, not a certificate.
The usual path to becoming a data analyst in Nigeria looks like this: learn spreadsheets properly, learn SQL, learn one visualisation tool such as Power BI or Tableau, add some Python or R if you can, then build projects using real data and share them. Throughout, you practise the most underrated skill of all: communicating findings to people who do not care about the technical details.
This guide breaks that down into practical steps, with honest notes on what to expect.
What does a data analyst actually do?
A data analyst helps an organisation make better decisions using data. In practice, that means:
- Answering business questions. "Why did sales drop in the North last quarter?" "Which customers are likely to stop using our app?"
- Cleaning and preparing data. Real data is messy: duplicates, missing values, inconsistent spellings of "Lagos". This often takes more time than the analysis.
- Analysing. Calculating trends, comparing groups, spotting patterns and outliers.
- Visualising. Building charts and dashboards that make the results easy to understand.
- Communicating. Presenting findings and recommendations to managers, often in a short meeting or a written summary.
Data analysts work in banks, fintechs, telecoms companies, retailers, NGOs, health organisations, government agencies and consultancies. Almost every sector needs people who can make sense of numbers.
Do you need a degree to become a data analyst?
Not a tech degree. Many analysts come from economics, statistics, accounting, engineering, the sciences and even the humanities. Some employers list a degree in any field as a requirement, while others focus purely on skills.
What helps is comfort with numbers and logical thinking. You do not need advanced mathematics for most analyst roles, but you should be at ease with percentages, averages, and basic statistics like median and standard deviation. Khan Academy has free statistics lessons if you need a refresher.
If you work in accounting or finance, you may already be closer than you think. Our guide on moving from accounting to data analysis explains why.
What skills does a data analyst need?
1. Spreadsheets (Excel or Google Sheets)
Spreadsheets remain the most widely used analysis tool in business. Go beyond basic formulas: learn lookups (XLOOKUP or VLOOKUP), pivot tables, conditional formatting, data cleaning and simple charts.
2. SQL
SQL is how analysts get data out of databases. It is arguably the most important technical skill for the role. Learn to filter, sort, join tables, group and aggregate, and use window functions.
3. A business intelligence tool
Power BI and Tableau are the best known. Power BI is widely used in organisations that run on Microsoft products. Learn to connect data, build a clean dashboard and design it for a specific audience.
4. Python or R (eventually)
Not every entry-level role requires programming, but it opens doors and lets you handle larger or more complex data. Python with the pandas library is a popular choice. Kaggle Learn has free short courses on Python, pandas and data visualisation.
5. Statistics and critical thinking
Know the difference between correlation and causation, understand sampling, and be suspicious of results that look too good.
6. Communication
The analyst who explains one clear insight beats the analyst who shows twenty confusing charts. Practise turning findings into a few sentences a busy manager can act on.
The traits that make a good analyst
Technical skills can be taught. These traits make the learning easier:
- Analytical reasoning: breaking a vague question into measurable pieces.
- Process orientation: being careful and methodical with data, and documenting your steps.
- Visual thinking: seeing which chart tells the story.
- Communication and empathy: understanding what the audience actually needs.
If you are unsure whether you have them, take the free TechDNA assessment. It measures these traits and scores your fit for Data Analyst alongside eight other roles.
A step-by-step plan
Phase 1: Spreadsheets and the basics of data
Pick a public dataset and practise cleaning and summarising it in a spreadsheet. Build at least one pivot table and one chart that answers a specific question.
Phase 2: SQL
Install a free database such as PostgreSQL or SQLite, load a dataset and write queries. Practise until joins and grouping feel natural. Plenty of free SQL practice sites exist, and Kaggle Learn has an introductory SQL course.
Phase 3: Visualisation
Learn Power BI or Tableau using free versions where available (check current licensing terms). Build a dashboard from one of your SQL projects.
Phase 4: Python
Learn Python basics (the official python.org tutorial is free), then pandas for data manipulation and a plotting library like Matplotlib or Seaborn.
Phase 5: Portfolio and job search
Build three or four strong projects, publish them, and start applying while you keep learning.
Portfolio project ideas with a Nigerian angle
Projects about topics that matter locally can stand out, because they show curiosity and real-world understanding. Look for open data published by Nigerian government agencies, international organisations or on Kaggle. Ideas include:
- Food price analysis: how prices of staple foods have changed across states over time.
- Exchange rate trends: the naira against major currencies, with clear context about major policy changes.
- Election or population data: turnout or demographic patterns by state, presented neutrally.
- A business dashboard: imagine a small Lagos retailer and build a sales dashboard from a realistic sample dataset.
For each project, write a short summary: the question, the data source, your method, what you found, and the limitations. That final section shows maturity many beginners lack. Our guide to building a tech portfolio with no experience has more tips.
Common mistakes to avoid
- Collecting courses instead of projects. Certificates show you studied. Projects show you can work.
- Skipping SQL. Many beginners go straight to dashboards, but most analyst interviews test SQL.
- Making beautiful dashboards that answer nothing. Every chart should answer a question someone actually has.
- Hiding your work. Publish projects on GitHub or a simple portfolio page and share what you learn.
Practical realities in Nigeria
Power and data costs. Download datasets and course materials when you have a good connection. Most analysis tools work offline once installed. A laptop with enough memory for larger spreadsheets makes life easier, though you can start on a modest machine.
Software costs. Use free tools while learning: Google Sheets, PostgreSQL, Python and the free tiers of BI tools. Avoid paying for software you do not yet need.
The job market. Data analysis is a popular target for career switchers, so entry-level roles can be competitive. Domain knowledge helps: an analyst who understands banking, telecoms or healthcare is valuable in that sector. Salaries vary widely by company, sector and experience, and remote roles with foreign companies exist but are competitive.
Your current job is a training ground. If your employer has data, offer to analyse something useful. Internal experience is real experience.
If you are also wondering whether to aim for data science instead, read data analyst vs data scientist.
Frequently asked questions
Can I become a data analyst with no experience?
Yes, but you need to replace work experience with evidence. Strong portfolio projects, clear write-ups and any data work you can do in your current job all count. Many people also start in roles like reporting or operations analyst.
Should I learn Excel, SQL or Python first?
Start with spreadsheets because they teach you how data behaves, then move to SQL, which most analyst roles require. Add Python once you are comfortable with both. This order builds on itself naturally.
Is Power BI or Tableau better?
Both are respected. Power BI is common in organisations that already use Microsoft tools, so check job adverts in the sector you want to join. The skills of designing a clear dashboard transfer between them.
How long does it take to become a data analyst?
It depends on your starting point and how many hours you can study each week. Consistent practice and real projects matter more than the calendar. Focus on reaching a level where you can complete a project from raw data to clear findings on your own.
Data analysis rewards curiosity, carefulness and the ability to explain what numbers mean. Before you invest months in learning, see whether your natural strengths point that way. Take the free TechDNA assessment to get your Data Analyst fit score, your strengths and recommended courses in about seven minutes.