ROADMAP to becoming a Data Analyst in 2024

Back in 2020, I entered the Data Analytics field after completing my Master’s in Business Analytics in the US. It cost me $50,000 and took two full years to master various analytical techniques, acquire necessary skills, complete numerous projects, and build a decent resume.
But guess what? You don’t need to go through all that.
In 2024, you can become a Data Analyst with zero investment, leveraging only KZbin and ChatGPT.
Curious how? Watch my latest video where I share the exact roadmap I’d follow if I were starting over from scratch.
Resources to get started:
Excel
- Excel tutorial(KZbin) - • Pivot Tables in Excel ...
SQL
- Codebasics(KZbin) - • SQL Tutorial For Begin...
- freeCodecamp(KZbin) - [ / @freecodecamp ]( • SQL Tutorial - Full Da... )
- Luke Barousse(KZbin) - • SQL for Data Analytics...
Python:
- Luke Barousse(KZbin) - • Python for Data Analyt...
- **Python for Data Science(**Udemy) - www.udemy.com/...
PowerBI:
- How to PowerBI(KZbin) - / @howtopowerbi
- Microsoft Power BI Desktop for Business Intelligence - www.udemy.com/...
Tableau:
- Tableau 2024 A-Z -www.udemy.com/...
Projects:
www.kaggle.com/
Timestamp:
00:00 Introduction
01:28 Excel
02:26 SQL
03:29 Python
04:14 Data visualization
05:33 Basic Math and Statistics
05:55 Build Projects
07:26 Outro
#datascience #dataanalytics #dataanalyst #sql #excel #powerbi #tableau #python #careertips #dataengineering #datavisualization

[@koushik-xs2qg]

i started my analytics journey around 2 weeks back , and yes i started it with excel and now working on SQL , i didn't expect that a random roadmap of mine is that accurate to crack a job . Thanks you !

[@rpsandeep22]

Thata awesome. Its not a random roadmap what you are following. The fact is thats enough to become a data analytics and not complicate things too much

[@mr.trendz3460]

@koushik-xs2qg hi can we connect because i am also started same sql done now i am starting python

[@LekhaSuresh_0417]

​@@mr.trendz3460hi can you please guide me as I am a recent graduate bit confusing to start could you please share resources you are going through

[@siddhardhareddyvadde4885]

I too

[@arshil6449]

Bro aapne course le rkha h ya youtube channel se krre ho please channel name batao ya course ke rkha h to wo batao

[@Sruthi-ej3qr]

I was really interested in data analysis and found your post to be very helpful. Thank you.

[@rpsandeep22]

Thanks a lot. Keep following!

[@LekhaSuresh_0417]

Heyy dear can we connect cause I am recent graduate a bit confused .. Could you please share the resources you are going through

[@raknasyoutubechanel3920]

Omg , I just listened to 30 seconds only, i liked your voice, tq amazing brother

[@rpsandeep22]

Haha. Thanks for the compliment.

[@krishnapriya038]

Those who are saying no jobs so listen I works as a IT recruiter and for one position we screen atleast 6-7 candidates. In the first round those who score high we consider them only for next round So yes there are jobs but high competition And yes for fresher sometimes it is difficult to find a job, so as a fresher try to grab a job even with less payscale, don't be too choosy. Your first aim should be getting an entry-level position then you can upgrade your skills and apply for higher roles.

[@rpsandeep22]

Wow. This is so perfect. Exactly what is needed for the freshers. Get into something and then upskill later on.

[@nirbhayshankar7238]

LinkedIn id pls

[@Investing-power]

What is your linkedin I'd

[@SANDATA764]

Thank you very much for such kind of content, really appreciated. Could you please start posting portfolio projects on different tools so we can get the idea of how you are solving or figuring out the problems in the real world.

[@rpsandeep22]

Yes sure. I am planning to make those videos soom

[@t_mahajan1411]

More frequent videos please, for 2025 intake...As it is a crucial time, your videos have been invaluable.

[@rpsandeep22]

Yeah sure bro. I will try my best

[@adnanashraf615]

Awesome video editing and content

[@rpsandeep22]

This video was edited by someone else. Credits to him. And thanks for appreciating the content

[@fintess_tv6517]

Thank you so much brother ❤love from tamil nadu

[@rpsandeep22]

Welcome

[@harshpal3795]

You have done great work. My question is where i can prepare for interview questions after learning this things. If possible please make a dedicated video for interview preparation for each of thing that is needed to become a data analyst

[@rpsandeep22]

Thank you! thats a great suggestion. I will make a video soon on data analytics preparation.

[@naveen4741]

Waiting sandeep Bhai..!!

[@mahalakshmia3287]

Got an idea regarding my next step thanks a lot master Yeah am currently in my 6th semester engineering this made me to work a lot more harder thanks for the info❤

[@rpsandeep22]

Thank you. Glad to hear.

[@sabaribabu-jp3ws]

The video is very good and informative. I have a doubt: is there a demand in the USA market for data analysis and data science? Can you also talk about data science and data engineering? Keep posting videos; they are very useful. Thank you.

[@rpsandeep22]

Yes there is demand. I will make those videos as well

[@KelvinMiano-yu9fn]

thank you very much for sharing this

[@rpsandeep22]

My pleasure

[@MayankAlawadhi]

Thank Bro This Video guide me with a complete Roadmap to Follow...

[@rpsandeep22]

Glad to hear that

[@muktasairatna2940]

Tq so much for this video especially about luke barouse I am searching for this info for very long time

[@rpsandeep22]

welcome bro.

[@pathanfirozkhan5503]

Informative video, Thanks

[@rpsandeep22]

Welcome bro

[@sunny-bv6rb]

i started following your channel and started course of data analyst

[@rpsandeep22]

Thank you brother

[@pratikashchoudhary7840]

From where bro you take the cource

[@sravankumar5634]

Thank You So Much!!😃

[@rpsandeep22]

You're welcome!

[@Swadeshi_Bharatiya]

I have just liked and subscribed

[@rpsandeep22]

Thank you!

[@abhi_chaudhari110]

bro i am in 5th semester of engineering and i wanna became data analyst, but i am little afraid of that is freshers can get job in data analyt in India? specifically in Maharashtra cities like mumbai, pune etc

[@Suhi__JS]

I recently started a data analyst course and have learned Excel, Power BI, and Python (including Pandas, NumPy, and Scikit-learn). I've completed some projects in Power BI and Excel, which I shared with my sir. However, he mentioned that my non-technical background might hinder my job prospects, and I've been feeling really down about it for the past week. As a result, I'm considering not continuing with the data analyst course because of his comments. What should I do?

[@rpsandeep22]

Thats fine. Try to build experience by freelancing or internships first. Be active on linkedin.

[@surveillancebott]

I am 27, and working as a Graphic designer from 2 years, My question is , Will companies offer me jobs, given that I was previously a graphic designer? Will it be a tough task for me to get a job? Will I be asked questions like, "You are not stable; you do this sometimes and that sometimes"

[@rpsandeep22]

Then Build your credentials as a data analyst and then start applying

[@haniabdulrehman7774]

I just started my Data Analytics journey around a month back focusing 1st on python & i subscribed to a 100 hour course on Udemy for Data science it consists of all the filtered python,sql,data visualization tools & the mathematical tools along with Deep learning...

[@rpsandeep22]

Thats great. Keep up the good job bro.

[@haniabdulrehman7774]

Thnx hardwork,consistency,sincerity, the 3 most important tools to be successful ,​@@rpsandeep22

[@devanshdubey4588]

Bhai course hindi mai tha yaa english me?

[@haniabdulrehman7774]

English main hain bhai.Hindi main mere ko maalum nahi hain avlble hain kyaa?​@@devanshdubey4588

[@Mr.Mahesh6]

Please make a video that there is a more demand of data analysts in US or UK , can we apply for the companies that are in US and UK , what is the procedure and How to crack that Other country interviews , please make a video bro ❤❤ Waiting 🙏

[@rpsandeep22]

Yes sure bro. thats a video lot of people have requested

[@Sai_Dangade]

Can you please review Full Stack Data Analytics course of i-neuron ?

[@jameelkasar249]

I am not from IT background Bro.I have completed html,css and now learning python from last 3 months...my question is it would be great for me for remote job because i can't go anywhere

[@rpsandeep22]

I dont understand your question.

[@Pruthvibalai2024]

Thanks

[@rpsandeep22]

Welcome

[@shanmugappriyak9430]

Thank you so much

[@ayeshaamjad2513]

Very informative 😊

[@rpsandeep22]

Thank you!

[@udayreddy1375]

Brother please tell me about Indian market on data analyst jobs (opportunity ratio, salary, any experience req...etc)😊

[@shwetas4388]

Pls bring data analyst interview vedio . Which area we should focus more

[@rpsandeep22]

Yes sure. I will make it soon

[@Puneet-Yadav7423]

Which institution is best coaching in Delhi and placement

[@sanjanpallerla7556]

Very nice bro 👍

[@rpsandeep22]

Thanks ✌️

[@dp0231]

please make a one more video for how to apply for this job

[@rpsandeep22]

Sure bro. Thanks for watching. I will make one soon

[@jojo342-o1n]

Thanks a lot

[@rpsandeep22]

Welcome!!

[@muthukumar.r7918]

Post a video about how to create a free data analyst portfolio

[@rpsandeep22]

Yes sure. I will make is soon.

[@roopar3815]

Hi sir your videos are magnificent i have completed my certificate course in data analytics but how to start or make projects on data analytics and please share your resume

[@rpsandeep22]

Check my linkedin. For projects start with codebasics playlist

[@mosesflood3716]

thank you for the video, it was short and to the point❤

[@rpsandeep22]

Thank you! That was the idea.

[@KrishnaGupta-gj9yt]

Can i become an data analyst after BCA.

[@A-M-A-N-G]

Thanks buddy 🙌

[@rpsandeep22]

Welcome bro

[@meenakshisingh2226]

Offline institute bta do sir koi data analytics k lie

[@cleanzodiac6247]

Hello, I was scraping data using Scrapy to obtain research on dataset search of autonomous vehicle efficiency and environmental impact, but now that I have the data scraped, I don't know what else to do. Do I add it to SQL, PowerBi or Excel? My data is based on 20 sites in total, and it's mostly text data and some numbers.

[@rpsandeep22]

Yeah load into a databsee first. And then take it to powerbi or tableau to anlayse it

[@sumitkoshti1171]

Load or dump your data on Mysql or SQL Server, Do adhoc analysis, Integrate Power BI or Tableau with Database System (Mysql, Sql server), Import data from Database, Do Analysis, Create visuals, Make Report of it and Publish it..

[@jatin68773]

Some reputed it coachings says there are no jobs for freshers in data science Is it true or not ?

[@rpsandeep22]

I dont think so. There are openings for freshers.

[@abdulnihaalsyed4782]

@@rpsandeep22 brother to become a data analyst or data scientist, is masters degree requirement to crack in data domain..please tell your views on it as ur in this field and know it better. btw i came accross this channel and its wonderful

[@allaboutpubg8301]

Can you share us your dataset for creating a application tracker, i also got laid off and i want to build the same.

[@rpsandeep22]

Yea sure. Please email me at [e-mail]. I will send

[@AnjaliAdapala]

For data analyst maths is needed or not and if I don't know maths is it possible to become a data analyst or not

[@rpsandeep22]

Basic math is enough

[@namratapatil6279]

Thank you so much sir for providing good n useful information..but sir excel is so vast so which formulas is used mostly in data analyst

[@manjulaannam257]

I need some information as a data analysis python concepts what will learn

[@Unique_Engineering]

is it possible to get a data analytics job without bachelors degree?

[@rpsandeep22]

Yes. But you would need some good kind of valuable degree atleast

[@ashishsamrat4248]

Sandeep i am doing data science & BI course in 2022-23 but after that i don't get a job as i am applying for also data analyst role but i don't get call or email from companies. So please help me.

[@rpsandeep22]

Try to get internships in startups or freelanceing

[@ayushsonimzp]

Bro, I am currently enrolled BCA program. So which are the topic should I focus to become a Data Analyst or Data Scientist

[@rpsandeep22]

Bro. This is the exact video for that. I am not sure what you mean.

[@ayushsonimzp]

@@rpsandeep22 What I mean to say is that the topic which you have explained in this video, should we have an advanced grasp on that topic or should we have a grasp on a beginner's level

[@subhamitadeb4809]

Thankyou!

[@rpsandeep22]

Welcome!

[@Catwoman071]

Sir i have to become data analyst but i don't know what to do and my school principal allotted commerce stream to me please guide what to do after 12th 🙏🏻

[@rpsandeep22]

Plz follow my channel

[@harshvardhan9403]

That's one of the nice videos out there, I just wanted to ask if I need to learn R language too? or python will be enough?

[@mihirpatel9214]

python is more than enough

[@SirishaVeedilana]

good explaination 🤗

[@rpsandeep22]

Thank you 🙂

[@aravinddas6813]

Can we clean data using power bi?

[@rpsandeep22]

Yes of course. Its easy to do in powerbi

[@abdulaleem9543]

As an electricak graduate ,can i get into this field or computer science degree is mandatory

[@rpsandeep22]

Yes you can. I am from electronics

[@amanxdasx]

One V Important Question, pls reply.. Is verbal English communication needed, much or understanding is enough..? Plzz reply

[@rpsandeep22]

Its very much needed

[@SaiCharan-k9q]

Hi sandeep there are 3 sql links should we watch all?

[@rpsandeep22]

Yes. Watch all to get a good understanding of SQL basica

[@SaiCharan-k9q]

@@rpsandeep22 thanks !!

[@SaiCharan-k9q]

@@rpsandeep22 how to find remote jobs in us?

[@dineshchandraneredumilli4363]

Bro Is DSA place a role in data analyst/data scientits IS dsa mandatory to learn for these jobs ? and how much percentage dsa role in interviews?? bro please tell me>

[@pavithrav945]

Do we need to build portfolio?

[@aniketshinde5415]

Hi sir I'm a bcom final year student and im going to do my MBA course after competition of bcom so what's the right time to start the course. And sir which platform will be better to complete tye course, can you plz tell me I'm stuck in between these...

[@sanjaib2043]

Thank you for this information! Also create video on the Best universities in the United states to pursue MS in Data Science or Data analytics

[@rpsandeep22]

Welcome! Yeah sure. I am planning to make that video. Keep following

[@trending_voice1013]

How to get data analyst internship for final year student.....

[@rpsandeep22]

Build projects, network on linkedin and apply

[@bhanuprasad_1718]

sir, i have all the skills that u have mentioned and also i did multiple projects related to finance, e-commerce and medical by using those tools and also i did multiple dashboards and reports by using BI, But even am not getting any type of job interviews , this is very much demotivating me, as I'm working on those tools since 1.5 years ago to today onwards. Sir, please take me out from this problem, it will be very helpful for me , pleaseeee. Thank You sir.

[@jothi626]

Can you post video by teaching postgresql in Tamil ,even python also am looking for Tamil version ? Thankyou

[@rpsandeep22]

I am not making videos in tamil anymore. Sorry

[@gauravmishra1946]

Sir i completed my bcom last year and now i have 1 year gap now i wanna go in corporate rmsector i i do data analyst with good command on languages will i be able to fetch good job Plese answer sir 🙏😊

[@veeraiahgadde-rw1oy]

Hi bro will you teach data analyst course

[@rpsandeep22]

Hi. I am honored to be requested to do a data analyst course. I will but not at the moment. I am just starting my journey.

[@tausifkhan1123]

I've just started my studies about data analytics. Pls give some important guidance

[@rpsandeep22]

Please wait for my next video

[@maazali9097]

Bro I have completed all things like SQL, excel,power bi and python...but even after I am applying for jobs I am not getting any revert back from companies... right now I am working in customer service but want to trasition to data analyst field...can you guide me little bit

[@rpsandeep22]

Have you tried creating a project portfolio to showcase your skills. And have you tried applying with referrals?

[@YenoshYellaturu]

Excel or power bi which is most imp in data analyst

[@rpsandeep22]

Depends on requirements

[@VIVEKA-sw6qb]

Kindly post videos like how to use linkedin wisely 😊

[@rpsandeep22]

Lol why did you comment 3 times

[@satyamsingh-sz2gp]

😂😂😂​@@rpsandeep22

[@SahilSharma-fx7rh]

Great video bro, tx for the learning sequence Suggestion - Your beside green plant is shaking

[@rpsandeep22]

Okay. Thanks for the compliment bro. I will correct it next time.

[@sahanamgowda5125]

Thanks for making this vedio. But as of now hiring for fresher data analyst is very less and spending more time on learning analytical skills and not getting job demotivate many.

[@rpsandeep22]

Hmm. Maybe the market is saturated. But try to stand out by building projects and portfolio. At the end of the day, its all about not giving up and trying

[@yashpawar6241]

Is this roadmap given in the description is all sufficient for landing a job in data analystics field

[@Rams954]

Hi, Can I get data analyst projects to put in my resume for 3.5 years.as iam self prepared

[@rpsandeep22]

Plz do projects and then put in the resume. Dont fake ur projects. I wont advise it

[@Rams954]

@@rpsandeep22 sure, definitely i will do , because then only I can explain to interviewer.

[@armish_08]

Where should I learn basic math and statistics, and what should I consider since I come from a non-technical background and don’t know much about these subjects?

[@jathin.1]

kzbin.info/www/bejne/govdomSwiLFkmNUsi=6jTRa703-Vftxkb8 This might help you

[@rpsandeep22]

You can learn basic math and statistics through KZbin videos and chatgpt. Thats enough. Since ur r from non tech, you need to start learning excel and sql. And focus on doing projects and showcase it in a portfolio

[@rpsandeep22]

Awesome recommendation

[@sumitkoshti1171]

Learn basic math and statistics concept like mean, median, mode, standar deviation, Variance, Probability thats enough.. if you want to go further then learn T-test, chi-square test, Annova test, AB testing etc.

[@PrincessSherr]

I'm thinking of joining Microsoft to get certificate in Power BI... It's 165$+. Is it worth it or can I learn online from KZbin from experts like you?

[@rpsandeep22]

Its good to have a Microsoft certificate for sure. But of course, just to learn it , KZbin is a great resource.

[@saitejaswini5650]

Can you make a video on how is AI gonna impact data analysis

[@rpsandeep22]

Yes sure I will

[@tanusreedutta4071]

To become a data analyst which degree is needed in 2024??

[@rpsandeep22]

Any bachelors degree

[@bunnywaj]

Can you help on what hierarchy is better to learn these 5 tools u mentioned .

[@rpsandeep22]

Excel, sql, python, powerbi/tableau. The same hierarchy is mentioned in the video

[@bunnywaj]

@@rpsandeep22 I felt to break and understand first python and then this, But yes thank you fro help

[@SirishaJ-sr3qw]

Video is very informative. I need a suggestion or advice on how does it work if we change the tech stack from software engineer/developer to Data Analyst. Mainly how to showcase the resume to land in different role than What I was doing before. Please reply. TIA

[@rpsandeep22]

Thank you. Try to related what you did with software engineering and development with data analytics. and you need to build projects related to data analytics and showcase it on resume and LinkedIn

[@SirishaJ-sr3qw]

@@rpsandeep22 Thank you for the reply and suggestion

[@amnaaly-mj9mn]

THANK YOUH SM SIR!!!1

[@navyasharma7119]

Which institute is best for that course in delhi

[@akashbudhiraja6227]

can tell me some unique combined projects

[@rpsandeep22]

Any finance, healthcare, e-commerce dataset is good enough.

[@akashbudhiraja6227]

@@rpsandeep22 is portfolio is necessary to make means like a website that will showcase your skill?

[@Isaiyal_ival]

Hiii may i know more about excel… what should i learn in excel for a data analyst??

[@rpsandeep22]

Hi. I have attached some links in the description. Please check it out.

[@Saniya-ds8nn]

Hi there! Thanks a lot for this informative video. I am from a non-tech background in 2nd year and I want to change my field to data analyst. Will it be okay?

[@rajeshramsetty8725]

Could you please tell interview attending process and questions and answers

[@rpsandeep22]

Yes. I will make video on this topic

[@user-bm7co6dg6f]

Avg salary for freshers in data analytics field? In india

[@aditimozarkar2916]

Which company you are working in USA

[@SoLoAbhiYt]

Hi brother.can we learn Excel with chatgpt and ai tools for becoming data analyst

[@rpsandeep22]

Yes of course. Using AI can speed up the learning process. I will make a video about this soon on how to learn data analytics using chatgpt

[@nitish_450]

Is analytix labs Insitute best for data analyst course ??

[@anushkadatta2852]

Can you suggest some resources from where we can learn math & stat ?

[@theeconomicsclass]

After M.A in Economics Data analyst ban sakte h

[@Yrfather1PUBG]

Will Ai replace the jobs of entry level data analyst?

[@ajnas647]

Is machine learning is mandatory for a data analyst ?

[@piyushpatil3772]

no

[@delin7574]

As a cs student can i do this?

[@rpsandeep22]

Yes of course.

[@anirudhtammana64]

Hey can you make a video on the project that you have done yourself the application tracker like how did you build it from scratch it will be useful Thanks.

[@rpsandeep22]

Yes sure bro. I am planning to do it soon. Thanks for suggestion

[@Bull_game23]

Can a java developer switch to data analyst job , is it a good decision? please guide . Does coding required?

[@dheepikaanandan3261]

Can freshers take this as an path and join course to learn!?

[@rpsandeep22]

Of course

[@SY2000.]

I also started from Excel course, I had one thing to ask, that on the outside it seems there is not that much in excel but there are so many formulas in excel, how can we keep them in our mind 😅

[@rpsandeep22]

Lol. Dont memorize anything. Just know the basics and then you can always google it up. In interview mostly excel is not asked.

[@anuragchhatwani8305]

What the the topic of maths that are required in the process of becoming data analyst?

[@rpsandeep22]

Simple bath like percentages, probability, basic arithmetics etc

[@anuragchhatwani8305]

​@@rpsandeep22 can you give more idea of topics to cover before I enter in this field? Because I come from non technical background.

[@anuragchhatwani8305]

Okayy