What you'll learn

<ul>

<li>Master Advanced Excel: Pivot Tables, VLOOKUP/XLOOKUP, Power Query, Macros, and VBA</li>

<li>Build interactive dashboards with Power BI and Tableau</li>

<li>Write SQL queries to extract and manipulate data from databases</li>

<li>Analyze data with Python: Pandas, NumPy, Matplotlib, Seaborn</li>

<li>Apply machine learning for predictive analytics with Scikit-learn</li>

<li>Clean, transform, and prepare messy real-world datasets</li>

<li>Create professional data reports and presentations</li>

<li>Build a portfolio of 12 data analysis projects</li>

<li>Pass data analyst job interviews at banks, telecoms, and fintech companies</li>

<li>Earn ₦500,000 - ₦3,000,000/month as a data analyst</li>

</ul>

Course syllabus

1. Week 1: Excel Foundations & Data Organization 5 lessons

Excel Interface & Data Entry Best Practices 45m Free preview

Essential Formulas — SUM, AVERAGE, COUNT, IF 50m Free preview

Data Validation, Formatting & Protection 45m

Sorting, Filtering & Basic Charts 50m

Practice: Analyzing Nigerian Sales Data 55m

2. Week 2: Advanced Excel — VLOOKUP, INDEX/MATCH & Power Functions 5 lessons

VLOOKUP & HLOOKUP Mastery 50m

INDEX/MATCH — The Superior Lookup 50m

Text, Date & Math Functions 50m

SUMIFS, COUNTIFS & Array Formulas 55m

Practice: Employee & Payroll Analysis 55m

3. Week 3: Excel Pivot Tables, Charts & Dashboards 5 lessons

Pivot Tables — Creation & Configuration 55m

Pivot Charts, Slicers & Timelines 50m

Calculated Fields & Advanced Pivot Techniques 50m

Building Interactive Excel Dashboards 55m

Project: Nigerian Bank Transaction Dashboard 65m

4. Week 4: Power Query & Excel Automation (Macros/VBA) 5 lessons

Power Query — Connect & Transform 50m

Power Query — Advanced Transformations 55m

Recording & Editing Macros 45m

VBA Programming Basics 55m

Project: Automated Monthly Report Generator 60m

5. Week 5: SQL for Data Analysts 5 lessons

SQL Basics — SELECT, WHERE & ORDER BY 50m

Aggregations & GROUP BY 50m

JOINs — Combining Tables 55m

Subqueries & Window Functions 55m

Project: Telecom Subscriber Analysis with SQL 60m

6. Week 6: Power BI — Data Modeling & DAX 5 lessons

Power BI Desktop — Interface & Data Sources 50m

Data Modeling & Relationships 55m

DAX Fundamentals — Measures & Calculated Columns 55m

DAX Advanced — Time Intelligence & Iterators 55m

Practice: Sales Data Model & DAX Calculations 60m

7. Week 7: Power BI — Dashboards & Report Publishing 5 lessons

Visualizations — Chart Types & Best Practices 50m

Interactive Features — Drill Through & Bookmarks 55m

Custom Themes & Mobile Layouts 45m

Power BI Service & Sharing 50m

Project: Executive Sales Dashboard 65m

8. Week 8: Tableau — Visualization Mastery 5 lessons

Tableau Interface & Data Connections 50m

Building Worksheets & Calculations 55m

Advanced Tableau — LOD Expressions & Analytics 55m

Dashboards, Stories & Publishing 50m

Project: Nigerian E-Commerce Tableau Dashboard 60m

9. Week 9: Python for Data Analysis — Pandas & NumPy 5 lessons

Python Setup & Programming Basics 50m

NumPy — Numerical Computing 45m

Pandas — DataFrames & Series 55m

Data Cleaning with Pandas 55m

Merging, Grouping & Aggregation 55m

10. Week 10: Data Visualization with Python 5 lessons

Matplotlib — The Foundation 50m

Seaborn — Statistical Visualization 50m

Plotly — Interactive Visualizations 50m

Exploratory Data Analysis (EDA) Workflow 55m

Project: Agricultural Yield Analysis — Nigeria 60m

11. Week 11: Machine Learning for Data Analysts 5 lessons

Machine Learning Concepts & Scikit-learn 55m

Linear Regression & Prediction 50m

Classification — Decision Trees & Random Forest 55m

Clustering & Dimensionality Reduction 50m

Project: Fintech Customer Churn Prediction 65m

12. Week 12: Capstone Project & Career Preparation 5 lessons

Capstone: End-to-End Data Project (Part 1) 65m

Capstone: Presentation & Storytelling 45m

Building Your Data Portfolio 45m

Data Analyst Interview Preparation 50m

Career Paths & Continuous Learning 40m

Requirements

<ul>
<li>A computer with Microsoft Excel installed (2016 or newer recommended)</li>
<li>Stable internet connection</li>
<li>Basic Excel knowledge (opening files, simple formulas) is helpful but not required</li>
<li>No programming experience needed — Python is taught from scratch</li>
<li>Curiosity and love for problem-solving</li>
</ul>

About this course

Data Analysts Earn ₦500,000 - ₦3,000,000/month — And Companies Can't Find Enough of Them!
Nigeria's biggest banks, telecoms, and fintech companies are desperately hiring data analysts. Guaranty Trust Bank, MTN, Flutterwave, Interswitch — they all need people who can turn raw data into business decisions. This course gives you every skill they're looking for.
You'll master the complete data analysis toolkit: Advanced Excel (VLOOKUP, Pivot Tables, Power Query, Macros), Power BI (interactive dashboards, DAX formulas, data modeling), Tableau (stunning visualizations), Python (Pandas, NumPy, Matplotlib, Scikit-learn), and SQL for database querying.
12 Real-World Projects: You'll analyze actual Nigerian datasets — banking transactions, telecom subscriber data, e-commerce sales, agricultural yield data, and more. Each project is designed to match the exact kind of analysis top companies need.
By week 12, you'll have a data portfolio that makes hiring managers say YES immediately.

₦120,000

Dr. Amina Yusuf

Live Zoom classes · recordings to rewatch · certificate on completion

Beginner to Advanced Data Analysis 2026

What you'll learn

Course syllabus

Requirements

About this course

Useful Links

Contact

Beginner to Advanced Data Analysis 2026

What you'll learn

Course syllabus

Requirements

About this course

Follow us for Updates