How to Become Data Analyst | Complete Data Analyst Roadmap

[@RamRam55510]

Most underrated channel in KZbin sir apki video's dekhta hu to ek ek bat samjh me ati hai easily

[@RishabhMishraOfficial]

Thank you Shubham :)

[@highsom]

bhai bahut he achhe se samjhaya hai apne bahut he achha laga mujhe apka yeh video. Thankyou so much for making this video.

[@iamsubhobanerjee]

Technical skills: 👇 • SQL - Joins - Aggreagiate Functions - Triggers - Query Optimization • Excel - Pivot table - Lookup, Vlookup - Macros, VBA • Power BI and Tableau • Math and Statistics • Python and R or SaS - Numpy - Pandas - Matplotlib

[@tanishjain1898]

Dear sir, this is a really detailed and a very helpful guide towards the career as a data analyst! Bahut bahut dhanyavaad for such a informative video! ❤️🙏😍

[@RishabhMishraOfficial]

You are most welcome ✨️

[@positivevibe47]

I'm being honest I'm Watching your videos for the first time and You are a Gem

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@mansikakani]

Hi! Honestly, this was the best video which explained the details of the requirements for the course. Thanks for the video.

[@RishabhMishraOfficial]

Glad you liked it, thanks :)

[@PracticalBhakti-wy7hy]

Yes, best roadmap video short and to the point

[@PracticalBhakti-wy7hy]

Best Data Analyst Roadmap

[@username123-g2v]

Hello sir, thank you so much for this useful information. I also wanna become a data analyst but i was confused how to start, but u gave all the required information for this career. Thank you once again sir.

[@RishabhMishraOfficial]

All the best 👍

[@kajalkr.5146]

Wat a Fantastic Roadmap . Great job done Mr. Rishabh. Good going. Keep up....

[@RishabhMishraOfficial]

Glad, you liked it! :)

[@sobhanthakur4]

This video was really super helpful. I was looking for such a roadmap.

[@RishabhMishraOfficial]

Thank you Sobham :)

[@RavikaUniverse.]

Very informative Rishabh, good going

[@RishabhMishraOfficial]

Thanks a ton, Ravi

[@iamsubhobanerjee]

Data - Retrieve / Extract -> SQL - Cleaning -> Excel - Analysis = Generate Insights /Action items Present through - Data visualisation

[@shreyaaa3950]

Nicely explained Sir!😃🙌

[@NileshPatil-pl2fj]

very nice explanation sir....thank you so much ...you gained new subscriber....

[@RishabhMishraOfficial]

So nice of you :)

[@Learnho]

Thanks 👍👍 It's very useful video

[@somnathchanda1250]

Sir, you are crisp clear,....please provide PDF notes for our referencce

[@RishabhMishraOfficial]

Hi Somnath, pdf notes for this video?

[@somnathchanda1250]

@@RishabhMishraOfficial Yes, it will be helpful as reference. You may just jot down your video into important points for us to follow & remember. Thanks

[@jabajalameaglejabajalameag8439]

Nice video thanks for information sir ji Good communication skills.

[@VishalYadav-ot5id]

Thnk you sir for most helpful information

[@iamsubhobanerjee]

• Portfolio - Project • Resume - Job description - keywords - Certification • Interview Preparation

[@mohittomer2623]

Most ultimate video bro.........

[@mohittomer2623]

How to contact u bro...???

[@mohittomer2623]

???????

[@vedantraut327]

Excellent explanation!

[@RishabhMishraOfficial]

Glad it was helpful! Thanks Vedant!

[@ankitwahane7410]

Hey Rishabh !!! Thank you for the great insights. it has helped me alot to get into the path of data analyst. Thanks brother...

[@RishabhMishraOfficial]

Glad you liked it :D

[@sunii8505]

Thank you☺

[@shivsharma9153]

I loved this video. To the point and really valuable points..hwowver I would like to say that you did not mention "statistics" which is also very critical

[@RishabhMishraOfficial]

Hi Shiv, yes Statistics is also imp.. but for entry level job as Data Analyst basic statistics will be enough

[@likhitak27]

Useful ♥️

[@dawoodshariff4726]

Hi bro thanks for details explanation I watched so many videos but this gave me a full clarity on data analyst....my small request is can you make same kind of video on business analyst road map

[@RishabhMishraOfficial]

Hi Dawood, glad this video helped you! Sure will make a dedicated video on Business Analyst Roadmap soon!

[@shivanikadam6006]

Hello Rishabh sir , your videos are absolutely benifirial for all the data aspirants✌️. Your efforts for giving proper roadmap and guidelines helping us to avoid distraction. Can you please guide us about how to land first job in data analytics career . struggling alot in applying for many roles in data analytics. But didn't getting one single call or response from the recruiter 😥. Can you please make video on do's and Don't for applying for data analyst job role??? Its big request to you✨🙇🏼‍♀️

[@RishabhMishraOfficial]

Yess, one video is coming tomo pls do watch it has your answer

[@GauravSharma-dv8oz]

got the job?

[@ajayjangir2134]

It was very short and simple without confusion. Great job! Please help me with my below question. - I am 33 yr old with 8 years of experience in technical support job. Will it be worth changing job role now - Want to start career in Data Analyst. Please suggest some online course/certification ?

[@RishabhMishraOfficial]

Hi Ajay, i have recently made a dedicated video on this topic- data science skills + course + projects + resume tips.. You can watch the video: How I Learned Data Science Skills & Switched Career. If you get any doubt please comment again i will reply.

[@NitishGaur15]

Please make a video on use of statistics in data analysis..there is no such video on KZbin

[@RishabhMishraOfficial]

Okayy noted ✅️

[@careerinstituteofsoftwaret8581]

Very good

[@ashutoshtripathi-rx3hs]

Thank you sir for your informative video. Respect from Bangalore.🧄🧄🧄🧄🧄

[@Satya_1011]

Helpful 🙏

[@RishabhMishraOfficial]

Glad it helped ✅️

[@nikitasinha8181]

Thank you so much sir

[@RishabhMishraOfficial]

Most Welcome!

[@soham8208]

Pls make similar video on Business Analyst 🙏

[@RishabhMishraOfficial]

Okayy,, soon will make one

[@ihgamingfun6295]

Almost well explained 👍🏼👍🏼👈

[@iamsubhobanerjee]

Soft skills: 👇 • Communication skill • Critical Thinking • Problem solving • Analytical skills • Time Management

[@iamsubhobanerjee]

Data comes from different data sources and stored in database.

[@Ajkr2]

Excel (advance),sql (very important) ->advance, python , numy panda matdot,power bi or tableau,maths and statistics Communication, critical thinking problem solving time management Resume :-job description,projects , certificate,key words:-description Excel sql and python finally power bi

[@dhanashrijadhav5699]

Hi Rishabh, thank you so much for sharing this roadmap in such an easy way. Could you please guide as how to get project experiences related to this courses.

[@RishabhMishraOfficial]

Hi Dhanashri, for projects ideas/topics i have discussed this point in a separate video: "How I learned Data Science Skills AND SWITCH MY CAREER FROM Digital Marketing got Data Science". You can watch this video and please let me know if you still have any questions .

[@__mr._mishraa_jee_._hkm__]

Sir, My name is also Hrishabh Mishra… Our names are really amazing...!!

[@atozmrayaz3279]

Thanks bro acha hai

[@komedyking9069]

Sir mujhe bilkul beginning se star krna h to kaise karu please help me

[@manishgupta4795]

Mujhe bhi kuchh nhi pata kaise kru koi guidance nhi krne wala h

[@RishabhMishraOfficial]

Hi folk, you just need to learn data science skills such as Excel, SQL, Python, Tableau and Statistics. Aprrox 3 months lagega to complete these skills if you staudy for min 3 hours daily. And based on these skills you need to make some good projects and that';s all you are done for applying DS jobs.

[@neeleshjaiswal4922]

Good content

[@RishabhMishraOfficial]

Thanks Neelesh bhai 😄

[@dimplegoswami790]

Please make a video on how to learn Data analysis

[@RishabhMishraOfficial]

Hi Dimple, recently i uploaded a new video: How I learned Data Science Skills and Switch my career. You can watch this video as i have shared details of data science skills, courses, projects and tip & tricks to update you resume for DS jobs .

[@dimplegoswami790]

Tysm Rishabh I am definitely going to watch your new video..

[@FCfacts008]

Super ❤️

[@RishabhMishraOfficial]

:)

[@rachnapandey3822]

Thank you

[@RishabhMishraOfficial]

Welcome! :)

[@lovelykumari5739]

Hi Rishab, can you please make a video on UI designer

[@RishabhMishraOfficial]

okayy, noted!

[@guruprasadgupta6310]

Nice

[@RishabhMishraOfficial]

Thanks, glad you liked it :)

[@tanuraut-rz2li]

Sir, im student of class 8th, im very confused,what i have to prepare from now for data analysis

[@tanuraut-rz2li]

Pls help, sir😥

[@vivekjoshi3769]

My problem is I did a data analytics course that was in R instead of Python. I did sql, excel & tableau also. Now I am stuck because I don't understand R properly when I apply it to make new project. Most companies asking for Python in their tech stack. I am completely blackout man.

[@RishabhMishraOfficial]

Hi Vivek Joshi, first thing don't worry, first thing in most of the companies you can go with either R or Python. So, that should not be a problem. Also, R and Python are almost the same in data analytics. if you know R properly then quickly you can also learn Python as well. In my case also, first i learned Python and then later i also got a chance to work with R. You just do some basics of Python first: like what is Python, variables, data types, loops, functions, etc abd then directly start with analytics part (Pandas, NumPy) and you can learn this with in a month- just give 2 hours daily. 🙂

[@chhotarafi7885]

Rishabh bhai kitne time period tak data analyst rahte h aur kab data scientist bante h finally please tell me🙏🙏❤️❤️

[@RishabhMishraOfficial]

Hi brother, yeh depend karta hai companies par.. if you keep on learning new skills then mostly within 2-4 Years you can go for Data Scientist role

[@kusum1909]

Hello Sir I like your way of teaching and I found honesty in your teaching. You have given a link for advance excel, is it right place to become a master in excel and trustworthy place to learn excel and more courses for data analyst. Please give me answer soon.

[@RishabhMishraOfficial]

Yes after learning, you need to practice n build projects

[@kusum1909]

@RishabhMishraOfficial Thanks sir but now I think that link is not available, I tried to search but couldn't find it. I don't know in which of your videos I got that link at that time.

[@beautymeanyou]

Helo sir mujhe apna kaam shuru Krna h bs smj nhi ata kaha aur kese start kru me RO sell aur service busseness Krna chata hu sir aur jese third party company h like just dial wo bht paise leklte aur sb fake call hoti h nuksaan hota h mene bht logo se sun liya wo barbaad ho gye paise laga kr kaam nhi mila usko kuch faida nhi hua kuch mam plzz mujhe ap help kroge me pay krunga kese start kru mujhe data milega kaha kis jagah koi website aur location pr service sell kaha milegi kaha jyada kaam milega iska data mil skta h mam plzz help me

[@guleria28madan]

nice

[@RishabhMishraOfficial]

Thank you, glad you liked it :)

[@vaibhavtyagi2687]

Hi Rishab very good and crisp description of Data Analyst field thanks for the information. Can you please suggest any platform or coaching to learn the data analyst field.

[@RishabhMishraOfficial]

Vaibhav, you can go with Coursera n Udemy courses

[@Abhishek-op8ht]

Hello sir, i am doing my BBA in retailng from IGNOU. it's my last year of this program. and so can i do MBA in data analytics. Is it will be beneficial for me in my future. or best bad decision.pls tell me that can make carrier in data analytics.

[@RishabhMishraOfficial]

HI Abhishek, Doing MBA or any PG program is better than the graduation but still there are lots of factors to be considered to say whether it's good or bad. First you need to see why you want to do MBA now, why not after having some hands on experience. My opinion will be first you can go for a job & work for at least 2 years and then you can decide for MBA or any other program.

[@bantooarya]

Bro iam A store manager at Zara Retail But I think if you good at number and maths and coding you should do it becouse salary is good than any retail stores .. and Work life balance is also good in Data analytics ..

[@Jayaa.Nishad]

I'll be done with my bachelor's in marketing this year. What all type of analyst options I've in data analytics related to my management/marketing field ?

[@RishabhMishraOfficial]

Hi Jaya, for marketing there are lots of options in data analytics, such as: data analyst customer experience/insights/advertisement/marketing/People.

[@9356079]

Learn python,sas or r and get trained in marketing research

[@chakshusharmawellnesscoach7227]

Thanku sir

[@RishabhMishraOfficial]

welcome!

[@reenabaghel9150]

Hello Rishabh sir I am Reena here , I have been working as a teacher in a school and teaching English and for some reason I want to change my career into IT in data analyst And I have done one year pg program in data science and machine learning so will it be possible for me to get a job in IT? Please reply

[@RishabhMishraOfficial]

Yes absolutely, if you have the relevant skills n knowledge you can switch to it. Try building good projects

[@bankersoon3331]

Sir please ye b btayei ki ye KNOWLEDGE seekhe kha se??

[@RishabhMishraOfficial]

Hi, to become data analyst konsa course karna hai aur kaha se karna hai yeh sara detail iss video mei hai: "How I Learned Data Science Skills & Switched Career from Digital Marketing to Data Science". Iss video ko dekhlo aur koi doubt hai tho comment karo

[@gopichandu7415]

I have done bsc statistics.. now what are the steps to do to become data analyst???

[@RishabhMishraOfficial]

First focus on data science skills, then build some good projects and then you can aply for jobs

[@prashantwaldia23]

Sir best colleges ya best institute btao data science k liye ❤️

[@avinashnair8433]

Hey Rishabh, How did you add text like Certification, Keywords, etc in your videos ? Also how did you add image in between your videonlike a lady teach data analytics in the beginning of your video ? Please suggest how you beautify your videos ?

[@Skeptic_Sage]

Bhai maine BA program kiya hai from Delhi University Open university, am I eligible for a data analyst job?

[@DATAisFuturRe]

very good explanation, thanks from skillup Yourselff Channel Dedicated to Data Science

[@nileshlonkar4080]

Hi sir, I have completed my 12 + 3Years diploma in Information Technology. Also I have 3+ years experience in Non- Technical field (working on Pivot Table and Macro in Excel) So my questions are 1.am I applicable to apply this course since I am an undergraduate and after course would I get opportunities like other graduate candidate? 2. Is my experience count?

[@033_jayasingh7]

hello RIshabh bhaiya!!! your videos are just amazing , i completely follow you. can you please tell about the avg pay package , growth & hikes in this field. is this a safe n good option to choose this field as whole time carrier point of view.

[@RishabhMishraOfficial]

Thank you :) sure Will do soon

[@aditidixit9830]

Hello sir kya aap bta sakte best coching kha mil sakti eski ofline agr Krna ho data anatical . Bangalore location ke liye .can u suggest 🙏

[@RishabhMishraOfficial]

Hi Aditi, sorry i'm not aware about the offline coaching. My suggestion will be to go with online courses/certification courses that will be less costlier and flexible as well. If you want to join offline classes in that case search a coaching which takes fees after your job selection.

[@aditidixit9830]

Thanku so much sir 🙏

[@swatirao4319]

please make one video on where i can learn these things

[@RishabhMishraOfficial]

Hi Swati, sure. Soon will upload a video on this topic

[@rahulgoel968]

Kuch logg khaa rhee hai ki data analytics kee liyee coding ki jaroorat nhi haii kuch khaa rhe hai hai jaroorat kyaa ager coding mee interest nhii haiiii tooo kyaa kreee😔😔

[@RishabhMishraOfficial]

Hi Rahul, good question. Actually most of the companies mei coding skills chahiye but agar nahi aati ya interest nahi hai tho koi aisa job dekha jaha bina coding k job mil jaye aur baad mei job k sath coding seekhlo.. future mei salary increase ho jayegi.

[@supriyamalewar9850]

Hey !! Can you tell me except python libraries which topics are important in python for DA?

[@dikshdipbhowate6538]

Brother I'm from arts background....but mujhe Data analytics me career banana hai aur main 24 saal ka hu .... kitne time Tak aur mujhe kya kya padna hoga iss field me jane k liye please reply

[@RishabhMishraOfficial]

Hi folk, you just need to learn data science skills such as Excel, SQL, Python, Tableau and Statistics. Aprrox 3 months lagega to complete these skills if you staudy for min 3 hours daily. And based on these skills you need to make some good projects and that';s all you are done for applying DS jobs.

[@dikshdipbhowate6538]

@@RishabhMishraOfficial thankx brother...Data analytics k liye bhi programing language important hai kya vmro

[@dikshdipbhowate6538]

@@RishabhMishraOfficial aur vmro ye sb skill konse plateform per sikh sakta huu and paid course hote hai ya free

[@anamitrachakraborty1378]

I have done my Civil Diploma engineering in 2016 and I have no graduation degree. Now I want to change my line as a Data analyst. Is that possible by any chance ? Please reply

[@kaustavsengupta9745]

The video was wonderful ..just wanted to ask is the Google data analytics course from Coursera worth it ? Will it help me to get a job ?

[@RishabhMishraOfficial]

Hi Kaustav, yes it's a good program but before starting that program first check what skills and tools that course will teach you, if that's what you want then go ahead with that course.

[@kaustavsengupta9745]

Thank you ..i will check it

[@Chancy_Gaming_YT]

Sir mera ak sawal h main open university se apna graduation kar raha hu to kya mera graduation complete hone ke bad main data analysis ban sakta hu kya please sir jawab dijiyega 🙂🙂

[@ranjeetmaurya65]

Data analysis vs web developer in dono me kaun sa simple rahega sikhane me? Please reply.

[@RishabhMishraOfficial]

Hi Ranjeet, if you like Maths and Data then Data Science is Easy otherwise web dev

[@ranjeetmaurya65]

@@RishabhMishraOfficial I don't know about data but l like maths

[@pareeksachin3963]

sir hum ye skills sikhe kha se koi institute ya certificate suggest kroge...ya free of cost sikh skte .....sikh skte but sikhe kha se....jo genuine ho...plz reply. by the way great video

[@randomchannel8057]

Sir please bataye ki data engineer actually kya ker te hey or data engineer or data analyst me kya difference hey .

[@RishabhMishraOfficial]

On high level data analyst work Analyzing the data and preparing reports/dashboards where as data engineer work on designing n managing database

[@alokkumarsrivastava2959]

Plz plz plz reply simplilearn se data analyst course kar skte hai plz plz plz replyyy...????....

[@deepalikumari9365]

Sir mein abhi sem4 ki student ho mein data analytics bana cha rahi hun

[@farhansayed5103]

Bhai mai soch Raha career switch karne but confused hu Karu ke nahi. Age scope hoga ke nahi

[@RishabhMishraOfficial]

Yes you can switch your career to data science and age doesn't matter

[@studywithshivam3556]

Sir mai english me 20percentage baat kr pata hu but samjh leta hu 90 percentage to kya mai isme interview me theek se perform kar paunga

[@RishabhMishraOfficial]

nahi bhai, you need to speak in English 100%, practice with your friends or looking at mirror you can talk to yourself for practicng

[@rkumar2869]

apki video dekh kr sir muje lgta he ek arts wala student to ye sb nhi kr skta mene to math bhi nhi kia hua muje to bassik math hi ata he to kya me data analytics bn skta hu

[@RishabhMishraOfficial]

Hi folk, you just need to learn data science skills such as Excel, SQL, Python, Tableau and Statistics. Aprrox 6 months lagega to complete these skills if you staudy for min 3 hours daily. And based on these skills you need to make some good projects and that';s all you are done for applying DS jobs.

[@mmani9659]

Please help to add projects in the resume.

[@RishabhMishraOfficial]

Will make a detailed video on this ✅️

[@SaurabhSharma-ry8iz]

Hello sir🙏🙏 Sir mujhe Advanced excel aata h Kya data analyst ka job sakta hu Please guide kijiye sir

[@RishabhMishraOfficial]

Hi Saurabh, Excel k sath you can learn SQL, Python (basic), statistics and Power BI/Tableau. Aur uske baad easily you can apply for jobs :)

[@kunaltyagi820]

M data analysis course Krna chahta hun pr mujhe koi knowledge nhi h is bare me Koi acha sa platform btaye jaha se m suru kar saku sir plz sir I have confused

[@RishabhMishraOfficial]

Hi, you can start with coursera website for FREE and learn data science skills

[@kunaltyagi820]

@@RishabhMishraOfficial iam a non technical background,I am a art background

[@monikakarki3359]

I am from non tech background I want to start a career in data analyst bt getting confused from how to start where to start??

[@RishabhMishraOfficial]

First learn data analyst skills and then do some good projects and try for data science internships or jobs

[@sumitsana1086]

For learning this thing what is best option online or offline what is your opinion?

[@RishabhMishraOfficial]

Online, you can go for coursera and udemy to learn new skills

[@sumitsana1086]

@@RishabhMishraOfficial thank you

[@runamandal2226]

how to get entry level data analyst job? I have already completed google data analyst course , I have skilled on TABLEAU, SQL, R , EXCEL . can not find any entry level job at all . please help

[@RishabhMishraOfficial]

Yes i agree, cracking first job is difficult but it's not impossible. You can ask for job referrals on Linkedin that may help. Also you can try for amcat or elitmus exam there you can find jobs for freshers (before registering on any of these websites check that it has required job profile/companies)

[@anjaliroy1976]

I m working as a . Net developer and wanted to switch my career after 4 year of exp in data analyst .. how can I ?

[@RishabhMishraOfficial]

I have created a dedicated video for this, " How I Learned Data Science Skills and Switched Career To Data Science". Have covered what skills, where to learn/courses, projects and resume tips. You can watch this video and let me know if you have any questions

[@bablichaudhary6720]

Hello sir, mai ek mother hu, abhi mera baby chhota hai pr mai job try karna chah rahi hu, maine aap ka power BI ka tutorial dekha aur practice kar rahi hu, mera previous job profile bilkul alag tha. To kya mai data analysist ki prepration karke job pa sakti hu? Please please suggest

[@RishabhMishraOfficial]

Yess absolutely you can, just learn the required skills n make projects. For detailed skills n free resources + resume preparation, you can watch my recent video on Data Analyst roadmap 2023.

[@bablichaudhary6720]

@@RishabhMishraOfficial thankyou sir

[@suprotimdeba]

My education is 10th/ITI/Diploma in Electrical Engineering. Currently working as a Department Manager in H&M.. I'm thinking of switching my career to a Data analyst. Is it a good decision?

[@sushamakumari2494]

sir ,isme machine learning ka bhi use hota h ?

[@mainakbiswas6210]

At the age of 32, being a Senior QA in customer Success, is it wise to shift to DATA ANALYSIS. Will I ever get the preference to plunge into the field of DATA. I am confused because the company will search for either YOUNG Freshers or EXPERIENCED One. Need your guide please :)

[@suchitrasnair6497]

Hi..can u plz let me know Data management Analyst and data Analyst role will be same or they are different

[@RishabhMishraOfficial]

Data management will be more around managing database (sql or no sql database) whereas data analyst focus on analyzing data to get insights

[@mayankkumar1688]

Communication skills, english speaking ka synonym hai kya.

[@RishabhMishraOfficial]

Yes you can say that, communication means how well/easily you can share your thoughts with others that they can understand

[@dhruwajeetiwari9213]

Sir I had done BCA in 2019 there after MBA in 2022 how can I take job in IT industry

[@RishabhMishraOfficial]

If you have strong data science skills + good projects then yes you may get a data analyst job easily

[@sarangsj8733]

Sir Hindi Data Analyst Courses kaha se kar sukte hai ???

[@RishabhMishraOfficial]

You can start for FREE with Coursera courses: IBM data analyst or Google data analytics course

[@NeuUniversity]

Hello Sir, Mai ETL Test Engineer hu, but company ne lay off kar diya. Data Analyst pe switch hona chahta hu. kya is time data analyst par switch hona thik rahega? aur career gap matter karta hai kya?

[@arifhussain4851]

Sir agar graduation nhi h sirf 12thpass out h to kr skte h data analytics

[@RishabhMishraOfficial]

Yes, but thoda difficult hoga