How I'd become a data analyst (if i had to start over) in 2024
HTML-код
- Опубликовано: 9 июн 2024
- Data Analyst Roadmap 2024. A data analyst career path can be broken down into 3 simple steps with timelines so that it's easy to follow for an entry-level data analyst. Curious about how to become a data analyst? Use this video as a reference to start your Data Analyst journey and answer data analytics important questions such as what data analyst skills (SQL, Microsoft Excel, Tableau, Data Visualization, Python) you should learn and what steps you should take for your data analytics portfolio. This video is good for a data analyst beginner interested in learning how to get a job as a data analyst, the day in the life of a data analyst, and what the analyst career path is.
📚 Resources
Excel: imp.i384100.net/jr6oAP
SQL (I've personally used DataCamp to learn SQL): datacamp.pxf.io/PynDkY
Tableau: imp.i384100.net/xkoGb5
Python: imp.i384100.net/Gmdz5m
Google Data Analytics Certificate: imp.i384100.net/9gqYQy
Interview Query: shorturl.at/lyLNT
🖥️ 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 in tech (FAANG), 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:29 - Roadmap
01:18 - Skills
01:55 - Excel
03:26 - SQL
04:48 - Tableau
05:44 - Projects
07:45 - Job Applications
08:50 - 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!
Thanks so much for the thoughtful comments! Feel free to connect with me on 📷instagram: instagram.com/agathaakang/ and through my 📬newsletter: agathakang.com/subscribe (free resume template in link)
I'm a junior in college at the moment studying Data Analysis, but unfortunately I have realized my college isn't actually preparing me for this career at all. I graduate next summer and I still don't have any technical skills. I am really grateful for your videos. I am a first-gen college student and I really hope to live a comfortable life without the struggles my parents had. I sincerely thank you for the wonderful information you give to people for free. I am going to work hard to follow a road map like this to reach my goals. Keep up the great work!
Thank you for sharing your experience. I am literally in the same position right now, first gen student, graduating next year with no experience and feeling like my degree hasn’t prepared me for the workforce. Give yourself some credit for taking the time out to research what to do outside of school and putting in that effort. I wish you the best for your career journey!
Literally in the exact same position we got this
same, i literally graduate in dec and just have mostly conceptual stuff to think about. I have to go back to actually practice this to be prepared for these interviews
So true, I'm in a similar position rn
I'm majoring in Business Analytics..and I'm confused as hell
I got an internship but it was totally a field work ( involves surveying people ). I had to leave it few days ago because of the heavy pressure of achieving targets, and toxic work culture...I want to start all over again, it surely gave me a reality check, and made me doubt If I chose the wrong career or smth
Thank you ! This is helping me tons. I’ve recently completed the Google DA Certificate but have felt stuck in starting my projects for the portfolio. And just really learning the skills. I had decided to focus on the 3 you mentioned in this video, so that’s my confirmation that I’m on the right track! 💕
Glad the video was helpful! It's overwhelming at first but break it down and follow the steps. Good luck with your journey!
Hello, I am considering taking google DA course. Is that really helpful according to your experience? Thank you
Is started the Google D A course but it's learning style didn't suit me. It is a person talking and talking. I switched to IBM Data analytics certification and liked it. It is very concise and solid.
@@arefwahb7771hello! I would recommend it as far as you have absolutely no background or experience in tech or data analysis. It introduces what the role is and introduces the main tools you will need for the job but you won’t be an expert at the end. I would go through it and absorb as much as possible but continue to learn outside the course itself. I don’t think it looks bad on your resume, it’s a recognized industry one but won’t get you the job.
You completed the certification and still felt stuck? That's not a good sign 😔
Great video Agatha! This is a golden nugget of a video that saves hours and hours of time searching how to begin data analysis! Love the simplicity of the information. Thanks 🙏🏼
Wow what a break timeline and thoughtful break down of info!! Thank you!!
Thanks for this content! I started binge watching you and will begin my 6 month journey. :)
Love this! And I’m excited for you :)
Thank you for sharing your insight and structure!
The way you explained is wonderful.
Great explanation! Thank you for sharing your experience!
Great video thank you. Trying to build my skill set geared towards analytics and cybersecurity
Thanks so much and yes analytics and cybersecurity is a growing field!
Thank you so much for the roadmap!
You’re welcome!!
Thank you so much ❤ for sharing. I have started the process as you recommended, will see how it ends 😊
You're welcome and good luck! Very excited for you!
update???
update?
This is awesome, I’m so overwhelmed with wanting to do everything. I really needed a structured roadmap. I do want to try to become an analyst in three months, so I might have to apply to other analyst roles. But this helps a lot!
Thank you for also providing examples of projects once finishing learning each skill
So glad this was helpful! If you have more time to commit, it’s possible to transition faster than I outlined!
This was a great video. Thank you 🙏
So glad I came across your channel! You are giving me hope and motivation to go after what I thought was a pipe dream. Thank you, Agatha ❤
Very helpful, Thank you!
Wow! The Fact that you are providing so much value for free is just amazing! Thank you so much!
You're welcome! I'm so glad the video was helpful!
You are GREAT at explaining!
This was really helpful. Thank you!
Glad it was helpful. Thanks so much!
Thank you so much it's very helpful ❤
THX for your motivating videos. I did recently stumble over your content and there is a lot of valuable information in it. /S.
So glad it's helpful! Yes keep going 🙌
Thank you, i will start today
Thorough advice and examples for resources as well as descriptive goals for each skill set. Wonderful! I've heard that the entry level job market for Data Analysts is not great at the moment but I still want to go for it.
Please can we learn together
Glad the video helped! I talk about the market in this week’s video and what you can do to stand out ruclips.net/video/dAsE77Y4DPI/видео.htmlsi=SFTU3pPYh5gjQMz0
I’m using a program called Springboard and the plan is exactly like you described the first months is about skills then projects and in last month we have a boot camp and lastly a career coach who’ll help us find jobs and create a resume
Thanks. Loved your content
Thanks so much!
This was an amazing breakdown! Thank you so much!
You’re very welcome!!
Great video!!
Wow! Thank you! Your presentation is awesome...To the Point! More power to u :)
Thanks so much for watching :)
I have decided to focus on data analyst roles now, already expertbin Excel, 10 years of experience and teaching, already good at SQL, computer science software engineering degree, MBA. Power BI experience. I did, php, java, C, javascript... back in collegue 10 years ago. Now i need to do tableau. Get like 5 certifications this year.
Well structured and very informative! I took notes on this video so that I can review key points later. I think this will help me know what level I should achieve for each steps on the skills, Projects and Job Applications.
Can you share your key points in this comment? I want to check if it's better than mine (to learn) and apply them irl
Thank you for this great Content
Thank you for these videos, they're really helping me
I’m glad they’re helpful! Thanks for watching!
Hey, thanks for the content. Great advices, you are inspiring.
Hey! Thank you 🩷
Refreshing information. Thank you.
You’re welcome!!
This was definitely very informative and will help folks thinking about moving to the data analyst field.
Thank you! Glad it was helpful!
thank you for this wonderful video it will help me a lot
This is valuable. Thank you Agatha.
You’re welcome! Thanks for watching
Thanks for the video, i will try it.
You’re welcome!
This is crazy. I did not even know this was a career option!! I am 1000% looking into this more.
Thank you. I appreciate videos like this where it’s straightforward and to-the-point. Subscribed !
Thanks for watching! And the subscribe! ❤️
Thank you for sharing your insights with us! I really appreciate this video. ❤
You’re so welcome!! ❤️
Thank you so much for the video. Now I get started to prepare data analyst.
Yes! Good luck with the data journey!
Thanks for this content. Such great advice I must say
You’re welcome!!
no fat straight to the point, subbed
Thanks. Your video give me a lot of tips that could guide me how to prepare myself to data analyst . much thanks.
You're welcome! I'm glad it was helpful
Great work❤
Exactly what I needed to hear. Realistic expectations & achievable. Trying to change careers, so this helped a TON. Really appreciate the info.
You’re so welcome! Glad it was helpful and good luck with the data journey!
Wow, this was so informative! Definitely followed..
Thanks so much!! ❤️
Thank you for your honesty. This is a great video
You are so welcome!
great sharing! love it, im thinking to learn phyton skills to b data scientist or data analyst, now tat u point it out. its true, entry level mostly require those 3skills.
Thank you!
love this....start and then you learn....not learn then you start........
Yes! Best way to learn is just by starting!
Thanks so much. ❤
Hello, could you help us with a video on how to do and find material for the data analyst projects in the 4th month of the learning route? a guide on how to find information to start a project, what tools to use and in each part of the process what tool to use (excelsql, tablue) thank you
Thank you very much for the video, Agatha. You can't imagine the burden you took off my shoulders and now I can start walking.
+1 subscriber
We learn a lot from you.
I'm glad the video was helpful!
Thanks for this road map
You’re very welcome!!
Great Content! @agathakang quick question about the end what did you mean by Start and then Learn versus Learn and then Start?
Also do you recommend focusing solely on the skills in the first 2 months or do you think there is any sense in still applying for jobs within that time as well if some good positions come up? Thank you for any advice in advance!
Thank you so much!
Thanks for watching!!
Thank you so much for making this video ❤ it is very useful 🙏🏻🙏🏻🙏🏻
You’re welcome ❤️❤️
i really needed to see this video right now. this helps me direct some of my next efforts. subscribing!
Glad it was helpful!!
Can we learn together?
I am looking for a study mate so that I can be serious
A realistic prep guide❤
Thanks so much! ❤
THANKS a lot for this road map, I am transitioning from Data center engineer to Data analyst.
You’re welcome! And good luck with the data journey!
Hey Agatha! Do you happen to have recommendations for certifications? Do you believe the Coursea Data Analytics one is good enough to consider for my' building my portfolio' stage?
Thank you for this video
You’re so welcome!
Very informative video , please do a video on how to create LinkedIn profile for applying data analyst roles,thank you
Thank you very much.
You’re very welcome!
Subscribed! Thank you. 🙏🏻
You are so clear thank you
You’re welcome!
Thank you so much Agatha - I'm stoked to watch all your videos as I'm considering this position... How likely would you think it is to land a fully remote Data Analyst position? And how likely for someone new to the field? .....Thanks again!
thank you very much this video is very amazing ❤❤ I have a question so I'm very afraid about AI in this job so what do you think about the in data analysis ?
Really appreciate this video and info. Looking to make a career change and Data Analytics is the path I'm leaning towards. How do you feel about Bootcamps? I've been researching and the Fullstack course looks like it covers all you've talked about. Honestly lost and just looking for guidance and feedback. Greatly appreciate your response.
Excellent presentation 🎉
thank you so much! 😀
Thank for this beneficial video
Thanks so much for watching!
Thank you❤
Thank you Agatha, you just made my day easier.
You're welcome 😊
hi! just found your channel and want to get started NOW! In the link to learn excel via IBM's course on coursera, there is a dropdown of multiple types of classes. Which one do you recommend? I do not have any excel/analyst background
THANK YOU SO MUCH, I CAN DO THIS OMG
Yes you can!! You got this!
you made my day
This content helped me a lot, although I am already doing a data analyst course I found this video today and it gave me clarity... you had won me over
congrats you are doing great!
Thanks so much! I’m glad the video was helpful ❤️❤️
Great tips.
Thank you!!
thank you so much💞
You're welcome 😊
Thank you very much
You're very welcome!
thanks a lot i watchhed tones of videos with no benifit you was breve and helpfull
Thanks so much! There’s a lot of videos but I’m glad this was helpful
Hi there, thank you so much for that information, I'm on my journey to become a data analyst. Could you recommend a website or a place to have the portfolio? I have seen some video where they have it on wix or other pages, but could you recommend one, thanks!!
Nice one
Thnks you l really appreciate your career and effort
l hope to learn you all that amazing skills one day
Thank u for wonderful video
❤ From chennai , India
You’re welcome! Thanks for watching! 😁
thank you !!!!!
You're welcome. Thanks for watching!!
Thank you.. I have a Bachelors degree, but fall short on the technical piece. This is absolutely helpful..
Same..The technical part is not my strength either but definitely doable!
Thankyou for your insight🥹.
Thanks. I have been preparing the statistical data report for 6 years in excel and adding data visualizations which are very helpful. Is that true that power BI can replace data analyst job?
Thank so much.
You're a gem.
All the way from Ghana, Africa.
You’re welcome! Thank you for watching ❤️
Nice video,do you think there is a connection between Data Analysist and Security Analysist ?
Another data analyst suggested using canva to create visuals for the analyzed data. Do you recommend this as well?
Спасибо!
I just stumbled on your post, and I’m glad I did. Please how do I move forward from recently completing a Cybersecurity Challenge with concentration on GRC domain, to getting a job but no hands on training. Any help please?
thank you!
You’re welcome ❤️
Please guide us about doing project .
is thier a course that bundles everything together?