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
So happy to contribute to the Open Source Community! Good luck to all the aspiring Analysts out there! ❤ Thanks FreeCodeCamp!
My last video before bed.
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. peace out.
Was just about to buy a course on SQL on udemy, now this drops!! My year is made. Thanks so much. Fellow aspiring Data analysts let's cook!!!!
Alex, I hope you know that your commitments to the community of aspiring data analysts are treasured.
When I stopped watching tutorials and started doing projects is when I started to learn. It's the only consistent zone of proximal development.
I can't believe that we live in this era wherein an entire bootcamp dedicated to data analysis is uploaded free of cost for the general public -> unbelievable power of educational tech joining hands with such immensely progressive people. This channel feels quite overwhelming at times due to the incredible wealth of knowledge it offers! I hope I just don't keep this course only in my saved playlist without actually starting it!
For people who cannot load the Covid Data properly in Excel (Data does not separate). You want to open excel first as blank document. Go to data menu at top. Click Load data from CSV. Select separator as a comma and check that it contains headers. Data should be laoded properly. Make sure to save as compatible file type.
4:18:52 Using Common Table Expressions (CTE) to create temporary tables for querying 4:23:08 The focus was on cleaning and standardizing the data. 4:25:09 Data cleaning techniques for a portfolio project 4:28:59 Covering essential data analyst skills and tools 4:30:29 Using bike store sales dataset for demonstration. 4:34:07 Demonstrating drill downs in Tableau for country and state data 4:35:53 Analyzing bike sales revenue by country and state 4:40:03 Creating a calculated field in Tableau to ensure accurate numbers 4:41:58 Understanding and using additional columns in data analysis 4:45:52 Understanding pivot tables in Excel 4:47:32 Streamlined tutorial with useful Excel formulas 4:51:03 IF function with multiple conditions 4:52:58 Using IF function in Excel for logical testing 4:56:53 Left and right functions extract specified number of characters from a text string. 4:58:38 Extracting specific date components from a date structure. 5:02:26 Converting data to text efficiently 5:04:15 Utilize concatenate to join text strings. 5:08:15 Substituting values using Python's substitute function 5:10:12 Using replace function in SQL 5:14:14 Using count, countif, and countifs functions in Excel 5:16:23 Functions for counting and calculating date ranges 5:20:03 XLOOKUP is a new feature in Excel to replace VLOOKUP. 5:21:36 Using VLOOKUP function for data matching 5:25:15 Limitation of multiple rows functionality 5:27:22 Explaining the match mode options 5:31:04 Demonstrating search techniques in data analysis
Alex is one of the best in this domain! His YT channel is also gold! Thank you for this boot camp!
Just did a comparison. Whole data analyst Bootcamp playlist in Alex's YouTube chanel in 17 hours and this video is 19 hours. Well appreciated 🎉
For the first portfolio project I was facing many issues importing data with the Sql 2022 edition, so to fix it uninstall Sql 2022 and install the older version Sql 2019 which Alex is using in the above tutorial
I'm currently a 4th year student of Accounting and Finance, working part time in accounting but wanting to become a Data Analyst. I'm starting with this course!
Amazing! Please give us a Data Engineering Bootcamp! <3
DAAAAAMNNN Starting the year with 100% quality content, love you guys!!!!
This channel is so overwhelming like the amount of things and knowledge they give out for free is unmatchable. I couldn't believe i have so many times seen alex recommend fcc but today he came here ig it honour for him also. Thank you fcc and Alex❤️
A long but very important path to go. Thanks Alex I'll make this commitment taking on step a day. You are a true coach.
Thank you, Alex and FCC for this Bootcamp! I started this 3 days ago and just completed the SQL Basics as a complete beginner. I hope to post my updates here as I go through this, so I have this comment to be accountable of.
As an entry level data analyst, I want to say thank you for putting this together here.
22-10-2025, lets do it