Don't be a Data Analyst if: 1. Not a self-learner, ability to learn on the go is weak. 2. Getting frustrated very easily. 3. Manual work - Data can be tedious. 4. Working with people. 5. If you think being a Data Analyst will get you rich quick.
welp, fml, i hate working with people (as in having to pretend that i care about their personal life). and i only work because i want to get paid then go to home to sleep. i'm fine with doing honest work and working hard, but seriously, there's more to life than your boss' stupid visions (no offense).
It's just sad that people feel the need to discourage others from a field by using phrases like, "if you think being a data Analyst will get you rich quick". It's just not relevant, I've worked In the software industry for years now, I've met loads of good people that are only in the industry for money. They aren't bad programmers... In many cases they were better than me. The thirst for money is irrelevant, and is actually a hobby for some people, especially those who trade stocks and currencies. What matters is the discipline you have to sit down and do the same thing for 9 hours a day, 5 days a week. I think these youngsters are being lied to by insecure people like you, being told they have to be special to get into tech. It's a load of rubbish, the tech industry is the fastest growing industry to ever exist. Come into tech if you want a good salary! Come if your interested in computers and math, come if you don't want to do physical labour. Trust in yourself, it takes years but anyone can get there.
To be fair, regarding reason #4, that is true of a lot of jobs. I can’t think of a job that doesn’t involve a lot of people/communication work. As an introvert I honestly don’t particularly like team work, but it’s a very fundamental condition of work life to learn how to work with others. :)
I am an introvert as well. And true, working in a team could be very exhausting. But the best part of being an introvert is the fact that we re-energize when were alone.
I'm an introvert and I have anxiety and I managed to hold a speech in front of 800 people. Honestly, it's just a matter of confidence, even if you're faking it (til you make it). It works because extroverts have no clue what's happening inside themselves or other people lol.
Man you just saved my life with point number 4. I was thinking about branching out into this field BUT... I just can't work with multiple people day in day out. Messaging, emailing, texting, zoom/skype, tons of emails back and forth, making presentations, going over and over discussions and not getting anywhere for weeks sometimes months... ah I'm having an energy drain/ micro panic attack just thinking about that stuff. I've had a marketing and advertising career that spans 13 years and I've done all of the above. All that's left of my candle now, is the wick.
I have gotten economics degree and am just trying to make my first steps in the field, I have accidentally stumbled upon your channel and just wanted to thank you so much, because it seems a bit daunting and lonely at times, but looking at your talking about it I understand I am not alone, and there bound to be a community that can provide help and advice Thank you for your work!
I'm an economist and have worked full-time for almost 2 years now. I am an analyst in a mayor bank in my country. What secured my position was coding knowledge and that I did machine learning in my thesis. As I'm a lot more interested in coding and problem solving than actual "economics" I will probably try to move towards Bering more of a data engineer than a data analyst.
Spot on! On top of being a self learner, you have to be good at problem solving and have lots of patience! There are tasks that are difficult and pricey to automate. Doing manual work is inevitable, which is why you need to be strategic in finding ways to optimize your workflow and reduce time to do manual work. Data preparation takes time and is vital and a good practice prior to creating reports/visualizations through dashboards, for instance. Anyhow, nice video Alex!
Tbh, I started learning few months ago and I’m already frustrated, I actually hate it. I’m impatient and sometimes doing data and coding just feels redundant to me, I definitely should have chided another tech specialty
I was about to say I only am watching this video because I realized that after graduating with a computer engineering degree, engineering and coding are not for me because I get frustrated so easily and tend to have little patience...
Almost every engineering major nowadays requires programming. I remember the first time my parents told me about college and when I got in it is very different from my expeectation and idk how I feel about that. Different era from my parents, nowadays we have computers in our hands.
As an Econ student this is a career I've been eyeing and this video sealed the deal for me. Whether I am good at it or not I wont know until I try, but I am 100% I want to give it a fighting chance. Thank you!
@@barbaraa5538 too many options Barbara! Eventually I’m going back to school for my masters. But I need to get back out there. Hopefully data analysis is the right track ❤️
I've started in data analysis less than a year now and the first 3 reasons kind of summarized what i've been through. Learning by myself is a joy. Manual work sometimes makes me feel dumb because I always feel that i should do something to automate it and save time, but it's clear now that sometimes is unavoidable. Handling frustration is something to work on, but is also part of the journey. This video is trully awesome and helped to handle better my understang of being a DA. Thanks for sharing. Great content on your channel.
@@Ellie80681 Hello LE, I just started out as a data analyst and I stumbled upon this comment of yours. I would like to be friends and learn from you. You could outsource some menial jobs to me and I am willing to do them for free so that I can get a hands-on experience of the core aspects of Data Analytics. The journey has been a bit lonely because I am mostly self-learning. I believe the presence of a tutor/mentor in my life would make a lot of difference. I am prepared to do all the hard work. I would appreciate a reply 😊. I hope you consider this request.
All of these points really hit home for me. Great video and spot on. High tolerance for frustration is so very important. At my current company, I've had managers sit beside me as I did analysis, or they did an analysis as I walked them through it. They just about always get mad ... at me, at themselves, and at their computer. Few people are patient enough to sit through hours of trial and error cleaning, documenting, rearranging, and visualizing data. They usually just want that final output and they want it yesterday, even if it's a complete mess that won't make sense after a night's sleep.
I am in an analytics role for a large Corp. I often get tasked with creating analysis on financial data that the financial analysts do not have the technical capability to execute. I primarily use 3 technology components to do this: 1. Writing code to extract data from the source 2. Use of an analytical modeling tool such as SPSS modeler or Alteryx 3. Visualization of the results in cognos Number 2 in the list above is where all of the “magic” happens. I feel It allows me to appear much smarter than I actually am. Access and the use of tools like that are key to separating yourself from the many people that have advanced excel skills, which is a large number of people. Hope this helps!
@@Kaan-yq9bl I’m not a good judge of pay as I am a consultant by trade with 20 years experience and have worked for several big name companies. My pay is reflective of doing lots of different things, There are so many data jobs out there.....lot of opportunities
I have a BA in mathematics and I’m leaving the teaching profession. I can tell you that 70+k /yr is good money compared to teaching. Thank you so much for all your videos, this convinces me I’d be perfect as a data analyst 😊
I also have a degree in math/economics and am trying to move away from teaching! I am currently taking a data analytics graduate certificate course to help make this change!
@@reetjatti1 I did the Harvard business school online graduate certificate in business analytics and in July I’ll be doing the graduate certificate in Data science with SQL and Tableau! I loveddd the business analytics program!!! Highly recommend!!
No. Don't become a doctor because you WILL have to BETRAY Hypocrates and the words "Do not harm". As you will no choice but become a Big Pharma puppet after 1000s in loan, you will be stuck and you can't disappoint your parents either by leaving a career that gives you prestige.
The more i watch your videos the more i appreciate them. Im enrolled onto a MSc Data Science course- now 5 weeks in. Ive already fallen behind from needless distractions. Your final point really hit home. Keep it coming. I do feel that this channel is necessary for me right now and will be all year to come.
Good idea to make people aware. That said, people can change. If you really want to be a data analyst then Alex has laid out the things you need to master along with the software.
James Sepello absolutely, these are things just to be aware of - none of them are dealbreakers where I think you cant be a Data Analyst. I think it’s just something people should think about before investing a lot of time and money into it.
This is me every day, only one exception, I LOVE to automate the analysis, I love to program the algorithm to avoid 3 or 5 days or work, I am probably addicted to Tylennol, when you are a data analyst must of the time you spend it thinking and writting the problem, testing it once, twice, or more, but just a few of us enjoy the moment when you find the proper algorithm, it is like finding the vaccine fpr covid hahah
I hear where you're coming from. I spent 4 years as a mature student getting my degree in psychology with the hope of a social care job. Every person from my class who went into it has been physical attacked numerous times (two wound up in hospital and one was sexually assaulted). I'm now enrolled on a higher diploma in data analytics - a lot safer...I hope. :)
WOW JUST WOW!! God Bless all and everyone who does social work. Yall doing the Lord's work out here FOR REAL!! Thankfully U have escaped such an experience that your peers have. Best wishes for you in Data Analytics!!
I hear you. I have a Master's in social work, have been in it for a decade, and now I'm fleeing to a new field. I did my part for humanity and now I'm DONE. 😂
The scariest day was when my husband who is a mental health clinician went on a client call and the man had a gun. It all turned out fine, no one was hurt, but not a fun phone call. It's been so much more calm now since he just does virtual appointments from home.
Hi Alex! I'm so happy I've found your channel. I am also a doctor and I've been struggling lately. For the last 2 years I've been considering changing my career as it doesn't suit me at all. I realised that the only thing that made me stay up all night was to do the statistical analysis for my dissertation. So, I'm starting to consider a career in data analysis and I'm finally ready to do it. I'll be using your videos to start studying. Thanks for the opportunity
I'm not really fan of the rhetoric currently circulating around telling people they can't do something because their not "motived by learning", or aren't easier fustrated... No. You can do anything. Even if you hate it and just want the money, you can still do it and be good at it too. Don't listen to these tech guru's telling you that you have to be special to do what *they* do. They are not special, they are not unique, they are mostly narcissistic and have their own insecurities. Computers are a tool, it doesn't matter if you're into data analysis, forensics, software development, networking. It's just a tool. And anyone can learn to use it. Get a 2:1 computer science degree and the world is your oyster.
I actually took your recommendation to take the Google analytics course to try to learn this and it is absolutely true that you start off confused and frustrated. I check like 3 of of the 5 reasons why I should not be a data analyst.lol However, I find the skills of data analyst useful in other parts of life so I will just learn it as a hobby. Thanks for the video.
I shared this video with my friend. We both are now more motivated than ever to become a data analyst. Thanks a ton!! Also the anecdotes really helped. Like the frustration part. Very true.
Another challenge could be when you have too many different managers asking for your help on different types of data inquiries/requests. Getting deep into thought on one project but being pulled abruptly to another project and so on can be rough sometimes but there are ways to address this or reprioritize projects. Loved the vid, thanks!
Thank you. This is the information I was looking for. I'm the most impatient person I know. However, I've trained myself to put that impatience "on a shelf" while I push through and get a project done. Am detailed oriented; B.Sci; math major. Will look further into this.
Thanks for sharing this! It is so true and data science/analyst might not be as sexy as we think! One of the most important characteristics is how to effect change management within the organization that you work in
Ive never liked anything ive had to do either as a job or at school. They should make more videos about ppl like that. Graduated with law degree. Hated law so i knew i wouldnt practice law. Now im 2 months away from graduating with 2nd bachelor, Business Informatics. And i was pretty sure that this is not for me, and I dont have the personality for it, but stuck with it coz i felt I "had to make it work". Went so deep that I decided to focus on ERP certifications, now im about to be SAP and azure certified. My first internship starting 1 June. I used to be so against just working for money or high pay, and that passion means a lot. Yet at this point in my life, i dont want to be 30 still working part-time jobs and studying, so money is the main priority.But all i really want to do is learn languages and travel, but i know thats a hard life with little reward. They really should make more videos for people like me
@@shoryacione5175 half the time I was on scholarship, and other half parents paid. Moved to Germany to do 2nd degree, where there are no student fees. Did anything and everything to avoid loans, debt free, always been.
That's true, I'm Data analysts, but most of time gathering inputs from people is tough job rather remaining work, its not not frustrating on work but on people I see. But your info is correct high tolerance needed even at escalation times .
@@AlexTheAnalyst If you have some bandwidth, I'd love to collab in a small way somehow this month. Comment on one of my videos if you wanna hash it out!
The rest I'm all for it. Except for the "You must learn on your own", like this is why I didn't want to become a Software Engineer despite being a CS student, there's only so much that I can learn alone.
This honestly helps me immensely. I always doubted if data analyst was a role I should do…it sounds awesome but damn I don’t think I would make it. Thanks you
I have worked in Project Controls and am a PM now. This is verbatim my life as a data oriented PM. I wait for data, clean the data, build reports and beg for people to help or software to capture and automate this. I don’t have time to build out the automation and I’m stuck doing the manual calculations all the time.
Thanks buddy for saving my money 💰 and time. I was very curious to join Data analysis PGP because of high salaries & great carrier opportunity but now when you explained reasons I am damn sure that this is not my cup of tea.
I want to be a data analyst and I’m about to begin my uni journey pursuing a degree in business economics & computer science. During this pandemic I learnt and still learning web development, a little python and Java all by myself!! Really tough but I worked and improved a lot! Want to learn sql soon too cuz it’s one of the core requirements .
Thank you. I've taken tests in college that said i would be good at data analysis but i do get frustrated easily. For the most part i am a self learner if i find it interesting such as excel. And monotony, no thank you. If something can be made more efficient that's what i strive for. I'm a fixer.
totally agree with you Sir Alex, I still hit my head with keyboard whenever assigned to a new project haha, so much new things too learn, at least for domain knowledge
I’m fine with everything except the communication part. I have pretty bad social anxiety and I am by no means assertive *sigh* I’m still going to give it a shot though.
You’re your own biggest critic and even those who seem unapproachable are generally happy to talk with people (figured that out). Anxiety is mostly irrational and can be accepted and overcame. Say hello to people :)
Yes vesides i have social anxiety like really bad and im becoming a counselor because i know how to ask people questions and gwt them to talk to me. Overall you will need to overcome your social anxiety to work in any job field
Full stack engineer in my previous companies need to be on call 24/7. I had a software dev who already left the office and was on her way home when one of the company's system crashed after deploying a fix and needed to come back to the office again.
You helped me a lot. I am in my fourth year of college and am thinking about my future career. Data Analyst is one of the directions I thought of. This video told me that this career path really might be a viable option.
As a business analyst in healthcare, when he said learning and working with python and sql, and hitting your head on your keyboard pretty much sums up my first year. It was and still is totally worth it.
Hi Alex, thanks for your great sharing! Insightful! I like and have much experience in self-learning, taking challenges, and working with people. The manual work is not as interesting as the rest part. But no pain no gain. The low salary at the beginning is all right for me. I care more about long-term career development. In 2017, I got to know we are stepping into the intelligent era and data is the new "fuel". Then I spent much time studying python, machine learning, statistics in hope of becoming a data scientist... The goal of becoming a data scientist seems unachievable at the moment due to the major and age. So I decided to land a data-analyst job and start my data career path this year.
@@tawhidasultana2808 Thanks for asking. I landed a job as a project manager in a data technology company, in which we implemented PowerBI dashboard, data warehouse for our customers (local, international).
@@brendali5803 many thanks for your reply mam. I also want to be a data analyst. I am studying master’s in IT management. I know SQL, Tableau, data scrapping…how can I step forward please?
Hi Mam, what were your challenges so far when you became a project manager? we're you able to transition yourself as a Data Analyst now or have you already enjoyed working in your current role?
@@IndividualExistence Hi Allan, I enjoy working in project manager role, which utilize much of my strength and experience. I've worked on four projects and reiceved compliments from my customers. The biggest challenges so far is to steer my way forward. It's hard to decide what is my priorities of study and tasks for my career development.
Very helpful. I'm learning on my own and it's really frustrating and tiring. Atleast I know it's normal. The passion for it is keeping me going. Will be like you someday. Thank you.
Mmm...once you said 'communication' and 'working with other people' it was like someone hit a nail in my heart. Thankfully becoming Data Analyst was just one career option for me, guess I'll continue looking for a career where I don't need to interact with other people.
I'm so sorry to hear that! I will say that even I sometimes fail on one of these. No one is perfect and won't have all of these boxes checked off. I hope everything works out for the best!
I get the impression you would make a wonderful coworker if I were an entry level analyst at your company. This video is like if you were coaching a junior analyst. In fact, you would make a great manager! And it would be awesome to be part of your team :)
Hi Alex. I’m Aida. 2nd year medical student in Malaysia. Though i love the idea of becoming a doctor, i dont think im willing to face another 15 years til i can become a specialised doctor. Plus, the job prospects as a doctor isnt that great here in my country. So i thought of going into data science. This is a big switch for me but I really hope I can do well :)
I have been a data analyst for 2 years now. FYI this guy is completely correct, I don’t like being a data analyst, and the random ad hoc requests that come on a strict deadline is such a pain. You might even get multiple such analysis and requests in one day with the same day delivery deadline. I really want to become a software engineer now. I am feeling fed up of this.
I am a software engineer. You really think, it is different here? We also have clients who think they can change requirements ten times through the project and just before the deadline. Some changes may take weeks to implement. Laughing my ass off. 😂
I'm actively trying to become a data analyst right and watched this video to see if I was in for something I didnt know! Your video actually strengthened my resolve to obtain this career. Anyone trying to get Rich working for someone else has a rude awakening lol
For those thinking on bailing out because of this video, DONT!! All those skills(communication skills, people skills etc) can be learn and if you persevere to learn them, they'll transform EVERY aspects of your life: - Marriage/ relationship -Confidence -Sence of accomplishment etc
I never want to discourage anyone from becoming a Data Analyst, but if these are things that they don't like or don't want to do it may be something for them to think about. I definitely agree that some of these things can be learned, but some people don't like social interaction or don't like learning on their own.
You can take SQL data and automatically put them into an R or Python data structure, then convert that to a CSV and boom it goes to Excel, though I don't know why you couldn't just stop at the R/Python level.
Jonathan C it’s definitely possible. You’d need to learn the right skills, but your experience as an accountant could be useful in maybe the financial industry.
You are correct, I am also an accountant too and missed out on a lucrative job offer because of data analysis and SQL, so I am learning that now using Cousera courses.
I was always a good student: at school, university or any other kind of course that I took in which I had to go to the place and had teachers/professors to help and etc. However, it was always a big challenge for me to study by myself and after trying to study different things related to IT in the past year especially, 2 months ago I finally decided to start the Google Data Analytics Certificate Program from Coursera and now that I am on the Capstone Project course (which is, of course, the last one), I'm really thinking that this career is probably not for me. 😅🙁
@@tobyjoshua2707 I didn't do the project and will not do it at all. It seems quite complex and they do not give you guidance on that like they do during the lessons and hands-on activities throught the course. If you are ABSOLUTELY SURE you want to become a Data Analyst, it is a good start point. But if you are like me: have no idea of what you want to do and are trying to study sth in IT, do a deep search before deciding to take the course.
Don’t know what else to do. Every job is frustrating and bosses are at most okay. If struggling to learn something new will get me to a some what happy place, I’ll strive for it.
Making near 70k a year just to start out? Sign me up, took me about 3 years of busting my hump just to make 60k, I wish I was smarter so I could learn this stuff quicker
If you think it'd be a good position for you you should look into it! You can always take a course or two to see if this is something you're interested in or if it's not for you.
@@AlexTheAnalyst Thanks for your reply Alex.. I am taking an Excel course right now and its going fairly well.. I just hope that at the end of my studies that it will be enough just to get my foot in the door.. I don't care about making big money, just want something to challenge me everyday.
Love these videos as always! I would really love a video that gives examples of queries you may be creating on a day to day basis. I know you can't have any company information bradocasted to the public, but as a Jr. Data Analyst I do foundational SQL queries and I would enjoy seeing what skills I am lacking there. Thanks :)
3:26 why you didn't try to do a template report using PBI or Tableau. Once a month, you clean the data get your excel files, connect the software to the new data and press refresh.
I want to say all of this is easy peasy considering i've had to deal with similar problems and issues with VFX. But something tells me I will be the person banging my head on the keyboard. XD
I just took an assessment on sharpest mind and the universe led me here. I’m searching for my next chapter and this gave me pause to really think about. Thank you 😊
I have a MSc in Physics with a focus on mathematics & Python, and a year of IT help desk experience. What steps would you recommend I take to make me more employable in the field?
See and then there is this video, which confirms that I think this might be the field for me. It was the five reasons you’ll make a good data analyst video that gave me pause, as I didn’t tick all of the boxes
This kinda works for me. Most of these I learned from either being in the Marines or my prior job as a web developer. I started laughing my ass off when he said that junior analysts won't make a lot of money, and it'll be under 70k a year. I used to get shot at by terrorists across the world for 2k a month. I'll gladly switch careers.
I love trading and analysing patterns and trends of the market, not realising there's actually a career path for people who loves analysing. Hence begin my love to learn and become a Data Analyst.
1. Be a self learner + lots to learn on the job. 2. Easily frustrated. 3. Hate doing menial work - data transformation. 4. Dislike working with people. 5. Thinking you'll get really rich quick.
Love the sharing Alex, I am pursuing a MSc for a career change and data analyst is definitely one of the top choice of my list. Inspiring on the point about can’t getting rich, I think it really a bit difficult to look for a career that really bring people the wealth we wanted. For this,do you think you can share some of your thought about should have a proper mentality on chase our fortune? Thank you all of your sharing, you really done a great job!
Very cool! I think having a realistic timeframe for your career is important. You’ll most likely start out making 40-50k, but can quickly transition to 60-80k with only 2-3 years experience. The initial investment and set up can be difficult, but experience sells huge in this industry.
@@AlexTheAnalyst Thank you so much for your reply, may I also have you advice about how is the opportunities that this career can provide in term of setting up your own business? Also, referring to the job nature you shared in another video the data scientist is able to catch the trend by the correct data in order to make forecasting judgements. It sound quite similar technique for those quantitative traders, I don’t know if it relevant but if it is, can you sharing the theories behind this assumption? After all I think math skills is very very important to work as technical industries such as data science ,computer science also for those working in finance. Thank you Alex.
Thank you for a great video, I appreciate the honesty, I have been thinking about it a lot, figuring out my thought patterns, and your video answered my questions and now I am more interested ✨
Hi Alex! A very interesting video, thanks. I have a question: does the data scientist role require the same level of interaction with people as the data analyst? Or does the data scientist work more with the machine compared to a data analyst?
Don't become a data analyst if:
1) you don't want to hear "man i hate mondays" and "happy friday!" every week for the rest of your life
Hahaha! Yes! or hear "What are your thoughts from a Data Analyst perspective?" every meeting. I need to make a video on this.... lol
@@AlexTheAnalyst A video or a skit on office politics / silly things you hear every day / week would be hilarious
@@taylorbosier I'm on it!
I work in construction ever see the movie office space that was me
*Case of the mondays* 🤯🤯🤯🤯🤯🤯🤯🤯🤯🤯🤯🤯🤯😉
Can you please explain in more details what do you mean by that ?
Don't be a Data Analyst if:
1. Not a self-learner, ability to learn on the go is weak.
2. Getting frustrated very easily.
3. Manual work - Data can be tedious.
4. Working with people.
5. If you think being a Data Analyst will get you rich quick.
welp, fml, i hate working with people (as in having to pretend that i care about their personal life). and i only work because i want to get paid then go to home to sleep. i'm fine with doing honest work and working hard, but seriously, there's more to life than your boss' stupid visions (no offense).
What parts are frustrating? Different things are frustrating for different people
It's just sad that people feel the need to discourage others from a field by using phrases like, "if you think being a data Analyst will get you rich quick".
It's just not relevant, I've worked In the software industry for years now, I've met loads of good people that are only in the industry for money. They aren't bad programmers... In many cases they were better than me. The thirst for money is irrelevant, and is actually a hobby for some people, especially those who trade stocks and currencies. What matters is the discipline you have to sit down and do the same thing for 9 hours a day, 5 days a week. I think these youngsters are being lied to by insecure people like you, being told they have to be special to get into tech. It's a load of rubbish, the tech industry is the fastest growing industry to ever exist. Come into tech if you want a good salary! Come if your interested in computers and math, come if you don't want to do physical labour. Trust in yourself, it takes years but anyone can get there.
@@freeopinion2140 Wait, I'm confused. Is this comment encouraging tech
2 and 3 for me
15 Years ago, I became a data analyst and I use it for any decision making process. Very great path for those who love digging issues deeper.
The last part caught my attention. Can you give me an example of digging issues deeper, please?
@@Sek-errrs Going down the rabbit hole.
@@atarbuck3452 correct 💯
00:50 - first thing
01:34 - second thing
02:40 - third thing
03:35 - forth thing
04:20 - fifth thing
To be fair, regarding reason #4, that is true of a lot of jobs. I can’t think of a job that doesn’t involve a lot of people/communication work. As an introvert I honestly don’t particularly like team work, but it’s a very fundamental condition of work life to learn how to work with others. :)
I am an introvert as well. And true, working in a team could be very exhausting. But the best part of being an introvert is the fact that we re-energize when were alone.
Im a introvert and love group projects(i say this even after almost every group project i have one person drops the class)
Same 👍
Same but I'm introverted and have social anxiety.
I'm an introvert and I have anxiety and I managed to hold a speech in front of 800 people. Honestly, it's just a matter of confidence, even if you're faking it (til you make it). It works because extroverts have no clue what's happening inside themselves or other people lol.
All of these answers makes me want to be a data analyst even more.
Haha then you know you're on the right path! :D
Same here
Funny I just thought the same thing... Just learning python
I also want to become data analyst, let's connect to share useful information
Lol he’s aware of that. That the aim of the video 🤣
Man you just saved my life with point number 4. I was thinking about branching out into this field BUT... I just can't work with multiple people day in day out. Messaging, emailing, texting, zoom/skype, tons of emails back and forth, making presentations, going over and over discussions and not getting anywhere for weeks sometimes months... ah I'm having an energy drain/ micro panic attack just thinking about that stuff. I've had a marketing and advertising career that spans 13 years and I've done all of the above. All that's left of my candle now, is the wick.
Hahaha being self-aware is half the battle sometimes. Glad you didn't make the plunge and regret it. Hope all is well!
@@AlexTheAnalyst I wish you all the best Alex you're a genuine man. Cheers from Toronto.
@@elvan12581so what do you do now? Still the same marketing or?
I have gotten economics degree and am just trying to make my first steps in the field, I have accidentally stumbled upon your channel and just wanted to thank you so much, because it seems a bit daunting and lonely at times, but looking at your talking about it I understand I am not alone, and there bound to be a community that can provide help and advice
Thank you for your work!
Question from someone in the last year of his economics degree path, where are you now and do you have any advice?
I want to know too
I think it's been more than a year know to guve us some answers on your current progress
I'm an economist and have worked full-time for almost 2 years now. I am an analyst in a mayor bank in my country. What secured my position was coding knowledge and that I did machine learning in my thesis. As I'm a lot more interested in coding and problem solving than actual "economics" I will probably try to move towards Bering more of a data engineer than a data analyst.
Spot on! On top of being a self learner, you have to be good at problem solving and have lots of patience! There are tasks that are difficult and pricey to automate. Doing manual work is inevitable, which is why you need to be strategic in finding ways to optimize your workflow and reduce time to do manual work. Data preparation takes time and is vital and a good practice prior to creating reports/visualizations through dashboards, for instance. Anyhow, nice video Alex!
That's very true! Thanks for watching Queen! :D
"There are tasks that are difficult and pricey to automate. Doing manual work is inevitable" - Too true! Try telling my boss that though... :(
Tbh, I started learning few months ago and I’m already frustrated, I actually hate it. I’m impatient and sometimes doing data and coding just feels redundant to me, I definitely should have chided another tech specialty
@@victorokoye3218 Like what tech speciality?
i'm almost two months into SQL
Whole programming requires HUGE patience and to be ready for frustration - not only data-analyst
Even another engineering major too
9
I was about to say I only am watching this video because I realized that after graduating with a computer engineering degree, engineering and coding are not for me because I get frustrated so easily and tend to have little patience...
Almost every engineering major nowadays requires programming. I remember the first time my parents told me about college and when I got in it is very different from my expeectation and idk how I feel about that. Different era from my parents, nowadays we have computers in our hands.
As an Econ student this is a career I've been eyeing and this video sealed the deal for me. Whether I am good at it or not I wont know until I try, but I am 100% I want to give it a fighting chance. Thank you!
I'm an Econ student as well! Trying to figure out what I want!
@@barbaraa5538 too many options Barbara! Eventually I’m going back to school for my masters. But I need to get back out there. Hopefully data analysis is the right track ❤️
That's great! I have a feeling you can do it :)
@@AlexTheAnalyst thank you so much for saying so! Really it means a lot
Hey how is it going?
I'm a Data Analyst and I love it!
Haha that's awesome :D
Sameee
Are you on twitter. Love to follow for some motivation. lol
Please guide me , I seek guidance
How do you become Data Analyst?
I've started in data analysis less than a year now and the first 3 reasons kind of summarized what i've been through. Learning by myself is a joy. Manual work sometimes makes me feel dumb because I always feel that i should do something to automate it and save time, but it's clear now that sometimes is unavoidable. Handling frustration is something to work on, but is also part of the journey. This video is trully awesome and helped to handle better my understang of being a DA. Thanks for sharing. Great content on your channel.
Stick it out. It's a great career choice. I have been doing it for many years.
Manual work makes me feel dumb too!!! Hahaha.
@@Ellie80681 Hello LE, I just started out as a data analyst and I stumbled upon this comment of yours. I would like to be friends and learn from you. You could outsource some menial jobs to me and I am willing to do them for free so that I can get a hands-on experience of the core aspects of Data Analytics. The journey has been a bit lonely because I am mostly self-learning. I believe the presence of a tutor/mentor in my life would make a lot of difference. I am prepared to do all the hard work.
I would appreciate a reply 😊. I hope you consider this request.
All of these points really hit home for me. Great video and spot on.
High tolerance for frustration is so very important. At my current company, I've had managers sit beside me as I did analysis, or they did an analysis as I walked them through it. They just about always get mad ... at me, at themselves, and at their computer. Few people are patient enough to sit through hours of trial and error cleaning, documenting, rearranging, and visualizing data. They usually just want that final output and they want it yesterday, even if it's a complete mess that won't make sense after a night's sleep.
Is this about Data Analyst or Data Scientist?
this made me laugh haha
I am in an analytics role for a large Corp. I often get tasked with creating analysis on financial data that the financial analysts do not have the technical capability to execute. I primarily use 3 technology components to do this:
1. Writing code to extract data from the source
2. Use of an analytical modeling tool such as SPSS modeler or Alteryx
3. Visualization of the results in cognos
Number 2 in the list above is where all of the “magic” happens. I feel It allows me to appear much smarter than I actually am. Access and the use of tools like that are key to separating yourself from the many people that have advanced excel skills, which is a large number of people. Hope this helps!
How much do you make and what level are you in your position? Thanks if you answer!
Any online paid courses you recommend some thing of 6 months?
@@Kaan-yq9bl I’m not a good judge of pay as I am a consultant by trade with 20 years experience and have worked for several big name companies. My pay is reflective of doing lots of different things, There are so many data jobs out there.....lot of opportunities
Hello Mike, do you have a data science degree or data analyst? How did you learn number 2? Thank you
@@MrDigitalIcon you can do #2 in Python code. Lots of training resources out there
Great video! Other than the salary part, I took this as 5 reasons I SHOULD become a data analyst. Look forward to watching your other videos.
Haha well that's great!
I have a BA in mathematics and I’m leaving the teaching profession. I can tell you that 70+k /yr is good money compared to teaching. Thank you so much for all your videos, this convinces me I’d be perfect as a data analyst 😊
Hey! I have the same degree and looking to start my career too. Are you learning SQL, python etc on your own?
@@katiagonzalez7784 You can learn that on your own in udemy.
I also have a degree in math/economics and am trying to move away from teaching! I am currently taking a data analytics graduate certificate course to help make this change!
@@melissahine7875 hi
Kindly share the course …I am looking to do one .. how long is the course
@@reetjatti1 I did the Harvard business school online graduate certificate in business analytics and in July I’ll be doing the graduate certificate in Data science with SQL and Tableau! I loveddd the business analytics program!!! Highly recommend!!
Top 1 Reason Not to Become a Doctor: You don't handle blood well.
lol the actual reason why I didn't become a doctor
No. Don't become a doctor because you WILL have to BETRAY Hypocrates and the words "Do not harm". As you will no choice but become a Big Pharma puppet after 1000s in loan, you will be stuck and you can't disappoint your parents either by leaving a career that gives you prestige.
@@samosa5925 But doctors do easily get jobs though unlike Engineering where it's over saturated and the entry level jobs are impossible to get.
@@samosa5925 that's only in murica
The more i watch your videos the more i appreciate them. Im enrolled onto a MSc Data Science course- now 5 weeks in. Ive already fallen behind from needless distractions. Your final point really hit home. Keep it coming. I do feel that this channel is necessary for me right now and will be all year to come.
You got it man! Just have to stay focused and keep working hard. Good luck my friend!
@@AlexTheAnalyst Thanks Bud :)
@@dean8147 so a year later, how are you getting on champ?
Good idea to make people aware. That said, people can change. If you really want to be a data analyst then Alex has laid out the things you need to master along with the software.
James Sepello absolutely, these are things just to be aware of - none of them are dealbreakers where I think you cant be a Data Analyst. I think it’s just something people should think about before investing a lot of time and money into it.
Anything above 25,000 a year is rich to me as I'm in the lower class
Me too.
I was even shocked when he mentioned 70k and I'm like does he really know what's going on 😁😁😁
The cost of living is higher here
This is me every day, only one exception, I LOVE to automate the analysis, I love to program the algorithm to avoid 3 or 5 days or work, I am probably addicted to Tylennol, when you are a data analyst must of the time you spend it thinking and writting the problem, testing it once, twice, or more, but just a few of us enjoy the moment when you find the proper algorithm, it is like finding the vaccine fpr covid hahah
Tylenol will kill you
I hear where you're coming from. I spent 4 years as a mature student getting my degree in psychology with the hope of a social care job. Every person from my class who went into it has been physical attacked numerous times (two wound up in hospital and one was sexually assaulted). I'm now enrolled on a higher diploma in data analytics - a lot safer...I hope. :)
daverage47 goodness gracious. Definitely sounds like a safer career path. Good luck!
WOW JUST WOW!! God Bless all and everyone who does social work. Yall doing the Lord's work out here FOR REAL!! Thankfully U have escaped such an experience that your peers have. Best wishes for you in Data Analytics!!
Did you get a job?
I hear you. I have a Master's in social work, have been in it for a decade, and now I'm fleeing to a new field. I did my part for humanity and now I'm DONE. 😂
The scariest day was when my husband who is a mental health clinician went on a client call and the man had a gun. It all turned out fine, no one was hurt, but not a fun phone call. It's been so much more calm now since he just does virtual appointments from home.
Hi Alex! I'm so happy I've found your channel. I am also a doctor and I've been struggling lately. For the last 2 years I've been considering changing my career as it doesn't suit me at all. I realised that the only thing that made me stay up all night was to do the statistical analysis for my dissertation. So, I'm starting to consider a career in data analysis and I'm finally ready to do it. I'll be using your videos to start studying. Thanks for the opportunity
Wow.. Life...
Wow. If this isn’t the saddest thing I’ve read all day.
A doctor which is at the top of the jobs hierarchy in many ways who wants to change career? Man...
I'm not really fan of the rhetoric currently circulating around telling people they can't do something because their not "motived by learning", or aren't easier fustrated... No. You can do anything. Even if you hate it and just want the money, you can still do it and be good at it too. Don't listen to these tech guru's telling you that you have to be special to do what *they* do. They are not special, they are not unique, they are mostly narcissistic and have their own insecurities.
Computers are a tool, it doesn't matter if you're into data analysis, forensics, software development, networking. It's just a tool. And anyone can learn to use it. Get a 2:1 computer science degree and the world is your oyster.
I actually took your recommendation to take the Google analytics course to try to learn this and it is absolutely true that you start off confused and frustrated. I check like 3 of of the 5 reasons why I should not be a data analyst.lol However, I find the skills of data analyst useful in other parts of life so I will just learn it as a hobby. Thanks for the video.
I shared this video with my friend. We both are now more motivated than ever to become a data analyst. Thanks a ton!!
Also the anecdotes really helped. Like the frustration part. Very true.
That's awesome! Glad to hear it! 😃
Another challenge could be when you have too many different managers asking for your help on different types of data inquiries/requests. Getting deep into thought on one project but being pulled abruptly to another project and so on can be rough sometimes but there are ways to address this or reprioritize projects. Loved the vid, thanks!
what are the ways you addressed these types of situations?
oh my God, I feel this as Data Analyst
Hey, how do you manage such scenarios
Thank you. This is the information I was looking for.
I'm the most impatient person I know. However, I've trained myself to put that impatience "on a shelf" while I push through and get a project done. Am detailed oriented; B.Sci; math major. Will look further into this.
Thanks for sharing this! It is so true and data science/analyst might not be as sexy as we think!
One of the most important characteristics is how to effect change management within the organization that you work in
OMG yes...
And how about Data engineering?
Ive never liked anything ive had to do either as a job or at school. They should make more videos about ppl like that.
Graduated with law degree. Hated law so i knew i wouldnt practice law.
Now im 2 months away from graduating with 2nd bachelor, Business Informatics. And i was pretty sure that this is not for me, and I dont have the personality for it, but stuck with it coz i felt I "had to make it work".
Went so deep that I decided to focus on ERP certifications, now im about to be SAP and azure certified. My first internship starting 1 June.
I used to be so against just working for money or high pay, and that passion means a lot.
Yet at this point in my life, i dont want to be 30 still working part-time jobs and studying, so money is the main priority.But all i really want to do is learn languages and travel, but i know thats a hard life with little reward.
They really should make more videos for people like me
You should have probaly done law for a while(especially if you have student loans) even if ypu hate it and save up money before going back to school
@@shoryacione5175 half the time I was on scholarship, and other half parents paid.
Moved to Germany to do 2nd degree, where there are no student fees.
Did anything and everything to avoid loans, debt free, always been.
That's true, I'm Data analysts, but most of time gathering inputs from people is tough job rather remaining work, its not not frustrating on work but on people I see. But your info is correct high tolerance needed even at escalation times .
Great points made in this video, and an incredible thriving community!
DataLeap Tech I appreciate it! Thanks for watching!
@@AlexTheAnalyst If you have some bandwidth, I'd love to collab in a small way somehow this month. Comment on one of my videos if you wanna hash it out!
The rest I'm all for it. Except for the "You must learn on your own", like this is why I didn't want to become a Software Engineer despite being a CS student, there's only so much that I can learn alone.
This honestly helps me immensely. I always doubted if data analyst was a role I should do…it sounds awesome but damn I don’t think I would make it. Thanks you
Me either
I have worked in Project Controls and am a PM now. This is verbatim my life as a data oriented PM. I wait for data, clean the data, build reports and beg for people to help or software to capture and automate this. I don’t have time to build out the automation and I’m stuck doing the manual calculations all the time.
Thanks buddy for saving my money 💰 and time. I was very curious to join Data analysis PGP because of high salaries & great carrier opportunity but now when you explained reasons I am damn sure that this is not my cup of tea.
I want to be a data analyst and I’m about to begin my uni journey pursuing a degree in business economics & computer science. During this pandemic I learnt and still learning web development, a little python and Java all by myself!! Really tough but I worked and improved a lot! Want to learn sql soon too cuz it’s one of the core requirements .
Java is no small feat - that's hard stuff! I am a huge fan of Python! Super cool!
Thank you. I've taken tests in college that said i would be good at data analysis but i do get frustrated easily. For the most part i am a self learner if i find it interesting such as excel. And monotony, no thank you. If something can be made more efficient that's what i strive for. I'm a fixer.
totally agree with you Sir Alex, I still hit my head with keyboard whenever assigned to a new project haha, so much new things too learn, at least for domain knowledge
I’m fine with everything except the communication part. I have pretty bad social anxiety and I am by no means assertive *sigh* I’m still going to give it a shot though.
Do it! That’s absolutely a skill that can be learned over time 👍
You’re your own biggest critic and even those who seem unapproachable are generally happy to talk with people (figured that out). Anxiety is mostly irrational and can be accepted and overcame. Say hello to people :)
Make sure you work on improving in those weaknesses on purpose. It takes time and persevering effort.
Yes vesides i have social anxiety like really bad and im becoming a counselor because i know how to ask people questions and gwt them to talk to me. Overall you will need to overcome your social anxiety to work in any job field
Same, I'm introverted too but I think the best thing is to become a freelancer data analyst
"waiting on co-worker" - this is the reason why being just an analyst would suck. Full stack engineer is the way to go...
Spencer Cooper haha wouldn’t that be nice 😁
@@AlexTheAnalyst thats what I'm recommending. I dont do analysis full time, i am an engineer, but I still do plenty of system analysis when i need to.
You cannot do everything by yourself specially when working for a mid to large company
Full stack engineer in my previous companies need to be on call 24/7.
I had a software dev who already left the office and was on her way home when one of the company's system crashed after deploying a fix and needed to come back to the office again.
@@professionalboycottservice7872 well don't deploy and immediately walk away lol
You helped me a lot. I am in my fourth year of college and am thinking about my future career. Data Analyst is one of the directions I thought of. This video told me that this career path really might be a viable option.
Michal Malík so glad to hear it Michal!
As a business analyst in healthcare, when he said learning and working with python and sql, and hitting your head on your keyboard pretty much sums up my first year. It was and still is totally worth it.
hey man I am also interested in becoming a Business analyst, does it have a alot of difference comparared to DA?
Hi Alex, thanks for your great sharing! Insightful! I like and have much experience in self-learning, taking challenges, and working with people. The manual work is not as interesting as the rest part. But no pain no gain. The low salary at the beginning is all right for me.
I care more about long-term career development. In 2017, I got to know we are stepping into the intelligent era and data is the new "fuel". Then I spent much time studying python, machine learning, statistics in hope of becoming a data scientist... The goal of becoming a data scientist seems unachievable at the moment due to the major and age. So I decided to land a data-analyst job and start my data career path this year.
Have you got the job of data analyst?
@@tawhidasultana2808 Thanks for asking. I landed a job as a project manager in a data technology company, in which we implemented PowerBI dashboard, data warehouse for our customers (local, international).
@@brendali5803 many thanks for your reply mam. I also want to be a data analyst. I am studying master’s in IT management. I know SQL, Tableau, data scrapping…how can I step forward please?
Hi Mam, what were your challenges so far when you became a project manager? we're you able to transition yourself as a Data Analyst now or have you already enjoyed working in your current role?
@@IndividualExistence Hi Allan, I enjoy working in project manager role, which utilize much of my strength and experience. I've worked on four projects and reiceved compliments from my customers.
The biggest challenges so far is to steer my
way forward. It's hard to decide what is my priorities of study and tasks for my career development.
I've only been a DA for about 9 months now. The title of this video scared me because I love my new job!
...but yes, this is dead-on accurate!!!
Hahahaha omg, everything that i needed to hear right now! Starting at data analysis in my new position, getting punished by postgresql
how's the job?
Did you end up being a data analyst
Same here! I'm a junior DA😂 Postgres, Python, statistical modeling, Apache superset/preset, BI analysis, Project Management also...
This made me even more excited to be an analyst! I like all those things.
Very helpful. I'm learning on my own and it's really frustrating and tiring. Atleast I know it's normal. The passion for it is keeping me going. Will be like you someday. Thank you.
That’s definitely a great thing to have to keep you motivated! Keep up the great work! 😁
Mmm...once you said 'communication' and 'working with other people' it was like someone hit a nail in my heart. Thankfully becoming Data Analyst was just one career option for me, guess I'll continue looking for a career where I don't need to interact with other people.
I’m doing data analysis as a step to become a data scientist.
That's great! Data Analysis and Data Science share a lot of common skills.
The best video I came across on the topic... so I made my decision right. Alhamdulillah
I already have a scholarship from Saudi Arabia for data analytics, and I can't change my major. Watching your vlog title itself is overwhelming.
I'm so sorry to hear that! I will say that even I sometimes fail on one of these. No one is perfect and won't have all of these boxes checked off. I hope everything works out for the best!
Glad I watched this, i can check this career off my list.
I get the impression you would make a wonderful coworker if I were an entry level analyst at your company. This video is like if you were coaching a junior analyst. In fact, you would make a great manager! And it would be awesome to be part of your team :)
Haha thank you 😁 and thanks for watching!
You've convinced me to keep going. 😊
Thanks Alex, really enjoyed this, definitely gave me more confidence that I should continue with studies in data.
Great to hear!
I get frustrated easily and a poor study but however I’m tired of not being challenged at work I need something that makes me feel happy.
Hi Alex. I’m Aida. 2nd year medical student in Malaysia. Though i love the idea of becoming a doctor, i dont think im willing to face another 15 years til i can become a specialised doctor. Plus, the job prospects as a doctor isnt that great here in my country. So i thought of going into data science. This is a big switch for me but I really hope I can do well :)
You're very welcome! I know you can do well. Good luck!
MBBS... Complete karo naaa 😘
I actually love all 4 things you said. The fifth is very very situational. But not false.
I have been a data analyst for 2 years now. FYI this guy is completely correct, I don’t like being a data analyst, and the random ad hoc requests that come on a strict deadline is such a pain. You might even get multiple such analysis and requests in one day with the same day delivery deadline. I really want to become a software engineer now. I am feeling fed up of this.
Any update?
I am a software engineer. You really think, it is different here? We also have clients who think they can change requirements ten times through the project and just before the deadline. Some changes may take weeks to implement. Laughing my ass off. 😂
Very insightful!
This is such a good video to let me know what Data analyst is.
Glad to hear it!
I have interview as data analyst this week!! I’m super excited and this video made me more excited lol wish me luck everyone
Good luck!
@@leelasaivoonna1728 thank you so much
I'm actively trying to become a data analyst right and watched this video to see if I was in for something I didnt know! Your video actually strengthened my resolve to obtain this career. Anyone trying to get Rich working for someone else has a rude awakening lol
Haha I'm glad it motivated you and I wish you the best of luck! :D
Although I sit on the other side of the data world as a data engineer. I can agree with a lot of similar sentiments. Thanks for the great content!
Sorry if this sounds stupid bit what does a data engineer do? I honestly didnt know a data engineer was a thing tbh
@@shoryacione5175 yes same
0:50
Me who doesn't read instruction manuals for anything
Me: pfft, easy
lol! :D
Piece of cake.
For those thinking on bailing out because of this video, DONT!!
All those skills(communication skills, people skills etc) can be learn and if you persevere to learn them, they'll transform EVERY aspects of your life:
- Marriage/ relationship
-Confidence
-Sence of accomplishment etc
I never want to discourage anyone from becoming a Data Analyst, but if these are things that they don't like or don't want to do it may be something for them to think about. I definitely agree that some of these things can be learned, but some people don't like social interaction or don't like learning on their own.
0:53 Love this moment
I couldn’t agree more, great advice
Very insightful video! This thankfully made me realise my weaknesses, so hopefully I can start correcting them before I get to the job interview haha
Definitely good to know beforehand!
You can take SQL data and automatically put them into an R or Python data structure, then convert that to a CSV and boom it goes to Excel, though I don't know why you couldn't just stop at the R/Python level.
Loved the “DO NOT show my wife this video.” Great information on the video.
Don't even know who the wife is and it doesn't matter.
Thank again, I pass these kinds of obstacle.
I’m an accountant with 5 years of experience. Would I be able to transition to a data analyst if I want to try something new?
Jonathan C it’s definitely possible. You’d need to learn the right skills, but your experience as an accountant could be useful in maybe the financial industry.
Hi Jonathan, I'm in the same boat. I'm an accountant as well. I started learning Python and getting more interested in the data field.
Finance departments in any larger corporates need data analysts with accounting background
You are correct, I am also an accountant too and missed out on a lucrative job offer because of data analysis and SQL, so I am learning that now using Cousera courses.
Love This ♥ Thank you !
I was always a good student: at school, university or any other kind of course that I took in which I had to go to the place and had teachers/professors to help and etc. However, it was always a big challenge for me to study by myself and after trying to study different things related to IT in the past year especially, 2 months ago I finally decided to start the Google Data Analytics Certificate Program from Coursera and now that I am on the Capstone Project course (which is, of course, the last one), I'm really thinking that this career is probably not for me. 😅🙁
What's your experience with the Data Analytics course on Cousera?
@@tobyjoshua2707 I didn't do the project and will not do it at all. It seems quite complex and they do not give you guidance on that like they do during the lessons and hands-on activities throught the course. If you are ABSOLUTELY SURE you want to become a Data Analyst, it is a good start point. But if you are like me: have no idea of what you want to do and are trying to study sth in IT, do a deep search before deciding to take the course.
Don’t know what else to do. Every job is frustrating and bosses are at most okay. If struggling to learn something new will get me to a some what happy place, I’ll strive for it.
Bit new, but why would you take things out of sql to put them back into excel then make pivot tables instead of power bi
Our client didn't use Power BI Dashboards - they wanted everything in Excel.
Exactly, some don't want PowerBI
@@AlexTheAnalyst what the reasons for it im interested
Thanks for your video!
Making near 70k a year just to start out? Sign me up, took me about 3 years of busting my hump just to make 60k, I wish I was smarter so I could learn this stuff quicker
If you think it'd be a good position for you you should look into it! You can always take a course or two to see if this is something you're interested in or if it's not for you.
@@AlexTheAnalyst Thanks for your reply Alex.. I am taking an Excel course right now and its going fairly well.. I just hope that at the end of my studies that it will be enough just to get my foot in the door.. I don't care about making big money, just want something to challenge me everyday.
Thank you, Alex! I'm golden on all those points so I'll still jump head first into the profession :)
How did i miss this in May
Great question - no hard feelings :D
Thanks, being social was the killing point. That random career test was wrong when I took it the second time :)
Very informative! I’m definitely NOT suited for a data analyst. You’re right babe - super easily frustrated! 😊😂
You are the best! 👌 I want to change career and become Data Analyst,currently working in maritime offshore industry😃
Love these videos as always! I would really love a video that gives examples of queries you may be creating on a day to day basis. I know you can't have any company information bradocasted to the public, but as a Jr. Data Analyst I do foundational SQL queries and I would enjoy seeing what skills I am lacking there. Thanks :)
That's a good idea! Thanks for the suggestion!
3:26 why you didn't try to do a template report using PBI or Tableau. Once a month, you clean the data get your excel files, connect the software to the new data and press refresh.
I want to say all of this is easy peasy considering i've had to deal with similar problems and issues with VFX. But something tells me I will be the person banging my head on the keyboard. XD
Same here bro. I’m into vfx and trust me, ITS HELL😂😂
I just took an assessment on sharpest mind and the universe led me here. I’m searching for my next chapter and this gave me pause to really think about. Thank you 😊
I have a MSc in Physics with a focus on mathematics & Python, and a year of IT help desk experience. What steps would you recommend I take to make me more employable in the field?
With your strong math and coding background I would focus on SQL and Tableau/Power BI. Learn the database and visualization side of things next.
@@AlexTheAnalyst Cheers Alex, I'll have a look in those areas :)
Don't become a data analyst. Do a program like insights data fellowship and try to be a data scientist instead
@@AlexTheAnalyst theres a really good business analytics course on udacity for Data visualization in Tableau and learning SQL.
See and then there is this video, which confirms that I think this might be the field for me. It was the five reasons you’ll make a good data analyst video that gave me pause, as I didn’t tick all of the boxes
This kinda works for me. Most of these I learned from either being in the Marines or my prior job as a web developer. I started laughing my ass off when he said that junior analysts won't make a lot of money, and it'll be under 70k a year. I used to get shot at by terrorists across the world for 2k a month. I'll gladly switch careers.
I love trading and analysing patterns and trends of the market, not realising there's actually a career path for people who loves analysing. Hence begin my love to learn and become a Data Analyst.
Dat like / dislike ratio tho. Great video as always.
The mentioned points are also valid for Data Science except the last mentioned one ;-)
Haha that's very true :D Thanks for watching!
1. Be a self learner + lots to learn on the job.
2. Easily frustrated.
3. Hate doing menial work - data transformation.
4. Dislike working with people.
5. Thinking you'll get really rich quick.
Love the sharing Alex, I am pursuing a MSc for a career change and data analyst is definitely one of the top choice of my list. Inspiring on the point about can’t getting rich, I think it really a bit difficult to look for a career that really bring people the wealth we wanted. For this,do you think you can share some of your thought about should have a proper mentality on chase our fortune? Thank you all of your sharing, you really done a great job!
Very cool! I think having a realistic timeframe for your career is important. You’ll most likely start out making 40-50k, but can quickly transition to 60-80k with only 2-3 years experience. The initial investment and set up can be difficult, but experience sells huge in this industry.
@@AlexTheAnalyst Thank you so much for your reply, may I also have you advice about how is the opportunities that this career can provide in term of setting up your own business? Also, referring to the job nature you shared in another video the data scientist is able to catch the trend by the correct data in order to make forecasting judgements. It sound quite similar technique for those quantitative traders, I don’t know if it relevant but if it is, can you sharing the theories behind this assumption? After all I think math skills is very very important to work as technical industries such as data science ,computer science also for those working in finance. Thank you Alex.
Thank you for a great video, I appreciate the honesty, I have been thinking about it a lot, figuring out my thought patterns, and your video answered my questions and now I am more interested ✨
Hi Alex! A very interesting video, thanks.
I have a question: does the data scientist role require the same level of interaction with people as the data analyst?
Or does the data scientist work more with the machine compared to a data analyst?
The titles are sometimes interchangeable. There's no definite demarcation point between the two.
10 minutes ago I decided to start learning this ....until I watched your video. Thank you for the discouragement 🙏🏼