How to Learn Data Analysis for Free and Get Hired in 90 Days

Data analysis is one of the most hireable skills in Nigeria right now. Banks, fintechs, consumer goods companies, and startups are all looking for people who can take raw numbers and turn them into decisions. The salaries are strong. You can get paid as much as ₦300,000 to ₦900,000 per month, depending on experience, and the skill gap is real.

Here is the exact 90-day plan to go from no experience to job-ready, using only free resources.

What Data Analysts Actually Do

Before you spend 90 days learning something, understand what the job is.

A data analyst:

• Collects and cleans messy data from spreadsheets, databases, or internal systems
• Analyses patterns and trends using statistical methods and tools
• Builds dashboards and visualisations that communicate findings clearly
• Answers business questions like “Why did sales drop in Q3?” or “Which customer segment is most profitable?”

The tools you need to know at the entry level: Excel/Google Sheets, SQL, and at least one visualisation tool (Power BI or Tableau). Python is a bonus that significantly increases your earning potential.

The 90-Day Learning Plan (Free Resources Only)

Days 1–30: Excel and Foundations

Excel is unglamorous but non-negotiable. Almost every Nigerian company runs on it, and your ability to handle it confidently signals competence immediately.

What to learn:

• VLOOKUP, INDEX-MATCH, SUMIF, COUNTIF
• Pivot tables and pivot charts
• Data cleaning techniques (removing duplicates, handling missing values, text functions)
• Basic statistical functions (AVERAGE, MEDIAN, STDEV)

Free resources:

• ExcelJet (exceljet.net) – the best free Excel reference on the internet
• Chandoo (chandoo.org) – practical tutorials with real datasets
• Google Sheets is free and fully sufficient for practice

Week 4 project: Download the Nigerian Bureau of Statistics Consumer Price Index data (publicly available at nigerianstat.gov.ng) and build a pivot table analysis showing price changes by product category over 12 months. Save this – it is your first portfolio piece.

Days 31–60: SQL

SQL is the language used to query databases. If Excel is the skill that gets you in the room, SQL is the skill that makes employers take you seriously.

What to learn:

• SELECT, WHERE, GROUP BY, ORDER BY, HAVING
• JOINs (INNER, LEFT, RIGHT)
• Subqueries and CTEs
• Aggregate functions (COUNT, SUM, AVG, MAX, MIN)

Free resources:

• SQLZoo (sqlzoo.net) — interactive and browser-based, no installation needed
• Mode Analytics SQL Tutorial (mode.com/sql-tutorial) — excellent for business context
• LeetCode SQL problems (start with Easy, move to Medium)

Week 8 project: Use a free SQL database platform (DB Fiddle or SQLiteOnline) and create a mock Nigerian sales database with 200+ rows of fictional data. Write 10 queries that answer real business questions. Screenshot and annotate them for your portfolio.

Days 61–90: Data Visualisation and Portfolio

You can be technically strong and still lose to candidates who communicate better. Visualisation is where your analysis becomes something other people can actually understand.

What to learn:

• Power BI — free desktop version, excellent for the Nigerian job market (Microsoft ecosystem is dominant in enterprise)
• How to choose the right chart type for different data questions
• Dashboard design principles (less is more; every element earns its place)

Free resources:

• Microsoft Learn Power BI learning path (learn.microsoft.com) — completely free
• Guy in a Cube YouTube channel — practical Power BI tutorials
• Data Is Beautiful (r/dataisbeautiful on Reddit) — for design inspiration

Week 12 project: Build a three-page Power BI dashboard using a Nigerian dataset – the NBS e-commerce data, Central Bank of Nigeria currency data, or any open data from data.gov.ng is all available. This is your headline portfolio piece.

Free Certification to Add to Your CV

Complete these free certifications alongside your learning — they add credibility without spending a naira:

• Google Data Analytics Certificate – apply for financial aid on Coursera and get it free
• Microsoft Power BI Data Analyst Associate – free prep materials on Microsoft Learn; the exam itself costs money, but prepare first and take it when ready
• HackerRank SQL Certificate – free and respected by technical recruiters

Building Your Portfolio

By the end of 90 days, you should have at a minimum:

1. One Excel analysis project using real Nigerian data
2. One SQL query collection solving actual business questions
3. One Power BI dashboard that tells a clear story

Host everything on GitHub (free). Write a short description for each project explaining what business question you were answering, what tools you used, and what insight you found. Employers read these descriptions because they reveal whether you think like an analyst or just a technician.

How to Apply and What to Expect

Start applying at Day 75. Do not wait until you feel “ready” – you will never feel ready. The application process itself is part of the learning.

Target roles titled: Data Analyst, Business Analyst, Reporting Analyst, MIS Analyst. Nigerian companies using these titles frequently hire candidates with solid portfolios over candidates with traditional degrees but no practical work.

Interview preparation matters. Practice explaining your portfolio projects out loud as if presenting to a non-technical manager. “I noticed that Lagos region sales were declining in Q2, so I segmented the data by SKU and found that 80% of the drop came from three underperforming products. I recommended a promotional focus on those SKUs and built this dashboard to track recovery.” That is a data analyst speaking. Practice it.

The 90-day timeline is achievable with consistent effort – roughly 2 to 3 hours per day. Some people do it faster. Very few need significantly longer if they stay focused.

The only thing standing between you and a ₦400,000/month data role is the decision to start today.

Building your data analyst CV? Workland Scout uses AI combined with our more than a decade of experience to analyse your CV and show you exactly what to strengthen before you apply.