Realistic day in the life of a data analyst | why I left healthcare, job, tech
Вставка
- Опубліковано 3 лип 2024
- 🚀 Take control of your schedule and boost your productivity with time-blocking! Try Akiflow today: bit.ly/akiflowagatha
As a business intelligence engineer at Amazon, my role is a mix of a business analyst, data engineer (I use ETL - extract, transform, load and data warehouse), and a data analyst. In this video, I talk about what my role is, who I support in the organization, what types of data projects I work on, and what tools I use (excel, sql, python, and a BI visualization tool). I also go over the reasons I left my career in healthcare to work in tech and what I enjoy about my job in tech. I hope this gives you a glimpse into my day working in big data and tech and gives a perspective for those interested in the tech industry.
📚 Resources
Excel: imp.i384100.net/jr6oAP
SQL (I've personally used DataCamp to learn SQL): datacamp.pxf.io/zNJ6xW
Tableau: imp.i384100.net/xkoGb5
Python: imp.i384100.net/Gmdz5m
Google Data Analytics Certificate: imp.i384100.net/9gqYQy
Interview Query (similar questions to the ones I’ve seen in my interviews): shorturl.at/lyLNT
Get certified as a Data Professional with Datacamp - Data Analytics certifications rated #1 by Forbes: datacamp.pxf.io/eKLNXr
🖥️ My Desk Setup
Keyboard: amzn.to/3Sny1fw
Mouse: amzn.to/47aYpgM
Cable Management: amzn.to/47hQz5b
Dell Dock: amzn.to/3tNVahv
🙆🏻♀️ Connect
📫 Newsletter w/ Free Resume Template: agathakang.com/subscribe
📸 Instagram: / agathaakang
🔗 LinkedIn: / agatha-kang
🎥 TikTok: / agathaakang
Business inquiries: info@agathakang.com
📄 ABOUT ME:
My mission is to help you grow your career, especially in the world of data analysis. Switching careers to become a data analyst from a non-tech background was overwhelming. I made a lot of mistakes and wasted time trying to figure it out. But having been a manager of data analytics and now a senior business intelligence engineer at Amazon, I've learned a lot and I'm excited to use my experiences to help you navigate your career path. I hope this channel gives you the clarity and motivation to get started!
⌚️Timestamps
00:00 - intro
00:57 - 9:45 AM
01:52 - what I do
02:10 - why I left healthcare
03:13 - technical skills
03:24 - who I work with
04:38 - what I like about tech
04:19 - 12:30 pm
04:48 - my schedule
06:48 - focus time
07:45 - outro
Content is for educational and entertainment purposes only. Some links are affiliate links that support the channel at no cost to you. As an Amazon Associate I earn from qualifying purchases. Thanks for your support!
🚀 Take control of your schedule and boost your productivity with time-blocking! Try Akiflow today: bit.ly/akiflowagatha
I just found your UA-cam 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! :)
@@agathakang Thank you i will keep going! cant wait to see more content from you :))
Great video!! It’s always nice to have a glimpse into your day. The walking back at the end 😂 loved it
thank you and haha I had to keep it real 😂
Awesome videos🎉 loved how u explained your work and why you chose to move to tech❤
Thank you so much 😁 ❤
Thank you for these insights, all the best insh'Allah
You're welcome!!
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?
Hey, I would say SQL is the tool I've used the most as a data analyst in both healthcare and in tech. It is a must-know skill for all data analysts
Nice!
Thank you!
Okay, the walking back caught me off guard 😆 Anyway, love your videos!
haha 😆 thanks for the love!!
Great video
Glad you enjoyed it!
@@agathakang 💞
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.
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!
@@agathakanghow u get job
Where you learn tableau and SQL
How much time it can take on an average to be good at sql at intermediate level.
Tips while learning sql
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.
Hi Agatha,
I am glad that I am leaving in public civil service and return to private in it. I like to be challenge
Hey, agreed there are definitely different challenges in the private sector and especially in tech!