How to become a Data Analyst in 2024? - No sugar-coated advice from IKEA data analyst

Подписаться 2,5 тыс.

Просмотров 59 тыс.

0% 0

How to become a Data Analyst in 2024? Here is my honest advice, without creating the illusion that it's an easy path. I provide a zero-to-hero roadmap with realistic timeframes, describe the necessary skills not only to land a job, but actually to make a solid career in data analytics. This path is relevant not only for beginners, but also for those who have the basics and want to become true data wizards.
0:00 - My wrong (long) way to success.
0:45 - Do not hunt for the money. Why intrinsic motivation is vital?
2:24 - Soft skill - the neglected component of success. Shadow data analyst is no strategy.
4:02 - Spoken English - the barrier for non-native speakers.
4:46 - Credibility. Why trusting you?
7:00 - Short on money? Hack the system, no glamour.
7:28 - Analytical thinking - that is what you are hired for (not for dashboards).
9:36 - SQL, Python, Tableau or Power BI are merely tools, no illusions.
11:07 - ChatGPT is a tutor but not a professor, unfortunately.
11:29 - You are ready to show off. Data drama and sexy portfolio.
12:36 - Perfect LinkedIn and CV. First CV in my life.
13:28 - No CV spam. Cover Letter tip - take the initiative.
13:54 - My timeframe estimate - not what you've been told. How to make it, though?
Me on LinkedIn: / oleksandr-rovnyak

Опубликовано:

10 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 382

@alexright_data_analytics 3 месяца назад

🙋‍♂Greetings! This my very first video on this channel. Let me know which other topics would you like me to cover in the same bold manner? I will try to answer each of your comments. Your feedback is greatly appreciated! Stay tuned. Rightly yours, Alex

@nimishchougule851 2 месяца назад

Could you make a video on how to get a data analyst/data scientist job as a fresher? Should you start with an internship or look for a job directly after completing a certification of few months or after graduation?

@alexright_data_analytics 2 месяца назад

@@nimishchougule851 Ok. Noted. In short, it depends. I would probably go for an internship as it is easier to get into in comparison to landing a job, generally.

@anshumansingh4669 2 месяца назад

I would like you to make video on which topics we should learn for Data Analytics like in SQL what we have to do or we have to do entire DBMS, in python what we need to learn , because people often confuse data analytics with data science and business analytics like I thought of doing dsa in python which has no use so in short I want to know which particular technologies i need to learn and it then what particular topics are relevant for data analytics?

@alexright_data_analytics 2 месяца назад

@@anshumansingh4669got it. Added to my list of ideas for new videos

@Dhdiebwhdbeodhs 2 месяца назад

Excited to see more videos from you, bro. You seem way more credible than the others talking about this subjec.

@vikadorofeeva7438 11 дней назад

The best informative channel I have ever watched!!! I am in college pursuing a Data Science major. Just in case I also tried an online IT school that promised ready-for-employment within 6 months. The information they provided was so surface. I am so happy I went to college to get a degree. Professors know how to teach you way better than these people on the internet. After each course, I see real growth in myself and the education builds strong confidence in my case. I just started my degree, it will take slower but I enjoy the way. I was born and grew up in Ukraine. Getting my degree in Maryland

@alexright_data_analytics 11 дней назад

Thanks for the feedback! It seems you are on a good path. During my university times I found especially valuable live interaction with my classmates - brought us so much. Btw, greetings from Uzhhorod, Zakarpattya

@hoangthuw 2 дня назад

This is my first comment on RU-vid ever! Thank you for your valuable insights; your sharing is both clear and comprehensive.

@alexright_data_analytics 2 дня назад

Thanks for such a lovely feedback! Glad it was useful for you

@emilyau8023 2 месяца назад

Thanks for giving everyone a reality check. My brain breaks when people say degrees are just useless paper. That's not what the data says.

@alexright_data_analytics 2 месяца назад

Yeah, I also do not like people trying to hype on youtube. You can be provocative, yes. But, please, do not be delusional

@Dee-zy2xv 2 месяца назад

Some " degrees" are useless in the paradigm of the material being brought forth. Lets not fool ourselves into thinking all of them carry weight..they do not. Stats also show this as well ...at least make an objective approach for both sides.

@alexright_data_analytics 2 месяца назад

@@Dee-zy2xv You have a point. Not all degrees are useful. But generally, having a decent degree for positions like data analytics gives you credibility, although, one should be careful about choosing a degree. Sometimes it is better to spend time and money on courses rather than on degree

@vazdabilo6983 Месяц назад

@@alexright_data_analyticsis it possible to find job without degree ?? Are certificates enough to land atleast some real life projects to put in portfolio ? I aim to work as data analyst next year

@alexright_data_analytics Месяц назад

@@vazdabilo6983 It depends. I would say having no degree significantly decreases your chances to land a decent job. But it does not mean that you can’t

@chimpwnzee Месяц назад

During college, I felt like I was going about it the 'wrong' way as well with all these social media videos preaching how you don't need school to get a Data Analyst/Scientist role. Glad I'm not the only one who took the 'wrong' path. :)

@alexright_data_analytics Месяц назад

Cool. So did the degree benefit you?

@as_below_so_above 27 дней назад

I'm so happy I pursued a career in data analytics. It was the right fit for me. It is where my skills and fascination intersect. I get to solve a large variety of problems and propose various solutions using tools and technologies that I love using and learning. Some of my colleagues do not have the same level of interest as I do, and it really shows in their day-to-day interactions and work.

@miaomao1449 27 дней назад

I'm thinking myself of going into data analytics coming from a background as a software developer. I'm also wondering if data analytics will be a right fit for me, the thing that appeals to me is a mix between technology (where its not so advanced that you have to build and scale massive software systems), but at the same time leaves room for creativity to explore data and to derive insights. What I do not enjoy with my job as a software engineer is the constant having to build things, there is no room for exploration or something like this. How do you know if data analytics is a right fit without trying it?

@alexright_data_analytics 27 дней назад

Wow, cool to hear some people who have proper intrinsic motivation. That is the key

@alexright_data_analytics 27 дней назад

In data analytics it can be also the case you will not do much of exploration. Instead, you might be building dashboards and cleaning data. So, be careful about choosing the right data analytics position for yourself

@dhondup10 19 дней назад

@@alexright_data_analytics Hi Alex, thanks for very informative video. Could you please explain more about "choosing the right data analytics position"? Are there different positions within data analytics? Which is the better position?

@alexright_data_analytics 19 дней назад

@@dhondup10 Certainly there are different positions. In short, there are positions with more emphasis on hard skills and less on soft skills and vice versa. Also, there are different domains. These are two main things to consider

@gennadiichelak 2 месяца назад

RU-vid algorithm brought me here:) I'm in the learning process so far, and your video was not just only useful, but it also proved my knowledge I had about the data analyst job. Thank you, subscribed!

@alexright_data_analytics 2 месяца назад

Thanks as well. Good luck and stay tuned

@SiloSolvent Месяц назад

Motivation is a big one, I'm glad you mentioned that. You have to know "why" and relate it back to the big picture you're contributing towards. It's such a buzz word now...but it takes deep understanding and like you said, there's no shortcut. I like you also mentioned soft skills and the reality of it. Communication, project management, tactful public speaking, etc. are all game-changers for technical skills.

@alexright_data_analytics Месяц назад

Thank you for the feedback! What is your intrinsic motivation for DA, if I may ask?

@NikkieMullet 2 месяца назад

Your video just appeared on my feed, and I must say bravo! Great video. Very informative and thorough, as well as being realistic about the expectations of getting into this field. It's refreshing to see after so many creators sugar-coating the ease and work that it takes to do this. I look forward to more videos!

@alexright_data_analytics 2 месяца назад

Thank you for the motivating feedback! Working on more

@Ceasbot 2 месяца назад

I appreciate the honesty and authenticity Alex its a breath of fresh air , you got a sub from me man , can’t wait to see more

@alexright_data_analytics 2 месяца назад

Thanks for the feedback. I was first afraid that the message will come across as too harsh. But with all the positive feedback I conclude this is the right way to go

@batuwka9796 2 месяца назад

Hey Alex! Congrats on your very first video on this platform. After a 3-year career break, I'm now focused on learning Data Analysis. I'd love to see more detailed videos on landing your first job as a Data Analyst - tips on projects, resume building, and more. Your guidance would be greatly appreciated!

@alexright_data_analytics 2 месяца назад

Hey hey. Got your message. This is in my plans. Currently writing a scenario for a new video. It will not be on the topics you are mentioning but the one after I plan to make educational which would address something from your list

@deimanterepsaite9014 7 дней назад

Evey other youtuber thinks that they broke the code and know how "actually" things work, though this one is the best so far I think. Way to go!

@alexright_data_analytics 7 дней назад

Thanks for good words

@pseudoplatanus6855 3 месяца назад

Valuable insights for someone looking to break into data analysis! Practical advice that cuts through the noise. Thanks for sharing!

@alexright_data_analytics 3 месяца назад

Thanks bro

@frankdosu4651 2 месяца назад

Thank you and congratulations for this first video. Very interesting and inspiring! Definitely motivated me to continue on my journey to become a Data analyst 🙏🏿😊 looking forward for the next video.

@alexright_data_analytics 2 месяца назад

Thank you for the inspiring words! Already working on the second video

@southpaw_mechanics 2 месяца назад

Thank you for the video. Recently at my job, I put myself in a position to extract and analyze data to improve Ecomm sales. Before that I handled basic accounting. All I know how to do is make sure things are balanced with no discrepancies. If there are reconcile it. Learning tools like Chat GPT, Helium 10 & Power BI have blown my mind. I have always been used to auditing information with my eyes. Then going over it and spotting something out. I feel like a caveman that discovered a UFO 🛸

@alexright_data_analytics 2 месяца назад

Huh. I can relate to that. In the university times I mainly used MATLAB and Stata. After I discovered Python, Tableau and Power BI, things got so much less tedious. ChatGPT was another breakthrough. With that, your analytical thinking and soft skills become even more valuable since the technical part gets easier to learn for the many

@karolczi8069 Месяц назад

This was the best video on this topic that I've watched so far - thank you. I feel like I actually know where to go from here and how to plan my path.

@alexright_data_analytics Месяц назад

Glad to hear it was helpful. Good luck on your path, stay tuned ❤️

@saeidk736 Месяц назад

ok Finally Someone who actually talks some REAL SENSE

@alexright_data_analytics Месяц назад

Thanks for the feedback!

@donaldmacdonald4901 Месяц назад

I have a degree in Statistics from the UK but have been out of the field for years. Now I am in a new role where hands on is more important, bit of a challenge but also a chance to work from a blank canvas. Thank you Alex.

@alexright_data_analytics Месяц назад

You are welcome! Btw, what is your motivation to come back to the data analytics?

@donaldmacdonald4901 Месяц назад

@@alexright_data_analytics I have a new job in a organization that doesn’t have the full complement of middle office, back office support and that gives me a big of a blank canvas to begin to understand the needs and create useful indeed sellable analytics.

@fattmeows8868 26 дней назад

All the best!

@viktorbondarenko7272 День назад

Thanks for the video Alex!

@santhoshkumar8143 2 месяца назад

This first video hit me very hard. Thanks, Alex.

@m00nlyter Месяц назад

thanks for the pragmatic video, its a breath of fresh air. i don't have strong math kills, my educational background is in communications. as my tech career progresses i am feeling the pressure to become more competent at data analysis. i can definitely lean into credible certificates and dump some quality time into learning sql + python. i want to be a good leader who is taken seriously, i want to own my results with confidence. this was a great video! i like how rooted it was in the reality of things, and not so much the 'dream peddling' you see on youtube. can't wait for more content.

@alexright_data_analytics Месяц назад

Thank you for such a feedback! It is really important tot me to see that this kind of style brings value. I do not want to sell dreams to people but at the same time I do not want to discourage. Check out my second video, you might like it

@slckaz1183 2 месяца назад

Clear and concise thank you Alex

@alexright_data_analytics 2 месяца назад

My pleasure

@eclipse.241 8 дней назад

Thanks for the good hints!

@onyemaugoh3346 2 дня назад

This is really lovely thank you.

@fecorreas 2 месяца назад

What a nice video! There is so many good advices that I had to take notes.

@alexright_data_analytics 2 месяца назад

Really nice to hear such a feedback. Thank you! This motivates me a lot

@mercyanyanso.810 День назад

Thanks. I'm about to go into this field, so I'm gathering info on it. This video sat right with my Spirit.. I watched to the end!! You put in a lot of thought into it. Will definitely Subscribe for more ❤🎉

@alexright_data_analytics День назад

Thanks you for the feedback. Will keep up

@frontire_ace 27 дней назад

Very informative, to the point, smartly presented, and was really helpful. Thank you, Sir!

@alexright_data_analytics 27 дней назад

My pleasure!

@michaels2208 Месяц назад

Great video. I'm 50, disabled vet and finally got to a spot where i wanted to get into tech. I am pretty good with data, but I'm going to go for a degree at wgu. I hope to eventually move to Germany or elsewhere in the EU. I'm trying to convince myself I'm not too old.

@rosetwinz Месяц назад

Younger, working on degrees #2/3 my wife and I, but I think that thought visits anyone who returns to school after a significant hiatus...or past traditional. Something that helped us "you're going to X age in 5-10 years anyways. Wouldn't you rather have given it your all, rather than play a game of what if". Also going through theor program, good luck 💪🏻

@michaels2208 Месяц назад

@rosetwins2x2 thank you. It does help to think about it like that. I'm going to be 60 in ten years whether I do this or not. So I may as well do it, nothing bad is going to come of it. It's a win only situation.

@alexright_data_analytics Месяц назад

If you feel it is your calling, I would give it a shot, no matter of age. Good luck!

@fattmeows8868 26 дней назад

Never too late to start something :) You are not bringing nothing to the table since there are also valuable transferrable skills accumulated from ur past work experience. You got this!

@michaels2208 26 дней назад

@@fattmeows8868 thank you

@johndaniel7569 2 месяца назад

Awesome kick start!! Eager for the upcoming Edu Videos

@alexright_data_analytics 2 месяца назад

Thanks for the feedback

@Jfindingale Месяц назад

Thanks, Alex. I look forward to new videos. I'm trying to explore what is my intrinsic motivations. I thought that after 15+ years, I have figured it out. But after being laid off, I find myself exploring a new roadmap - data analytics.

@alexright_data_analytics Месяц назад

So what would be your intrinsic motivation for data analytics? I am interested

@user-ns9gz3ov2l 2 месяца назад

Just discovered your chanel, i love your realistic tone. We are waiting more videos bro!

@alexright_data_analytics 2 месяца назад

Thanks, I will!

@itsjustme684 2 месяца назад

You are insightful here. Great one!

@alexright_data_analytics 2 месяца назад

Thanks for the feedback!

@ChibuzorNwakasi 2 месяца назад

This is by far the most honest and insightful video I have seen on this topic. I recently started my journey to become a data analyst and this video is one I will come back to every time I need fuel for the fire. Thank you, Alex. Subscribed.

@alexright_data_analytics 2 месяца назад

Thank you and good luck!

@idanartzi3526 Месяц назад

good luck man , if i can ask you what journey did you choose , a degree or official certifications in data analysis ? thanks

@ChibuzorNwakasi Месяц назад

@@idanartzi3526 I am taking Google data Analyst course on Coursera

@ChibuzorNwakasi 21 час назад

@@idanartzi3526 I started with the Google Data Analytics Professional Certificate on Coursera. Then Learn SQL Basics for Data Science Specialization. I am going the certifications path.

@octagonmixltd Месяц назад

Wow! Motivated. Thank you.

@alexright_data_analytics Месяц назад

My pleasure

@kylerowland1227 2 месяца назад

Thank you for realistic expectations

@alexright_data_analytics Месяц назад

My pleasure

@xevilman1 2 месяца назад

Very clearly presented.

@alexright_data_analytics 2 месяца назад

Glad it was helpful!

@marketingsolutions6691 14 дней назад

Thank you so much for providing all this information.

@alexright_data_analytics 14 дней назад

You are welcome!

@relaxingtunes3779 2 месяца назад

Thank you! Very much on point!❤

@alexright_data_analytics 2 месяца назад

You are welcome. Don’t hesitate to ask questions in the comments

@relaxingtunes3779 2 месяца назад

I will definitely do that sir!

@alecantropo98 2 месяца назад

Nice video, waiting for more! Subbed

@alexright_data_analytics 2 месяца назад

Tnx

@Sreshta7 2 месяца назад

You've spoken some facts here. Thank you so much Alex ✨ I really needed to see this today, keep going!

@alexright_data_analytics 2 месяца назад

Thanks for the feedback!

@Udom_soup 2 месяца назад

I’m 38, no college education, 20 years exp in healthcare, unhappy in my current role, and was looking to break into data analytics. Sounds like it’s too late for me 🥲

@alexright_data_analytics 2 месяца назад

Why so? It might just take you more time. Yet, I see you could use your experience in health care as domain knowledge. Then put DA skills on top and you good to go

@Lynn-pp8vn 2 месяца назад

@@Udom_souphey hey, I’ve been working in research and my daily operations involve a lot of data and its analysis. Yet my degree wasnt a maths, stats or computer science one. Even in this position, I come up with many problems trying to bridge to a data analytics role. If possible, I would advise you to start a bachelor of computer science

@blessingagbamoro4300 21 день назад

This was really good Thank you

@alexright_data_analytics 20 дней назад

Glad you liked it

@fernandoortiz6026 2 месяца назад

Interesting, I've just recently started my data analytics journey, ATM I'm doing a bootcamp, but I'm absorbing a ton of resources on the internet, so I really admire your honesty, coz certainly, you're not just saying what people want to hear, you're making points on the reality about this. Thank you so much for sharing your points of view and experiences.

@alexright_data_analytics 2 месяца назад

Thank you for the feedback! Knowing what reality is makes you stronger, but not the sugary messages about 3 month you hear here and there

@TradewithRaymond 2 месяца назад

Alex, awesome work. I'm watching as I am interested in data analytics. Teach me bro.

@alexright_data_analytics 2 месяца назад

Will do my best bro

@ericrobbins6953 2 месяца назад

Thank you, Great content. Thank you for your honest recommendations. I would suggest updating soft skills to human skills or social skills. Like technical skills versus social skills. Hard and soft are not specific enough.

@alexright_data_analytics 2 месяца назад

Thank you for the feedback! As far as I know, “soft skill” and “hard skill” are standard concepts in the tech world. If I would use another terminology, not sure I would deliver the point across that effectively

@ericrobbins6953 2 месяца назад

@@alexright_data_analytics Yes, that is correct. Those are the standard phases, however I see a trend to redefine the terms. Your channel seems to emphasize these needs, (soft skills and truths), and you can be ahead of the game before your channel matures.

@MySisao 19 дней назад

It’s not my passion but it’s entertaining and good enough to make a good amount of money, so whatever. I didn’t study a related field in university. Learned online in a year and then got my first job through a personal connection. Have mastered this field in about three working years, making six figures consulting now.

@MySisao 19 дней назад

Stuck around for the part on analytical thinking, I studied journalism so in hindsight I suppose the degree was relevant in this sense

@alexright_data_analytics 19 дней назад

Cool story. You mention it is entertaining. What is entertaining about it?

@harshddesai 14 дней назад

Hey @@MySisao im currently learning it, can you help me get better at it while avoiding the pitfalls you had to go through?

@MySisao 14 дней назад

@@harshddesai Get good at SQL transformations

@beatrix-ec1xf 5 дней назад

Smh it's definitely always about who you know.

@ismailowino2866 2 дня назад

Shukran bro!This is so insightful!

@alexright_data_analytics 2 дня назад

no problem, bro

@yashpaljadhav7079 День назад

@@alexright_data_analytics He meant Thank you. It's a Urdu word to say thank you.

@Durio_zibethinus Месяц назад

Thank you for your no bs approach with this video. Pandemic wrecked me down from every sides, too many relatives just....passed away, especially in 3rd world countries. Too many youngsters are abandoned until this day and they still need food everyday. I left my future and live more realistically. Online courses are my gateway, not just to learn but to connect. I hope not getting golden-spoon mamaboy though, they never heard what a hunger is 👀

@alexright_data_analytics Месяц назад

You are welcome. I hope you will get through and will be able to live a stable life

@Durio_zibethinus Месяц назад

@@alexright_data_analytics thank you for your kind words. I really appreciate it.

@ShahZ 2 месяца назад

Well done Dude

@YarynaBeley Месяц назад

Could you make a video on what kind of statistics is needed for data analytics?

@ABFPV584 Месяц назад

30 seconds in and I love this guy

@alexright_data_analytics Месяц назад

Please, pay attention to the content, not to the persona :)

@lexycruz1 Месяц назад

Thanks for the advice Alex! From a future Data Analyst 😊

@alexright_data_analytics Месяц назад

My pleasure

@Axel-vt8no 13 дней назад

Great video!

@alexright_data_analytics 13 дней назад

Thanks!

@kellymyshrall3006 Месяц назад

I have a degree in Psychology and 3 years of leadership in the non-profit world. I have the soft and analytical skills you speak of, but need to learn the tools. I am currently doing a data analytics essentials 4 month course. Hopefully I am on the right track! Thanks for the video, very helpful!

@alexright_data_analytics Месяц назад

You are welcome and good luck on your journey!

@chatbass2468 10 дней назад

Came for the video, stayed for the chill background music 😀 (good vid though!)

@alexright_data_analytics 9 дней назад

Heh, will take it as a compliment for my taste

@elmersumalinog8944 2 месяца назад

more video please, and also create a video where you find the insight of the data you work on, cause a lot of channel they only teach technical but not soft skills and analytical

@alexright_data_analytics 2 месяца назад

Yeah, these are in my plan

@iam_topg 2 месяца назад

Thanks bro for your content

@alexright_data_analytics 2 месяца назад

U r welcome. I plan to do more

@RT-mn2pb 2 месяца назад

Yes, Alex this was a good video. I like your serious and down to earth demeanor and attitude. Too many RU-vid people aim to be cool or funny. Well, career planning isn't funny it's serious. So, thank you for treating in an adult manner, good approach. The content was appropriate and well-presented. This video is a good start. For added, future topics, I suggest "how to enter the data analytics field leveraging the business you already know". The point here is that many people want to move from other, non-IT fields to an IT Data Analytics career. So, why not aim your new data analytics training toward how it is currrently being used there, and how a person can you their "other carrer" knowledge to create new tools and solve new problems? They could be a DA/Old-Business expert. That addresses a problem many business managers say about IT guys "you don't know my business". This would be a very helpful series of sessions; more than one, I'm sure. And for you, Alex, I think it would make your channel stand out. --- What do you think of this suggestion?

@alexright_data_analytics 2 месяца назад

Hey! First of all, thank you for such a feedback, well elaborated. I really appreciate that. Second, yes, I think the topic you are pointing at must be relevant for many many people who want to switch their careers. I gonna note that and think of how I can contribute. Thanks again

@nichellegraf839 4 дня назад

That is a great idea, I would find that very useful....I think many people changing careers considering DA would, especially coming from Alex.

@abdihassan6715 Месяц назад

Awesome work so refreshing as former data analyst turned network engineer

@alexright_data_analytics Месяц назад

Thanks

@lovelove-jx9qt Месяц назад

What made you want to make the switch?

@abdihassan6715 Месяц назад

@@lovelove-jx9qtDue to my original masters experience in computing and former placement years in field

@rbbautista5814 Месяц назад

Thank you

@alexright_data_analytics Месяц назад

My pleasure

@maria_erams 2 месяца назад

Alex, your video is incrible! I think is the first video that I watched that is talking the hard truth about becoming a data analyst. I hope you post more videos like this one... Can you give us a tip about practice English for the data world? Greetings from Brasil!

@alexright_data_analytics 2 месяца назад

For me, the breakthrough was going to English speaking clubs many years ago during my bachelors degree. I was speaking there in front of many people, remember myself struggling to formulate basic thoughts. But I loved speaking in front of audience and over time my skill got better. It was self reinforcing positive loop. I would try to find such clubs in your local community and go there as frequently as possible. Another option would be finding a job where you would be forced to speak English, could be something different from data analytics. There are no shortcuts but generally it works when you either love it or you are forced to learn it. The former is better than the latter, imho

@maria_erams 2 месяца назад

@@alexright_data_analytics Thanks, Alex!

@pepperpeterpiperpickled9805 2 месяца назад

Your first video and you hit 10k views?! great job mate. quality info, too. Would you consider sharing the Pareto distribution of SQL and Excel formulas? (like what is the 20% of Excel/SQL queries that will be used 80% of the time)

@alexright_data_analytics 2 месяца назад

Huh. Yeah. 10K for the first video. I am excited myself about it and thankful to all of you guys for the positive feedback. Really good idea about the Pareto thing regarding the use of SQL/Excel. I think it worth asking ChatGPT about it, maybe it could derive the statistics from its large data base? Yet, I will take this comment as an idea for a new video as it needs some deep dive into the topic. Thank you!

@pepperpeterpiperpickled9805 2 месяца назад

@@alexright_data_analytics I look forward to it! Ive just been looking to learn Excel, but there are 100s of formulas and no one can seem to tell me what the essentials are.

@alexright_data_analytics 2 месяца назад

@@pepperpeterpiperpickled9805 If I would start over, I would not go for Excel

@pepperpeterpiperpickled9805 2 месяца назад

@@alexright_data_analytics Isnt that *the* tool to have if you want an office job?

@alexright_data_analytics 2 месяца назад

@@pepperpeterpiperpickled9805 for some typical office job, yes. But for most DA positions you will most likely use it to open files, not more. I would go for Python first. It really set's your mind properly for the data world. With that Tableau and PBI are sugar

@vaikunthavaasan Месяц назад

Great Video.I subbed after watching this video, and gosh 1.3k other people already want to become Data Analyst...

@alexright_data_analytics Месяц назад

Yeah, all the data out there needs some analysts

@vaikunthavaasan Месяц назад

@@alexright_data_analytics😂 You are right and the competition is high...

@MS-wy4sb 2 месяца назад

I want to become a data analyst to get into data science. My motivation to get into Data Analytics are varied: possibilities for remote work, I can use a lot of the core skills from chemistry, good pay and higher pay ceiling, allow me to afford living in my home state, a science degree I'd applicable and won't require reeducating myself.

@alexright_data_analytics 2 месяца назад

But do you actually like the data analytics stuff? Do you like the DA flow? Would you enjoy the everyday challenge? Or work is work?

@MS-wy4sb 2 месяца назад

@@alexright_data_analytics I'm still figuring that out. I like working with SQL and Tableau. Working with spreadsheets can be tedious. Figuring out how to analyze the data is fun, so is summarizing and sharing it. The pipeline of data can be fun depending on what you're working on. Those are my feelings so far.

@alexright_data_analytics 2 месяца назад

Great feedback, thanks. Looks like you indeed have some intrinsic motivation. Data Science could be very tedious too. Pipelines with multiple lines of code, black box algorithms and so on

@distruktiv8504 2 месяца назад

Faced with a softskills problem. For me specifically, it is a very big problem, as I am learning two languages at once to get a job as a data analyst in Poland.

@alexright_data_analytics 2 месяца назад

That is a tough one! Good luck

@idanartzi3526 Месяц назад

Hey Alex, thanks for the straight forward video, I’ve started researching what career path should I take , and I do feel that data analysis can be a good career choice for me, as I’m naturally curious, I like statistics and I have several of the soft skills you talk about in this video, as well as good English. I wanted to ask you, what degree would you advise for me to study, as there is no " data analytics degree". I understand statistical/ finance / business and math are the top options for this career path, what would you recommend or do if you had to start over again today ? thank you and good luck with your youtube chanel !

@alexright_data_analytics Месяц назад

It is a complex question. But in short, if you are more on the business side and less interested in technical aspects, I would go for economics-like degree. In contrast, if you are rather up for technical stuff, I would go for math/cs.

@hailekassaye434 Месяц назад

I found this video very important.Please make a video on the tools.

@alexright_data_analytics Месяц назад

Thanks for the feedback. What particular kind of video would you like to see?

@gopichand2 2 месяца назад

Great

@yunikartika8215 17 дней назад

I thought your video will be just the usual click bait stuff but mannn, I truly appreciate your work. One question, is that possible to use Golang instead of Python?

@alexright_data_analytics 17 дней назад

Thanks, man! Appreciate the feedback. I think Python is a go to classic

@rossita6634 Месяц назад

Thank you for telling us the real, real, real reality on this data analytics job and the journey to be it. Actually I doubted some youtubers that said they only needed 4 months process from a drop-out college to be a well-paid data analyst. As a retired mathematics teacher who learned by autodiduct some codings, I think that claim does not make sense 😅😅😅. Again, thank you 🙏🏽 Edit: Alex, if you don't mind, can you explain about big data? How to gather it? Can we get any data to be in a big data? Sorry for my poor English, I'm not a native speaker 🙏🏽. Thank you 🙏🏽

@alexright_data_analytics Месяц назад

Hey! Thanks for the feedback. Big data is a wide topic and can mean many things depending on the context. I might make a video on that, thanks for rising this question

@mimi.1. 2 месяца назад

New subscriber 🦋

@FEVERNOVAA 2 месяца назад

Well put video, but I'm curious When do you use python (+ matplot, pandas ect), as in situations where you can't clean the data or visualize using any other method I'm currently self learning to become an analyst and I've been kicking the python can down the road because it seems to me that its functions for data analysis can be substituted with SQL or power query/bi or even excel

@alexright_data_analytics 2 месяца назад

Python is my favourite. It can not replace Power BI effectively, though. But when I have to manipulate or clean data, Python is go to. I prefer it over SQL even, especially when it comes to complex “data blading”. Also ChatGPT ❤️ , it’s really good with Python. No more scrolling Stackoverflow, God bless

@doc2407 2 месяца назад

Hi sir, I am 1st year Data Science student. Firstly, thanks for the video and hoping a your guidance in future. 😁

@alexright_data_analytics 2 месяца назад

All the best!

@ustvb7_4326isg Месяц назад

Spitting facts

@alexright_data_analytics Месяц назад

Trying hard

@marcobarroso-xv8eq 2 месяца назад

Hello alex ! nice video btw! Wanted to ask , what is your take on microsoft certifications? (fresh in DA) :)

@alexright_data_analytics 2 месяца назад

Hey! Are you talking about this one? "Microsoft Power BI Data Analyst Professional Certificate" on Coursera? I haven't heart much about it, but it seems legit just my looking at the description

@Gyaanwala. 3 месяца назад

Hey , Alex I liked your video as you said that its your first video for data analyst. I'm a data analyst student and I started this course recently so , I think it will be very helpful for me if I watch your video or connect with you so you can give me proper guidance to become perfect data analyst. Thank you

@alexright_data_analytics 3 месяца назад

Hey! Glad you are on the way. How specifically could I help you?

@marcink6879 Месяц назад

I believe what you need the most is natural curiosity and urge to understand the world. If you don't desire to bring out the deeper meaning of things, what's your actual motivation then?

@alexright_data_analytics Месяц назад

For most people it is just surviving, just job, imho. But I believe it will not work very well for data analytics, long term

@ValentinArnaudov-7 29 дней назад

Thank you for being honest - that's better than the other stuff where someone can boost your motivation for a short period of time, telling you the things you want to hear, and then... reality hits. It's always good to help people and motivate them during this journey, but in the right way, and telling the things the way they are.

@alexright_data_analytics 29 дней назад

Really well pointed re the temporary motivation boost. It works exactly like that when things are sugar coated

@thoratpriyanka16 2 месяца назад

You look cute explaining that..love the quality of the content too.

@alexright_data_analytics 2 месяца назад

Glad you enjoy it!

@america55pp 2 месяца назад

i’m graduating w a masters this december in business analytics, how many projects should I have to showcase my work in my resume? Alsoooo Is there any job searching places you recommended or companies to work for? Nice video!

@alexright_data_analytics 2 месяца назад

Cool that you are making progress. Go for 5-10 projects. Search on LinkedIn. Also go on the companies website (those companies you admire), search for some contacts there and apply actively. Even if they are not hiring

@xhotdog100 Месяц назад

Thanks for mentioning soft skills as I was wondering about this. I plan on leaving my current field and going into DA due to my social anxiety. In your opinion, how much of the job success as a DA comes from technical skills versus. soft skills, if you must put a number on it? 50 50? 80 20? Thanks! And, what are your thoughts on boot camps?

@alexright_data_analytics Месяц назад

It depends. Generally it is more soft skillish than back-end developer role or so. I would say from 50/50 to 80/20 hard/soft. Have nothing against bootcamps, especially if they give real knowledge and credibility

@xhotdog100 Месяц назад

@@alexright_data_analytics thank you for your quick reply!

@ilugu 21 день назад

i’m someone who is searching something to be more in the backend. did a BA in data & service engineering. what do you advice me? is data engineering more off from all this communivative work?

@alexright_data_analytics 20 дней назад

Yes, I think so. Data engineering is if far more away from communication than data analytics

@marcelaperez7222 3 месяца назад

Loved this video! I'm starting as a business analyst, and analytical thinking is still challenging for me. I tend to panic every time someone brings a new project or question, and I have to figure out how to solve it. Does it ever get easier?

@alexright_data_analytics 3 месяца назад

Ohh, this is a good question. My hypothesis is that your panic comes from being afraid to fail. Being afraid to fail comes from insecurity. Insecurity comes from low experience, usually. However, with analytical thinking - it’s a skill you can not define clearly. You can not go through a course and you got it. You need practice, a lot of it. It is kind of magic that just happens after you applied it many times, somehow. My advise would be to get experience, go through panic at least 20 times but solve the problem, then knowing that you have the experience, just give your brain the space to apply it. It should happen naturally. Even if you can’t solve the problem immediately, the answer is on its way and will appear in your mind during a casual walk or so. So, 1) Get experience, go through some pain; 2) Do not control, allow; 3) Do not overthink or force, trust the brain; 4) Over time, it will appear more and more naturally. imho

@emilyau8023 2 месяца назад

@alexright_data_analytics you're so reasonable. I wish most people used their brain like this.

@alexright_data_analytics 2 месяца назад

@emilyau8023 I wish I could use that brain in everyday life more often, not only on videos 😊

@velloer 2 месяца назад

Awesome

@alexright_data_analytics 2 месяца назад

Thanks!

@kwagalashalom4717 16 дней назад

Hello, thank you so much for the video, I'm studying on coursera though i have no degree yet, can I join an online university for a degree? Is it accredited or it needs a physical class?, thank you.

@alexright_data_analytics 16 дней назад

It all depends on the credibility of the university. Online university with higher credibility is better than no-name one offline, imho.

@Kxuyi Месяц назад

First of all, a very informative, helpful, and honest video. I do have a question about the job of a Data Scientist. I am currently close to graduating from school and I am planning to study Data science at the University of Applied Sciences. I am interested in the field of Data Science, however, I am not the most skilled when it comes to presentations or PowerPoints. I actually try to avoid them if I can. As I saw after investing some time into this topic and as mentioned in this video as well, soft skills/ communication skills are very important later in the job. Do you think a career on this path is still possible/ realistic for me? I would like to focus more on the technical part, similar to a software engineer, and less on the communication part, as I am not a good speaker.

@alexright_data_analytics Месяц назад

Hey! Thank you for the positive feedback. To answer your question, I see that you are mentioning that you want to become a data scientist, not a data analyst. In this video, I focus specifically on becoming a data analyst. I believe that for data analyst positions, soft skills are crucial. But for data science, it could be different. A data scientist could be focused more on technical stuff, and if you are very good at it, it could be the case that you might be doing that most of your time, although soft skills are also important, but not that crucial as for data analyst role, A data analyst is usually in contact with business directly. A data scientist is more like a developer, who is less demanded on soft skills. So, I think if you want to be a data scientist, soft skills are less of importance in comparison to hard skills.

@john3sixteen870 2 месяца назад

Thanks bro! Really help me especially on someone just starting on this career path. Subscribed!

@alexright_data_analytics 2 месяца назад

Glad to hear it!

@linseyk5728 23 дня назад

A lot of the job posting is my area (remote) for data analysts do not reqiure a degree. Great salaries.

@alexright_data_analytics 23 дня назад

I would be surprised by that. Which area is that? And what do they actually require?

@linseyk5728 22 дня назад

@@alexright_data_analytics Western Canada. 0-3 years technical experience. Proficient in Python, Excel, SQL, etc. Think creatively. Strong communication skills. Min point salary: $91,800 CAD. Max salary $133,000.

@linseyk5728 22 дня назад

@@alexright_data_analytics Western Canada. 0-3 years experience. Proficient in SQL, Excel, Python, etc. Good communication skills. Ability to think creatively. Min salary: $91k CAD. Up to 130k. That is one example.

@linseyk5728 22 дня назад

@@alexright_data_analytics Western Canada. 0-3 years experience. SQL, Excel, Python, etc. Good communication skills. Ability to think creatively. Min salary: $91,800 CAD UP Max: 133K

@linseyk5728 22 дня назад

@@alexright_data_analytics I cannot reply. My comments keep getting deleted.

@ashbestos9071 Месяц назад

Do you have any advice for somebody with a non-stem or business degree looking to get into data analytics? I have a bachelors in radio-tv-film and a varied career history. Should I pursue a graduate degree in data analytics?

@alexright_data_analytics Месяц назад

It depends. One's situation should be analysed to give a solid advice. Generally, if you had something related to data in your previous experience, some quality courses might suffice to make it convincing that you could be a good DA candidate. If you have nothing to show related to data, a degree might be an option

@kimh8990 2 месяца назад

Would you mind sharing the schedule to keep practicing all skill, maintaining them?

@alexright_data_analytics 2 месяца назад

Not sure, what do you mean. Could you please clarify?

@kimh8990 2 месяца назад

@@alexright_data_analytics I mean how to make a plan to keep practicing every skills. When I focused on Python, I would forget others. (SQL, R, Power BI, etc.)

@alexright_data_analytics 2 месяца назад

I plan to create end to end study projects involving all the tools. So stay tuned

@usmanyousef1949 Месяц назад

How many of you all got into data for the love of data- out of curiosity? I understand aligning myself for success but I truly want to make myself more valuable to better support myself and my family.

@alexright_data_analytics Месяц назад

So, no intrinsic motivation basically?

@aissalamin9528 Месяц назад

Currently, I'm in the process of deciding to do more and more data analytics projects, and I think my best motivation would be to start generating side income and to feel the fulfillment of completing a project for someone as a freelancer, but I am not sure how to get my first freelancing job offers or how to take this route. Any Advices.

@alexright_data_analytics Месяц назад

Hey! Cool that you are up for creating value and getting fulfilment from it. Did you try freelancing platforms like "upwork"?

@yashikjain-0611 2 месяца назад

too good

@alexright_data_analytics 2 месяца назад

Tnx

@therealmcgoy4968 4 дня назад

Could you become a data analyst if you have experience as a database administrator or work in other various IT roles? My school offers Data Analytics as a concentration with an IT degree (which I’m pursuing)…. I’m stuck between cybersecurity and data analytics. I plan on taking courses in both either way but kind of leaning on data analytics.

@alexright_data_analytics 3 дня назад

Yeah. Pretty much any data related experience is a plus, especially experience as a database admin. Btw, why data analytics? What is about it you particularly like?

@user-co4wn3cj2d 3 месяца назад

Can you make a video on how to gain domain knowledge for data analyst and what topics of Statistics to be covered. Would be really helpful

@alexright_data_analytics 3 месяца назад

Thanks for the idea. Will add to my backlog 😌

@user-co4wn3cj2d 2 месяца назад

@@alexright_data_analytics waiting for the video about domain knowledge and Statistics

@SeiduMohammed-et7hh 2 месяца назад

This a great video. Can I share your link on twitter for aspiring data analyst to learn from?

@alexright_data_analytics 2 месяца назад

Yes, sure!

@mariannabravo8208 Месяц назад

I am starting my Journey I have 15 years experience in Supply Chain Management and I want to move to other position within Data Analyst, Can you recomend a Good Platform and the courses ? there are so many options Thank you for your video I like to be real about learning it takes time and effort

@alexright_data_analytics Месяц назад

Ohh good luck! I think I recommended the platforms in the video. Or would you like to know something more specific?

@yogamayaa Месяц назад

How come you didn't talk about networking? I have all of the pointers you covered and still not even getting single phone screen. When I asked people, they told me I need to network. But again networking is with total strangers who may become eventually willing to get you a referral maximum. Even with referrals I have had rejections. So I am deeply confused. I have project portfolio, resume tailored to every job I apply, cover letter and a well maintained Linekdin. What is missing according to you?

@alexright_data_analytics Месяц назад

Hey! I understand your struggle. I do not think networking is super important for data analysts. You can showcase your skills, unlike some manager or so. To answer your question, you particular situation should be assessed. But from what you say,iIf I would be in your shoes, first I would do, I would make sure I am not biased re my portfolio, CV, soft skills. Try to show your portfolio, CV etc to someone in the field. What is their opinion on that? Anything to improve? Or work with a career advisor. Also, I would train job interviews with someone to make sure my soft skill is good, at least for the interviews

@MichaelNgotho 2 месяца назад

My intrinsic motivation: To Work through healthcare sector problems through analytics

@alexright_data_analytics 2 месяца назад

Meaning, helping people with their health by contributing through data analytics within the healthcare industry? Yet, it still sounds like extrinsic motivation. You use data analytics as a tool to reach some goal. Do you think you would enjoy the process of it? Moving data around, etc.

@MichaelNgotho 2 месяца назад

@@alexright_data_analytics thanks Alex for refining this for me. I do love moving and wrangling with data and finding. I do love data work.

@sumanzia9874 3 месяца назад

Really Informative Video

@alexright_data_analytics 3 месяца назад

My pleasure

@sushugowda5743 2 месяца назад

My motivation is Money and slowly I want to switch to Data science and ML/AI. What do you think? Also I have 4 years experience in sales and Marketing

@alexright_data_analytics 2 месяца назад

I do not think money is a good motivation. It won't work long term. Why would you like to switch to data science though? For more money? 😊