2026 FREE Data Analyst Bootcamp [24 Hours+] for FREE | SQL, Excel, Python, Power BI, GitHub, AWS

Wow! Thank you for this. Will start ASAP

I completed the entire course previousy I watched 24+ hours video in the end he launched this adding data fundamentals + R + databricks which are very useful. Thank you for your contribution to aspiring data analysts. TQ ❤

Its been 7days into the course. 7hrs in. I'm loving it.

Thank you so much Alex. You keep me into track of data analyst. Thank you. I will come back to inform you guys when it land me a lucrative job

Started this course thinking I’d probably leave it halfway like most courses I do… but somehow this one completely hooked me.I’m 7 days in and already at 3:37:40 of the SQL section, and I genuinely haven’t been bored once. The explanations, pacing, and teaching style are just that good. Now I’m finally moving on to the projects, which is something I usually never reach 😭If you’re wondering whether this course is worth starting, it definitely is.

Thank you so much Alex You are a God sent 🌹

This is amazing, Thank you Alex.

Course Introduction & Overview 0:00 - Welcome & What's New in the 2026 Bootcamp 3:36 - Roadmap to Learning Data Analyst Skills Career & Job Application Strategies 7:18 - Building Projects and Your Portfolio 8:50 - Crafting a Data Analyst Resume 10:02 - Job Application Tips & Working with Recruiters 12:09 - Realistic Timelines to Land a Job Module 1: Data Fundamentals 15:05 - What is Data? (Definition & Real-World Examples) 18:09 - Structured vs. Unstructured Data 21:27 - KPIs and Metrics Explained 26:51 - Introduction to Data Types 31:25 - File Types and Formats (CSV, XLSX, JSON, Parquet) 37:28 - Data Collection & ETL Pipelines 41:54 - Data Cleaning Cycle Module 2: MySQL (Beginner to Advanced) 48:34 - Installing MySQL and Setting up the Database 1:00:36 - The SELECT Statement & Math Operations 1:11:36 - Filtering Data with the WHERE Clause & LIKE Operator 1:24:02 - GROUP BY and ORDER BY Statements 1:34:48 - HAVING vs. WHERE Clauses 1:38:33 - LIMIT Clause and Aliasing 1:42:30 - Deep Dive into SQL Joins (Inner, Left, Right, Self) 1:59:40 - Combining Results with UNIONS 2:07:01 - Essential SQL String Functions 2:18:54 - Conditional Logic with CASE Statements 2:27:34 - Introduction to SQL Subqueries 2:38:47 - Window Functions (ROW_NUMBER, RANK, DENSE_RANK) 2:52:16 - Common Table Expressions (CTEs) 3:02:46 - Working with Temporary Tables 3:10:32 - Creating Stored Procedures 3:23:08 - Automating with Triggers and Events 3:37:50 - Project 1: SQL Data Cleaning Walkthrough 4:29:00 - Project 2: Exploratory Data Analysis (EDA) in SQL Module 3: Microsoft Excel 5:01:44 - Analyzing Data with Pivot Tables 5:18:51 - Master Formulas (IF, IFS, SUMIFS, COUNTIFS, etc.) 5:52:45 - VLOOKUP vs. XLOOKUP Deep Dive 6:11:31 - Visualizing Patterns with Conditional Formatting 6:32:30 - Creating and Customizing Charts 6:47:40 - Data Cleaning Techniques in Excel 7:08:43 - Project 3: Building an Interactive Excel Dashboard Module 4: Tableau 7:49:33 - Tableau UI & Creating Your First Visualization 8:06:37 - Bins and Calculated Fields 8:13:01 - Advanced Charts (Scatter Plots & Density Maps) 8:27:05 - Managing Data Connections and Joins 8:41:33 - Project 4: Airbnb Full Dashboard Project Module 5: Power BI 9:25:51 - Getting Started & Introduction to Power BI Desktop 9:37:52 - Transforming Data with Power Query 9:51:17 - Building Data Models and Relationships 9:59:52 - Introduction to DAX Formulas (Sum vs. SumX) 10:15:35 - Creating Hierarchies & Slicing Data (Drill Down) 10:21:37 - Conditional Formatting in Reports 10:31:30 - Grouping Data with Bins and Lists 10:41:01 - Dashboard Design & Visualizations Gallery 11:05:15 - Project 5: Data Professional Survey Dashboard Module 6: Python 11:37:52 - Setting Up Anaconda and Jupyter Notebooks 11:47:54 - Variables and Naming Conventions 12:01:11 - Python Data Types (Lists, Tuples, Sets, Dictionaries) 12:23:09 - Comparison, Logical, & Membership Operators 12:30:23 - Conditional Logic with If/Else Statements 12:37:03 - Iterating with For Loops 12:46:20 - Controlling Logic with While Loops 12:51:59 - Writing Custom Functions & Passing Arguments 13:04:42 - Converting Data Types (Type Casting) 13:11:18 - Project 6: Building a BMI Calculator 13:25:40 - Project 7: Creating an Automatic File Sorter Module 7: Python Web Scraping & Pandas 13:42:31 - HTML Basics for Web Scraping 13:48:24 - Introduction to BeautifulSoup and Requests Libraries 13:55:22 - Using Find and Find_All to Extract Data 14:07:32 - Project 8: Scraping Wikipedia Data into Pandas 14:32:54 - Reading and Writing Files in Pandas (CSV, Excel, JSON) 14:52:10 - Filtering and Sorting Pandas DataFrames 15:03:58 - Indexing and Multi-Indexing Data 15:15:20 - Grouping and Aggregating Data in Pandas 15:26:25 - Combining DataFrames (Merge, Join, Concat) 15:33:58 - Creating Plots directly in Pandas 16:05:23 - Real-World Data Cleaning with Pandas 16:44:00 - Exploratory Data Analysis (EDA) Techniques 17:16:13 - Project 9: Building an Amazon Price Tracker Scraper Module 8: Cloud Platforms (Azure, AWS, Databricks) 18:03:26 - Project 10: Automating Crypto API Data Ingestion 18:54:40 - Building and Hosting Your Portfolio Website on GitHub 19:30:08 - Resume Walkthrough & Review Tips 19:47:45 - Solving Easy SQL Technical Interview Questions 20:00:02 - Solving Medium SQL Technical Interview Questions 20:12:25 - Solving Hard SQL Technical Interview Questions 20:33:51 - Solving Very Hard SQL Technical Interview Questions 20:50:54 - Introduction to Microsoft Azure Cloud Services 20:57:30 - Managing Azure Blob Storage & Data Access 21:13:11 - Setting up SQL Databases in Azure Cloud 21:26:57 - Creating Pipelines with Azure Data Factory 21:51:27 - All-in-One Analytics with Azure Synapse 22:11:04 - Getting Started with AWS Cloud Platform 22:18:24 - Storing Data in AWS S3 Buckets 22:33:02 - Serverless Querying using Amazon Athena 22:57:35 - Data Engineering with AWS Glue and Data Brew 23:43:05 - Cloud Data Visualization with AWS QuickSight 23:55:03 - Introduction to the Data

This was exactly what I needed, thanks!

I am at a horrible place right now in my personal and professional life and also my deteriorating health (due to my lifestyle) at this point adds to the pain , I know some of you might feel the same and I know we can fight back . I promise I'm going to fight back. I am starting this slow I target around 2-3 hrs of course content daily . Please keep replying to me and ask me how is it going so I feel accountable and also you can reply to this comment about your own progress that will help me get back at it if i stop. I don't trust myself at all but I wanna build that trust one step at a time

Thanks Alex for this bootcamp, it's indeed loaded

Is this a compilation of the data analyst bootcamp playlist? I prefer the playlist so I would not feel overwhelmed

Introduction: (0:00) Data Fundamentals: (15:00) MySQL: (48:33) Excel: (5:01:47) Tableau: (7:49:33) Power BI: (9:25:51) Python: (11:37:51) Pandas: (14:32:33) Building a Portfolio Website: (18:52:39) Building a Data Analyst Resume: (19:30:07) Practicing for Data Analyst Interviews: (19:47:45) Azure: (20:50:53) AWS: (22:11:04) Databricks: (23:55:03) R: (26:40:14) Using LinkedIn to Find a Job: (28:32:37)

Started my journey today..and I Will finish successfully

Wishing everyone all the luck in the world🙌❤️

Guys I'm here to tell you that you can do it. For four years I spent many nights studying DA tools and concepts. I think what makes the difference is when you start introducing yourself as a Data Analyst in the interviews, and start working on side projects in your current role. Even if your current manager doesn't need you to analyze data, you can do it and then you willl have something to talk about during the interviews.

Great respect to the people who make long videos to teach others valuable skills for finding a job, and then provide translations into all languages. You are truly angels, incredibly humane. ❤❤❤❤

about to complete SQL part, still super excited though...

:00 Introduction 15:00 Data Fundamentals 48:33 MySQL 5:01:47 Excel 7:49:33 Tableau 9:25:51 Power BI 11:37:51 Python 14:32:33 Pandas 18:52:39 Building a Portfolio Website 19:30:07 Building a Data Analyst Resume 19:47:45 Practicing for Data Analyst Interviews 20:50:53 Azure 22:11:04 AWS 23:55:03 Databricks 26:40:14 R 28:32:37 Using LinkedIn to Find a Job

Thank you so much Alex, I hope you know how much you're contributing positively to the society!