Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)

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

⭐️ 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

[AlexTheAnalyst]

So happy to contribute to the Open Source Community! Good luck to all the aspiring Analysts out there! ❤ Thanks FreeCodeCamp!

[turmoilstabilizer]

Alex, I hope you know that your commitments to the community of aspiring data analysts are treasured.

[mrluis]

Starting the year with 100% quality content, love you guys!!!!

[sege]

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!!!!

[rajdeepsenapati]

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❤️

[EdsonNascimentoEN]

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.

[dreamofyesterday]

Alex is the GOAT when it comes to Data Analysis. Thank you both Alex & freeCodeCamp for this massive bootcamp!

[kenway]

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!

[kinnaribhalerao]

Alex is one of the best in this domain! His YT channel is also gold! Thank you for this boot camp!

[aarondas]

I literally just started doing the bootcamp from Alex's playlist on his own channel. It's so funny how the entire thing is now on this channel

[josephoke]

This is amazing and really helpful. With this Bootcamp am super-packed for my journey into Data Analytics. Thank you so much, Alex the Analyst.

[jamesmiths]

Great to see you here. Thank so much for your valuable contribution.

[Isasseguya]

Thank you Alex & FCC starting out today as a complete beginner. Here to prove it's possible to become a data analyst under 6 months

[idontknowexcel]

Using Microsoft's version of SQL!! THANK YOU!! In Healthcare Finance, that is all that I see and everyone on YouTube seems to teach MySQL or something else. I know they are basically the same. But.... when you are first starting, it is nice to have something familiar.

[Friend_]

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.

[RohitKumar-gxzx]

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

[augustinetoniadavidson]

Just started, and I'm already enjoying every
Alex, you're the
Thanks so much.

[kandoras.guzman]

Amazing!

Please give us a Data Engineering Bootcamp! <3

[hazielgonzalez]

Feels so right to see you two making a collab on this topic. Congrats to both!

[ProductGrower]

When I stopped watching tutorials and started doing projects is when I started to learn. It's the only consistent zone of proximal development.