What you'll learn

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

Build interactive dashboards with Power BI and Tableau

Write SQL queries to extract and manipulate data from databases

Analyze data with Python: Pandas, NumPy, Matplotlib, Seaborn

Apply machine learning for predictive analytics with Scikit-learn

Clean, transform, and prepare messy real-world datasets

Create professional data reports and presentations

Build a portfolio of 12 data analysis projects

Pass data analyst job interviews at banks, telecoms, and fintech companies

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

Course syllabus

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

Master the fundamentals that 90% of professionals get wrong. Learn proper data structuring, cell referencing, essential formulas (SUM, AVERAGE, COUNT, IF), formatting, data validation, and keyboard shortcuts that save hours.

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

Unlock Excel's power functions. Master VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH, nested IFs, SUMIFS, COUNTIFS, text functions, date functions, and array formulas that solve real business problems.

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

Transform raw data into executive-ready reports. Create Pivot Tables, Pivot Charts, slicers, timelines, and build interactive dashboards that tell compelling data stories. Work with real Nigerian banking data.

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

Automate repetitive tasks forever. Learn Power Query for data transformation (cleaning, merging, appending), record macros, write VBA scripts, and build automated reporting systems that run on schedule.

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

Query databases like a pro. Learn SQL SELECT, WHERE, JOINs, GROUP BY, HAVING, subqueries, window functions, CTEs, and optimization. Practice with MySQL on real-world datasets (Nigerian telecom subscriber data).

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

Microsoft's premier analytics tool. Connect to data sources, build data models with relationships, write DAX measures (CALCULATE, FILTER, ALL, RELATED), create calculated columns, and understand row context vs filter context.

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

Build stunning interactive dashboards. Master visualizations (bar, line, scatter, maps, KPI cards), implement drill-through and cross-filtering, set up scheduled refresh, and publish to Power BI Service for stakeholder access.

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

Learn the industry standard for data visualization. Connect to data, build calculated fields, create worksheets, combine into dashboards, use parameters, sets, and LOD expressions. Create a Tableau Public portfolio.

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

Learn Python programming focused on data. Master Pandas DataFrames, Series, data cleaning (handling missing values, duplicates, outliers), merging datasets, grouping, and NumPy for numerical computing.

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

Create publication-quality visualizations. Master Matplotlib, Seaborn, and Plotly for static and interactive charts. Statistical visualization: distributions, correlations, time series plots, and geospatial mapping.

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

Apply predictive analytics. Learn supervised learning (linear regression, decision trees, random forests), unsupervised learning (clustering, PCA), model evaluation, and Scikit-learn workflows. Predict customer churn for a Nigerian fintech.

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

Complete end-to-end data analysis project: collect data, clean, explore, analyze, visualize, build ML model, and present findings. Build your portfolio. Master data analyst interview questions and case studies.

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

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

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