How I'd Learn to be a Data Analyst in 2024
Вставка
- Опубліковано 11 січ 2024
- 📊 Become a Data Analyst - Google Certificate 👉🏼 lukeb.co/GoogleCert
👨🏼💻 My ChatGPT Tutorial 👉 • ChatGPT for Data Analy...
Courses for Data Nerds
==================================
🐍 Python for Everybody 👉🏼 lukeb.co/PythonForEverybody
💿 SQL for Data Science 👉🏼 lukeb.co/SQLdataScience
🧾 Excel Skills for Business 👉🏼 lukeb.co/ExcelBusinessAnalyst
📈 PowerBI for Data Viz 👉🏼 lukeb.co/PowerBI
📊 Tableau for Data Viz 👉🏼 lukeb.co/Tableau_UCDavis
🏴☠️ Data Science: Foundations using R 👉🏼 lukeb.co/RforDataScienceJH
➕ Coursera Plus Subscription (7-day free trial) 👉🏼 lukeb.co/CourseraPlus
👨🏼🏫 All courses 👉🏼 kit.co/lukebarousse/data-anal...
Books for Data Nerds
==================================
📚 Books I’ve read 👉🏼 kit.co/lukebarousse/book-reco...
📗 Data Analyst Must Read 👉🏼 geni.us/StorytellingWithData
Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 kit.co/lukebarousse/computer-...
🪟Windows Virtual Machine for Mac (Parallels) 👉🏼 lukeb.co/ParallelsFreeTrial
Social Media / Contact Me
======================
📫Newsletter: www.lukebarousse.com/
👨🏼💼 Linkedin: / luke-b
🅧 X/Twitter: / lukebarousse
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.
#datanerd #dataanalyst #datascience - Наука та технологія
I'll come to this Channel when I get my first data analytics job and thank you. Waiting for that day
Looking forward to your return!
same here
@@LukeBarousse I'll love you to mentor me,, I'm Emmanuel from Nigeria, a self learning Data analyst
Good luck. You got this!
@@emedit8036 my name sake , I'm in the learning process too .
Loved this! Having someone breakdown and do deep dives on the newest technologies really helps with picking what to learn first.
Cant be thankful enough for all the great content. Thanks so much😊
Another great video Luke!
Thanks.
Keep up please
Great video Luke Congratulations!! I also think that Salesforce owning Tableau has impacted the development of new features in the app and slowly but consistent Power BI is picking Up with Tableau.
Your channel is incredible, thank you for all of your work.
Very intuitive and always a pleasure to watch your technology related videos 😺
Great video! As a data analyst, I find myself using all of these programs/languages, except for Tableau.
Great video, man!
Excellent content!
Awesome edition!
Thanks for sharing, Luke!
Bro, I love how you explained this and did the hard work.❤
Facts , sure it is, love the depths of the subjects discussed
Just started my google data analytics course and your channel is one of the best I have come across.
I come from accounting background but I have been in sales development more in my working years. Data analytics will come in handy for me in my next chapter. Thank you for this content
Thank you!!
Can you explain how data analytics would help in sales development?
Hey We have the same background wow! I have a background in accounting alongside some coding knowledge
@@designj1451 the future is bright. Let’s do this
I finished the Google Data Analytics Cert last week. Took me 7 days.
Great video, thanks Luke
I am trying to get into Data Analytics, feeling a bit overwhelmed and anxious at the same time. I hope I can have a different feeling in a month time as I go deeper
Happy new years, Luke!
Happy new year!
Thank you, Luke
You're the best bro!
Love this skill overview, Luke! Super up to date and all super exciting! So many things I didn’t know about the tooling landscape. Btw, how can I learn to become a Generative AI specialist? 😀🧐
Ha! Maybe that's the next video I need to get on 😜
Thank you so much!
Thanks for sharing
thank you this gives me the confidence to pursue a career in data science even tho i have my bachelor in business!
My major is port management and logistics maritime, and I want to learn this cuz I think this skill is flexible in this advance digital era
It was very helpful.
Yes I’ll be here to as I am a beginner in SQL for school
This is awesome, I am in the middle of the google cert and am working on getting a data analyst position over the next few months, go Mr.Beast very cool you got to join his team.
This guy is a gem!
Data Science typically offers higher salaries and broader opportunities compared to Data Analyst roles. With advanced skills in machine learning and big data, Data Scientists are in greater demand, leading to lucrative salaries and diverse career paths.
Keep Rocking Man, all the best insh'Allah
I have been studying on my own to become a data analyst (already applying to job listings) but this video freaks me out a bit tbh. These AI tools are scary. I know they should be treated as tools but still. I hope it is still worth learning.
Anyway, thank you very much, Luke! And best of luck to everyone pursuing this path.
Okay, you managed to calm me down at the end😅
Thanks again, Luke!
AI will make smart people smarter. Don’t give up on your pursuit just include AI in it cause it’s here to stay
may i ask you that how did you study by urself, what are those method? thanks
I am pivoting for a time to learn data analysis and machine learning skills. I eventually want to do work as a biologist (once I finish my college education but I want to be able to use data analysis as part of my skillset in any research I might be doing in the future.
Love the vid ❤, would you possible please mind adding the link for the KPMG survey to the description 🙏
advisory-marketing.us.kpmg.com/speed/genai2023.html
Hi Luke.. Thanks for the great content and guiding our ways.. I am currently working as a credit analyst but looking to switch to data analysis. Since these coursera courses are charged monthly , they are some available for 1 tome fee on udemy. Do you recommend doing those instead if they are equally good?
My major is port management and logistics maritime, and I want to learn this cuz I think this skill is flexible in this advance digital era 😅
Great video, Luke! Speaking from my own experience, those are precisely the tools I utilize in my role as a data analyst/BI developer. Initially, I underestimated the importance of SQL 😬 Interestingly, I don't use Python extensively for data analysis, as most of my calculations are performed in Excel. However, I frequently use Python for building internal APIs, crafting custom GUIs, and scraping Excel files 😅. I'm always blown away by the versatility of Python. It doesn't matter what you want to do; most likely, there's a Python library for it 😅
Gotta love the open-source community for that; so crazy how so much is free to use with PYthon and the capabilities it has. Thanks for sharing this perspective Sven! 🙌
This gonna sound stupid but people say we have to dream big even if it’s crazy so here it goes… I would absolutely love to work with you one day, man! It would all come full circle
Thanks Luke for the great video, actually a couple of months ago I was searching for a roadmap to follow in order to become a data analyst, I was so confused about the reach youtube contents, but finally I find your channel and decided to follow your plan, and I never regret it.
After watching your video today I totally agree with you that every data analyst have to use AI assistants professionally, but I think beginners can't get benefits from it if they don't have the basics knowledge of the domain and don't know how to understand the code syntax, so even after all the AI revolution, learning the basics concepts in the traditional way is still needed, do you agree me with that? And what do you think?
Yep. Basics are still v much important
PLEASE what are the basics
Cheers ! Recently I started learn SQL :)
How's it going?
What would be nice is one of you guys that promote data analysis is to actually do a project from start to finish using all the tools that you you recommend every one to learn in your road map, so we could see how everything works with each other and why they are needed. Because when you start to learn each step you don't really know how it all comes together.... I'm sure you would also boost your watch time and follow, like and share basically boosting your channel.
this right here
Great insight with this video. I had my concerns AI was going to kill this career. Your data analysis saved my hopes.
Not sure about others, but he explained this really well, and also, new thing! Ai Coding Tool, like I have missed a lot since I "postpone" my analytics learning.
Tuning in religiously to this guy now on!
Hey Luke what computer do you recommend for data analysis?
How did you make the transition to that career coming from the military? Im also about to get out and am interested in pursuing that path
Luke have you try the functionality of "Cody" inside VS Code?
How did you install power bi on MacBook? I couldnt figure it out🫤
Would you 'handshake' with AI tools, if dealing with sensitive datasets (i.e. personal medical information or finance)?
Self learning! Lets go :)
it is so good❤
Would you be willing to do a video on how long it might take to build dashboards with examples? I'm wondering if the stress from my self-imposed time constraints is warranted.
12:05 if every organization replaces data analysts with AI from their workforce they can still archive more, like reducing spends on salaries.
There have been many data breaches in recent years. The databases of banks, insurance companies, and shops are becoming publicly available. How can a data analyst protect himself? An analyst has access to and works with huge databases. He is likely to be among the first to be under suspicion. Please tell us about your experience Luke. And share some tips. Otherwise it seems like a very dangerous profession.
If I recall your previous video in this format suggested learning R over python? How the tides turn
Great video. Thanks for sharing this info.
I am a former HR Business Partner with an interest for Data Analytics and will start a new role as an HR Data Analyst.
I will probably take the People Analytics Certificate from AIHR to start with and then will go with the Google Data Analytics Professional Certificate.
I was considering the Microsoft Power BI Data Analyst Professional Certificate after taking the Google Certificate.
What are your thoughts on this?
Thanks so much.
HIi Luke. Do. you feel taking a SQL course through ZTM or coursera I'd overkill if I plan on doing the META or goolgle data analytics certificate? Thanks!
No I don’t think it’ll be overkill. The Google cert is just the basics. From there you’ll need to dive deeper
Is it wishful thinking to want a job posting that is willing to take someone currently changing careers and offer some on the job training?
Hi Luke ... In one of your old videos you said you built a bot that logged into LinkedIn and scraped for data science jobs. I'm just curious how you'd manage to code a bot that could login to a social network and perform tasks like that. Was it hard? Probably not for you lol... Love your content Luke and just subscribed
It was def a learning experience. Took me some time but so many resources now adays with ChatGPT and the works that I think it can be done even easier
@@LukeBaroussedid you use python for that project?
thank you so much for the video, I really appreciate your effort, but I feel overwhelmed by plethora of information, and the use of a lot of technical words, I would love a video where you target each skill separately and provide a source to learn it, even though I am set on becoming a data analyst, I don't think that I understood the majority of the video and the many nuances mentioned.
Much love
Luke, for my masters' program in Business Analytics and Econometrics, they are teaching me R instead of Python which is kind of disappointing but also understandable because our course includes a lot of advanced statistics. My question is that how easy is it to learn python after learning R?
I think once you get the fundamentals down of R, it's relatively easy to switch over to Python. Python has a lot more functionality in my opionon, so it will take a learning curve for some of the features it has that R doesn't. But overall doable
Speaking from 10 years experience with R, I love R, but Python simply allows you to do more, a lot more. The transition to using/learning Python was a mixed bag for me, but it never overwhelmed me. So give a it go, you won’t regret it.
Luke - R you sure?
I learned R after Python and it wasn't too bad. I think learning Python after R would be easier. I have some tutorials!!!
Thanks for the answers, everyone. Appreciate it!
As a data analyst, watching the end of this video has got me so high on hopium
Let' me know. Is BI Analyst and Data Analyst the same?
Your enthusiasm made me interested in data science i came from a different background can i get a job in this field without certification? I heard self taught programmers getting jobs without earning a degree i wonder if its the same for data analytics. Im going 36 this year just going back to school to get a degree for this just giving me nightmares.
My issue is I dont know if data analytics would be suitable for me?
Luke, does the google cert actually hold weight in the industry? it is obviously fairly affordable in terms of being able to go back and get educational skills, just curious how it holds up with someone whos background isnt comp sci, but job is driving towards data analysis
great question, I have a quite a few videos on my channel interviewing those that got the certificate; and I feel will answer this
Sorry i have a question : why dont you switch to data scientist? I understood that its better skills ai oriented and its better pay.
Please let me know if i m wrong. Thanks.
I don't have any of these skills . I mean what should I learn first?? Excel??
Hey Luke, question for you, I see that you're using a Mac; have you ever run into any road blocks/difficulties using a Mac and excel ? Just curious since I use Mac's as well and have started taking Data Analysis courses, but have notice that many people tend to use Windows since excel seems to have a bit more functionality on the windows platform compared to that of a Mac.
Haven't really run into any major issues with Excel
Cool. 👍👍👍👍
What about Shiny... Nice video
"Yo! Heading for the role Research Analyst, wish me luck, will ya?"
Can someone summarize the video? I did not understand much

They have removed the 300 seat limit as of yesterday
I think Excel isn't higher because it's assumed people know Excel. It would be redundant to list it explicitly.
In the short-term, data analyst and data scientist jobs could grow more plentiful, but I expect junior data analyst jobs to start going away very soon. Most jobs in this entire profession could start going away within 10 years.
What about google data studio (looker)? Is it worse than power bi or tableau?
Looker studio fine for students and very small mom & pop businesses. It is free. Not good for mid-size nor large business.
Google offers a larger version (regular Looker), but it costs more than Power BI and Tableau. $10 for the base version of Power BI per user per month, $20 for the enterprise version of Power BI, $42 for the base version of Tableau, and $60 for the base version of regular Looker.
what about SAS ?
12:06 I call Bull
Unless you can defend your job against AI, you will be replaced
interesting video
Great video! I guess you should do it for every month, for every year is too rare. So much happens in a week. Actually also think about "How I'd learn to be DA TODAY!!!" on a daily basis, this will be huge!!! ☣
hey can i learn or work this thing bc iam 15 years old
For some silly reason I thought _taking a Statistics class_ would be on the list, if not at the top.
Hi luke i am graduate from BMS degree in finance and i have switch my interest to data analyst and taken up and offline course of data science and analyst with AI from institution name IT Vedant and i have almost finished my course but they had only teach us the basic of everything not an industry level knowledge so i want to have an one to one session with you so that i can get answers to my never ending question about it so plzz if you read my comment plzz reply back and may be in future i would like to take on your data course
2:48 MOOD
Mistral AI is not free. One has to pay for a subscription and for keys as well.
I do not understand why are people talking so positively about this video, I do not think that the vast majority of the viewers are thinking about seriously kickstarting their DA career. The creator Luke spent 13min talking mostly about some potential AI to use, most of which was either canceled, or you need to pay a large sum (which the creator Luke doesn't recommend), or the creator Luke is not even sure in the first place which one to pick. He just talks about sticking with his channel to find out which one he likes. Totally useless information without any real plan. Just Luke talking extensively about his knowledge to establish himself as a pro. This is fine, but if the video is titled "How I'd Learn to be a Data Analyst in 2024" then give me real guidance. This video should be titled "Interesting surveys about in-demand DA skills and how to potentially improve them". 100% misleading title
So, Can you tell a better way
You're 100% right... About the title. The video itself is not bad, but there's no guidance is just basically him giving some news and updates about DA tools.
Yeah this video isn’t good
Yeah, I'll just stick learning sql, tableau (because it's more eye catching) and python later. I have already mastered enough excel while working so that's one check in my skill box
Agreed
can i get a job without any degrre
Nukes from the Navy tend to end up in tech lol
❤❤❤
Misleading title
❤
How about java
Not as highly ranked as these. Checkout my app at datanerd.tech to see where it’s ranked
Hi everyone, I am from South Africa. Can I get someone to help me pay for the CareerFoundry Data Analyst course.
i wish more tech logos had animals in them.
We need some more love for the insects in logos!
I'm working as a data-guy in security, I would probably get fired if I started using chat gpt for data related tasks, why is no one talking about the security issue with cloud and gpt? Why would any data professional with a real job advice someone to use gpt? I am speechless.
I actually talk about the security issues quite a lot in my videos and have some alternatives for this
Will AI completely replace DA?
Someday, but by then being replaced will be the least of your worries.
If you had to redirect to another video to tell us how to learn, then why is the title of the video so?
These AI assistants sound pretty hefty!!!!
An AI editor would be even more hefty!
I'm here because of Stephenovic😤
But can you even trust what HBS says?
Or any corporate figurehead for that matter.
People need to run AI (for the moment), but soon enough, the cost involved will see AI driving AI, or at least many less humans running AI.
One of the greatest dudes I know came out of that school 😘
'If you're not a lazy English speaker' oh but my bro, none of those letters even exist in te reo Māori...
He kōrero ahau 'squeel' mō sql ;)
Don't learn R ever ! (unless you are statistician) they ask about R in hope that if you know R then you can move to Python...
6 Months from now, we'll just have to say "Siri, baby, what insights does this data tell me?"
wrong
Luke, do you know a tool with which I can download everything you know from your brain into mine?😂
I think elons working on that 😂
@@LukeBarousse He better be because it's a much needed tool🤣
epic