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.
- Lessons30
- Videoabout 6 hours
- LevelBeginner
- PriceFree
- Datasets22
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
13 minPython Variables & Data Types Explained | Data Analytics #1
11 minPython Control Flow: If, For & While Loops | Data Analytics #2
11 minPython Functions & Modules for Reusable Code | Data Analytics #3
11 minPython Lists, Tuples, Sets & Dicts Explained | Data Analytics #4
13 minRead & Write Files in Python (CSV & TXT) | Data Analytics #5
14 minNumPy Arrays & Operations for Beginners | Data Analytics #6
15 minPandas Series & DataFrames from Scratch | Data Analytics #7
13 minPandas Data Cleaning: Missing Values & Duplicates | Data Analytics #8
11 minPandas Data Wrangling: Reshape & Transform Data | Data Analytics #9
12 minPandas GroupBy & Aggregation Made Simple | Data Analytics #10
12 minPandas Merge, Join & Pivot Explained | Data Analytics #11
12 minPandas Time Series Analysis Tutorial | Data Analytics #12
10 minData Visualisation with Matplotlib | Data Analytics #13
12 minBeautiful Charts with Seaborn in Python | Data Analytics #14
15 minBuild a Streamlit Dashboard in Python | Data Analytics #15
12 minSQL Fundamentals for Data Analysts | Data Analytics #16
12 minSQL Joins & Aggregations Explained | Data Analytics #17
12 minPython + SQL: Real Analyst Queries | Data Analytics #18
12 minAutomate Excel with Python | Data Analytics #19
12 minExcel Pivot Tables & Charts for Reporting | Data Analytics #20
10 minPull Data from APIs with Python | Data Analytics #21
10 minWeb Scraping with Python: Step by Step | Data Analytics #22
10 minStatistics Fundamentals Every Analyst Needs | Data Analytics #23
10 minCorrelation, P-Values & Confidence Intervals | Data Analytics #24
10 minMachine Learning for Beginners in Python | Data Analytics #25
11 minFeature Engineering & Model Evaluation | Data Analytics #26
12 minStorytelling with Data: Present Like a Pro | Data Analytics #27
13 minRetail Analytics Project in Python: RFM, Discounts & Shipping
12 minBusiness Operations Analytics Deep Dive | Data Analytics #29
15 minEnd-to-End Analytics Capstone Project | Data Analytics #30
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.