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

Sdílet
Vložit
  • čas přidán 1. 06. 2024
  • 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

Komentáře • 351

  • @alexright_data_analytics
    @alexright_data_analytics  Před 2 měsíci +37

    🙋‍♂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
      @nimishchougule851 Před 2 měsíci +1

      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
      @alexright_data_analytics  Před 2 měsíci +1

      @@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
      @anshumansingh4669 Před 2 měsíci +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
      @alexright_data_analytics  Před 2 měsíci +2

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

    • @Dhdiebwhdbeodhs
      @Dhdiebwhdbeodhs Před 2 měsíci +1

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

  • @vikadorofeeva7438
    @vikadorofeeva7438 Před 3 dny +3

    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
      @alexright_data_analytics  Před 2 dny

      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

  • @chimpwnzee
    @chimpwnzee Před měsícem +6

    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. :)

  • @MySisao
    @MySisao Před 10 dny +4

    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
      @MySisao Před 10 dny +1

      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
      @alexright_data_analytics  Před 10 dny

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

    • @harshddesai
      @harshddesai Před 6 dny

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

    • @MySisao
      @MySisao Před 6 dny

      @@harshddesai Get good at SQL transformations

  • @emilyau8023
    @emilyau8023 Před 2 měsíci +72

    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
      @alexright_data_analytics  Před 2 měsíci +12

      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
      @Dee-zy2xv Před měsícem

      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
      @alexright_data_analytics  Před měsícem +4

      @@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
      @vazdabilo6983 Před měsícem

      ​@@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
      @alexright_data_analytics  Před měsícem +2

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

  • @as_below_so_above
    @as_below_so_above Před 19 dny +8

    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
      @miaomao1449 Před 18 dny +1

      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
      @alexright_data_analytics  Před 18 dny +1

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

    • @alexright_data_analytics
      @alexright_data_analytics  Před 18 dny +1

      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
      @dhondup10 Před 11 dny +1

      @@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
      @alexright_data_analytics  Před 11 dny

      @@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
    @gennadiichelak Před 2 měsíci +12

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

  • @eclipse.241
    @eclipse.241 Před 8 hodinami +1

    Thanks for the good hints!

  • @NikkieMullet
    @NikkieMullet Před měsícem +7

    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!

  • @Ceasbot
    @Ceasbot Před 2 měsíci +7

    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
      @alexright_data_analytics  Před 2 měsíci

      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

  • @SiloSolvent
    @SiloSolvent Před měsícem +7

    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.

  • @batuwka9796
    @batuwka9796 Před 2 měsíci +11

    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
      @alexright_data_analytics  Před 2 měsíci +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

  • @pseudoplatanus6855
    @pseudoplatanus6855 Před 2 měsíci +9

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

  • @southpaw_mechanics
    @southpaw_mechanics Před 2 měsíci +8

    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
      @alexright_data_analytics  Před 2 měsíci +1

      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

  • @donaldmacdonald4901
    @donaldmacdonald4901 Před měsícem +5

    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
      @alexright_data_analytics  Před měsícem

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

    • @donaldmacdonald4901
      @donaldmacdonald4901 Před 29 dny

      @@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
      @fattmeows8868 Před 18 dny +1

      All the best!

  • @frankdosu4651
    @frankdosu4651 Před 2 měsíci +4

    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.

  • @slckaz1183
    @slckaz1183 Před 2 měsíci +2

    Clear and concise thank you Alex

  • @santhoshkumar8143
    @santhoshkumar8143 Před měsícem +2

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

  • @karolczi8069
    @karolczi8069 Před měsícem +2

    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.

  • @saeidk736
    @saeidk736 Před 27 dny +4

    ok Finally Someone who actually talks some REAL SENSE

  • @fecorreas
    @fecorreas Před 2 měsíci +2

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

  • @user-ns9gz3ov2l
    @user-ns9gz3ov2l Před 2 měsíci +1

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

  • @johndaniel7569
    @johndaniel7569 Před 2 měsíci +2

    Awesome kick start!! Eager for the upcoming Edu Videos

  • @Jfindingale
    @Jfindingale Před měsícem +1

    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.

  • @octagonmixltd
    @octagonmixltd Před 25 dny +1

    Wow!
    Motivated. Thank you.

  • @itsjustme684
    @itsjustme684 Před 2 měsíci +1

    You are insightful here. Great one!

  • @frontire_ace
    @frontire_ace Před 18 dny +2

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

  • @michaels2208
    @michaels2208 Před měsícem +5

    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.

    • @rosetwins2x2
      @rosetwins2x2 Před měsícem +3

      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
      @michaels2208 Před měsícem +2

      @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
      @alexright_data_analytics  Před měsícem +3

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

    • @fattmeows8868
      @fattmeows8868 Před 18 dny +1

      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
      @michaels2208 Před 18 dny

      @@fattmeows8868 thank you

  • @ChibuzorNwakasi
    @ChibuzorNwakasi Před 2 měsíci +4

    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
      @alexright_data_analytics  Před 2 měsíci +1

      Thank you and good luck!

    • @idanartzi3526
      @idanartzi3526 Před měsícem +1

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

    • @ChibuzorNwakasi
      @ChibuzorNwakasi Před měsícem

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

  • @marketingsolutions6691
    @marketingsolutions6691 Před 6 dny +1

    Thank you so much for providing all this information.

  • @chatbass2468
    @chatbass2468 Před dnem +1

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

  • @kylerowland1227
    @kylerowland1227 Před měsícem +2

    Thank you for realistic expectations

  • @relaxingtunes3779
    @relaxingtunes3779 Před 2 měsíci +1

    Thank you!
    Very much on point!❤

  • @xevilman1
    @xevilman1 Před 2 měsíci +1

    Very clearly presented.

  • @m00nlyter
    @m00nlyter Před měsícem +1

    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
      @alexright_data_analytics  Před měsícem +1

      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

  • @Axel-vt8no
    @Axel-vt8no Před 4 dny +1

    Great video!

  • @blessingagbamoro4300
    @blessingagbamoro4300 Před 12 dny +1

    This was really good
    Thank you

  • @fernandoortiz6026
    @fernandoortiz6026 Před měsícem +7

    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
      @alexright_data_analytics  Před měsícem

      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

  • @descubriendopatronesML
    @descubriendopatronesML Před 2 měsíci

    I absolutely agree with all being said on this video, really liked the focus you did since most videos of this kind refers to programming languages. I got a job in a little US Company as Data Analyst, I am not a native english speaker but i trust on non language barrier, language should be not even a barrier for getting the job you desire to get.

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci

      Thanks for the feedback! What do you think about the “intrinsic motivation” point? What is your intrinsic motivation? Would be interested to hear

  • @alecantropo98
    @alecantropo98 Před 2 měsíci +1

    Nice video, waiting for more! Subbed

  • @ericrobbins6953
    @ericrobbins6953 Před 2 měsíci +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
      @alexright_data_analytics  Před 2 měsíci +3

      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
      @ericrobbins6953 Před 2 měsíci +1

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

  • @TradewithRaymond
    @TradewithRaymond Před 2 měsíci +2

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

  • @Durio_zibethinus
    @Durio_zibethinus Před měsícem +1

    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
      @alexright_data_analytics  Před měsícem +1

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

    • @Durio_zibethinus
      @Durio_zibethinus Před měsícem +1

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

  • @ShahZ
    @ShahZ Před 2 měsíci +1

    Well done Dude

  • @RT-mn2pb
    @RT-mn2pb Před měsícem +1

    Yes, Alex this was a good video. I like your serious and down to earth demeanor and attitude. Too many CZcams 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
      @alexright_data_analytics  Před měsícem

      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

  • @Sreshta7
    @Sreshta7 Před 2 měsíci +2

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

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci

      Thanks for the feedback!

    • @Udom_soup
      @Udom_soup Před 2 měsíci +1

      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
      @alexright_data_analytics  Před 2 měsíci +1

      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
      @Lynn-pp8vn Před měsícem +1

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

  • @elmersumalinog8944
    @elmersumalinog8944 Před měsícem +1

    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

  • @lexycruz1
    @lexycruz1 Před měsícem +1

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

  • @kellymyshrall3006
    @kellymyshrall3006 Před 26 dny +2

    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!

  • @iam_topg
    @iam_topg Před 2 měsíci +1

    Thanks bro for your content

  • @abdihassan6715
    @abdihassan6715 Před měsícem +1

    Awesome work so refreshing as former data analyst turned network engineer

  • @maria_erams
    @maria_erams Před 2 měsíci +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
      @alexright_data_analytics  Před 2 měsíci +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
      @maria_erams Před 2 měsíci +1

      @@alexright_data_analytics Thanks, Alex!

  • @rbbautista5814
    @rbbautista5814 Před měsícem +1

    Thank you

  • @ABFPV584
    @ABFPV584 Před měsícem +2

    30 seconds in and I love this guy

  • @YarynaBeley
    @YarynaBeley Před měsícem +1

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

  • @pepperpeterpiperpickled9805
    @pepperpeterpiperpickled9805 Před 2 měsíci +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
      @alexright_data_analytics  Před 2 měsíci

      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
      @pepperpeterpiperpickled9805 Před 2 měsíci +1

      @@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
      @alexright_data_analytics  Před 2 měsíci +1

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

    • @pepperpeterpiperpickled9805
      @pepperpeterpiperpickled9805 Před 2 měsíci +1

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

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci +1

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

  • @vaikunthavaasanravinarayan9150

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

  • @hailekassaye434
    @hailekassaye434 Před měsícem +1

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

  • @rossita6634
    @rossita6634 Před měsícem +1

    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
      @alexright_data_analytics  Před měsícem

      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

  • @doc2407
    @doc2407 Před měsícem +1

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

  • @yunikartika8215
    @yunikartika8215 Před 8 dny +1

    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?

  • @mimi.1.
    @mimi.1. Před 2 měsíci +1

    New subscriber 🦋

  • @gopichand2
    @gopichand2 Před měsícem +1

    Great

  • @MS-wy4sb
    @MS-wy4sb Před 2 měsíci +1

    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
      @alexright_data_analytics  Před 2 měsíci

      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
      @MS-wy4sb Před 2 měsíci +1

      @@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
      @alexright_data_analytics  Před 2 měsíci

      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

  • @FEVERNOVAA
    @FEVERNOVAA Před 2 měsíci +1

    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
      @alexright_data_analytics  Před 2 měsíci

      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

  • @Gyaanwala.
    @Gyaanwala. Před 2 měsíci +1

    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

  • @idanartzi3526
    @idanartzi3526 Před měsícem +1

    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
      @alexright_data_analytics  Před měsícem +1

      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.

  • @distruktiv8504
    @distruktiv8504 Před měsícem +1

    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.

  • @ValentinArnaudov-7
    @ValentinArnaudov-7 Před 21 dnem +1

    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
      @alexright_data_analytics  Před 20 dny

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

  • @thoratpriyanka16
    @thoratpriyanka16 Před 2 měsíci +1

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

  • @velloer
    @velloer Před měsícem +1

    Awesome

  • @ustvb7_4326isg
    @ustvb7_4326isg Před měsícem +2

    Spitting facts

  • @xhotdog100
    @xhotdog100 Před měsícem +1

    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
      @alexright_data_analytics  Před měsícem +1

      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
      @xhotdog100 Před měsícem +1

      @@alexright_data_analytics thank you for your quick reply!

  • @ilugu
    @ilugu Před 13 dny +1

    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
      @alexright_data_analytics  Před 12 dny

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

  • @marcobarroso-xv8eq
    @marcobarroso-xv8eq Před měsícem +1

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

    • @alexright_data_analytics
      @alexright_data_analytics  Před měsícem +1

      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

  • @kwagalashalom4717
    @kwagalashalom4717 Před 7 dny +1

    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
      @alexright_data_analytics  Před 7 dny

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

  • @user-co4wn3cj2d
    @user-co4wn3cj2d Před 2 měsíci

    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
      @alexright_data_analytics  Před 2 měsíci +1

      Thanks for the idea. Will add to my backlog 😌

    • @user-co4wn3cj2d
      @user-co4wn3cj2d Před 2 měsíci +1

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

  • @marcink6879
    @marcink6879 Před měsícem +1

    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
      @alexright_data_analytics  Před měsícem

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

  • @sumanzia9874
    @sumanzia9874 Před 2 měsíci +2

    Really Informative Video

  • @marcelaperez7222
    @marcelaperez7222 Před 2 měsíci +2

    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
      @alexright_data_analytics  Před 2 měsíci +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
      @emilyau8023 Před 2 měsíci +1

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

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci +1

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

  • @america55pp
    @america55pp Před 2 měsíci +1

    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
      @alexright_data_analytics  Před 2 měsíci

      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

  • @linseyk5728
    @linseyk5728 Před 14 dny +2

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

    • @alexright_data_analytics
      @alexright_data_analytics  Před 14 dny

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

    • @linseyk5728
      @linseyk5728 Před 14 dny

      @@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
      @linseyk5728 Před 14 dny

      @@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
      @linseyk5728 Před 14 dny

      @@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
      @linseyk5728 Před 14 dny

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

  • @ashbestos9071
    @ashbestos9071 Před měsícem +1

    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
      @alexright_data_analytics  Před 29 dny

      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

  • @Kxuyi
    @Kxuyi Před měsícem +1

    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
      @alexright_data_analytics  Před měsícem

      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.

  • @yashikjain-0611
    @yashikjain-0611 Před 2 měsíci +2

    too good

  • @kimh8990
    @kimh8990 Před 2 měsíci +1

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

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci

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

    • @kimh8990
      @kimh8990 Před 2 měsíci +1

      @@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
      @alexright_data_analytics  Před 2 měsíci +1

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

  • @holasoynico165
    @holasoynico165 Před měsícem +1

    Do you think i can get a job even if im persuing a degree in "other field", like bussines administration ? thanks

    • @alexright_data_analytics
      @alexright_data_analytics  Před měsícem

      Yes, I think so. Because DA is only partially technical. Another part is soft skill and business knowledge

  • @aissalamin9528
    @aissalamin9528 Před měsícem +1

    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
      @alexright_data_analytics  Před měsícem

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

  • @maryreprado
    @maryreprado Před měsícem +1

    great video!! ☺🙌 can you please deep dive on the public speaking part? 🔝 How to tell a good story with data?

  • @yogamayaa
    @yogamayaa Před měsícem +2

    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
      @alexright_data_analytics  Před měsícem +2

      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

  • @mariannabravo8208
    @mariannabravo8208 Před 22 dny +1

    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
      @alexright_data_analytics  Před 22 dny

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

  • @mildlyinfuriatingfox
    @mildlyinfuriatingfox Před 13 dny +1

    That actually encouraged me to keep learning and continue on this pathway haha
    I study industrial engineering, but want to start working a more meaningful, serious job, because life won't wait for me and I didn't finish my first degree choice 🥲
    I think those two blend together well and I'm genuinely interested both by the topic and learning about it.
    In a sense I've always thought going into this that my soft skills are actually what can save me a little bit, over the fact that I'm not ultra technical, but I do not mind working in a non-fancy position at first ^^
    I'm hoping my experience working with stakeholders, although in a different position might be beneficial and reassuring.
    We will see how it goes, but you did make some good points and thankfully it reassured me more than scare me away 😀

  • @sushugowda5743
    @sushugowda5743 Před 2 měsíci

    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
      @alexright_data_analytics  Před 2 měsíci

      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? 😊

  • @MichaelNgotho
    @MichaelNgotho Před 2 měsíci +1

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

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci

      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
      @MichaelNgotho Před 2 měsíci +1

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

  • @usmanyousef1949
    @usmanyousef1949 Před měsícem +1

    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.

  • @SeiduMohammed-et7hh
    @SeiduMohammed-et7hh Před měsícem +1

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

  • @syedwahab14
    @syedwahab14 Před měsícem +2

    My motivation is coming back home rather than living out of a suitcase

    • @alexright_data_analytics
      @alexright_data_analytics  Před měsícem

      What do you mean by that?

    • @syedwahab14
      @syedwahab14 Před měsícem

      @@alexright_data_analytics My current job requires me to travel around the world. Move from country to country for different projects. Having done 10 years of this, I want a change in my life and some stability. That is my motivation for learning data science/machine learning

    • @alexright_data_analytics
      @alexright_data_analytics  Před měsícem

      @@syedwahab14 I see. Good luck!

  • @OutTech-Learn
    @OutTech-Learn Před 2 měsíci +1

    Great content Alex. Very insightful. Is there a way to contact you for further information 🤔

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci

      Just state your question here in the comments. I will certainly reply

    • @OutTech-Learn
      @OutTech-Learn Před 2 měsíci +1

      I wanted to know more about your thoughts on English lessons as a valuable skill. So it might be a bit nuanced for a YT comment. Do you have research, personal experience or insider knowledge on how valuable it is truly?

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci

      @@OutTech-Learn I am not sure I understand. What is exactly valuable? And valuable for what?

  • @adilnaeem7928
    @adilnaeem7928 Před 2 měsíci +1

    Great Piece of Advice. As a college drop out, how can i pursue in Data Analytics?

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci +1

      Thanks for the feedback. Could you please clarify what do you mean by saying “pursue in Data Analytics”?

    • @adilnaeem7928
      @adilnaeem7928 Před 2 měsíci +1

      As I don't have any degree, What is the process from zero to expert in Data Analysis to finally land a job without having a degree?

    • @alexright_data_analytics
      @alexright_data_analytics  Před 2 měsíci +1

      @@adilnaeem7928 6:24 - an on, I am mentioning what I would do in this situation

    • @adilnaeem7928
      @adilnaeem7928 Před 2 měsíci +1

      @@alexright_data_analytics Thanks

  • @kiwifrenchie6036
    @kiwifrenchie6036 Před měsícem +1

    What is the path to learn? I finished mechanical engineering masters degree but want to switch to IT