Mathew K Analytics

Data analytics zero to hero

A free 30-lesson course. Every lesson has a video walkthrough and a Jupyter notebook you can download or open in Google Colab; 22 lessons include real datasets. Tools covered: pandas, Matplotlib, SciPy, NumPy, SQLite, scikit-learn.

About this course

Data Analytics Zero to Hero takes you from your first Python variable to a full analytics capstone project. The first half builds the toolkit: Python basics, files, NumPy, and pandas for cleaning, reshaping, grouping, merging and time series. The second half puts it to work the way an analyst does: charts with Matplotlib and Seaborn, a Streamlit dashboard, SQL from Python, Excel automation, APIs and web scraping, core statistics, a first machine learning model, and data storytelling. It ends with two deep-dive projects and a capstone.

Data analytics zero to hero is a free beginner course with 30 video lessons (about 6 hours of video in total). It starts with “Python Variables & Data Types Explained | Data Analytics #1” and finishes with “End-to-End Analytics Capstone Project | Data Analytics #30”. Every lesson comes with the exact Jupyter notebook used in the video, and 22 of them include the dataset, so you can follow along with the same data.

Along the way you'll use pandas, Matplotlib, SciPy, NumPy, SQLite and scikit-learn.

It suits complete beginners who want a job-ready data analytics skill set. No prior coding is assumed.

What you'll be able to do

  • Write clean Python for data work: variables, loops, functions and data structures
  • Load, clean, reshape, group and merge data with pandas
  • Build charts with Matplotlib and Seaborn, and an interactive Streamlit dashboard
  • Query databases with SQL, including joins and aggregations, from Python
  • Automate Excel reports and pull data from APIs and web pages
  • Use statistics (correlation, p-values, confidence intervals) to back up a finding
  • Train and evaluate a first machine learning model
  • Finish real projects: a retail deep dive, an operations deep dive and a capstone

All 30 lessons

Python Variables & Data Types Explained | Data Analytics #113 min
Lesson 1

Python Variables & Data Types Explained | Data Analytics #1

📓 Notebook

Python Control Flow: If, For & While Loops | Data Analytics #211 min
Lesson 2

Python Control Flow: If, For & While Loops | Data Analytics #2

📓 Notebook

Python Functions & Modules for Reusable Code | Data Analytics #311 min
Lesson 3

Python Functions & Modules for Reusable Code | Data Analytics #3

📓 Notebook · datetime

Python Lists, Tuples, Sets & Dicts Explained | Data Analytics #411 min
Lesson 4

Python Lists, Tuples, Sets & Dicts Explained | Data Analytics #4

📓 Notebook

Read & Write Files in Python (CSV & TXT) | Data Analytics #513 min
Lesson 5

Read & Write Files in Python (CSV & TXT) | Data Analytics #5

📊 Dataset · 📓 Notebook · CSV · JSON

NumPy Arrays & Operations for Beginners | Data Analytics #614 min
Lesson 6

NumPy Arrays & Operations for Beginners | Data Analytics #6

📊 Dataset · 📓 Notebook · NumPy

Pandas Series & DataFrames from Scratch | Data Analytics #715 min
Lesson 7

Pandas Series & DataFrames from Scratch | Data Analytics #7

📊 Dataset · 📓 Notebook · pandas

Pandas Data Cleaning: Missing Values & Duplicates | Data Analytics #813 min
Lesson 8

Pandas Data Cleaning: Missing Values & Duplicates | Data Analytics #8

📊 Dataset · 📓 Notebook · pandas

Pandas Data Wrangling: Reshape & Transform Data | Data Analytics #911 min
Lesson 9

Pandas Data Wrangling: Reshape & Transform Data | Data Analytics #9

📊 Dataset · 📓 Notebook · pandas

Pandas GroupBy & Aggregation Made Simple | Data Analytics #1012 min
Lesson 10

Pandas GroupBy & Aggregation Made Simple | Data Analytics #10

📊 Dataset · 📓 Notebook · pandas

Pandas Merge, Join & Pivot Explained | Data Analytics #1112 min
Lesson 11

Pandas Merge, Join & Pivot Explained | Data Analytics #11

📊 Dataset · 📓 Notebook · pandas

Pandas Time Series Analysis Tutorial | Data Analytics #1212 min
Lesson 12

Pandas Time Series Analysis Tutorial | Data Analytics #12

📊 Dataset · 📓 Notebook · pandas

Data Visualisation with Matplotlib | Data Analytics #1310 min
Lesson 13

Data Visualisation with Matplotlib | Data Analytics #13

📊 Dataset · 📓 Notebook · pandas · Matplotlib

Beautiful Charts with Seaborn in Python | Data Analytics #1412 min
Lesson 14

Beautiful Charts with Seaborn in Python | Data Analytics #14

📊 Dataset · 📓 Notebook · pandas · seaborn · Matplotlib

Build a Streamlit Dashboard in Python | Data Analytics #1515 min
Lesson 15

Build a Streamlit Dashboard in Python | Data Analytics #15

📊 Dataset · 📓 Notebook · pandas

SQL Fundamentals for Data Analysts | Data Analytics #1612 min
Lesson 16

SQL Fundamentals for Data Analysts | Data Analytics #16

📊 Dataset · 📓 Notebook · SQLite · pandas

SQL Joins & Aggregations Explained | Data Analytics #1712 min
Lesson 17

SQL Joins & Aggregations Explained | Data Analytics #17

📓 Notebook · SQLite · pandas

Python + SQL: Real Analyst Queries | Data Analytics #1812 min
Lesson 18

Python + SQL: Real Analyst Queries | Data Analytics #18

📓 Notebook · SQLite · pandas

Automate Excel with Python | Data Analytics #1912 min
Lesson 19

Automate Excel with Python | Data Analytics #19

📊 Dataset · 📓 Notebook · openpyxl · pandas

Excel Pivot Tables & Charts for Reporting | Data Analytics #2012 min
Lesson 20

Excel Pivot Tables & Charts for Reporting | Data Analytics #20

📊 Dataset · 📓 Notebook · openpyxl · pandas

Pull Data from APIs with Python | Data Analytics #2110 min
Lesson 21

Pull Data from APIs with Python | Data Analytics #21

📓 Notebook · Requests · pandas

Web Scraping with Python: Step by Step | Data Analytics #2210 min
Lesson 22

Web Scraping with Python: Step by Step | Data Analytics #22

📓 Notebook · Requests · BeautifulSoup · pandas

Statistics Fundamentals Every Analyst Needs | Data Analytics #2310 min
Lesson 23

Statistics Fundamentals Every Analyst Needs | Data Analytics #23

📊 Dataset · 📓 Notebook · pandas · NumPy · SciPy

Correlation, P-Values & Confidence Intervals | Data Analytics #2410 min
Lesson 24

Correlation, P-Values & Confidence Intervals | Data Analytics #24

📊 Dataset · 📓 Notebook · pandas · SciPy

Machine Learning for Beginners in Python | Data Analytics #2510 min
Lesson 25

Machine Learning for Beginners in Python | Data Analytics #25

📊 Dataset · 📓 Notebook · scikit-learn · pandas

Feature Engineering & Model Evaluation | Data Analytics #2611 min
Lesson 26

Feature Engineering & Model Evaluation | Data Analytics #26

📊 Dataset · 📓 Notebook · scikit-learn · pandas

Storytelling with Data: Present Like a Pro | Data Analytics #2712 min
Lesson 27

Storytelling with Data: Present Like a Pro | Data Analytics #27

📊 Dataset · 📓 Notebook · Matplotlib · pandas

Retail Analytics Project in Python: RFM, Discounts & Shipping13 min
Lesson 28

Retail Analytics Project in Python: RFM, Discounts & Shipping

📊 Dataset · 📓 Notebook · pandas · NumPy · SciPy

Business Operations Analytics Deep Dive | Data Analytics #2912 min
Lesson 29

Business Operations Analytics Deep Dive | Data Analytics #29

📊 Dataset · 📓 Notebook · pandas · SciPy

End-to-End Analytics Capstone Project | Data Analytics #3015 min
Lesson 30

End-to-End Analytics Capstone Project | Data Analytics #30

📊 Dataset · 📓 Notebook · scikit-learn · pandas · NumPy

Frequently asked questions

Is the Data analytics zero to hero course free?

Yes. All 30 videos, notebooks and datasets are free, with no sign-up.

Do I need to install anything?

No. You can open each notebook in Google Colab in your browser, or download it and run it in Jupyter or VS Code with Anaconda installed.

How long does the Data analytics zero to hero course take?

The videos add up to about 6 hours. Most learners take one to two lessons a day, so plan on 4 to 8 weeks if you code along.

What level is it?

Beginner. It suits complete beginners who want a job-ready data analytics skill set. No prior coding is assumed.