Ultimate Data Analyst Bootcamp [24 Hours!] for FREE | SQL, Excel, Tableau, Power BI, Python, Azure

I'm sick of the hospitality industry. Starting this today 4/27/2026, wish me luck!

Started this today, 18/3/2026. Wish me luck

I did it. Just completed the video which took weeks. This is my first ever bootcamp on Data Analysis..... Thank you Alex

Here's a tip that might help those of you struggling to complete this excellent training course. For every minute of online training, set aside 3 - 5 minutes to consume, reflect, etc. So, for example, budget 1 hour to get through 15 minutes of content. Do not try to rush through this. EXCELLENT GIFT to the Data Analysis community, Alex. Thank you!

SQL: 1. Installation of MySQL- 00:17:30 2. Beginner Level- 00:24:00 2.1. SELECT Statement- 00:28:25 2.2. OPs Order(PEMDAS)- 00:34:30 2.3. DISTINCT- 00:36:10 2.4. WHERE Clause/Statement- 00:39:25 2.5. Logical Operators in WHERE- 00:44:00 2.6. LIKE Statement- 00:47:25 2.7. GROUP BY- 00:51:45 2.8. ORDER BY- 00:57:40 2.9. HAVING VS WHERE- 01:02:30 2.9. Limit and Aliasing- 01:06:15 3.Intermediate Level- 01:10:00 3.1. Joins- 01:10:20 3.2. Outer Joins- 01:16:35 3.3. Self Join- 01:18:50 3.4. Multiple Tables Join- 01:23:40 3.5. UNION- 01:27:20 3.6. String Functions- 01:34:50 3.7. CASE Statements- 01:46:45 3.8. Subqueries- 01:55:40 3.9. Window Functions- 02:06:30 4.Advanced Level 4.1. CTE- 02:20:05 4.2. Temporary Tables- 02:30:30 4.3. Stored Procedures- 02:38:20 4.4. Triggers- 02:50:50 4.5. Events- 02:59:55 5.PROJECT 1: DATA CLEANING- 03:05:30 6.PROJECT 2: EXPLORATORY DATA ANALYSIS- 03:56:50 EXCEL- 04:30:00 1. Pivot Tables- 04:31:50 2. Basic Formulas (LEN, IF&IFS, COUNT, MIN-MAX, TRIM...)- 04:48:20 3. Formulas ( XLOOKUP's )- 05:22:00 4. Conditional Formatting (Cell Format...)- 05:41:00 5. Charts and Graphs- 06:02:10 6. Data Cleaning Project- 06:17:45 7. Full Excel Project (Bike Sales)- 06:37:35 7.1. Developing Dashboard- 06:50:40 TABLEAU- 07:18:45 1. Installation- 07:19:10 2. Overview and Introduction- 07:23:00 3. Analysis, Charts-07:25:00 4. Bins and Calculated Fields- 07:35:00 5. Visualization (Scatter plots, Density plots)- 07:41:20 6. Joins- 07:56:00 7. Project(Airbnb)- 08:10:30 Happy Learning!!!👍

Started Jan 6 2025. Finished March 11 2025. Thank you, Alex for this bootcamp.

After purchasing many courses and wasting my time & parents money,. i am here starting my journey on 24/04/2026 lets se where this takes me...wish this course prove me wrong and help me get my 1st job

Alex, please, never delete this video. THANK YOU.

05:20:07 XLOOKUP in Excel | Excel Tutorial 05:38:52 Conditional Formatting in Excel | Excel Tutorial 05:59:49 Charts in Excel | Excel Tutorial 06:14:58 Cleaning Data in Excel | Excel Tutorial 06:36:02 Full Project in Excel | Excel Tutorial 07:19 How to Install Tableau and Create First Visualization | Tableau Tutorial 07:33:53 How to use Calculated Fields and Bins in Tableau | Tableau Tutorial 07:40:17 How to Create Visualizations in Tableau | Tableau Tutorial 07:54:20 How to use Joins in Tableau | Tableau Tutorial 08:08:47 Full Beginner Project in Tableau | Tableau Tutorial 08:53:02 How to Install Power BI | Building First Visualization | Microsoft Power BI 09:05:51 How to use Power Query in Power BI | Microsoft Power BI 09:18:57 How to Create and Manage Relationships in Power BI | Microsoft Power BI 09:27:33 How to use DAX in Power BI | Microsoft Power BI 09:43:16 How to use Drill Down in Power BI | Microsoft Power BI 09:49:18 How to use Conditional Formatting in Power BI | Microsoft Power BI 09:59:10 How to use Bins and Lists in Power BI | Microsoft Power BI 10:08:40 Popular Visualizations in Power BI | Microsoft Power BI 10:22:54 Full Power BI Guided Project | Microsoft Power BI 11:05:31 Installing Jupyter Notebooks/Anaconda | Python 11:15:34 Variables in Python | Python 11:28:51 Data Types in Python | Python 11:50:48 Comparison, Logical, and Membership Operators in Python | Python 11:58:03 If Else Statements in Python | Python 12:04:42 For Loops in Python | Python 12:13:59 While Loops in Python | Python 12:19:39 Functions in Python | Python 12:32:22 Converting Data Types in Python | Python 12:38:57 Building a BMI Calculator with Python | Python Project 12:53:19 Building an Automated File Sorter in File Explorer using Python | Python Project 13:10:10 Inspecting Web Pages with HTML | Web Scraping in Python 13:16:03 BeautifulSoup + Requests | Web Scraping in Python 13:23:01 Find and Find_All | Web Scraping in Python 13:35:11 Scraping Data from a Real Website | Web Scraping in Python 14:00:33 Reading in Files in Pandas | Python Pandas Tutorials 14:19:49 Filtering Columns and Rows in Pandas | Python Pandas Tutorials 14:31:37 Indexes in Pandas | Python Pandas Tutorials 14:42:59 Group By and Aggregate Functions in Pandas | Python Pandas Tutorials 14:54:04 Merging DataFrames in Pandas | Python Pandas Tutorials 15:16:13 Creating Visualizations using Pandas Library | Python Pandas Tutorials 15:33:02 Data Cleaning in Pandas | Python Pandas Tutorials 16:11:39 Exploratory Data Analysis in Pandas | Python Pandas Tutorials 16:43:52 Amazon Web Scraping Using Python | Data Analyst Portfolio Project 17:31:03 Automating Crypto Website API Pull Using Python | Data Analyst ProjectP 18:22:13 How to Create a Portfolio Website 18:57:39 Create the Perfect Data Analyst Resume 19:15:16 Top 3 Tips on Using LinkedIn to Land a Job 19:22:05 Get Your Data Analyst Bootcamp Certification

0:00 Introductions 17:30 MySQL 4:30:00 Excel 7:18:00 Tableau 8:54:00 Power BI 11:06:30 Python 14:01:30 Pandas 16:45:00 Python Projects 18:23:30 Building a Portfolio Website 18:59:00 Creating a Resume 19:16:30 Practicing for Technical Interviews 20:19:43 Azure 21:39:50 AWS 23:24:00 How to use LinkedIn to Land a Job