Westhub Academy
Log in Get Started
← Back to Courses
Free 🎓 Verifiable Certificate

Advanced Data Analysis & Machine Learning

79 modules · Advanced

The advanced, professional half of the Westhub Data Analysis Program: SQL for analytical databases (joins, subqueries, window functions, cohort analysis); Power BI (data modeling, DAX, dashboard design, row-level security); Python for data analysis (NumPy, Pandas, Matplotlib/Seaborn, statistical analysis); ten real-world analytical projects spanning retail, marketing, HR, finance, healthcare and more; SPSS for research and statistical testing; R and the tidyverse/ggplot2 for statistical analysis and reproducible reporting; advanced statistics (multivariate methods, regression diagnostics, time series); advanced Python (OOP, APIs, databases, automation, data pipelines); machine learning for analysts (regression, classification, clustering, model evaluation, ethics); and a final capstone where you take an unfamiliar real-world dataset from business question through cleaning, statistical analysis, visualization, predictive modeling and a professional report and presentation. Completing this course — the sequel to Data Analysis Fundamentals — earns the Professional Certificate in Data Analysis.

Course Content

1. Database Fundamentals

  • Lesson
    45 min
  • 1. Database Fundamentals Quiz
    10 min
  • Database Fundamentals — Homework & Mini Project
    45 min

2. SQL Fundamentals

  • Lesson
    45 min
  • 2. SQL Fundamentals Quiz
    10 min
  • SQL Fundamentals — Homework & Mini Project
    45 min

3. Filtering Data

  • Lesson
    45 min
  • 3. Filtering Data Quiz
    10 min
  • Filtering Data — Homework & Mini Project
    45 min

4. Aggregation

  • Lesson
    45 min
  • 4. Aggregation Quiz
    10 min
  • Aggregation — Homework & Mini Project
    45 min

5. Joins

  • Lesson
    45 min
  • 5. Joins Quiz
    10 min
  • Joins — Homework & Mini Project
    45 min

6. Subqueries

  • Lesson
    45 min
  • 6. Subqueries Quiz
    10 min
  • Subqueries — Homework & Mini Project
    45 min

7. Advanced SQL — Window Functions

  • Lesson
    45 min
  • 7. Advanced SQL — Window Functions Quiz
    10 min
  • Window Functions — Homework & Mini Project
    45 min

8. SQL for Data Cleaning

  • Lesson
    45 min
  • 8. SQL for Data Cleaning Quiz
    10 min
  • SQL for Data Cleaning — Homework & Mini Project
    45 min

9. Analytical SQL

  • Lesson
    45 min
  • 9. Analytical SQL Quiz
    10 min
  • Analytical SQL — Homework & Mini Project
    45 min

10. Final SQL Project — E-Commerce Analytical Database

  • E-Commerce Analytical Database Project
    90 min
  • Checkpoint Quiz: SQL Fundamentals to Advanced
    15 min

11. Introduction to Business Intelligence

  • Lesson
    45 min
  • 11. Introduction to Business Intelligence Quiz
    10 min
  • Introduction to Business Intelligence — Homework & Mini Project
    45 min

12. The Power BI Interface

  • Lesson
    45 min
  • 12. The Power BI Interface Quiz
    10 min
  • The Power BI Interface — Homework & Mini Project
    45 min

13. Data Import

  • Lesson
    45 min
  • 13. Data Import Quiz
    10 min
  • Data Import — Homework & Mini Project
    45 min

14. Power Query in Power BI

  • Lesson
    45 min
  • 14. Power Query in Power BI Quiz
    10 min
  • Power Query in Power BI — Homework & Mini Project
    45 min

15. Data Modeling

  • Lesson
    45 min
  • 15. Data Modeling Quiz
    10 min
  • Data Modeling (Power BI) — Homework & Mini Project
    45 min

16. DAX

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

17. Power BI Visualization

  • Lesson
    45 min
  • 17. Power BI Visualization Quiz
    10 min
  • Power BI Visualization — Homework & Mini Project
    45 min

18. Dashboard Design

  • Lesson
    45 min
  • 18. Dashboard Design Quiz
    10 min
  • Dashboard Design — Homework & Mini Project
    45 min

19. Advanced Power BI

  • Lesson
    45 min
  • 19. Advanced Power BI Quiz
    10 min
  • Advanced Power BI — Homework & Mini Project
    45 min

20. Power BI Project — Sales & Business Intelligence Dashboard

  • Sales & Business Intelligence Dashboard Project
    90 min
  • Checkpoint Quiz: Business Intelligence & Power BI
    15 min

21. Python Foundations

  • Lesson
    45 min
  • 21. Python Foundations Quiz
    10 min
  • Python Foundations — Homework & Mini Project
    45 min

22. Python for Data Analysts

  • Lesson
    45 min
  • 22. Python for Data Analysts Quiz
    10 min
  • Python for Data Analysts — Homework & Mini Project
    45 min

23. NumPy

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

24. Pandas

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

25. Data Cleaning with Pandas

  • Lesson
    45 min
  • 25. Data Cleaning with Pandas Quiz
    10 min
  • Data Cleaning with Pandas — Homework & Mini Project
    45 min

26. Exploratory Data Analysis in Python

  • Lesson
    45 min
  • 26. Exploratory Data Analysis in Python Quiz
    10 min
  • Exploratory Data Analysis in Python — Homework & Mini Project
    45 min

27. Data Visualization with Matplotlib & Seaborn

  • Lesson
    45 min
  • 27. Data Visualization with Matplotlib & Seaborn Quiz
    10 min
  • Data Visualization with Matplotlib & Seaborn — Homework & Mini Project
    45 min

28. Statistical Analysis with Python

  • Lesson
    45 min
  • 28. Statistical Analysis with Python Quiz
    10 min
  • Statistical Analysis with Python — Homework & Mini Project
    45 min

29. Working with Real Data

  • Lesson
    45 min
  • 29. Working with Real Data Quiz
    10 min
  • Working with Real Data — Homework & Mini Project
    45 min

30. Final Python Project — Complete Exploratory & Statistical Analysis

  • Complete Python Data Analysis Project
    90 min
  • Checkpoint Quiz: Python for Data Analysis
    15 min

31. Real-World Data Analysis Projects

  • Project 1 — Retail Analytics
    60 min
  • Project 2 — Customer Analytics
    60 min
  • Project 3 — Marketing Analytics
    60 min
  • Project 4 — HR Analytics
    60 min
  • Project 5 — Financial Analytics
    60 min
  • Project 6 — Education Analytics
    60 min
  • Project 7 — Healthcare Analytics
    60 min
  • Project 8 — E-Commerce Analytics
    60 min
  • Project 9 — Government / Public Data
    60 min
  • Project 10 — Complete Business Case
    60 min
  • Checkpoint Quiz: Applied Data Analysis Skills
    15 min

32. The SPSS Environment

  • Lesson
    45 min
  • 32. The SPSS Environment Quiz
    10 min
  • The SPSS Environment — Homework & Mini Project
    45 min

33. Data Preparation in SPSS

  • Lesson
    45 min
  • 33. Data Preparation in SPSS Quiz
    10 min
  • Data Preparation in SPSS — Homework & Mini Project
    45 min

34. Descriptive Analysis in SPSS

  • Lesson
    45 min
  • 34. Descriptive Analysis in SPSS Quiz
    10 min
  • Descriptive Analysis in SPSS — Homework & Mini Project
    45 min

35. Statistical Testing in SPSS

  • Lesson
    45 min
  • 35. Statistical Testing in SPSS Quiz
    10 min
  • Statistical Testing in SPSS — Homework & Mini Project
    45 min

36. Regression in SPSS

  • Lesson
    45 min
  • 36. Regression in SPSS Quiz
    10 min
  • Regression in SPSS — Homework & Mini Project
    45 min

37. Research Analysis

  • Lesson
    45 min
  • 37. Research Analysis Quiz
    10 min
  • Research Analysis — Homework & Mini Project
    45 min

38. Advanced SPSS

  • Lesson
    45 min
  • 38. Advanced SPSS Quiz
    10 min
  • Advanced SPSS — Homework & Mini Project
    45 min

39. SPSS Research Project

  • SPSS Research Analysis Project
    90 min
  • Checkpoint Quiz: SPSS for Statistical Analysis
    15 min

40. R Foundations

  • Lesson
    45 min
  • 40. R Foundations Quiz
    10 min
  • R Foundations — Homework & Mini Project
    45 min

41. Data Import in R

  • Lesson
    45 min
  • 41. Data Import in R Quiz
    10 min
  • Data Import in R — Homework & Mini Project
    45 min

42. Data Manipulation with the Tidyverse

  • Lesson
    45 min
  • 42. Data Manipulation with the Tidyverse Quiz
    10 min
  • Data Manipulation with the Tidyverse — Homework & Mini Project
    45 min

43. Data Visualization with ggplot2

  • Lesson
    45 min
  • 43. Data Visualization with ggplot2 Quiz
    10 min
  • Data Visualization with ggplot2 — Homework & Mini Project
    45 min

44. Statistical Analysis in R

  • Lesson
    45 min
  • 44. Statistical Analysis in R Quiz
    10 min
  • Statistical Analysis in R — Homework & Mini Project
    45 min

45. Advanced Statistics in R

  • Lesson
    45 min
  • 45. Advanced Statistics in R Quiz
    10 min
  • Advanced Statistics in R — Homework & Mini Project
    45 min

46. Reporting with R Markdown

  • Lesson
    45 min
  • 46. Reporting with R Markdown Quiz
    10 min
  • Reporting with R Markdown — Homework & Mini Project
    45 min

47. R Statistical Investigation Project

  • R Reproducible Research Report
    90 min
  • Checkpoint Quiz: R for Data Analysis
    15 min

48. Statistical Theory

  • Lesson
    45 min
  • 48. Statistical Theory Quiz
    10 min
  • Statistical Theory — Homework & Mini Project
    45 min

49. Advanced Probability

  • Lesson
    45 min
  • 49. Advanced Probability Quiz
    10 min
  • Advanced Probability — Homework & Mini Project
    45 min

50. Advanced Hypothesis Testing

  • Lesson
    45 min
  • 50. Advanced Hypothesis Testing Quiz
    10 min
  • Advanced Hypothesis Testing — Homework & Mini Project
    45 min

51. Regression — Beyond Simple Linear

  • Lesson
    45 min
  • 51. Regression — Beyond Simple Linear Quiz
    10 min
  • Multiple & Polynomial Regression — Homework & Mini Project
    45 min

52. Regression Diagnostics

  • Lesson
    45 min
  • 52. Regression Diagnostics Quiz
    10 min
  • Regression Diagnostics — Homework & Mini Project
    45 min

53. Logistic Regression (Advanced)

  • Lesson
    45 min
  • 53. Logistic Regression (Advanced) Quiz
    10 min
  • Logistic Regression (Advanced) — Homework & Mini Project
    45 min

54. ANOVA (Advanced)

  • Lesson
    45 min
  • 54. ANOVA (Advanced) Quiz
    10 min
  • ANOVA (Advanced) — Homework & Mini Project
    45 min

55. Multivariate Statistics

  • Lesson
    45 min
  • 55. Multivariate Statistics Quiz
    10 min
  • Multivariate Statistics — Homework & Mini Project
    45 min

56. Time Series Analysis

  • Lesson
    45 min
  • 56. Time Series Analysis Quiz
    10 min
  • Time Series Analysis — Homework & Mini Project
    45 min

57. Advanced Statistics Project

  • Advanced Statistical Methodology Project
    90 min
  • Checkpoint Quiz: Advanced Statistical Methods
    15 min

58. Advanced Python

  • Lesson
    45 min
  • 58. Advanced Python Quiz
    10 min
  • Advanced Python — Homework & Mini Project
    45 min

59. Advanced NumPy

  • Lesson
    45 min
  • 59. Advanced NumPy Quiz
    10 min
  • Advanced NumPy — Homework & Mini Project
    45 min

60. Advanced Pandas

  • Lesson
    45 min
  • 60. Advanced Pandas Quiz
    10 min
  • Advanced Pandas — Homework & Mini Project
    45 min

61. Advanced Data Cleaning

  • Lesson
    45 min
  • 61. Advanced Data Cleaning Quiz
    10 min
  • Advanced Data Cleaning — Homework & Mini Project
    45 min

62. APIs

  • Lesson
    45 min
  • 62. APIs Quiz
    10 min
  • APIs — Homework & Mini Project
    45 min

63. Python with Databases

  • Lesson
    45 min
  • 63. Python with Databases Quiz
    10 min
  • Python with Databases — Homework & Mini Project
    45 min

64. Automation

  • Lesson
    45 min
  • 64. Automation Quiz
    10 min
  • Automation — Homework & Mini Project
    45 min

65. Advanced Visualization

  • Lesson
    45 min
  • 65. Advanced Visualization Quiz
    10 min
  • Advanced Visualization — Homework & Mini Project
    45 min

66. Data Pipelines

  • Lesson
    45 min
  • 66. Data Pipelines Quiz
    10 min
  • Data Pipelines — Homework & Mini Project
    45 min

67. Final Project — Automated Data Pipeline

  • Automated Python Data Pipeline Project
    90 min
  • Checkpoint Quiz: Advanced Python & Data Pipelines
    15 min

68. Introduction to Machine Learning

  • Lesson
    45 min
  • 68. Introduction to Machine Learning Quiz
    10 min
  • Introduction to Machine Learning — Homework & Mini Project
    45 min

69. Data Preparation for Machine Learning

  • Lesson
    45 min
  • 69. Data Preparation for Machine Learning Quiz
    10 min
  • Data Preparation for Machine Learning — Homework & Mini Project
    45 min

70. Regression Algorithms

  • Lesson
    45 min
  • 70. Regression Algorithms Quiz
    10 min
  • Regression Algorithms — Homework & Mini Project
    45 min

71. Classification Algorithms

  • Lesson
    45 min
  • 71. Classification Algorithms Quiz
    10 min
  • Classification Algorithms — Homework & Mini Project
    45 min

72. Clustering

  • Lesson
    45 min
  • 72. Clustering Quiz
    10 min
  • Clustering — Homework & Mini Project
    45 min

73. Model Evaluation

  • Lesson
    45 min
  • 73. Model Evaluation Quiz
    10 min
  • Model Evaluation — Homework & Mini Project
    45 min

74. Model Improvement

  • Lesson
    45 min
  • 74. Model Improvement Quiz
    10 min
  • Model Improvement — Homework & Mini Project
    45 min

75. Unsupervised Learning Revisited

  • Lesson
    45 min
  • 75. Unsupervised Learning Revisited Quiz
    10 min
  • Unsupervised Learning Revisited — Homework & Mini Project
    45 min

76. Model Interpretation

  • Lesson
    45 min
  • 76. Model Interpretation Quiz
    10 min
  • Model Interpretation — Homework & Mini Project
    45 min

77. Ethical Machine Learning

  • Lesson
    45 min
  • 77. Ethical Machine Learning Quiz
    10 min
  • Ethical Machine Learning — Homework & Mini Project
    45 min

78. Machine Learning Practice Projects

  • Project 1 — Predict House Prices
    60 min
  • Project 2 — Predict Customer Churn
    60 min
  • Project 3 — Classify Customer Segments
    60 min
  • Project 4 — Predict Employee Attrition
    60 min
  • Final Project — Complete Predictive Analytics Solution
    60 min
  • Checkpoint Quiz: Machine Learning Fundamentals
    15 min

79. Professional Data Analyst Capstone

  • Lesson
    45 min
  • Professional Data Analyst Capstone Project
    90 min
  • Capstone Review Quiz: Complete Data Analysis & Machine Learning
    15 min
Sign Up — It's Free

Free · Learn at your own pace

No open cohort right now

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

Programme Details

Self-Taught
Free
Certificate
NGN 20,000.00
Cohort
NGN 150,000.00
VIP (1-on-1)
NGN 400,000.00
Modules
79
Lessons
241
Programme Length
14 weeks

Certificate Preview

John Doe
SAMPLE · PREVIEW

Complete the course to unlock your certificate for download.