Data Analysis Course in Nigeria | Excel, Power BI, SQL

01 Why Data Analysis

Nigeria's data economy is growing. Most companies do not have the analysts to match.

High demand, very low supply

Data analyst roles on LinkedIn Nigeria grew sharply through 2024 and 2025. Very few applicants have practical SQL and Power BI skills an employer can actually verify.

Remote work is real now

A large share of data roles at Nigerian companies now accept remote applicants. Your LeadarX certificate is publicly verifiable and recognised by hiring managers.

The salary premium is documented

Entry-level data analysts in Lagos consistently earn well above peers in non-technical roles with the same years of experience and education.

Data analyst reviewing charts and visualisations on a laptop

02 10-Week Curriculum

Every week builds on the last. Nothing is taught in isolation.

Live classes every Saturday. Recordings within 24 hours. Instructor office hours mid-week.

Week 01

Introduction to Data Analysis
- What is data analysis?
- The analytics workflow
- Types of data
- Data analyst roles and career paths
- Real-world business problems
- Data-driven decision making
- Introduction to datasets
- Mini practical: exploring a sales dataset and identifying business questions
Excel

01
Week 02

Excel for Data Analysis I
- Excel interface
- Working with tables
- Importing data from Excel and CSV
- Introduction to Power Query
- Data types
- Removing errors and duplicates
- Replacing values
- Splitting and merging columns
- Trimming and cleaning text
- Filtering and sorting
- Append and merge queries
- Practical data cleaning project
Microsoft Excel

02
Week 03

Excel for Data Analysis II
- Pivot tables
- Pivot charts
- Slicers and timelines
- Conditional formatting
- Excel charts
- Interactive dashboard design
- KPI cards
- Data storytelling
- Dashboard best practices
- Sales dashboard project
Microsoft Excel

03
Week 04

SQL for Data Analysis I
- Database fundamentals
- Installing MySQL
- Creating databases and tables
- SELECT, FROM, WHERE
- Comparison operators
- Logical operators (AND, OR, NOT)
- ORDER BY
- LIMIT
- Practical query exercises
MySQL

04
Week 05

SQL for Data Analysis II
- Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
- GROUP BY
- HAVING
- CASE statements
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- Business analysis queries
- Mini SQL project
MySQL

05
Week 06

Power BI I: Data Prep and Visualisation
- Power BI interface
- Connecting to Excel and CSV files
- Data transformation with Power Query
- Data modelling basics
- Creating charts, cards, maps and slicers
- Building interactive reports
Power BI Desktop

06
Week 07

Power BI II: Dashboard Development
- Relationships
- DAX measures
- Calculated columns
- KPIs
- Time intelligence basics
- Dashboard design best practices
- Business dashboard project
- Presenting insights
Power BI Desktop

07
Week 08

Introduction to Python for Data Analysis
- Python basics
- Variables
- Data types
- Lists
- Dictionaries
- Functions
- Jupyter Notebook
- Introduction to Pandas
- Reading Excel and CSV files
- Basic data exploration
PythonJupyterPandas

08
Week 09

AI for Data Analysts and Python Analysis
- Cleaning data with Pandas
- Filtering and aggregation
- Visualisation with Matplotlib
- Using ChatGPT and AI tools for Excel, SQL, Python and Power BI
- Writing effective prompts
- AI ethics
- Automating analysis tasks
PythonChatGPTGamma AI

09
Week 10

Capstone Project and Portfolio
- End-to-end data analysis project
- Data cleaning
- SQL analysis
- Dashboard development
- Business insights
- Presentation skills
- Building a data analyst portfolio
- Career roadmap, CV and LinkedIn tips
ExcelSQLPower BIPython

10

Lesson delivery

Inside every Saturday session

Each live class runs the same three-hour structure: a short recap, focused teaching, then most of the time spent with your hands on the tools.

10 minRecap of the previous lesson and Q&A

75 minNew concepts, live demonstration and guided practical

15 minBreak

60 minHands-on practical: you work independently while the instructor guides

20 minClasswork, challenge exercise, assignment and wrap-up

03 Outcomes

What you walk away with is measurable.

Not a certificate that gathers dust. Real, demonstrable proof of what you built and what you can do.

Real projects in your portfolio

Each project uses actual Nigerian business datasets, not toy examples built to look good on slides.

0

Industry tools on your CV

Excel, SQL, Power BI, Python, Pandas and ChatGPT. The tools employers specifically search and test for in interviews.

Verified, publicly checkable certificate

Every certificate has a unique code. Employers verify it at leadarx.com/verify. It is not a PDF badge.

Close-up of hands typing on a laptop during a data analysis session

Analyst reviewing a business data dashboard

Colleagues collaborating on data analysis work

04 Student Stories

They started exactly where you are.

No prior background required. Consistency and showing up every Saturday is what makes the difference.

"I joined with zero Python experience. By Week 4 I was writing SQL joins I had only seen in job descriptions. I received a data analyst offer before the cohort even ended."

"Saturday classes are not lectures you watch passively. We work through problems live. My Power BI dashboard from Week 5 is now in production at my current company."

"I was a nurse. I switched to healthcare data analysis because of this programme. The curriculum is intense but the mentorship makes it possible. Best investment I have made in myself."

05 Pricing

One class format. One fee. ₦65,000 all in.

One format: Real-Time Online, live with an instructor every Saturday. No tiers and no upsell. Everyone in the cohort gets the same class.

Our one class format

Real-Time Online

Next cohort, enrolling now

Saturdays, 8am to 11am WAT

Online, live via Microsoft Teams

Live sessions with your instructor

Dedicated class group

Recorded session replays within 24 hours

Weekly assignments marked by a human

Capstone project and portfolio review

Verified certificate on completion

Pay in full, once₦65,000

Or 2 payments of₦35,000

Instalment total₦70,000

Pay in full and save ₦5,000

No application fee and no separate certificate fee. One course fee, however you pay it.

Register for Data Analysis

Enrolment in progress. Limited spots left.

How the class works

One format, one fee, one room. Everyone in the cohort learns together, live, at the same price.

Class Live on Microsoft Teams every Saturday, 8am to 11am WAT, with the instructor in the room answering questions as you work.

If you miss Every session is recorded and posted within 24 hours, so a missed Saturday does not put you behind.

Paying There is no application fee and no certificate fee. Pay the whole course fee at once, or pay it in 2 equal parts. Your first payment secures your spot and opens your account.

Certificate Issued on completing the capstone, with a code anyone can verify at leadarx.com/verify.

Verified certificate included

No hidden charges

Secure payment via Korapay

100% online. Learn from anywhere in Nigeria

06 Questions Answered

The questions everyone asks before enrolling in Data Analysis.

Do I need programming experience to join the Data Analysis course?

No experience required. The programme starts from the very basics in Week 1 and builds through Excel and SQL before introducing Python in Week 8. If you can use a computer, you have more than enough background to begin.

How much does the Data Analysis course cost in Nigeria?

₦65,000 if you pay in full, or 2 payments of ₦35,000 if you spread it. That is the whole cost: there is no application fee and no separate certificate fee. Paying in full saves you ₦5,000, and your first payment is what opens your account.

What tools will I learn?

Microsoft Excel and Power Query, MySQL, Power BI, Python with Pandas and Matplotlib, plus AI tools such as ChatGPT for analysis work. Every tool is taught hands-on inside the live class.

What happens if I miss a Saturday class?

All classes are recorded and uploaded within 24 hours. You can catch up before the next session. That said, we strongly encourage attendance, because the live Q&A and peer work is where most learning happens.

Can I join the Data Analysis class from Lagos, Abuja or Port Harcourt?

Yes, and from anywhere else in Nigeria. The class is live online over Microsoft Teams, so there is no campus to travel to. Our data students join from Lagos, Abuja, Port Harcourt, Ibadan and outside the country.

Do I need to be good at maths to become a data analyst?

No. Day-to-day analysis work is far more about asking the right question, cleaning messy data and presenting a clear answer than it is about advanced maths. If you can work with percentages and averages, you have enough. Excel and Power BI do the calculation for you.

How long does it take to become a data analyst in Nigeria?

Ten weeks of guided, consistent practice is enough to be employable at entry level, which is the length of this programme. You finish with a capstone project and a portfolio, which is what a hiring manager actually asks to see.

Is the certificate recognised by employers?

Every LeadarX certificate has a unique verification code. Employers can verify it at leadarx.com/verify. We work with Nigerian tech companies who request candidates directly from our alumni network.

I have a full-time job. Can I still do this?

Yes. The programme is designed for working professionals. Classes are on Saturdays, recordings are available on demand and assignments are done in your own time. Most of our graduates completed the programme while employed full time.

Other courses at LeadarX

Same 10-week structure, same live Saturday format, same verified certificate.

The data skills
that get you hired.
In 10 weeks.

Nigeria's data economy is growing. Most companies do not have the analysts to match.

High demand, very low supply

Remote work is real now

The salary premium is documented

Every week builds on the last. Nothing is taught in isolation.

Introduction to Data Analysis

Excel for Data Analysis I

Excel for Data Analysis II

SQL for Data Analysis I

SQL for Data Analysis II

Power BI I: Data Prep and Visualisation

Power BI II: Dashboard Development

Introduction to Python for Data Analysis

AI for Data Analysts and Python Analysis

Capstone Project and Portfolio