How I Would Learn to be a Data Analyst

[@CodingIsFun]

*Thanks for the shoutout, Luke!* I totally agree with everything you said in the video, especially about Python. In my experience as a Data Analyst, I rarely needed Python for actual analysis... MS Excel (best tool ever 😍) usually did the trick. But I used Python (and good old VBA) more for automating tasks, like managing spreadsheets, building internal tools and creating interactive charts. That said, I think learning programming is still super useful. Understanding concepts like variables and loops makes tools like Power Query and Power Automate much easier to use since they rely on similar ideas. And yeah, AI tools these days make writing and debugging code so much simpler. Wish I'd had those tools when I wrote my first line of VBA code back in 2012 👴

[@LukeBarousse]

Heck yeah, totally agree with your point of how learning programming can be useful; especially for automation. And yeah wish I had ChatGPT when I was learning to code.. would have saved so many hours banging my head on the desk.

[@stephaniejsmes8991]

Thanks for talking about what you used Python.

[@jas0609]

That's so true what he said that most of your co-workers don't understand a programming language. All of the jobs that I had in finance/accounting , none of my co-workers knew nothing about programming. So if had done report in Pandas/Python, they wouldn't even looked at it and trust the numbers, and; therefore, I would have to do the entire report again but in Excel.

[@LukeBarousse]

Hopefully AI will enable more people to use programming languages.

[@Rafael-up2hp]

Luke, I cannot express how grateful and trilled to your content. I had a accident and I'm away from work for 90 days. Im investing all my time in career transition and your content is playing a major whole in my life right now. thank you kindly

[@LukeBarousse]

Hoping you have a speedy recovery my dude! 🙏

[@aissamboudra7995]

Many thanks Luke, following your videos and tutos was so benefic and level up my skills and my productivity in my work. I am very grateful to you and I thank you very much, I intend to follow and finish all the new tutorials

[@lehsik23]

Thanks for all your work Luke!

[@akin242002]

Excellent video! As someone who did lots of spreadsheets for insurance claims as a former underwriter, Excel is very helpful for row sizes below 1k. Cloud SQL is better for larger row sizes.

[@gwonky931]

In my experience now having been 4 years out of college working as a data analyst at one of the big banks and an AAUDE University, SAS is still very much alive and depended on. Some industries are slow to embrace change.

[@djl3009]

Now that I'm relatively familiar with Python/Pandas, I find it to be an invaluable tool for EDA (Exploratory Data Analysis). If I'm presented with relatively new (not well-known) and complex data, I perform EDA with Pandas. But it is true that Excel tends to be the most widely used tool in most work environments, hence I often "export" my work to an Excel compatible format when sharing. If the data is relatively "well-known" and it's inherent complexity is low, I would work primarily in Excel or LibreOffice Calc or Google Sheets.

[@JamesBrogan-w5t]

I'm a full time Data Analyst and have been for a couple of years but I still enjoy watching these types of video

[@loodwich]

Data Scientist here with ph. a Ph.D. in material science. The IA fails because it lacks the courage to look where it needs to later. However, it does help a lot by showing you how to make something when you are stuck in code. But they don't answer correctly; you must change the bit part to have a functional code. Python is easy. When I tried to master Java 20 years ago, it was difficult to code with my limited knowledge of Java and C. I learned Python very quickly.

[@edudomingos]

Wow, Luke! This was a really helpful video! I'm definitely check out those free courses of yours! Thank you very much!

[@bouseuxlatache4140]

looking forward to the new courses. thanks Luke!

[@LukeBarousse]

You bet!

[@successnwokeleme8523]

Thank you so much Luke, you're a great Coach

[@krzysiekkrzysiek9059]

6:56 Freak! 🤣 I'm so glad I found this channel although I'm a Junior WebDev with Django. I'd love to learn an advanced Python from your future tutorial Luke 💪

[@AmanTheDisciple]

Much needed video, thank you.

[@andre717.8]

He makes sense to learn in this manner!!

[@Elvisjunr]

Thanks for this information 🎉

[@wazowski5296]

2:05 I LOVE YOU DUDE! You just made our life so much easier, this is so helpful! thankyou thankyou!!

[@sumitpatidar1215]

I'm just waiting for your advanced SQL course ❤

[@DiogoCabral20]

Great vid with great value. I know a bit of each of those skills (other than Excel cuz that's on my day to day work) however I feel I don't know enough to make the jump to data analyst. So great tips and mentoring on what should I focus. Thanks 🙏

[@vamshikrishna5123]

You are a hero Luke!! A lot of creators in here tend to sell there courses, but you are honest man for saying and sharing youtube has all the learning tutorials you need to get into a job. This is the first time im here and watching you. You earned my respect🫡. Thank you and looking forward for your videos. Cheers

[@vijaybalraj6913]

Thanks Luke... really really helpful.. nowhere such info...

[@e.b.9178]

Thank you for great videos. I have professional level in statistical analysis using R and data mining using sql. I have great level of tableau and high level of excel. My python level is satisfactory. I have an MA and i have got a google data analytics professional certificate. I built my personal webpage and i have posted 6 projects on it demonstrating my data analysis skills using these tools. I have applied for more 400 job posts. However, i have got only two interviews! I think has something more than just these skills.

[@mysteriousreviewer3872]

Thank you thank you so much... Subscribed it on the first time....❤❤

[@ntsouglomartin8766]

Luke thank for the road. Im biginner as a Data analyst

[@samyarkhanzadeh]

your videos are unbelievably great. you teach everything in details (like your total python course which is a full course and it was free.... this part really makes me thinking about :wow that person helps millions of people in all around the world even without knowing where they are..... ) As i said before : your KZbin channel is the most comprehensive one in all around the KZbin

[@LukeBarousse]

🥹

[@tessalu4015]

It's helpful, thank you!!! Hope you have Power BI course soon

[@askiGeek]

KZbin literally bless me with this video😂 thanks for this vid bro, ❤ I subscribed🎉

[@ForbiddenFish]

7:26 Oh look, it's me bellyflopping my way into SQL and into a better job hopefully! Thanks Luke!

[@matsberg1568]

I have a pretty good grasp on SQL, PBI and Python as well as knowledge with data engineering/science, but never landed the job. This made me want to pursue it again! I always found it difficult coming up with good projects to display though. Any tips? Great video!

[@AZ-gs6hj]

Were you getting interviews?

[@مح_ارب_مج_هول121]

I was about to watch the video uploaded 3 years ago but, this showed up😅❤

[@EjenaviBelieveOkotie]

I was studying data science with python and R in MSC but I dropped. Now I can use SQL excel Tableau and Power Bi without MSC looking forward to my first role.

[@zabeardybeardy232]

I never understood why no data analysts ever talk about statistics. You telling that barely anyone uses python and R tell me that no one seemingly goes beyond descriptive stats.

[@adityaratan179]

Then, can you please tell me what i should learn to become a data analyst

[@PepperPatch_17]

​@adityaratan179 Data Analysts have a deceptive name. Maybe data transformer is a better term. You're reformatting data into a way that better communicates across an organization and more importantly to people of authority. A basic average can be enough to be significantly impactful but it's buried in data produced between departments that aren't communicating.

[@akin242002]

You can, but most mid-level managers do not care about Inferential or Predictive statistics. Executives care, but they only want to hear from someone who has a Ph. D or masters degree. Someone with a BS degree in Economics is only listened to for descriptive analysis by mid-level managers most of the time.

[@LukeBarousse]

Really depends on your job on what level of statistics you use. Statistics is important but yes many projects descriptive statistics was enough.

[@eannane8712]

​@akin242002 Even worse our data guy never has his data questioned because I don't think they want to admit they don't know it's good or not. I regularly used to point out problems, but stopped caring.

[@abdihakimmoge9257]

Thanx luke when are you releasing the new course.?

[@LukeBarousse]

Intermediate SQL should be sometime in March

[@WealthyChronicle]

So traditional sales roles are declining, but social influence and leadership are in high demand. Is this the era where soft skills finally outshine technical expertise?

[@leninrana]

Hey Luke, when will you upload the Power BI course on your channel? I have been waiting for this course for a long time. I’ve used Power BI a bit but still feel stuck on some things, so a proper guide would be super helpful.

[@LukeBarousse]

Later this year. Wrapping up a couple sql courses first

[@kahinaabbas9792]

Luke , could you please make for us a more full real sql projet please 😅

[@juandavidyanezlabarca7272]

Great video! Regarding to the statistics at the end, about AI; Is what majority feels or believe what actually happens?

[@RashmiranjanChoudhury]

Please make a tutorial on power Bi

[@JosephTrump]

any tip for people trying to make career in IT but don't like coding

[@josecruz4631]

Get into helpdesk role

[@MadaraUchiha-q2i]

Which one should i choose for data analyst MacBook or Windows?

[@LukeBarousse]

Windows is the safe choice

[@pranavjha4949]

hey luke! pls make a video on "How I would train to be a cross-fit athlete" pls!!!!

[@LukeBarousse]

😂😂😂

[@monsieurpetit3617]

Google Coursera course focus on SQL and R. Data scientist on python and SQL. Confusing

[@MadMan920]

What's your opinion on Google Sheets VS Excel? Are they similar enough it doesn't matter which one you use more?

[@LukeBarousse]

There are some transferable skills for the basics (formulas, functions, tables, etc.) but skills aren't really transferable when you get into advanced features of Excel.

[@jelenadj7289]

What if we find someone who wanna PBi dashboards that are based on Excel and we do that. How the maintenance of that report works, do they fill the Excel all the time or?

[@mrmime774]

I can do a little python but i dont know what i should use it for ^^

[@chriss2295]

Is Python a more important over SQL?...Or am I leaning into the Data Scientist role.

[@LukeBarousse]

sounds more like Data Scientist

[@AnkurSinghSengar0709]

Can you make a video on data engineer

[@AbdulazizAlquhidan]

Where can I find your course for Excel?

[@LukeBarousse]

Linked in description

[@AbdulazizAlquhidan]

@@LukeBarousse with the name of “5 Days To Become A Data Analyst” ?

[@mindblownreactions]

Hi Luke I'm facing issues with the Terminal in my PyCharm IDE. Local Terminal Behavior: Whenever I delete the local terminal instance, it disappears completely. Environment Setup: My environment variables (or 'Envev') seem to be improperly configured. Project Creation and Data Import: Due to these issues, I'm unable to: Start new projects using libraries like Pandas. Import CSV data into my projects. Could you please assist me in resolving these problems?"

[@SakibKhan-g6b]

will AI be able to replace data analyst job in future?

[@FarhanAsus-d4j]

Hi, Is there a high demand for data analyst around the world, weather it is remote or physical jobs, in 2025?

[@mysteriousreviewer3872]

Sir can i get a job as a data analyst in the USA as I'm from another country? Could you guide me for this please? 🙏 Thank You.

[@Biswajitg99]

Data analysts will be dead in the future because Satya Nadella says the agents will be doing all of the data analytics work 😂Share your thought 💭 in comments

[@LukeBarousse]

😂

[@thisisepic1709]

we need AI and MAchine Learning Road map please

[@michellemacco]

2025 Roadmap 🔥

[@AlexWoolf-x8v]

O-H-I-O!

[@safakaranfil]

I love your content and storytelling however, learning what and how is not a question now. How to land a job with 0 experience as a analyst is the actaul question. Please don't say portfolio or something because I don't think it works.

[@josecruz4631]

Actually need a portfolio with the tools you used and why, same goes with projects

[@tank_boi442]

Perhaps you need to gain this experience yourself through work on your own projects

[@tank_boi442]

And maybe in this way, working on your own portfolio makes sense

[@chriss2295]

"Ai agents doing data analysis is the future". I laugh at this. People don't know how to use Excel. Good luck pulling that ad-hock report from the database!

[@ragulmarley4900]

😊for power bi kindly upload basic to advanced level in single video luke 🙏 way u teaching really understable 😊

[@LukeBarousse]

Power BI is definitely on the list!