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.

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 Deep Dive Project | Data Analytics #2813 min
Lesson 28

Retail Analytics Deep Dive Project | Data Analytics #28

📊 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