Become a data analyst by following along with this massive course. You will learn the core topics that data analysts need to know. And along the way, you will build plenty of projects to gain hands-on experience. ✏️ Bootcamp developed by @AlexTheAnalyst 🔗 Analyst Builder: https://www.analystbuilder.com/ 💻 Access the datasets used here: https://github.com/AlexTheAnalyst ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp ⭐️ Chapters ⭐️ 00:00:00 Introduction 00:01:10 How to Become a Data Analyst in 2023 (Completely FREE!) 00:15:08 SQL Basics Tutorial | Installing SQL Server Management Studio and Create Tables 00:24:44 SQL Basics Tutorial | Select + From Statements 00:30:57 SQL Basics Tutorial | Where Statement 00:38:54 SQL Basics Tutorial | Group By + Order By Statements 00:47:03 Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases 01:02:55 Intermediate SQL Tutorial | Unions | Union Operator 01:08:19 Intermediate SQL Tutorial | Case Statement | Use Cases 01:15:44 Intermediate SQL Tutorial | Having Clause 01:19:15 Intermediate SQL Tutorial | Updating/Deleting Data 01:23:51 Intermediate SQL Tutorial | Aliasing 01:30:02 Intermediate SQL Tutorial | Partition By 01:34:16 Advanced SQL Tutorial | CTE (Common Table Expression) 01:37:59 Advanced SQL Tutorial | Temp Tables 01:48:18 Advanced SQL Tutorial | String Functions + Use Cases 02:02:06 Advanced SQL Tutorial | Stored Procedures + Use Cases 02:08:20 Advanced SQL Tutorial | Subqueries 02:16:57 Data Analyst Portfolio Project | SQL Data Exploration 03:34:01 Data Analyst Portfolio Project | Data Cleaning in SQL 04:28:41 Pivot Tables in Excel | Excel Tutorial 04:46:15 Formulas in Excel | Excel Tutorial 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:16:49 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 Project 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
ADVERTISEMENT
nice
This video helped me immensely in an interview for a DA role and I ended up receiving an offer! Thanks so much for this amazing resource, and good luck to any other aspiring data analysts out there :)
1:04:39 Day 1 1:31:15 Day 2
It was a slow start for me due to having a full time work. But I really dedicated some time, even if it's just 30 minutes of my time, to study. Already in the final project of Power BI. Can't wait to get to the data scraping section. Really excited about it. Tiny progress is still progress. Be consistent and patient with your progress.
Amen
If importing the data is giving you a hard time using SQL Server 22, download the Developer version and not the Express. After which you should download Microsoft SQL Server 2012 Native Client setup (about 4mb).
Really appreciate the insights in this video.
march 2 day 1 :: installed the servers and ran few basic commands march 3 day 2 :: SQL Basics Tutorial | Select + From Statements 00:30:57 SQL Basics Tutorial | Where Statement 00:38:54 SQL Basics Tutorial | Group By + Order By Statements
This video just turned me into the person people ask for help. Terrifying.
19 day challenge start day1: 1:00:00 day 2: 2:00:00
My Learning Progress 📈 Day 1 - 13/01/2026 - 47:01 Day 2 - 14/01/2026 - 01:30:01 Day 3 - 15/01/2026 - 02:19:01 Day 4 - 16/01/2026 - 02:40:22 Day 5 - 21/01/2026 - 03:00:06 Day 6 - 22/01/2026 - 03:34:06 Day 7 - 23/01/2026 - 03:56:25 Day 8 - 28/01/2026 - 04:33:25 Day 9 - 29/01/2026 - 05:10:26 Day 10 - 30/01/2026 - 06:37:16 Day 11 - 03/02/2026 - 07:16:34 Day 12 - 04/02/2026 - 09:19:31 Day 13 - 05/02/2026 - 09:50:30 Day 14 - 06/02/2026 - 10:24:43 Day 15 - 09/02/2026 - 10:51:45 Day 16 - 11/02/2026 - 11:05:39 Day 17 - 16/02/2026 - 11:39:25 Day 18 - 17/02/2026 - 12:32:34 Day 19 - 27/02/2026 - 14:12:06 Day 20 - 03/03/2026 - 15:32:45 Day 21 - 16/03/2026 - 17:32:04 Day 22 - 17/03/2026 - 18:08:16 Day 23 - 20/03/2026 - COMPLETED 🥳
I’m genuinely excited to learn more from you!
This was masterfully explained, phenomenal job!
This video has completely transformed my understanding!
1:14:20 The Office fans definitely smiled when Toby got a 0.000001% raise. Extra like for making me smile
Day 1 starting a new career
22-10-2025, lets do it
breakdown of video : 1) 17:54 to 4:28:27 SQL 2) 4:29:22 to 7:16:34 EXCEL 3) 7:18:15 to 8:08:34 TABLEAU part 1 4) 8:10:01 to 8:52:48 TABLEAU part 2 5) 8:54:47 to 11:05:03 POWER BI part 1 and 2 after that PANDAS and Project work.
Completed upto 3:33:56 today
Topic Start Time Introduction & Data Analyst Career Roadmap [00:00] Part 1: Core Data Analyst Skills (SQL, BI, Excel, Python, Cloud) [01:59] Part 2: Build Projects & Portfolio [07:09] Part 3: Build a Data Analyst Resume [08:39] Part 4: Apply for Jobs (Recruiters) [09:50] Timeline: How Long It Takes to Get Hired [11:59] SQL Basics: Creating Tables & Inserting Data [15:24] SQL Basics: SELECT & FROM Statements [24:43] SQL Basics: WHERE Statement [31:01] SQL Basics: GROUP BY & ORDER BY [38:56] Intermediate SQL: JOINs (Inner, Outer, Left, Right, Full) [47:18] Intermediate SQL: UNIONs [01:02:58] Intermediate SQL: CASE Statements [01:08:24] Intermediate SQL: HAVING Clause [01:15:50] Intermediate SQL: Updating and Deleting Data [01:19:20] Intermediate SQL: Aliasing [01:23:52] Intermediate SQL: PARTITION BY [01:30:13] Advanced SQL: CTEs (Common Table Expressions) [01:34:20] Advanced SQL: Temp Tables [01:38:01] Advanced SQL: String Functions (TRIM, REPLACE, SUBSTRING) [01:48:17] Advanced SQL: Stored Procedures [02:02:12] Advanced SQL: Subqueries [02:08:20] Portfolio Project: COVID Data Exploration (SQL) [02:16:57] Excel: Pivot Tables [04:30:00] Excel: Formulas (IF, LEN, SUM, COUNT) [04:46:16] Excel: XLOOKUP vs VLOOKUP [05:20:17] Excel: Conditional Formatting [05:39:03] Excel: Charts [06:00:00] Excel: Clean Data [06:15:03] Excel Project: Dashboard Creation [06:36:12] Tableau: Introduction & First Visualization [07:16:59] Tableau: Bins & Calculated Fields [07:33:53] Tableau: Visualizations (Scatter, Density Map) [07:40:27] Tableau: JOINs [07:54:20] Tableau Project: Dashboard Creation [08:08:52] Power BI: Introduction & First Visualization [08:53:10] Power BI: Power Query (Data Transformation) [09:05:56] Power BI: Relationships (Modeling) [09:19:02] Power BI: DAX (Measures & Calculated Columns) [09:27:37] Power BI: Bins & Lists [09:59:15] Power BI: Visualizations [10:08:45] Power BI Project: Final Dashboard [10:22:59] Python: Environment Setup [11:05:34] Python: Variables [11:15:34] Python: Data Types (String, List, Tuple, Dict, Set) [11:28:57] Python: Operators (Comparison, Logical, Membership) [11:50:54] Python: IF/ELIF/ELSE Statements [11:58:03] Python: FOR Loops & Nested Loops [12:04:46] Python: WHILE Loops & Break/Continue [12:13:59] Python: Functions [12:19:43] Python: BMI Calculator Project [12:39:03] Python: Automatic File Sorter Project [12:53:20] Web Scraping: HTML Basics & Inspection [13:10:48] Web Scraping: Beautiful Soup & Requests [13:16:32] Web Scraping: Scrape Table to Pandas DataFrame [13:35:10] Pandas: Reading Files (CSV, Excel, JSON) [14:00:36] Pandas: Filtering & Ordering Data [14:19:54] Pandas: Indexing (LOc, ILoc, Multi-Index) [14:31:39] Pandas: Group By & Aggregation [14:43:05] Pandas: Merge, Join & Concatenate [14:54:20] Pandas: Visualizations [15:16:51] Pandas: Data Cleaning [15:33:05] Pandas: Exploratory Data Analysis (EDA) [16:11:39] Portfolio Project: Amazon Web Scraper (Python) [16:44:05]