Alex The Analyst Data Analyst Bootcamp: study plan and how long it takes
The Alex The Analyst playlist is 84 videos and 23.6 hours long. Here's how long it takes at different paces, a week-by-week schedule built from the real videos, and a planner that turns it into your own daily plan.
84 videos · 23.6 hours · Alex The Analyst
Alex The Analyst's free Data Analyst Bootcamp covers the whole data analyst toolkit: SQL (basics, joins, unions, data cleaning), Excel, Tableau and Power BI, Python with pandas and web scraping, exploratory data analysis, and cloud tools on Azure and AWS, with portfolio projects throughout.
It's one of the most popular free routes into a data analyst job.
Who it's for: Career changers and students aiming for an entry-level data analyst role.
How long does it take?
The full playlist is 23.6 hours across 84 videos. Here's roughly how many days that is at different daily watch times and speeds, counting video time only:
| Daily time | At 1x | At 1.5x | At 2x |
|---|---|---|---|
| 30 min a day | 48 days | 32 days | 24 days |
| 1 h a day | 24 days | 16 days | 12 days |
| 2 h a day | 12 days | 8 days | 6 days |
Make your own schedule
The playlist link is already filled in. Press Plan, set how much time you have each day and your speed, and you'll get a day-by-day schedule with a finish date and a calendar file. It reads the live playlist, so new videos are included.
Week-by-week schedule
A sample plan at 1 hour a day and normal speed, using whole videos so none is split across days. That's 5 weeks in total. For a different pace, start date or speed, use the planner above.
Week 1Videos 1–23 · 5h 44m
Day 1 · 56m
- 1FREE Data Analyst Bootcamp!!7m
- 2How to Become a Data Analyst in 2023 (Completely FREE!)14m
- 3Installing MySQL and Creating Databases | MySQL for Beginners12m
- 4Select Statement in MySQL | Beginner MySQL Series11m
- 5Where Clause in MySQL | Beginner MySQL Series12m
Day 2 · 55m
- 6Group By + Order By in MySQL | Beginner MySQL Series11m
- 7Having vs Where in MySQL | Beginner MySQL Series4m
- 8Limit + Aliasing in MySQL | MySQL Beginner Series4m
- 9Joins in MySQL | Intermediate MySQL17m
- 10Unions in MySQL | Intermediate MySQL7m
- 11String Functions in MySQL | Intermediate MySQL Series12m
Day 3 · 52m
- 12Case Statements in MySQL | Intermediate MySQL9m
- 13Subqueries in MySQL | Intermediate MySQL11m
- 14Window Functions in MySQL | Intermediate MySQL13m
- 15CTEs in MySQL | Advanced MySQL Series11m
- 16Temp Tables in MySQL | Advanced MySQL Series8m
Day 4 · 27m
- 17Stored Procedures in MySQL | Advanced MySQL Series13m
- 18Triggers and Events in MySQL | Advanced MySQL Series15m
Day 5 · 51m
- 19Data Cleaning in MySQL | Full Project51m
Day 6 · 50m
- 20MySQL Exploratory Data Analysis | Full Project33m
- 21Pivot Tables in Excel | Excel Tutorials for Beginners18m
Day 7 · 53m
- 22Formulas in Excel | Excel Tutorials for Beginners34m
- 23XLOOKUP in Excel | Excel Tutorials for Beginners19m
Week 2Videos 24–42 · 5h 37m
Day 8 · 57m
- 24Conditional Formatting in Excel | Excel Tutorials for Beginners21m
- 25Charts in Excel | Excel Tutorials for Beginners15m
- 26Cleaning Data in Excel | Excel Tutorials for Beginners21m
Day 9 · 58m
- 27Full Project in Excel | Excel Tutorials for Beginners41m
- 28How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners17m
Day 10 · 35m
- 29How to use Calculated Fields and Bins in Tableau | Tableau Tutorials for Beginners6m
- 30How to Create Visualizations in Tableau | Tableau Tutorials for Beginners14m
- 31How to use Joins in Tableau | Tableau Tutorials for Beginners14m
Day 11 · 57m
- 32Full Beginner Project in Tableau | Tableau Tutorials for Beginners44m
- 33How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners13m
Day 12 · 53m
- 34How to use Power Query in Power BI | Microsoft Power BI for Beginners13m
- 35How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners9m
- 36How to use DAX in Power BI | Microsoft Power BI for Beginners16m
- 37How to use Drill Down in Power BI | Microsoft Power BI for Beginners6m
- 38How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners10m
Day 13 · 24m
- 39How to use Bins and Lists in Power BI | Microsoft Power BI for Beginners10m
- 40Popular Visualizations in Power BI | Microsoft Power BI for Beginners14m
Day 14 · 53m
- 41Full Power BI Guided Project | Microsoft Power BI for Beginners43m
- 42Installing Jupyter Notebooks/Anaconda | Python for Beginners10m
Week 3Videos 43–64 · 5h 28m
Day 15 · 58m
- 43Variables in Python | Python for Beginners13m
- 44Data Types in Python | Python for Beginners22m
- 45Comparison, Logical, and Membership Operators in Python | Python for Beginners7m
- 46If Else Statements in Python | Python for Beginners7m
- 47For Loops in Python | Python for Beginners9m
Day 16 · 56m
- 48While Loops in Python | Python for Beginners6m
- 49Functions in Python | Python for Beginners13m
- 50Converting Data Types in Python | Python for Beginners7m
- 51Building a BMI Calculator with Python | Python Projects for Beginners14m
- 52Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners17m
Day 17 · 50m
- 53Inspecting Web Pages with HTML | Web Scraping in Python6m
- 54BeautifulSoup + Requests | Web Scraping in Python7m
- 55Find and Find_All | Web Scraping in Python12m
- 56Scraping Data from a Real Website | Web Scraping in Python25m
Day 18 · 54m
- 57Reading in Files in Pandas | Python Pandas Tutorials19m
- 58Filtering Columns and Rows in Pandas | Python Pandas Tutorials12m
- 59Indexes in Pandas | Python Pandas Tutorials11m
- 60Group By and Aggregate Functions in Pandas | Python Pandas Tutorials11m
Day 19 · 39m
- 61Merging DataFrames in Pandas | Python Pandas Tutorials22m
- 62Creating Visualizations using Pandas Library | Python Pandas Tutorials17m
Day 20 · 39m
- 63Data Cleaning in Pandas | Python Pandas Tutorials39m
Day 21 · 32m
- 64Exploratory Data Analysis in Pandas | Python Pandas Tutorials32m
Week 4Videos 65–80 · 5h 41m
Day 22 · 47m
- 65Amazon Web Scraping Using Python | Data Analyst Portfolio Project47m
Day 23 · 51m
- 66Automating Crypto Website API Pull Using Python | Data Analyst Project51m
Day 24 · 53m
- 67How to Create a Portfolio Website for FREE35m
- 68Create the Perfect Data Analyst Resume | Free Templates!18m
Day 25 · 46m
- 69Solving Easy SQL Interview Questions on Analyst Builder12m
- 70Solving Medium SQL Interview Questions on Analyst Builder12m
- 71Solving HARD SQL Interview Questions on Analyst Builder21m
Day 26 · 53m
- 72Solving VERY HARD SQL Interview Questions on Analyst Builder17m
- 73Azure Account Setup + $200 Free Credits | Azure Fundamentals7m
- 74Blob Storage and Storage Accounts in Azure | Azure Fundamentals16m
- 75How to use Azure SQL Databases | Azure Fundamentals14m
Day 27 · 51m
- 76Getting Started in Azure Data Factory | Azure Fundamentals25m
- 77Getting Started in Azure Synapse Analytics | Azure Fundamentals20m
- 78AWS Setup and UI Walkthough | AWS7m
Day 28 · 39m
- 79S3 Storage in AWS | AWS Essentials15m
- 80Amazon Athena in AWS | AWS Fundamentals25m
Week 5Videos 81–84 · 1h 6m
Day 29 · 58m
- 81AWS Glue DataBrew and Glue | AWS Essentials46m
- 82AWS Quicksight | AWS Essentials12m
Day 30 · 9m
- 83Top 3 Tips on Using LinkedIn to Land a Job7m
- 84How To Download Your Data Analyst Bootcamp Certification (Congrats!!)2m
Tips for finishing
- Build the portfolio projects and publish them; they matter more than the certificate.
- Schedule it tool by tool (SQL, then Excel, then a BI tool, then Python) using the planner's From and To fields.