How to get a data analyst job with no experience (data analyst roadmap)

Data Analyst Roadmap 2024. Data Analyst career path broken down into simple steps so that it's easy to follow for data analytics training. 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 tools (SQL, Excel, Tableau, BI 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 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 (similar questions to the ones I’ve seen in my interviews): 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: [e-mail]
📄 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
01:28 - Data Analysis
05:04 - Portfolio
07:04 - Apply for Jobs
08:34 - 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!

[@agathakang]

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)

[@intanjdon]

Thank you for the tips! I hope your channel will grow bigger.

[@currlinechong]

Great tips, thanks!

[@agathakang]

You're welcome!

[@NtombozukoZenani]

When you said "Theu are going to be a lot of people watching this video that have the idea of being a data analyst but never do anything.Because they either have doubts,fear or are just lazy[😢sad truth you're talking to me] Im putting myself out there ,I will take action.I will start today with Excel🤚

[@TY-zl1vw]

Thank you, so many great points you're making in this video. For me, particularly the reminders about portfolios and taking actions.

[@agathakang]

Thank you! Yes it's easy to just watch tutorials but taking action is what will get you closer to the data analyst role. I'm glad the video was helpful

[@jayhommy11]

Very informative, clear messages I’d like to hear more about interview settings. Thank you!

[@agathakang]

Yes it's on the list! and glad it's helpful!

[@pranav3523]

beautiful job Agatha. Video was very well structured to the point and filled with valuable info for a beginner. Thanks a lot

[@agathakang]

Thank you! I'm glad it was helpful

[@LeandraParkerFit]

Thanks for sharing so many insights in this video Agatha! I am in the beginning of my journey to learn data analytics and you've inspired me to take action!

[@agathakang]

You're welcome. Thanks for the comment and I'm glad it was helpful!

[@meyragonull]

I've just discovered your channel, and I genuinely believe it's gonna be the best action in my data analyst journey. Thanks a million, Agatha. Please keep going with your videos. 🌹

[@agathakang]

Hey thanks so much! Reading comments like yours really keeps me motivated to keep adding value to your data journey. I'm glad this is helpful!

[@davidkaramagi]

Thanks alot for the advice, it has really motivated me. wooow, juat starting on my journey and this is great guidance

[@agathakang]

You're welcome! Good luck on the data journey. You got this!

[@milktea147]

I like how the video content is structured and provide actionable insights. Looking forward to see more videos on how to prepare portfolio/ job hunting tips from you!

[@agathakang]

Thank you! I'm glad it was helpful. Yes I'm working on more videos with data analyst tips for you guys so stay tuned!

[@nhinvalerabayugao1418]

Love your videos and thanks for sharing and advices ❤

[@agathakang]

Thank you for watching ❤

[@wilhelmvon]

Thank you! More interview and job videos please!

[@agathakang]

Thanks for the feedback! Yes I will work on the video

[@mai192]

Thank you for your video! You addressed all concerns. I felt like you made this video for me! I needed this encouragement to keep going because I constantly feel like I am not good enough.

[@agathakang]

You're welcome! I'm so glad the video was helpful and please keep going!!

[@b.l70]

This video was very helpful and clear. Thank you so much. I subscribed! I’m on my journey to become a data analyst and I was feeling discouraged thinking I’ll never be good enough to land a junior position. I’m also feeling discouraged doing random assignments instead of hands on practice working with real data in my courses. Looks like I have to focus on my own personal projects for my portfolio.

[@courtneyp5963]

Thank you for this video! It’s very encouraging and insightful.

[@agathakang]

I’m glad it was helpful!!

[@fabianochela3552]

Thanks for the video Agatha, It's very helpful. I am currently trying to transition from teaching to data analytics. Your tips will go a long way. I have done some Excel, SQL and Tableau and I'm working on some projects for my portfolio.

[@agathakang]

You're welcome! Sounds like you're already doing all the right things. With a teaching background, you have a lot of transferable skills such as communication so definitely use that to your advantage on your resume and interviews!

[@tomatof]

Find it very related as my major was Sociology as well! Wanted to fully transition to be a data analyst for a while, I have taken so many course to learn R, python, SQL, tableau, PowerBI, you name it I have studied them all, and have built a portfolio on Kaggle, even have read stuff on statistics, but always lack the courage to take the leap, the furthest I have done is taking up a 50% analyst role in my current company and stayed 50% in my original role (not my most ideal choice but I thought it's a good starting point of an at least 50% analytics role). After watching this I am more confident, seeing someone with similar background doing the same! Also I am concerned about the age thing, just turned 30 to start fresh-ish.. But anyways, thank you for the great video!

[@NtombozukoZenani]

Thank you so much for your videos Agatha, I'm on my journey and you explained it so well.

[@mo-chen]

Great video! Congrats on getting your DA job 😃

[@agathakang]

Thank you!! 😁

[@leematabire1315]

I love your videos and they are very informative. An Interview Video will be awesome too.

[@agathakang]

Interview video is on the list! Thanks so much for watching!

[@bigbri04]

Thanks for making this video. I've been on my journey transitioning to data analytics for a bit. I'm guilty of the "watching a bunch of videos" and impostor syndrome. Still working towards it though!

[@agathakang]

You're welcome and good luck with the data journey! Data analysis is definitely as skill that anyone can acquire with practice so keep at it

[@brosjay2131]

well said. I've been so blessed. I'm transitioning into being an analyst but had gotten lazy along the way. I'm going to be intentional from hence forth. Thank you so much and oh, I liked and subscribed!

[@agathakang]

You're welcome and good luck with the transition!

[@brosjay2131]

@@agathakang thank you very much!

[@agathakang]

Let me know if you're in the data analyst journey. Would love to hear from you!

[@bars7897]

Hi, first of all thanks alot for joining youtube and making these videos, they are top-notch! I have been learning data analyst skills in last 6 months or so and I have learned a lot more than I expected to in this time. I feel like it is time for me to update my beginning projects with better ones and start applying for jobs but the job opportunities are quite low in my country. Fortunately I've always wanted to move abroad and work there but I don't know if it is even possible. I've encountered some job postings that doesn't accept applies from outside of their country and most of them doesn't say anything specific about that. Would you happen to know if such thing as my dream of finding a data analyst job abroad is possible without experience? Sorry for the long comment/reply. And thanks again for your work! They really help me keep myself motivated and can't wait to learn more from you!

[@marvelmad7]

​@@bars7897i would suggest.... Get an entry-level position in your country.... work for more than a year....then try searching for jobs in abroad companies.....but let's wait to hear her suggestions 😅

[@haris4748]

Wanted to start my journey but stopped as the AI code interpreter rolled out

[@marvelmad7]

@@haris4748 and what's that?

[@luis18axel]

I have been in the journey for quite some time now. Let me say, I enjoy it. But I still get cold feet from time to time.

[@gayalaknatha]

Thanks for the inspirational video !!!

[@agathakang]

You’re welcome!! Thanks for watching

[@NtombozukoZenani]

Your videos are so informative, thank you Agatha❤

[@drinaceballos8888]

Subscribed! I loved this video. I've been dealing with imposter syndrome nearly my entire adult life. I have earned a B.S. in Sociology and an MBA and I still lack confidence. I'm currently an HR Generalist, Latina, well into my 40s - I mention this because in our culture, education was not always at the forefront. And at my age, I should be settled in my career. However, I've always been fascinated with data analytics, I just never felt "smart enough" to pursue it. Just recently I decided to start pursuing it. Although I love my current job, I just don't know how long I want to deal with the drama that comes with working in HR. I'd like something that will provide me with a livable salary and less drama but also keep me challenged.

[@agathakang]

Hey thanks for the comment and sharing! It sounds like you're already well qualified and have a lot of work experience. Career changes happen all the time whether in you're in your 20s or 40s, so don't let that stop you. Life is too short to settle! If you enjoy data analytics please keep going. From my experience, anyone can get into the industry. With some studying and practicing you'll get there. Good luck on the journey!

[@ejaypumpkin]

Thanks Agatha. You're a real analyst for giving me the basics to join the Analytics Industry.

[@agathakang]

You’re welcome! Glad it was helpful!

[@siphokazisimelane3169]

Love your content. I'm from Africa and I'm in the process of learning skills to be a data analyst. I hope I make it

[@agathakang]

Thank you! And I’m excited for you to start your data journey!

[@miteshkareliya8540]

Really you are provide informative content to aspirant .thanks

[@agathakang]

You're welcome! Glad it was helpful

[@miteshkareliya8540]

Making this type of more informative video for carriers guidance thanks dear 🙏

[@Ma-Attia]

A great work and video I loved your words ❤

[@agathakang]

Thanks much! ❤️

[@AbhishekKumar-uj6nf]

Absolutely fascinating insights into the world of data analytics! As someone venturing into the field, your video has been an invaluable resource for gaining a deeper understanding of the intricacies involved in data analytics. I appreciate the real-world examples you provided, making the content not only informative but also highly relatable. Looking forward to more content from you to continue expanding my knowledge in this exciting field.

[@agathakang]

Thanks so much for feedback and I'm glad the video was helpful! Will continue to add more content :)

[@rondraughon5572]

Yes, I would like to learn more interview tips. Thanks.

[@agathakang]

Yes! I have a video on SQL interview questions coming on 3/1 and another one in the coming weeks :)

[@NoDrizzy630]

Excellent video! I’m currently going to school for a data analytics degree and while working at amazon and your video is great and to the point.

[@akin242002]

Are they teaching Tableau at the school? I know Amazon, Salesforce (owner of Tableau), and Target use it for their data analytics.

[@TauheedAbubakar]

How can I secure job with Amazon.I am Nigerian

[@NoDrizzy630]

@@akin242002 yes tableau and power bi

[@agathakang]

Thank you and I'm glad you found it helpful! Sounds like you're already taking steps to transition into a data analyst role. Good luck!

[@raneem9321]

Would love to hear more about the interview tips from you

[@agathakang]

Thanks for the feedback! Yes I will work on the video

[@Okaysam09]

🙋🏼 I would like to know more interview tips, also maybe a glimpse at your portfolio will help me to start building mine. Thank you for this!

[@agathakang]

Yes interview tips is on the list of videos! My portfolio at this point is all work related projects so I can't publicly share it. I will try to give more tips though!

[@ianhudson208]

I subscribed because you said you would hire the "people person" over the 'soley high tech' person. Thank you. :)

[@saisandeep6098]

Thanks agatha! 😊

[@agathakang]

You’re welcome! Thanks for watching 😁

[@stephanies3862]

This was a really encouraging video. I am thinking of taking the free courses to see if Data Analysis could eventually be a career change for me from teaching. Thank you for making this content.

[@agathakang]

You’re welcome! So glad the video helped!

[@KatlegoMokgomme]

Currently in my transition from the finance industry into data analytics. The thought of venturing into a new world was scary all the technical jargon was intimidating but I took a leap of faith and since then have not looked back, and now I'm forecasting that by the end of the year, I'll have a portfolio in place and start applying for jobs. So if there's any who really wants to start but is scared, just start you'll be amazed at how you begin to adapt over time.

[@agathakang]

Love this ❤️ yes I can completely relate to the leap of faith and feeling like you’re making no progress until you see how much you’ve done over time..I have a video on exactly this coming out next week! Also SO excited for how far you’ve come and for your portfolio 🎉

[@sevaraseva]

best video I have ever seen 😀

[@agathakang]

Thanks so much!!

[@darshanapawar399]

yes please make more for interview tips

[@agathakang]

Thanks for watching and it’s on the list!

[@rkhan736]

Tips on displaying your portfolio, best places to do it.

[@Tpmcd2010]

Very nice video! Just a friendly note.... at 3:38, when you're introducing Python, your video is showing PHP, a different programming language =)

[@agathakang]

Thanks for the note!

[@danztv6897]

I'm still looking for my first job as data analyst. Hopefully, I can get one this year lol

[@jeffreygonzalez-dg6cj]

Thanks for this video!!! I am taking a course in EXCEL via Udemy. Along with SQL and Tableau afterwards. Is there any other place you recommend to learn more?

[@janetvvan7387]

Thanks so much for sharing the information! Thanks for the clear expression! Could you share more about how to make a resume? like how to include soft skills and how to show the project without Data analyst work experience to attract the recruiter to get an interview chance? thanks so much!

[@agathakang]

Yes! This is actually next on my list of videos so stay tuned and I will share my tips on resumes

[@janetvvan7387]

Thanks so much!@@agathakang

[@kumkumchakraborty2892]

please make a video, on how to develop soft skills.

[@b1gbro398]

Please continue to share the knowledge, @agatha, thank you so much for your informative video regarding data analyst starting from "Day in the Life of a Data Analyst" it covers a lot and gives us an idea of what is the work as a data analyst. :-)

[@agathakang]

You're welcome! I'm glad it's helpful and gives an idea of what to expect as a data analyst. I just released a new one today that is more of a realistic day in the office: kzbin.info/www/bejne/oaeyZZZ6hr9nns0

[@samsbodhitree]

Thanks - I'm doing the Google Cert. course for Data Analytics(almost finished). It's so-so for me. I use supplemental material to fill the gaps. My goal for by end of the year is to be somewhat proficient in Excel, SQL, Tableau and Python.

[@marvelmad7]

Hey ... Nice that u r dng this course....i just started today.... So is it worth it for getting a good paid entry level data analyst job?

[@samsbodhitree]

@@marvelmad7 A couple of things that can speed it up: Forget about the optional forum input(it doesn't advance the % done) and personal story videos(scan the text). Also, some of video instruction is poorly done (not up-to-date). It's important to take notes and to go with links in the reading materials. Don't get bogged down on something, press forward, takes notes and use outside sources to get you up to speed. This is just a survey course which gives you an overview. Is it worth, sure you get the certificates so at least employers know that you put in the time. Getting a good portfolio together is a must (when completed).

[@aryansethi5097]

​@@samsbodhitreehey i have some working knowledge of this field already. so i was thinking of going straight to the advanced data analytics course. any suggestions or is that a bad idea?

[@marvelmad7]

@@samsbodhitree Man thanks a lot for ur explanation 👍💪

[@marvelmad7]

@@samsbodhitree And your absolutely right..... Same thoughts here too ....this course gives an introduction to data analytics field...but also very informative.....and to learn the tools and software, we need to find another source..... like KZbin videos!

[@Marelybbmarley]

Great video! You might have this already but how about technical videos about simple projects using Excel, then SQL, then Tableau and finally with Python. But I know that's a lot to ask. Thank you!

[@agathakang]

Thank you! I'll have to think about how to do technical videos if I do them but it's on the list for now. I have a long list of videos I want to create to help you guys so stay tuned!

[@Marelybbmarley]

@agathakang awesome thank you! You're videos are so good 👍I just started learning data analytics and I'm glad I clicked on is video.

[@lilychepkemoi3041]

I am currently studying to become a data analyst. It's Avery new field to me since I am a teacher by profession, I hope I will make it

[@monicahkaranja4291]

Hey how is it going for you ?

[@agathakang]

Yes as a teacher you have great communication and presentation skills. Leverage your professional experience along with technical skills and that will help you transition to the data analyst field.

[@dushkina_alona]

nice to see Kyiv National University in the first second of the video 😊

[@agathakang]

that's awesome 🙂

[@samueltatsu]

Thanks for the video, sharing and explanation! I dropped out of college, which is something I regret but can't do anything about now, but I don't want to waste the years I spent studying. I majored in applied math because I was quite interested in data science/analysis. I'm about to start participating in a data science bootcamp, so excited to start this journey. That's why I'd like to prepare myself as best as I could and your video really helped me a lot in giving me direction what to do. So, once again, thanks a lot!

[@agathakang]

I took a data science bootcamp too which I talk about in next week's video. It helped level up my skills but definitely requires a lot of discipline to still do a lot of studying on your own. Good luck with the bootcamp!

[@03_dineshkumarv20]

I'm looking for DATA ANALYSIS

[@thumpertorque_]

I've been hearing the software field is extremely hard to find a job at now days and people can't even get an interview after thousands of applications. Maybe I'll just get my CDL license and drive trucks which is more physically challenging but the fastest way to start earning close to a 6 figure salary.

[@agathakang]

The job market has been incredibly tough this year but the market does have its ups and downs. It's not realistic to expect a 6 figure salary for an entry level data analyst job immediately. It does take time. When you get to senior and higher levels the salary does go up more.

[@luis18axel]

In minute 9:27, when impostor syndrome is mentioned, that's when I felt identified immediately. I am aware that I use analytical skills every day, but not belonging even though that's where I want to be at is my fear.

[@agathakang]

I still struggle with this myself. You're not alone in feeling that way. It's an uncomfortable feeling but embracing it and using that to move past it helps!

[@microsmart714]

Why is PowerBI called merely a visualization tool while it can do so much more? The Dax formulas are so powerful. Am I missing something?

[@Disa484]

Can you give your portfolio link so that we can walkthrough and understand how to do

[@Jackson_rw]

Hey Agatha, how much math would you say someone should know when working as a data analyst? Cheers

[@agathakang]

Basic math is required such as mean, median, mode, percentile, average. You don't have to manually do these calculations but you should know what they mean and when to use them. It really depends on the industry and the job but in my role, I don't use more than those listed. Especially for an entry level role, it should be enough to know those.

[@Divy91311]

Hey Agatha , really nice video! I was wondering if I could help you edit your videos and also make a highly engaging Thumbnail which will help your video to reach to a wider audience .

[@agathakang]

I'm still working on editing the videos myself but thanks for the feedback!

[@MsOr12]

Can you do a video of how and where to create this portfolio? Pleaseeeeeee

[@EnonyVict]

What about the promotion process? In my state, BA and DA are two specialized fields, and in the long run, will it be easier for BA to get promoted to PO or manager? What do you think about DA?

[@agathakang]

The promotion process really differs by company but you're right the BA and DA are 2 separate specialized fields usually. Many factors will determine which field gets promoted faster such as the industry, availability of positions, what type of manager. In my experience, I've had a lot of non-technical managers too so if your goal is to eventually be a manager I would say choose the path you enjoy more as moving up will be easier.

[@mounirnassiri5693]

I completed the Google Data Analysis Certificate in approximately a year and a half, but I did not work in it and I feel as if I do not know anything in this field. What is your advice?

[@agathakang]

The thing about certificates and courses is that it's really hard to learn without applying hands on knowledge. Even I get rusty when I don't use SQL for a few months. The best way to learn is to do a project. Whether it's through an internship, on the job, volunteer, or on your own. There are datasets available on Kaggle where you can start with a problem statement first and try to solve it using data analysis with the dataset to get a sense of what data analysis is.

[@rcamis]

Nice

[@agathakang]

Thank you!

[@NB20079]

You're background before Somehow it can help you get a Job as a data analytics

[@zabashhd459]

Hi Agatha can you share some top quality projects for my portfolio

[@agathakang]

It's on the list of video ideas. I need to think about this one!

[@vishnuraalla9527]

Any suggestions on internship programs for data analytics

[@agathakang]

The best way would be online. I personally use Google careers and would recommend linkedin to see if anyone in your network has internships or opportunities listed there.

[@chandreshslal9686]

We can get data from Kaggle but how can we prepare set of questions to get ready for analysis.

[@agathakang]

It can be any question that you can solve with data and do an analysis with trends. For example, if you're looking at your bank statement you can analyze "what is the trend of spending in 2023?" and categorize the spending into "entertainment" and "food" to see what types of insights you can get.

[@PavanKalyan-ro7zp]

Can you please share us how to bulid our first portfolio please Mam.

[@agathakang]

It's on the list of video ideas. I need to think about this one!

[@super_man.]

I'm a fresher, I applied many companies but didn't get reply please talk about job search process

[@agathakang]

Yes it's on the list!

[@luvyoukiki]

just wondering is that possible to land a job as data analyst without bachelor degree?

[@agathakang]

Yes it's possible but you will need to leverage work experience. If you can get your foot in the door with any work experience related to the industry you want to work in and have hands on experience, you will stand out and have a better change to land a job without a degree.

[@akin242002]

Oh, not the dreaded SSRS. I had to use it in college (mid 2000s). Horrible data visualization tool. I'm very happy for the rise of Tableau and later Power BI. Matlab was nice but used for hard science and academia. Not so much for business like Tableau and Power BI.

[@agathakang]

Same! SSRS was terrible and we thought that was good back in the day 😂

[@tahreerhussain3898]

How much is pay for data analyst and how much you get ?

[@agathakang]

Hey I go over this topic in this video: kzbin.info/www/bejne/jnm8l5xrnbZ2aac the second topic in here is how much a data analyst gets paid and what factors go into it

[@MB-cd7eo]

Pie chart with more than 5 categories. Boo! :)

[@tanjaa9092]

yeah, it's a false statement. You had a business background. If you were coming from any unrelated to business (or similar) and/or IT - THEN I would assume it's applicable. For you - to give an honest title to this video - would be "how to transfer into business analytics for business professionals". Everything else is misleading.

[@Miro-_]

Don’t think you need to have a business background to learn sql or python lol

[@mvjnatividad3136]

To give an illustration, a person can not be a carpenter in a day just because he's able to put planks and shingles on a house. He just knows the basic concept, but if he's to put in hours in getting the foundational knowledge and able to apply it, he'll eventually be a carpenter. Sure, who's to say having a finance, maths, or MBA wouldn't give you an edge in analytics? Of course they do, but having no background doesn't negate the fact that learning fundamentals can get someone's foot in the door in data analysis.

[@userwheretogo]

Don’t become one. This is a dead end job

[@The14roscoe]

Don’t want to brag, but my clothes hamper has two sections. One for each.

[@agathakang]

I need that!

[@1000xp]

Data analyst jobs are dead, ai taking ever .

[@justluckyz]

wow on the last day of 2023 and I saw your videos. They are so helpful! thank you for being so honest and direct! i really appreciate it! I wanted to become a data analyst but has no experience. I applied to so many jobs but I didnt even get a single interview despite I have a math degree😭 It is embarassing and depressing. Thank you for your videos now I have a better idea what i need to do!

[@agathakang]

Thanks so much for the thoughtful comment! I too got rejected several times before landing my job. It's all about what you learn from it and keep going! Happy New Year and good luck on the data journey!