I just found your RU-vid channel today and watched a few videos. I really like how you present the realistic side of data analysis. I’m 22, coming from an IT role, and I’m currently learning SQL from beginner to advanced level (I already know some basics). I’m also learning advanced Excel, Tableau, and Power BI, plus SQLite and Postgres, with the goal of starting to apply for data analyst jobs within the next few months, maybe sooner. I love what you do so thank you haha :)) you really inspire people whether you realize it or not
Hey that's exciting! You're already taking the right steps to transition your career to a data analyst. And it means a lot that my content helps!! Thank you for the thoughtful comment and I'm excited for your data journey. Keep going! :)
Can you talk about how you got to pivot to tech. I'm a Sr. Data Analyst in Healthcare. 3y of experience. I mainly use Tableau, SQL, and excel. I also want to move to learn and use different tools. I used snowflake, aws etc during my internship but in my current role I feel like I'm not learning or practicing anything new. Ive been applying to roles for tech companies and no one interview. I also applied to Finance and got 2 interviews. I got to final rounds no offer yet. I find it very difficult to switch fields. The fact that I have no experience in finance or product always comes up. But for me analizing data in tech, healthcare, finance etc. is the same. I need to problem solve and have my tech skills not the deepest knowledge of product dev or finance.
Hey! Yes I agree there are a lot of transferable skills when moving between industries as a data analyst. To pivot my career to tech, I actually took a bootcamp. This is where I learned more about data modeling, cloud technology, machine learning, and did hands on projects. I can't say that it's one specific skill that helped me get into tech but I definitely think it's because I continued to up skill and learn new skills. Look at the specific tech roles you're interested in, learn those skills, and try to use it on the job. For product experience, I have taken product manager courses which also helped me think about my data solutions as a product - something they do in tech. Hope this helps!
As someone who is about to take a bootcamp for data analytics in september, I was really looking for advice or an insight on how this career is and what it takes to become a successful person. This channel has really helped me be confident in my decision to take a bootcamp and to pursue a career as an analyst. Wasn't really feeling a career involving biochemistry, which was my major, and felt kinda lost the past few years. Thank you so much for creating this content for us!
The dashboard you showed didn't look that complicated. Being a green newbie without a data job yet, I feel stuck on the analysis part. How did you figure out and then explain what that dashboard was actually showing, and how do you know what to suggest for whatever problem you feel that you found? I'm still trying to get more comfortable with CTE and subquery. I'd probably fail hard in a coding interview. I still use AI a lot to figure some coding out. I don't fully know yet in my self education every query type like data functions, ranks, which are hard when you're using practice data from kaggle. I know on the job I'd learn quickly by doing, but I haven't even gotten an interview yet. Great job on this video!
Thank you for watching! To answer your first question - what you are showing and what to suggest is based on the problem you are solving. In the real world, you'll have a customer and a clear problem defined and that'll be your guide to everything you do in your analysis. Independently, it's hard to figure out whether your analysis is "right" which is why it's so important to define a problem statement first and that'll guide you. The coding interviews will just require practice and yes definitely on the job, you'd pick up the skills quickly. If there's any opportunity to use data on the job, that is a great way to break into a data analyst role as well.
Hi Agatha, thank you for your video post. Very insightful to see what a professional does in their day. You mentioned that you use SQL mostly in your current role at Amazon. Did you also use a lot of SQL as a healthcare data analyst, or did you use another tool more?
Learning the basic SQL syntax will take you 1-2 weeks but you'll want to practice and apply it to reinforce your learning. My tip would be to use sql hands-on like projects to really learn it.