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‬
🔗 Analyst Builder: www.analystbuilder.com/
💻 Access the datasets used here: github.com/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!

[@abdopower5913]

Thx Alex we appreciate your efforts, btw I like your channel 😊

[@Novok242]

Amazing. Thanks a Ton.

[@FredericGariepy]

Thank you so much!! Your efforts bring real change to the world!

[@yakubumoshood7776]

@AlexTheAnalyst, I just subscribed to your channel. Thank you.

[@brendansully12]

This looks great, thank you so much for making it! I'll bee seeing you a lot more now that I'm subscribed to your youtube channel

[@sege8197]

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

[@okorafororji]

You certainly are a Nigerian, "lets cook!" lmao

[@Isasseguya]

let's go #Day one

[@ehiztv6394]

Haha na we dey here😂😂​@@okorafororji

[@azeezwhales7134]

@@okorafororji😂😂

[@KevinDChanx]

How did it go

[@turmoilstabilizer9054]

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

[@AlexTheAnalyst]

Really appreciate it!

[@lsr4243]

W2w 😢😢w

[@lavatr8322]

But did you get any entry level job

[@HaroutBlack]

Jesus is the only way to healing, restoration and salvation to all souls. Please turn to him and he will change your life, depression into delight, soul heading from hell to heaven all because of what he did on the cross “Whoever calls upon the name of the Lord shall be saved” Romans 10:13

[@jamesmiths72]

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

[@mrluis96100]

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

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

[@Friend_2162]

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.

[@mariaritabarnaski3331]

You are an angel!!

[@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.

[@ProductGrower]

Offer to build a report/automation for free to get experience. Find a small business locally that you know is using Excel or doing manual data entry. Once you do the first report you will know if the industry, business and underlying software are worth continuing to develop on.

[@cloealbertodesouza6038]

For sure! Watching courses without practice is only entertainment.

[@janaka5423]

How's this one? Is he doing projects or is he doing only the explanations?

[@anushkasaxena6742]

hey could you please explain i've created a view but it isn't showing

[@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.

[@aarondas6543]

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

[@dreamofyesterday]

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

[@augustinetoniadavidson5700]

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

[@listless0]

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!

[@azraelfirstofhisname8695]

Same I’m about to graduate good luck we got this

[@kenway346]

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!

[@olecram8217]

O que adianta se não tem trampo para todos 😂😂😂

[@kandoras.guzman6705]

Amazing! Please give us a Data Engineering Bootcamp!

[@brendansully12]

This is just what I needed! Thank you so much!

[@josephoke7670]

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.

[@funvideoscorner]

Just started watching it now. It's amazing

[@idontknowexcel]

Using Microsoft's version of SQL!! THANK YOU!! In Healthcare Finance, that is all that I see and everyone on KZbin 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.

[@prasopchokrodsiri2265]

38:56 18/05 Last time we left with IN statement -> Tomorrow start with GROUP BY. 1:08:20 19/05 We already explored GROUP BY, ORDER BY JOIN and UNION -> Tomorrow, start with case statement. 1:34:15 20/05 I have learned updating, deleting, AS and PARTITION BY (very powerful cluase) -> Tomorrow start with common table expression. 2:02:05 21/05 Common Table Expression, Session, Temp Table, Clean data -> TMW, stored procedure and subqueries. 2:20:00 22/05 I have learned stored procedure, ALTER stored procedure(including parameters) and subquery -> we will do a project involving data exploration with COVID19 data.

[@boladeemmanuel2671]

dont stop bro

[@user-cm1ps2xb6l]

how is it going bro?

[@prasopchokrodsiri2265]

Thank you for all of you guy to remind me this. I have faded out because I got an internship as data engineer. Forturnately, this course provide me with basic SQL and tableau so it help me a lot.

[@mellowbeatz93]

THE PERFECT COURSE!!! THANK YOU!!

[@maxgalson7362]

Love this course. Very easy to follow and the lessons can be learned very quickly.

[@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

[@Vaibhav13609]

My last video before bed.

[@aftab9539]

You won't be sleeping i guess

[@BiP00]

It’s gonna take a while mate

[@vadcrch]

You will sleep in tomorrow night😂

[@AlexandraTijuana]

😁nice

[@mayanktiwari5069]

You goono sleep day after tomorrow.... 😂

[@rodrigoivanduarte581]

Thank you very much, just these days I was looking for something like this, greetings from Buenos Aires, Argentina.

[@prashanthchandroth8108]

This is really amazing complete tutorial for a Data Analysis

[@fededeluca]

My first video of the morning. You changed our lives, thank you!

[@karishmayadav1391]

Thank you so much for the video. You're doing a great job. ❤ God bless you ☀️

[@RohitKumar-gx5zx]

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

[@islammuradov1]

Thanks bro❤

[@waltervivancopalacios3993]

Consulta, como lo puedo traducir al español, o aunque sea el texto, te agraceria

[@xeniblack]

​@@waltervivancopalacios3993you can turn on captions then press the cogwheel ⚙️ in the upper right corner on the video and press, auto translate then pick your language

[@rajanlayugan3433]

I just finished the SQL Tutorial - Full Database Course for Beginners today... time to watch a new video :)

[@asifsiddiqui7522]

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

[@user-fv7us5el2n]

this needs to be at the top, i was going insane at how many things that went wrong

[@zahidhussainzd5576]

Thank you sr. This is like a heaven camp. God bless you. Blessings from ITALY.

[@kinnaribhalerao8112]

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

[@AlexTheAnalyst]

So honored to hear that! Thank you!

[@CarlosRamirezTrades]

Awesomeness

[@faisalafzali9330]

Well done bro thanks from you dear Alex my search for become a data analyst is finished here❤❤

[@teedow8130]

This is greatt!! Can't wait for a data science bootcamp😭💫🔥

[@hazielgonzalez8509]

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

[@trendmav]

Alex, You are a very good teacher!! You just make it look easy..Thanks!..from a upcoming analyst!!

[@Troublesomeadam]

This is so cool! I'm a brand new data analyst and I've been learning a lot on my own. I'm totally going to make time in my day to go through this!

[@kenchuks6158]

Love to hear your review on this video and how it truly compares to the real world. I'm trying to get into the field and would love to hear how it mimics your environment, if at all. Thanks!

[@mint9121]

Amazing course, thank you!

[@oscooro]

Thanks Alex you are a great instructor, cut to the chase syle that i liked.

[@joyoluchi7226]

Thank you Alex for this beautiful courses , I am in Awe

[@ANISHKUMAR-ku1jl]

this guy is awesome, the way he makes everything understand is just so smooth I loved it and best for beginers

[@gokhanmtly]

In Tableau section who have problem with price, you can change price column as numeric in excel to solve. Also for map visualization issue, check the map -> edit location. it may be defaulting to your country.

[@user-wi1vn6ie9y]

I must really thank Mr Alex on behalf of all others here. This bootcamp came in just at a very crucial time. I know like many others who might have been doing self paced learning sifting through many materials gies with a lot of grit and determination. With this fine package, it makes the journey all the more easier. Once qm done on the learning ill be sharing working on some very crucial portfolios i have already earmarked for myself as crucial data analysis projects. Hope to share with you soon. Thanks 🎉

[@sbastug2906]

Thank you for your heart and thank you for your course

[@AK-ox3mv]

Just did a comparison. Whole data analyst Bootcamp playlist in Alex's KZbin chanel in 17 hours and this video is 19 hours. Well appreciated 🎉

[@abubakaribrahim6843]

Which one do you recommend? Also, does this come with a certificate of completion as well?

[@boladeemmanuel2671]

@@abubakaribrahim6843 yes i think it does

[@kaushikhs1035]

Woah.!!! Finally the MOST awaited video on FCC. This Alex is a next level DA.

[@shimkumordzie4797]

I'm a project manager interested in using this course to gain insights into customer behavior. This knowledge will help us leverage the data we collect to create truly engaging products and keep users hooked. As the book" Limitless" by Kwik puts it, the best way to test your understanding of a concept is to teach it. Thanks

[@GamerGuygameing]

Thank you so much Alex for valuable information

[@dhenryg4796]

This is the path I was looking for. Thank you freecodecamp👍

[@Anmol.singh.10]

@AlexTheAnalyst Thanks for the course and providing so much content for free. Jan 2024 Completed Excel ✅️

[@PawanKumarSG]

Hi thank you much for this knowledge sharing us. ❤❤

[@ChrisDIY.Project.SPXtraderIT]

WOW Great way to jump start new skills for 2024 ... Thank you so much . I will work on this every day until I Got it all down .

[@Racio00]

This is what ive been looking for!!!❤

[@alisher.m]

Exactly what I needed

[@itmannlearn]

thanks for this.most appreciated

[@slapto]

Love this Alex! Had to do some tinkering around because I have a Mac and using MySQL but once I figured out how to input the data, following along is pretty flawless

[@justpassingbylearning]

How’d you figure out a way around this?

[@sahithikamutla5977]

@@justpassingbylearning I had the same problem how did you guys figure it out

[@slapto]

@@justpassingbylearning on Alex's channel, he has instructions on how to download mysql, so I just followed that process and used the data set he uses in this video

[@jenni8075]

THANK YOU FOR COMMENTING, I WAS ALSO PONDERING IF I SHOULD WATCH BECAUSE I HAVE MYSQL WIH MAC =) I WAS JUST ABOUT TO JUST LOAD THE DATA AND FIGURE IT OUT.

[@Dongnanjie]

Absolutely amazing.

[@ricarkad7373]

unbelievable work!

[@elliscaicedo9045]

i am waiting for SOC analyst Bootcamp someday :) thanks for your efforts

[@guitarman813]

Well, my new Junior Data Analyst role starts tomorrow. What great timing for such a course thus! 😀

[@kogureyoeh]

awesome! I wonder if you already have the skills prior on getting the junior data analyst position?

[@stevesmith0624]

thanks so much, this was really helpful!!

[@de_seer]

Thank you immensely!

[@ahmedbadal3795]

this is so awesome as soon i started teaching my self about data analytics week ago freecodecamp posts 19 hours course now i have to forget other platforms

[@user-wi1vn6ie9y]

I must really thank Mr Alex on behalf of all others here. This bootcamp came in just at a very crucial time. I know like many others who might have been doing self paced learning sifting through many materials gies with a lot of grit and determination. With this fine package, it makes the journey all the more easier. Once qm done on the learning ill be sharing working on some very crucial portfolios i have already earmarked for myself as crucial data analysis projects. Hope to share with you soon. Thanks

[@lindavega8859]

Alex this is extremely helpful! Many thanks for your hard work :)

[@Alloo4]

This is a great story. Well delivered

[@pm_96]

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.

[@pm_96]

21/01/2024 - Just Completed SQL Intermediate Tutorials and going to start Advanced Tutorials right away 😻

[@pm_96]

22/01/2024 - Completed Advanced SQL Tutorial today 😸

[@frhadlizad2013]

​@@pm_96we wait for updates

[@abdulmoiz4773]

@@pm_96 very good man what is current situation.

[@RickS-ct7yz]

@@pm_96how is it going ?

[@user-un7tv7hm8l]

Thanks for information

[@nika8cz]

02:16:57 - if you struggle at following with first project and cannot import excel data into destination SQL SERVER NATIVE CLIENT 11.0 - it's because microsoft updated it into - MICROSOFT OLE DB PROVIDER FOR SQL SERVER

[@republicofazerbaijan6671]

yeah, this information is incredibly valuable to young, thks🙏🏻

[@atthebeach-r7t]

Thank you so much Alex

[@brosjay2131]

This is massive. I was already learning data analysis to become an analyst and your video popped up in KZbin suggestion. Thanks so much Alex. I'm hoping to be done with this entire video in about 3 weeks

[@denisbhadani8199]

so what's the review of this course

[@brosjay2131]

I'm still not done. But if you want a review, you can continue looking at the comments. Many people have left reviews. You could also take the course to get your review since the course is free😊😊

[@firerock77730]

Thanks for Alex and Freecodecamp

[@edikanebu-nkamado5063]

Wow. Amazing!

[@komgyamfieric]

Thank you, Alex❤

[@user-pt8he5lw5h]

This is pure gold😊

[@isaac80745]

I've taken a couple of courses recommended by alex and I noticed he came a long way.

[@robertojimenez111]

This video was so good and helpful.

[@thanhvanle3024]

The only comment section that I would love to part of, thank you, Alex, for making this course available to everyone!

[@aspectoflife]

massive contributions, thanks

[@kamilkarczmarczyk9445]

What a nice surprise. So glad there is a smth like this kind of boot camp for free. To all aspiring data analysts/bi devs - there is no sense to pay for any resources at beginning, do not get catch for dreams sellers, data vizzards or other data selfsuperhero

[@mindsetgoal7042]

Thank u sir ❤

[@joeljunior7426]

Thank you teachers.

[@samueloluwapelumi8002]

This is amazing!

[@elyssa_141]

i appreciate this. so so much

[@hamezaree300]

Best course I learned from it!

[@bharathnaveen8870]

Absolutely goated channel

[@mahendranath2504]

wow, Nice thanks for sharing the amazing content, I liked it

[@zerry4353]

Thats literally what i just needed

[@nochanel349]

Thank for sharing, i wish you made the videos short by putting it on a playlist

[@DKSigh]

For anyone going through the projects, to import the data you can right click the database > Tasks > Import Data... it seems to automatically run the 32 bit version of the wizard if you're struggling to find the file

[@DKSigh]

For the second project, he seems to find a workaround to import the data. I was able to still use this method to import the data easily. I haven't worked it through but if the issue is that SSMS doesnt detect your excel version, all I did was install the 32 bit of Microsoft Access 2010 Runtime. I'm using some 2021 Excel version but that got me around that part. Then instead of "initial server" or whatever it says for your destination, just pick the Microsoft OLE DB Driver for SQL Server. It's a more updated version of what he picks in the dropdown.

[@fernandosimon5621]

This is gold, thank you

[@manuelaherrerab6849]

Amazing content!!! 💯

[@georgekplivi8643]

Am glad Alex is also here

[@ZerberusEmprendedor]

Excellent 🎉

[@jyress]

Thank you ❤

[@RounakJain-ll6rr]

Thanks for mentorship

[@rishiraj2548]

Great thanks

[@sonandpets1215]

Thanks so much!!