How I'd become a data analyst (if i had to start over) in 2024

Подписаться 25 тыс.

Просмотров 310 тыс.

50% 1

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/zNJ6xW
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!

Опубликовано:

27 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 366

@agathakang 5 месяцев назад

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)

@AlexC.-fy8xx 27 дней назад

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!

@LeeWel 24 дня назад

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!

@theneoncookie8402 21 день назад

Literally in the exact same position we got this

@supryaazhakath7385 21 день назад

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

@moonchild1749 20 дней назад

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

@victormanuelhernandez6431 15 дней назад

I wish you the best Life is a trip, enjoy the road 😊

@lancelaube3233 Месяц назад

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 🙏🏼

@elizabethchrismanshurtz1208 Месяц назад

Thank you for sharing your insight and structure!

@starttofinishmediaco.2520 2 месяца назад

Wow what a break timeline and thoughtful break down of info!! Thank you!!

@Motivation4self24 2 месяца назад

The way you explained is wonderful.

@sabinaorujova2046 Месяц назад

Great explanation! Thank you for sharing your experience!

@aminasonus 3 месяца назад

Thanks for this content! I started binge watching you and will begin my 6 month journey. :)

@agathakang 3 месяца назад

Love this! And I’m excited for you :)

@omarbarron1767 5 месяцев назад

Great video thank you. Trying to build my skill set geared towards analytics and cybersecurity

@agathakang 4 месяца назад

Thanks so much and yes analytics and cybersecurity is a growing field!

@xOrchid23x 5 месяцев назад

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! 💕

@agathakang 5 месяцев назад

Glad the video was helpful! It's overwhelming at first but break it down and follow the steps. Good luck with your journey!

@arefwahb7771 5 месяцев назад

Hello, I am considering taking google DA course. Is that really helpful according to your experience? Thank you

@tinaviju580 5 месяцев назад

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.

@xOrchid23x 5 месяцев назад

@@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.

@alexzandriathegood 2 месяца назад

You completed the certification and still felt stuck? That's not a good sign 😔

@aridjferhat8919 27 дней назад

Thank you, i will start today

@rvsesei 2 месяца назад

Thank you so much it's very helpful ❤

@Avocado-fg3eu Месяц назад

Very helpful, Thank you!

@candlemcstick4024 4 месяца назад

Thank you so much for the roadmap!

@agathakang 4 месяца назад

You’re welcome!!

@Its_vickkiii_ Месяц назад

You are GREAT at explaining!

@vivimaslachaprimananda4828 День назад

I truly appreciated your video. The way you teach the audience is incredibly clear. You explain complex topics in a way that's easy to understand, and the language you use is straightforward and engaging.

@albertlopez03 3 месяца назад

Wow! The Fact that you are providing so much value for free is just amazing! Thank you so much!

@agathakang 3 месяца назад

You're welcome! I'm so glad the video was helpful!

@kawaiihikari0 2 дня назад

wow you are so knowledgeable omg im binge watching videos of yours such value img etting literally bookmarking everything

@mysterykardashian 2 месяца назад

This was a great video. Thank you 🙏

@LaydyDivine 4 месяца назад

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!

@LaydyDivine 4 месяца назад

Thank you for also providing examples of projects once finishing learning each skill

@agathakang 4 месяца назад

So glad this was helpful! If you have more time to commit, it’s possible to transition faster than I outlined!

@svenfriess8275 5 месяцев назад

THX for your motivating videos. I did recently stumble over your content and there is a lot of valuable information in it. /S.

@agathakang 5 месяцев назад

So glad it's helpful! Yes keep going 🙌

@Beeteedub Месяц назад

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 ❤

@EssamAmmar Месяц назад

Thank you for this great Content

@telly_0 5 месяцев назад

This was really helpful. Thank you!

@agathakang 5 месяцев назад

Glad it was helpful. Thanks so much!

@eumirjaggeruy5024 Месяц назад

thank you for this wonderful video it will help me a lot

@ddrevm Месяц назад

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

@chandreshslal9686 5 месяцев назад

Thanks. Loved your content

@agathakang 5 месяцев назад

Thanks so much!

@michaeloliver6745 21 день назад

Great video!!

@weiliuvivian 5 месяцев назад

Thank you so much ❤ for sharing. I have started the process as you recommended, will see how it ends 😊

@agathakang 5 месяцев назад

You're welcome and good luck! Very excited for you!

@EdgarRios-rl4no 2 месяца назад

update???

@bozlj24 Месяц назад

update?

@mohabmohammad164 5 дней назад

Update?

@ThePrinceUva 3 месяца назад

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.

@CuteButLonely9 2 месяца назад

Hey, thanks for the content. Great advices, you are inspiring.

@agathakang 2 месяца назад

Hey! Thank you 🩷

@3Oh3metrostation 5 месяцев назад

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.

@Aminamuhammadummy 4 месяца назад

Please can we learn together

@agathakang 4 месяца назад

Glad the video helped! I talk about the market in this week’s video and what you can do to stand out ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dAsE77Y4DPI.htmlsi=SFTU3pPYh5gjQMz0

@hugomartinez8114 3 месяца назад

Refreshing information. Thank you.

@agathakang 3 месяца назад

You’re welcome!!

@clair5385 2 месяца назад

no fat straight to the point, subbed

@JettIM96 5 месяцев назад

Thank you for these videos, they're really helping me

@agathakang 5 месяцев назад

I’m glad they’re helpful! Thanks for watching!

@AlexanderBlessing 22 дня назад

Thanks so much. ❤

@Frendoftoni 29 дней назад

Thank you!

@kittsantos-ocampo6432 5 месяцев назад

Wow! Thank you! Your presentation is awesome...To the Point! More power to u :)

@agathakang 5 месяцев назад

Thanks so much for watching :)

@rajakarthick3413 Месяц назад

Great work❤

@chimdinmamelikam7021 2 месяца назад

Thanks for this content. Such great advice I must say

@agathakang 2 месяца назад

You’re welcome!!

@rexhua4833 5 месяцев назад

This is valuable. Thank you Agatha.

@agathakang 5 месяцев назад

You’re welcome! Thanks for watching

@Talkswithmargarita Месяц назад

Thank you for your honesty. This is a great video

@agathakang Месяц назад

You are so welcome!

@stanshy89 4 месяца назад

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.

@muhammadfayiz6869 5 месяцев назад

Thanks for the video, i will try it.

@agathakang 5 месяцев назад

You’re welcome!

@freyblake9028 8 дней назад

Thank you so much mam This looks really helpful I will start from today 😊❤

@sasadayuka867 3 месяца назад

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.

@XGARXS 2 месяца назад

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

@orangefly3263 4 месяца назад

Thanks. Your video give me a lot of tips that could guide me how to prepare myself to data analyst . much thanks.

@agathakang 4 месяца назад

You're welcome! I'm glad it was helpful

@mssdot6374 4 месяца назад

Thank you for sharing your insights with us! I really appreciate this video. ❤

@agathakang 4 месяца назад

You’re so welcome!! ❤️

@noko145817 5 месяцев назад

love this....start and then you learn....not learn then you start........

@agathakang 5 месяцев назад

Yes! Best way to learn is just by starting!

@staywithamber 5 месяцев назад

This was definitely very informative and will help folks thinking about moving to the data analyst field.

@agathakang 5 месяцев назад

Thank you! Glad it was helpful!

@corilou5273 4 месяца назад

Wow, this was so informative! Definitely followed..

@agathakang 4 месяца назад

Thanks so much!! ❤️

@romaniamaseko2460 24 дня назад

You are so clear thank you

@agathakang 20 дней назад

You’re welcome!

@chickenkiddy123 4 месяца назад

Thank you. I appreciate videos like this where it’s straightforward and to-the-point. Subscribed !

@agathakang 4 месяца назад

Thanks for watching! And the subscribe! ❤️

@NiNi-et1dd Месяц назад

Thank you❤

@cuddy90210 4 месяца назад

Thank you so much!

@agathakang 4 месяца назад

Thanks for watching!!

@linseyk5728 Месяц назад

This is crazy. I did not even know this was a career option!! I am 1000% looking into this more.

@tamilatorabeghdami9711 2 месяца назад

Thank you so much for making this video ❤ it is very useful 🙏🏻🙏🏻🙏🏻

@agathakang 2 месяца назад

You’re welcome ❤️❤️

@octagonmixltd 3 месяца назад

Thank you very much.

@agathakang 3 месяца назад

You’re very welcome!

@silveriojohan 27 дней назад

Thank you Agatha, you just made my day easier.

@agathakang 20 дней назад

You're welcome 😊

@ayshasaleem6 Месяц назад

Thankyou for your insight🥹.

@rohitbhandari6382 9 дней назад

Nice video thanks

@user-de9kq8yv1x 5 месяцев назад

Thank you so much for the video. Now I get started to prepare data analyst.

@agathakang 5 месяцев назад

Yes! Good luck with the data journey!

@valtecioc.soeira786 Месяц назад

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

@user-eh9pv9yc3j 3 месяца назад

Thank you for this video

@agathakang 3 месяца назад

You’re so welcome!

@MeelXfiles 2 месяца назад

you made my day

@mariameboukrim657 5 месяцев назад

We learn a lot from you.

@agathakang 5 месяцев назад

I'm glad the video was helpful!

@benedictaiheme489 3 месяца назад

Thanks for this road map

@agathakang 3 месяца назад

You’re very welcome!!

@Xilent1 5 месяцев назад

Exactly what I needed to hear. Realistic expectations & achievable. Trying to change careers, so this helped a TON. Really appreciate the info.

@agathakang 5 месяцев назад

You’re so welcome! Glad it was helpful and good luck with the data journey!

@dhassard8327 Месяц назад

Subscribed! Thank you. 🙏🏻

@Madhu._.01 5 месяцев назад

A realistic prep guide❤

@agathakang 5 месяцев назад

Thanks so much! ❤

@abdulrahmansh7131 5 месяцев назад

Thank for this beneficial video

@agathakang 5 месяцев назад

Thanks so much for watching!

@KingdomChat 17 дней назад

Thank you

@hlengidlamini8764 3 месяца назад

THANK YOU SO MUCH, I CAN DO THIS OMG

@agathakang 3 месяца назад

Yes you can!! You got this!

@prabhabejjanki6174 4 месяца назад

Very informative video , please do a video on how to create LinkedIn profile for applying data analyst roles,thank you

@ruby2thursday 4 месяца назад

i really needed to see this video right now. this helps me direct some of my next efforts. subscribing!

@agathakang 4 месяца назад

Glad it was helpful!!

@Aminamuhammadummy 4 месяца назад

Can we learn together? I am looking for a study mate so that I can be serious

@IguineMicheal 3 месяца назад

thank you so much💞

@agathakang 3 месяца назад

You're welcome 😊

@breedavis5659 4 месяца назад

Great tips.

@agathakang 4 месяца назад

Thank you!!

@Hippowalker0 4 месяца назад

Thank you very much

@agathakang 4 месяца назад

You're very welcome!

@o1techacademy 4 месяца назад

Excellent presentation 🎉

@agathakang 4 месяца назад

thank you so much! 😀

@jeanpierreidi5597 5 месяцев назад

THANKS a lot for this road map, I am transitioning from Data center engineer to Data analyst.

@agathakang 4 месяца назад

You’re welcome! And good luck with the data journey!

@chiomalilianezema8535 2 месяца назад

Nice one

@oscarivanmartinez3473 5 месяцев назад

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

@samsonpaulus8298 Месяц назад

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!

@asgdino 5 месяцев назад

thanks a lot i watchhed tones of videos with no benifit you was breve and helpfull

@agathakang 5 месяцев назад

Thanks so much! There’s a lot of videos but I’m glad this was helpful

@jesseaddo2041 4 месяца назад

Thank so much. You're a gem. All the way from Ghana, Africa.

@agathakang 4 месяца назад

You’re welcome! Thank you for watching ❤️

@sameershahul112 5 месяцев назад

Thank u for wonderful video ❤ From chennai , India

@agathakang 5 месяцев назад

You’re welcome! Thanks for watching! 😁

@jtasaurus 24 дня назад

thank you!

@agathakang 20 дней назад

You’re welcome ❤️

@maimunahassan6519 Месяц назад

Thnks you l really appreciate your career and effort l hope to learn you all that amazing skills one day

@JoseLuisMNguba 4 месяца назад

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!

@agathakang 4 месяца назад

Thanks so much! I’m glad the video was helpful ❤️❤️

@user-ih7si1fs1p Месяц назад

Спасибо!

@loshon38 5 месяцев назад

Thank you.. I have a Bachelors degree, but fall short on the technical piece. This is absolutely helpful..

@agathakang 5 месяцев назад

Same..The technical part is not my strength either but definitely doable!

@jfong3646 Месяц назад

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!

@yashbhlaerao8819 5 месяцев назад

thank you !!!!!

@agathakang 5 месяцев назад

You're welcome. Thanks for watching!!

@siminakhlaghi5466 3 месяца назад

Please guide us about doing project .

@ilyas..19 3 месяца назад

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 ?

@nicakufm 2 месяца назад

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.

@tharindunuwan1819 4 месяца назад

what a clear video wow

@agathakang 4 месяца назад

Thanks so much!!

@Intensification 4 месяца назад

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

@angelamagp 2 месяца назад

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!!