Free 🎓 Verifiable Certificate

Data Analysis Fundamentals

30 modules · Beginner

A complete, practical, beginner-friendly introduction to data analysis: what data analysis actually is and the full analysis lifecycle; collecting, organizing and cleaning real-world data; exploratory analysis and basic visualization; a full data-analysis-focused Excel toolkit (formulas, lookups, PivotTables, Power Query, dashboards, what-if analysis); and the statistics every analyst needs (descriptive statistics, probability, sampling, distributions, hypothesis testing, correlation and simple regression). Learning by doing throughout, with a retail sales analysis project, five Excel business projects culminating in an interactive sales dashboard, and a statistics capstone investigating what drives employee performance. Completing this course earns the Certificate in Data Analysis and is the first half of the Westhub Professional Data Analysis Program — continue into Professional Data Analysis & Machine Learning for the Professional Certificate in Data Analysis.

Course Content

1. Understanding Data

Lesson
45 min
1. Understanding Data Quiz
10 min
Data vs. Information vs. Knowledge — Homework & Mini Project
45 min

2. Types of Data

Lesson
45 min
2. Types of Data Quiz
10 min
Types of Data — Homework & Mini Project
45 min

3. The Data Analysis Lifecycle

Lesson
45 min
3. The Data Analysis Lifecycle Quiz
10 min
The Data Analysis Lifecycle — Homework & Mini Project
45 min

4. Data Collection

Lesson
45 min
4. Data Collection Quiz
10 min
Data Collection — Homework & Mini Project
45 min

5. Data Quality

Lesson
45 min
5. Data Quality Quiz
10 min
Data Quality — Homework & Mini Project
45 min

6. Data Cleaning Fundamentals

Lesson
45 min
6. Data Cleaning Fundamentals Quiz
10 min
Data Cleaning Fundamentals — Homework & Mini Project
45 min

7. Exploratory Data Analysis

Lesson
45 min
7. Exploratory Data Analysis Quiz
10 min
Exploratory Data Analysis — Homework & Mini Project
45 min

8. Basic Data Visualization

Lesson
45 min
8. Basic Data Visualization Quiz
10 min
Basic Data Visualization — Homework & Mini Project
45 min

9. Introduction to Data Interpretation

Lesson
45 min
9. Introduction to Data Interpretation Quiz
10 min
Introduction to Data Interpretation — Homework & Mini Project
45 min

10. Course Project — Retail Sales Analysis

Retail Sales Analysis Project
90 min
Checkpoint Quiz: Data Fundamentals Through EDA
15 min

11. The Excel Data Environment

Lesson
45 min
11. The Excel Data Environment Quiz
10 min
The Excel Data Environment — Homework & Mini Project
45 min

12. Essential Excel Functions

Lesson
45 min
12. Essential Excel Functions Quiz
10 min
Essential Excel Functions — Homework & Mini Project
45 min

13. Lookup and Reference Functions

Lesson
45 min
13. Lookup and Reference Functions Quiz
10 min
Lookup and Reference Functions — Homework & Mini Project
45 min

14. Data Cleaning in Excel

Lesson
45 min
14. Data Cleaning in Excel Quiz
10 min
Data Cleaning in Excel — Homework & Mini Project
45 min

15. Excel Tables

Lesson
45 min
15. Excel Tables Quiz
10 min
Excel Tables — Homework & Mini Project
45 min

16. PivotTables

Lesson
45 min
16. PivotTables Quiz
10 min
PivotTables — Homework & Mini Project
45 min

17. Power Query

Lesson
45 min
17. Power Query Quiz
10 min
Power Query — Homework & Mini Project
45 min

18. Excel Data Visualization

Lesson
45 min
18. Excel Data Visualization Quiz
10 min
Excel Data Visualization — Homework & Mini Project
45 min

19. Advanced Excel Analytics

Lesson
45 min
19. Advanced Excel Analytics Quiz
10 min
Advanced Excel Analytics — Homework & Mini Project
45 min

20. Excel Practice Projects

Project 1 — Sales Performance Analysis
60 min
Project 2 — Employee Performance Analysis
60 min
Project 3 — Customer Churn Analysis
60 min
Project 4 — Financial Expense Analysis
60 min
Final Project — Interactive Business Sales Dashboard
60 min
Checkpoint Quiz: Excel for Data Analysis
15 min

21. Statistical Thinking

Lesson
45 min
21. Statistical Thinking Quiz
10 min
Statistical Thinking — Homework & Mini Project
45 min

22. Descriptive Statistics

Lesson
45 min
22. Descriptive Statistics Quiz
10 min
Descriptive Statistics — Homework & Mini Project
45 min

23. Probability

Lesson
45 min
23. Probability Quiz
10 min
Probability — Homework & Mini Project
45 min

24. Sampling

Lesson
45 min
24. Sampling Quiz
10 min
Sampling — Homework & Mini Project
45 min

25. Probability Distributions

Lesson
45 min
25. Probability Distributions Quiz
10 min
Probability Distributions — Homework & Mini Project
45 min

26. Inferential Statistics

Lesson
45 min
26. Inferential Statistics Quiz
10 min
Inferential Statistics — Homework & Mini Project
45 min

27. Hypothesis Tests

Lesson
45 min
27. Hypothesis Tests Quiz
10 min
Hypothesis Tests — Homework & Mini Project
45 min

28. Correlation

Lesson
45 min
28. Correlation Quiz
10 min
Correlation — Homework & Mini Project
45 min

29. Introduction to Regression

Lesson
45 min
29. Introduction to Regression Quiz
10 min
Introduction to Regression — Homework & Mini Project
45 min

30. Statistics Capstone — What Drives Employee Performance?

Employee Performance Investigation
90 min
Checkpoint Quiz: Statistics Fundamentals
15 min

Free · Learn at your own pace

👥 COHORT - Group Class

No open Cohort right now

✨ VIP (1-on-1 Class)

Want an instructor all to yourself?

VIP gets you a schedule built entirely around you, full instructor attention with no sharing, and faster feedback on your work — the quickest path through the course.

🧑‍🏫 Book VIP (1-on-1) Training

Self-Taught: Free
Certificate: ₦20,000.00
VIP (1-on-1): ₦250,000.00
Modules: 30
Lessons: 91
Programme Length: 8 weeks

Certificate Preview

John Doe

SAMPLE · PREVIEW

Complete the course to unlock your certificate for download.