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

[@Mohdfardeen]

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

[@katrineisfeld]

Thx ❤

[@julesaly]

the actual king of the analysts

[@arunachalamairtel9031]

Hi julesaly

[@haidakuh3234]

Its amazing knowing that the 20k people that have started watching this course hasnt finished based on the length of the video, obviously myself included. Good luck to everyone persuing their ambitions!!

[@mizzpenguin2]

If you watch at 2x speed you could be done based on the length of the video 😊. I watch most everything at 2x speed and when I'm learning something new depending on the training format and how fast the instructor speaks I'll slow it down to 1.5x 😊

[@monique1112223]

I wouldn't finish because I know for a fact that you can bootcamp all you want and even get a BS in Data Analytics like I did and there is still a very slim chance of actually getting hired as an entry level data analyst in this current hellscape.

[@jessed2314]

I feel the hunger to get through the painful part and meet on the other side. I have read comments from a more negative point of view, some of which can be discouraging. I want to say-and believe-that it's all about my mindset, how badly I want it, and how strong my life experiences have made me to this day. I have started so many tutorials in the past and stopped midway. So far, the only explanation I have found for that is that I didn’t really want it that badly. I want to rely on these principles and just jump through with it.

[@onoriodeemosairue7758]

⁠@@mizzpenguin2we are in the same boat 2x

[@TechKeeda0708]

Day 4 - Just completed the first project of MySQL at 3:56:41 ... I will comment at the end of each day....Thank you for your efforts Alex....I have seen your channel....not used much ....but now I'm starting to use it and learn from it.....and I will continue to learn from it......❤ Day 5 - just completed the EDA part at 4:29:40..... I already had some prior knowledge about SQL....i would say i was at the intermediate level but now i can say I'm on advanced level with knowledge about triggers and events and stored procedure and temporary tables.....i would appreciate it more if you would have taught about functions too but its okay.....loving the video....i will get back tomorrow now for starting the Excel series....i have pretty good knowledge about excel so i would watch the tutorials at 2x speed and later on will switch to 1.5..... Thank you Alex.... the video is so helpful ❤ Day 6 - Just completed till 6:37:01.... completed the Excel intro completely....will continue with the project tomorrow Day 7 part 1 7:17:44 completed the Excel project.... Never have worked with tableau....I will start it on the same day.... I will learn just the basics of tableau... Day 7 part 2 completed till 8:09:43 tableau basics done....

[@eccentric10]

I graduated in Materials Science and Engineering, but I want to become a data analyst. It’s great to see you’ve made this boot camp-I really appreciate it!

[@Aima_11]

I was learning data analytics from your free codecamp bootcamp but now I headed over to your this updated bootcamp and adding Azure is a plus. Thanks Alex for providing million dollars value for free!

[@AlexTheAnalyst]

You're more than welcome!

[@FictusFilmsPROTrailers]

@@AlexTheAnalystis the playlist better or this?

[@mehek6440]

Started my data science learning journey from today🎉

[@sphc648brr]

i found a 84 video parts version of this bootcamp hosted from a year ago in Alex The Analyst channel, which helps me keep track of my lessons, than the full 24 hr video, Thanks Alex

[@ikgaming9]

This is one of my favourite bootcamp of the year😊

[@Earthlighte]

Scream, I've learnt a lot from analyst builder... gonna dig into this video. Thank you for everything. Life started 'lifing' but I'm getting back into it. Yes, Python was harder for me to grasp.

[@Waqas-u8s]

At the end of the year Alex comesup with the gift surprise for all of us. Thanks man....

[@donnelly5757]

Yes! Thank you Alex for giving me something productive to do during this holiday season with this 24 hour bootcamp! It will also be a great refresher on topics that I may have gone over before.

[@AlexTheAnalyst]

:D

[@sivanyamurayama5523]

this is the only course i need, i shall start today evening after work

[@hidayahbashirdayyib443]

BarakAllah Feeka Ya Alex We appreciate you and wish you all the best of the worlds.

[@eto5609]

In SQL you can as well use this sign to mean Not Equal To

[@khalidelgazzar]

Wow 😳😲 .. 24 hours of content!! This is insane!! Thanks Alex! 😊

[@heidelms]

This is amazing! Thanks for sharing… This is good to have an overall overview 👍🏽

[@PhilosopherMindset-on4kk]

Hey Alex! Totally love the work you're putting into this. Just started learning SQL. I'd love to get to meet you in person.

[@Ese_oy]

Sharing this link to my friends ASAP! Thanks Alex.

[@moonchild1749]

Thanks Alex, I will be starting my last semester from Jan, I hope I can get a job real fast

[@aurora-rene4263]

Came here to say...thank you very much! You sharing and spreading knowledge is greatly appreciated

[@melissaCScom]

Python! Nice way to start my new years resolutions early, Much appreciated Alex! ❤ See you in the Analyst Builder. 😉

[@keletsonkadimeng2255]

Thanks Alex. Started yesterday on the 15 Dec 2024. I will be pursuing this along with the Google Analytics Certificate which I'm on course 3 already.

[@keletsonkadimeng2255]

18 Dec 2024. Learned how to use the group by and order by clauses. Long day, a little goes a long way they say.

[@keletsonkadimeng2255]

😴 19 Dec 2024. Just finished the SQL beginner series, I'll be starting joins next time.

[@keletsonkadimeng2255]

20 Dec 2024. Joins.

[@sulekhamalik1543]

Hey Alex Thank You for your hard work and kind gesture by giving it free of cost. Thank you again!!

[@AneesaJugnu]

Alexx!!you're great, loving the bootcamp ❤

[@Matt-dl2iy]

Working as a PMM right now and looking to enhance my resume and maybe even contribute on the data side of things. This should help.

[@ifyluv7402]

Christmas came early. I'm going to devour this this holiday. I'm going into 2025 Alex prepared to conquer the data world. Thank you Alex for your hard work.

[@ekeminimaurice572]

Time is to make good use of the holiday.💃🏾💃🏾💃🏾💃🏾💃🏾Thank you Alex.

[@ProfessorBelz]

You are insane Alex. Needed a refresher and am looking forward to going through it. Will help me in my current role.

[@zahidhussainzd5576]

KIng of Data Analytics and Great humanbeing. Thank you sir

[@mukesh_awale]

Everything in one shot thanks for the great tutorial.

[@marcinzale]

Unbelievable! You're great, Alex! Thanks!

[@obayorie]

This is awesome Alex. Thanks for doing this.

[@CodewithAshwani]

This is awesome bootcamp.❤ Thanks alex!!

[@anuoluwapotenibiaje3845]

This is awesome 😎 Thanks for all you do for the data community 🎉

[@ichigo_ichie777]

Thank you so much for sharing this Santa Alex!!!

[@yashlife_23]

Thank you Alex... I really wanted this!!... You are a legend

[@affro254]

Amazing work. Thank you Alex.

[@curioustreelife]

Thank you so much for this, really appreciated ❤💚

[@kareemsolt5069]

thank you Alex for your support I really appreciate your work, and this video is excellent because you aggregate all we need as DA in one video. We tried a lot to search for the best videos to fill our roadmap. This is a very amazing source, Alex. #Egypt

[@victorianwandu905]

Thanks 👍 Alex you are one in a million

[@NandaMenon-c3x]

Baaaammmm;!!!!thankyou sir...thanks for the insane support and work put in🎉🎉😊

[@bid19]

Man i was just starting in this, this is amazing 😅

[@chychy6642]

Thank you Alex for this bootcamp

[@tenavin4461]

This is insane Alex. Thank you.💪

[@asamwill4076]

Thanks for your great effort

[@edgargarcia324]

Alex the Goat 🐐 🙌

[@blessingjohnson5513]

My Mentor 🎉❤

[@sharonwarner7422]

Excellent resource. Thank you so much.

[@josephkyambadde6117]

Love your videos always

[@abdelhakyahiaoui6326]

Thank you so much Alex.

[@broname2557]

Grab your snack, grab your drink, prepare your machine, because alex is going to COOKING. Analyst style🎉🎉👍👍

[@aliahmadazad10]

My dear, you are like a live university!

[@samermelhem7344]

I spent the whole day watching this 😅

[@georgejetson9801]

this is awesome thank you!

[@Chaoes96]

Absolute Legend

[@hashiradnan4120]

You are a hero

[@anime_upx8096]

Amazing ❤

[@bakuaremiyaw]

Alex my Analyst

[@DataScientist268]

Thank you ❤.

[@khayalhajiyev8779]

I love you man ❤❤❤

[@aderonkebakare4594]

Thank you Alex🙏🏾

[@702thomas]

THANK YOU!!!!! 🥳🥳🥳🥳

[@LskAtmos]

ready to finish this.

[@Manriquenlinea]

Thanks a lot!

[@乐文玉]

Thank you so much for sharing!

[@ajamosci4901]

Thanks so much for the initiative @Alex The Analyst I'm pleading if you can personally add a project or two on AWS as well🙏 All I've seen so far in your resources are but AZURE projects.

[@peterM20]

Alex. This is why you are a legend 🤣

[@AhmadAbuGhazaleh-su1zt]

I think it would be great if you could add a Git and GitHub course to this video or the next one.

[@AzizabonuTashpulatova]

Appreciate your hard work))

[@gizlihesap1567]

Thank you so much!

[@Samo_1221_s]

Thank you so much

[@husnain_analyst]

Alex The Analyst 🔥

[@manoharhunt]

you're the best

[@ADELAKY]

I’m ready

[@omotolababalola5092]

Thank you Alex

[@navyavarma6000]

Thank you

[@McArthur-z7k]

Ur an angel

[@faustinaonuoha4583]

Thank you Sir

[@menshift]

thank you soo much

[@maiyadevi-ee7ht]

Tnx Sir

[@maitogai1995]

Lies…. This is only 23 hours 32 minutes and 48 seconds! Where are the rest of the 28 minutes and 12 seconds!?

[@gibranhyder9102]

that is a break time for us to eat 🤣

[@ayufadjriyanti1014]

😂😂😂

[@ceeemm727]

😂😂😂😂

[@michaelsolomon6033]

😅😅😅😅

[@cypriankrenski3491]

27 minutes and 12 secs to be precise 😅

[@atufeesther399]

Christmas came early 😅🥺

[@stephenoluwafemiherbert]

Thanks

[@abdurraqeebnizamani]

i need to learn all this from only this bootcamp or get your course of each tool? mean i can be a data analyst from this video's content or watch your more courses

[@gopalkrishnab]

Hello Alex.. I am bit perplexed. I am at 8:26 hr in the video and trying to complete Tableau full project. I loaded the XL file after combining all 3 CSVs into XL file. I pulled Zipcode into Columns and Price into Rows in Tableau working sheet, But it's not giving me Bar Graph visualization at all.... It's showing me only Map and Symbolic Map visualization and all other visualizations are blurred. What am I doing wrong ? What's missing ? After spending some time, I guess, i understood the problem. Price is appearing as Dimension instead of Measure. How do we address such issues ? If I try to convert "Price" to Measure from Dimension, Price gets automatically calculated as Count Distinct, it appears as CNTD(Price). How to handle such issues ? What should I do with the file that I am using for the exercise ? I didn't even get the Map properly. Can you help me here ?

[@prestonmagakwe5895]

What are best practices for keeping data secure when working with SQL, whether it be MS SQL Server or MySQL?

[@olowookeresamuel2703]

Is this different from the Data Analyst bootcamp playlist?

[@ahmedmakram659]

bro you the goat, I'm binging this Got a question, what's the main difference between this and the paid program for a beginner objectively speaking?

[@florianboulay6055]

Hi Alex, First of all, thank you so much for your incredible content and resources! You make the journey into data analytics so much more approachable for everyone. I wanted to ask for your opinion on a strategy I've been considering: starting with your complete roadmap on Analyst the Builder and then taking the Advanced Google Data Analytics Certification at the end (skipping the beginner one). My thinking is that this approach could maximize my chances of landing a job by combining the skills gained from your platform, a strong portfolio, and the globally recognized Google certification. Additionally, I hold a master’s degree from a business school, which might help strengthen my profile. What do you think of this plan? I'd love to hear your thoughts!

[@BeyzaGüler-k5u]

Is this suitable for beginners? Thank you

[@zishanmallick6745]

Please add chapters for the time from when the different softwares are used

[@chor8687]

Can we get timestamp

[@AlexTheAnalyst]

Oh boy - I'll do my best lol

[@chor8687]

Thanks for full Course Sir ❤

[@yvetteramble6510]

Ty

[@masuodmayanbari]

hello,seems you have forgotten to put one or two videos on before and after of 17.32.34 time of video because before that you explained first part of amazon T-shirt exmaple and you said in the next I work on other project about books and more complete.but i see that after 17.32.34 you directly jump to after of json file of crypto

[@tmsrequest5840]

hi @alex you said to click the drop down if you are trying to download SQL for Mac (18:00). I did it but the dropdown doesn't give the option for Mac. please anyone let me know what I am missing. Thanks.

[@kyleakimura361]

would learning and knowing the content presented in this video be enough to land a first data analyst job?

[@divyanshsaraf8836]

my create statement is not opening for layoffs_staging2 (timestamp 3:20:29) MYSQL Data Cleaning part any help ?

[@Daniman_LG]

Why wasting 4 years in college when I could finish all in 24 hours video 😊

[@manikkvarma]

I have genuine question, I am a CSE undergrad first year, I am still figuring out that even in CSE which direction should I go, I want to end up in quant finance, either as a developer or strategist or a visualisation engineer can you provide me with the road map, please