Data Analysis

Data Analysis Professional

Master Excel, Power BI, SQL & AI tools to become a data analyst in 3 months

3 months500+ enrolled4.9 ratingbeginner

What You'll Achieve

Build professional dashboards in Power BI from scratch
Write SQL queries to extract insights from databases
Master advanced Excel for business analysis
Use AI tools to accelerate your data work 10x
Tell compelling data stories to non-technical stakeholders
Clean, transform, and analyse messy real-world data
Land a data analyst role or freelance clients

Who This Course Is For

Fresh graduates seeking high-demand tech roles
Finance and accounting professionals levelling up
Business owners who want data-driven decisions
HR and operations professionals
Anyone curious about working with data

Course Curriculum

6 modules · 29 lessons

1

Module 1: Excel Foundations & Advanced Techniques

5 lessons

Excel interface, shortcuts, and best practicesPreview
60 min
Essential formulas: VLOOKUP, INDEX-MATCH, SUMIFPreview
90 min
Pivot Tables and data summarization
75 min
Excel charts for business storytelling
60 min
Data cleaning and preparation techniques
90 min
2

Module 2: SQL for Data Analysis

5 lessons

What is SQL? Setting up MySQL
45 min
SELECT, WHERE, GROUP BY — the core queries
90 min
JOINs: combining data from multiple tables
90 min
Subqueries and window functions
75 min
Real-world Nigerian business database analysis
120 min
3

Module 3: Power BI Dashboard Development

6 lessons

Power BI interface and data connections
60 min
Data modelling and relationships
90 min
DAX formulas for calculated measures
90 min
Designing professional dashboard layouts
75 min
Publishing and sharing dashboards
45 min
Project: Sales analysis dashboard
180 min
4

Module 4: AI in Data Analysis

4 lessons

Using Claude AI for data cleaning and formulas
60 min
AI-assisted SQL query writing
75 min
Automating reports with AI
60 min
ChatGPT + Python for quick data exploration
90 min
5

Module 5: Data Storytelling & Communication

4 lessons

Principles of data visualization
60 min
Choosing the right chart for the right story
45 min
Building executive-ready presentations
90 min
Communicating with non-technical stakeholders
60 min
6

Module 6: Job Readiness & Portfolio

5 lessons

Building a portfolio on GitHub
60 min
Capstone Project: End-to-end business analysis
240 min
Writing a data analyst CV and LinkedIn profile
60 min
Interview prep: common data analyst questions
90 min
Freelancing as a data analyst in Nigeria
60 min

Tools You'll Master

Microsoft ExcelPower BISQL (MySQL)Python basicsClaude AIGoogle Looker StudioTableau Public

Real Projects You'll Build

1Sales performance dashboard for a retail business
2Customer churn analysis with SQL
3Financial reporting dashboard in Power BI
4HR analytics: workforce insights report
5E-commerce analysis: product performance
6AI-assisted market research report

Frequently Asked Questions

Is this course suitable for absolute beginners?

Absolutely. We start from the very basics and build up gradually. Many of our successful graduates had zero data experience when they started.

Do I need a Mac or Windows PC?

Power BI requires Windows. If you have a Mac, we'll guide you on using alternatives like Google Looker Studio. All other tools work on both.

Will I be able to get a job after this?

Our curriculum is designed around what Nigerian and remote employers actually ask for. We have graduates working at banks, fintechs, and international remote companies.

How much does a data analyst earn?

Entry-level data analysts in Nigeria earn ₦150,000–₦400,000/month. With 1-2 years of experience and remote skills, you can earn in USD.

What datasets will we work with?

We use real African business datasets — retail sales, banking transactions, e-commerce data — so your portfolio looks relevant to Nigerian and African employers.

Is there support during the course?

Yes! You get access to a private WhatsApp group, weekly Q&A sessions with Israel, and peer study groups.

Can I pay in installments?

Yes! We offer flexible payment plans. Message us on WhatsApp to get started with a convenient option.

Course Fee

₦100,000

Payment plans available

Price increases in

27

Days

15

Hours

53

Mins

06

Secs

Enroll via WhatsApp
Satisfaction guaranteed or full refund
500+ students enrolled
Live & recorded sessions
WhatsApp support group
Certificate on completion
8+ real-world projects

Requirements

  • Basic Excel familiarity helpful but not required
  • Access to a Windows PC (Mac users get guidance)
  • No statistics or math background required
  • Commitment to completing 6+ analysis projects

₦100,000

Payment plans available

Enroll Now