Hello, Alex. Great video. I had some questions as well, wanted to clarify some thing. 1) Do you recommend learning T-SQL or PL/SQL as well? 2) What type of datasets to use for a project as a beginner? From a simple dataset to a more intermediate level. 3) How to make sense of data, to spot trends, facts, relationship between them and make inferences? It would be great if you can do a project series. 4) I've been toying with the idea of freelancing. So, if I get a project, how do I go about asking client the questions? Like, what are they looking for or just how do I communicate with them? I have no work experience and honestly this part terrifies me a bit. 5) Suppose a project is at it's end, we have made a report/dashboard. What comes after this? How to convey to the client what insights we have made?
Heck yeah, thank you for answering my question Alex! I'm always curious on what others in our field are planning next in their careers. I'm also a little unsure as well on where I want to go next, so it was refreshing to hear that others are encompassing the same thoughts and issues when planning for the future. Keep up the content! P.S. Regarding my first question (Python vs R), IMHO I would have installed Pandas first... ha!
It was very refreshing to hear that a data Analyst not necessarily needs to become a data scientist. I share the same feeling more towards data engineering and with this video I have realized that I am not crazy for thinking about it hahaha
17:49 It’s awesome how you’re crystal clear on your passion! Great video Alex!
He's not a data scientist because I have monopolized all the data science.
The thing is that data analyst and data scientist are very different things. I was a data scientist for 3 years, our department got consolidated and I was let go. Due to extremely high work requirements for a data scientist I actually was looking at a data analyst role and quickly learned that I have never built KPIs, SSRS reports, and very basic forecasting. In one of my interviews I was given a task to do some simple EDA on a medical dataset. When I was done with the task, I actually built a pretty solid XGboost / Classification Models in Python ##(I know python, R, MATLAB, SQL and have written my own packages, cleanup functions) ## including the requested data cleanup EDA. In presenting my findings the manager and her team were more confused with my analysis than anything else. Needless to say I learned that you can’t go from data scientist to data analyst. Recently I got hired back as a data scientist with a different company.
This is really the most authentic Q&A video I'v ever watched, love your content and wishing you the best of luck on your new role
Got SQL( a bit beyond basic select snd joins), Tableau and Excel covered, Excel actually pretty well, as I ve worked with it for a year. Now, the hardest part is getting a job! Literally all jobs I'm seeing out there ask for at least two years of experience.. This is the hardest part to deal with. I 'd like to see a video about legit job requirements; I think I ve seen the one, maybe two, about resumes, and the one about totally unrealistic job requirements, but I think I d appreciate more detailed content in this direction. I got laid off last year when the pandemic hit, so I no longer have the option of transitioning, but have to actually start from zero. Getting the skills is half of the task, the other half being applying them; and I find this part much more challenging. But great work so far, I really appreciate your content.
Wicked, I love your channel man: good to hear an honest opinion about degrees and that you don't just give any old bull about "no regrets" and "just follow your passion", you're open about thinking you could've done better with a different education. Fair enough, I know the feeling! :D Am looking forward to the portfolio video! Peace from UK
Really looking forward to your SQL portfolio video. I searched high and low and I literally couldn’t find anything 😭
I really appreciate the fact that your answers and reaction to the questions were quite honest and real. I enjoyed and learned a lot while watching this Q & A. Thanks a lot and keep doing it !!
Your videos motivate me to work towards my goal! Thankyou Alex
Hey there! I really appreciate the videos you are putting out. You have helped me a lot in overcoming questioning my own capabilities for a data scientist role. I just recently was accepted into a master's program for data science and you have played a large part in helping me get there! I just wanted to relay a sincere thankyou from a fellow Texan and future data analyst. :)
I'm new here and found so much related to my career. I wanna be into data analytics and i have to start my learning. Your content has clear my path and has given me such valuable guidance. Thank you! Your channel is the most clear search i gave gone through till now. 🤗
Thanks Alex for a great video! I've been sort of slowly working towards Data Science. However, the more I look into the field, the more I see I'm probably better suited for a Data Analysis role. A good part of the reason for my change has been your very informative videos, so thank you. Yes, DA is the sexy cool job everyone is pushing but damn...the MATH! MY GOD, THE MATH!!!!!!! LOL You might as well just add a dual Statistics major along with anything else you're studying. That, and making data models doesn't seem that interesting. Watching your videos (along with Ken Jee and Jen's Career Force videos) has really helped me refine what I should be working towards. Thanks again!
Hey Alex. Like your videos... The way you present yourself and your thoughts is really appreciable. Last year I was thinking of transitioning my career from an engineer to become a Data analyst. Your videos helped me a lot. Your videos also helped me to choose the right courses and skills. And now I have all the right skillset to become a data analyst. Thanks! 😄
As a current data analyst (health informatics analyst) living in Ohio but working (remotely) out of Michigan I can tell you that Alex is correct. Recently had an offer for a data analyst role and the hourly rate was less than $18.00.
New subscriber here! Great channel. I'm a recovering digital advertiser transitioning into becoming a data analyst. Looking forward to diving through the SQL videos that you've made! :D
Great video! I really liked that you shared your thoughts on why you prefer data analyst work over data science work. Keep doing what makes you happy! Anyways, this has motivated me to start my final project in my data analysis course haha
@timbatman1958