Data Analyst Interview Questions Asked For Fresher, Google
Вставка
- Опубліковано 7 лип 2024
- #dataanalyst #fresher #dataanalytics
0:00 - Round 1
1:22 - Round 2
1:57 - Round 3
3:04 - Round 4
4:18 - Puzzles
7:19 - Root Cause Analysis Question
8:19 - Guestimate Question
9:59 - Case Study Question
10:31 - Resources and Advice
11:29 - Golden Tip
Social Media Handle
LinkedIn :- / kedar-gaikwad-660596218
Instagram :- kedar_bhai_...
In this Video i have explained my journey from Tier 3 Indian College Fresher to data Analyst and how i got selected in top MNC like Google with no experience
Topic covered was
Interview
Guestimate
Case Study
Root Cause Analysis
![Learn & Work With @Google| Data Analytics Apprenticeship Program [No Experience Required]](http://i.ytimg.com/vi/NhW8cwoYx08/mqdefault.jpg)
I have solved Some of your Question in this video also go check it out :- 👉 ua-cam.com/video/FU36BK4POWM/v-deo.html
1st Cut the 7m gold ber into 2 pieces - 4m,3m...
2nd Cut, place the 3m on top of 4m and cut at 2m distance, then pieces would be 2m,1m,2m,2m...
3rd cut, place 3 2m bers on top of each other and cut at 1m distance, 1m,1m,1m,1m,1m,1m and 1m from the previous cut..
Very insightful video. Total yes for DA daily blog . Also Can you please give us the list of top DA companies like yours . I am new to this field, I do not know the top companies.
Highly appreciated 😊 I like your content please make more videos on the life of a data analyst and more.....😍😍
Thanks for sharing such insightful Knowledge
So nice of you, hope you have subscribe too 🙏 so i can make more for supporter like you
very insightful content!!
As an 2nd year student aspiring to get into Data science role
Thank you very much for your appreciation, hope you have also subscribe for more such content 🙏🏻
I think the gold bar puzzle is easy. Let's say the employer can cut the bar 2 times, then it can be of lengths 1, 2, and 4 metres, respectively. So for Day 1, the employer can give 1 metre gold, on Day 2, he can take back the 1 metre and give 2 metre gold, on Day 3, he can give the 1 metre gold, and on Day 4, he can take back the 1 and 2 metre gold bars and give the 4 metre gold bar. This can be done until 7 days are completed.
Good try solving next question also, hope you like the video and also have subscribe for more such content 🙏🏻👍🏻
For the train problem, we just have to find the time in which they both will collide, and then we have the speed of the bee, so we can calculate the time travelled. We know that speed = distance/time, so time will be distance upon speed (speed will be the sum of the speeds of both trains, and distance will be the distance between them) (for e.g., d/(a+b)), where d is the distance and a and b are the speeds of both trains, respectively). Now if c is the speed of a bee, we can simply say that the distance will be t*c (make sure to convert values to a common unit (km/hr)).
@@dhyeysampat7845 bro kaaha se sikha mujhe bhi batao
@@dhyeysampat7845 why is your comment so underrated ? Give me some tips bro ! Please tell where we can get these types of puzzles which are related to interviews !
@@dhiraj.a.prasad1 bhai pata chale to batana please 😇
Great video! Your interview experience in Data Analysis was really useful for me as I'll be preparing for my own soon. Could you please consider sharing your resume format since you don't have prior work experience or internships? Your insights would be valuable for people in similar situations. Keep up the good work!
This
please reply asap. am also looking for it.
thank you for your experience for data analyst Q&A it will help a lot to crack the specific interview☺!
Glad it was helpful!, Hope you have also Subscribe for more such info 🙏
good bro can see your struggle all the best for your career work hard and become data scienthist
Yes, we need a data analyst daily lifestyle video so we can understand how to prepare for the same and crack the interview.
Sounds good!, Sure i Will make it soon, hope you Subscribed Too 🙏
@@Kedar_Bhai_Sunno Yes, I did
Bro your face can tell me ur worked so hard,Thanks for this!
Thanks for watching!, if you really loved it please do like share and subscribe bro 😎
Thankyou for sharing your experiences! Furtheremore, I request you to aptly explain the garnered roadmap(along with resources) for the same. This will indeed add in our expediency! Thankyou once again!
I will surely make a in-depth video on it
yes i too want to go into data science but i m really confuse to how to start this
bro plzz make some more videos about this, it is very useful ,make as soon as possible
and once again thanks for everything
Sure i will As soon as possible it then do like share and Subscribe for more such videos 🙏
Very useful information. Thanks
yes bring more video to basic of data analyst n all confusion topic also
Surely bro and I hope you have also subscribe so you won’t miss an update 🙏🏻
Daily vlog means not jus thing like woke up going to work wat i eat how i dress etc etc once in while is good but regular vedios on educating about industry projects courses how to improve in particular things etc such things will b more useful
Yes subscribed 👍
Yes, that’s what I meant in terms of daily vlogs I won’t be doing eating sleeping and all I will be showing all my educational stuffs and thank you for subscribe
and also i already subscribe your channel😇 thankful to the knowledge
Thank you 🙏🏻
Thank you for the guidance video. I am preparing for Data Analyst. Can you please enlighten with the study materials ( as there are a lot of sources and not every playlist have complete information on the requirements of Data Analyst Skills ). Please do share some guidance material. I am doing Hands-on on Udacity and also learning SQL from W3 school.
For the gold bar ques if we make 3 cuts we get 3 piece of 2m bar and one of 1m bar so on first day we give the 1m bar as pay and on next day we take it back and give 2m bar instead and repeat this, Is this a acceptable solution?
Great Video! Plz can u share how much package did you get with this much preparation? So we also can ask for similar amount with similar qualification!
i think data analyst interview question solving video making is much worth it for whole world. Because there is no such channel for preparing interview question solving. So i think it both way all benifited. Per pay give us some question idea. Thank you so much
yes we want a day in life of data analyst
Sure i Will make it soon, hope you Subscribed Too 🙏
Yes you can do vlog episode of data analyst
Hi, where can we prepare for guestimates and case studies?
please provide an information of data analysis future scope and to prepare for data analyst in 4 months please inform us and especially which books should buy for preparing interviews,logical resoning,aptitude and puzzles
can you share some practice sets which are mostly been asked in the interviews with resources to learn it for the interviewed preparation also
Do visit Glassdoor website and search in google for company interview questions to practice more, hope you liked the content and have surely Subscribe the channel for more 🙏
Very informative video bhai keep it up 👍
Thank you very much bro, hope you have also subscribe the channel 🙏🏻
@@Kedar_Bhai_Sunno obviously bro, appreciate you content 🤝
thank you
Intrested for fresher first day vlog in company
Coming soon!, bro thanks for your suggestion, Hope you also have Subscribe our channel so i can make more such videos 🙏
Thanks for the video can you make a video on resume tips as well.
Of course bro, till then please subscribe we are very close to 5000 subscribers
Yes, do videos on day to day operations for data Analyst.which type of data you are handling in organisation like this...
Sure I will, hope you have also subscribe our channel ❤️
I want to take a data analytics course
I am confusing with which website is better to take this course
Is it best carrier for the fresher?
From where should i practice case studies/guesstimates?
Daily lifestyle is a common thing now a days.
Your videos should be informative, like this one and you can also start making videos on how to approach critical thinking questions with examples.
Thank you very much for your appreciation I will try to make both, hope you have already subscribe it helps a lot 🙏🏻
Would you be able to tell me if DSA is required for a role as a data analyst or data scientist as a fresher.
can you show your resume or other certifications ?
I ahve subscribed and also followed you on linkedIn . I hope we will get great content related to data science
Welcome aboard!, and thank you for your appreciation 🙏🏻
bring more educational content......it will also help you to improve in storytelling
Yes, with your help and support will bring more such content till then do Subscribe🙏
Can you please tell me about the resume project ideas, what technologies I should use in it. Like you did...
Is online mtech from IIT Hyderabad 3 years in data science worth kya to start a career in this field ,can u pls confirm?
Can you please make the perfect resume video for Fresher..🙏🏼
Bhaiya ek doubt hai..
Mera abhi 2nd year complete hone wala hai
Mujhe data science ki field me Jana hai aur around 200 problems solve kar lie hai leetcode par aur 1600 rating hai codechef par, toh agar me data science as a option chunta hu toh interview me sirf data science ke que puch jayenge ki DSA ke bhi..
Dono depends upon the situation interview lene wale bohot sharp hote hai unko pata hai tumhara strong and weak point, hope apna bhi thoda contribute kiya ho by subscribing as we are very close to 5000 🙏🏻
After applying in so many companies didn't get even a single call for interview. That is the reality of Data analyst.
Sch me??😢
Is it really??😢
Sir. Please share some platefrom Or make some detailed vedio for interview preparation
you can practice more questions from Glassdoor, AmbitionBox, GeekforGeek and many more, Hope you also have Subscribe our channel so i can make more such videos 🙏
I am from finance background and working in a stock broking company as an dealer..i want to switch into data feild as an analyst..but main itna confuse hu cause there are lots of rewievs ki jobs nahi hain fresher ke liye specially if u are came fron a non tech background..there are some institutions who give 100% placent guarentee like Cloudy ML ,alma better and other..kya karu join karu ya nahi
hello sir Very nice Initiative sharing By Ur Interview Experience. If You have any References let us know.
As now my 3rd year of CSE btech will start im getting very frustrated that on what should i focus... and also that how can i get trained in particular area ...after watching your videos there is a hope 🙏
Don't worry bro there is always a way I have done it you can also do it
Thanks 😢
How do they know that we are copying answers during a test?
in the video you told last you will tell but you're not telling the answer.
Hey, I'm from ARTS background, so if I'm done with the skills that are needed to become a data analyst, is there a possibility that I can be less prefered to the employers as I'm from ARTS background??
Noo...
If you have skills they'll hire ...
But they will definitely ask that why did you changed from arts background to data profile👍🏾👍🏾
thankyou for video it helped a lot for me. i am also a beginner to data field can you make a roadmap video on how to get good in data analysis roadmap from zero to hero as a beginner what should i learn and how should a beginner start journey in this field. what topics should i learn I am so confused please reply.
Sure I will make in fact i am currently making it, Hope you have also Subscribe for more such info 🙏
can you please provide interview questions for practicing purpose.
share your educational background like your collage courses you have done or preparation you did....
I am 2022 passport fresher for Atharva College of Engineering I had done Bachelors of Engineering in Computer engineering I prepared by my own. Hope this was helpful and you have also subscribe to our channel for more such content 🙏🏻
Bro i saw ur previous videos. Gained a lot of valuable info.
Im also Currently doing google data analytics course from coursera n completed half way through i had some questions.
1) firstly im from commerce background just completed my graduation with no experience at all a total fresher and planning to go dubai for job via my dads connection but afraid is i wud even get selected so what shud i do i have some knwledge abt mysql, sql and excel n a lil bit abt python and R shud i stay india n get a job or go dubai whats ur suggestion?
2) Should i learn in-depth abt sql , R , python n excel ?
3) I like coding n maths too coz being from commerce background maths was my forte so i shud shift towards data science ?
Also keep doing the good work and make vlogs too thanks for sharing ur story and amazing experience keep growing ❤
Bro if I were you I would have choose going to Dubai talking about skills yes do everything in depth and if you found that you are now comfortable then you can try for data science, 😀 hope you Liked the content and also have subscribe for more such content 🙏🏻
@@Kedar_Bhai_Sunno Already subscribed bro and thanks for advice
@@krishnakanwate7440 pickup a Ssc and Hsc textbook and learn all lessons those are basic maths lessons u need it after that u can go learn some probability theories too
Right
Bro I know that's a silly question but i dare to ask you, how should they phrase this question in interviews with data analysts if root cause analysis will be included in the Six Sigma courses?
Video is worth watching 👍
Thank you very much for your appreciation and if you really liked the content please do subscribe as we are very close to 5000🙏🏻
@@Kedar_Bhai_Sunno already subscribed
@@010tapankumar9 thank you 🙏🏻
Nice content, looking forward to watch project based more easy to complex videos, videos on kaggle and many more. I hope you avoid daily lifestyle videos on this channel. Try to keep this channel pure analytics oriented.
People will definitely support you.
Thank you very much for your appreciation I will try to make both, hope you have already subscribe it helps a lot 🙏🏻
@@Kedar_Bhai_SunnoI am also in Canada, looking forward to connect with you on LinkedIn. Would you mind highlighting your profile?
I have given my social account in description
Bhaiya daily life of data analytics, free perks for data analytics, office tour, ese video banao please
Off-course bhai thank you for you suggestion bro, Hope this information was helpful to you and hope you have also subscribe to the channel 🙏
Kya data analytics role ke interview me v DSA puchte hain?
keep it educational content only yr ........nd tell more about how to breakdown a guestimate question to answer
Ok I will try to make video in more creative ways, hope you have also subscribe for more such content 🙏🏻
What is the maximum knowledge we should have to crack any interview for data analyst ? And what to prepare or study for aptitude and from where?
What to study that i have said in the video talking about where then you can learn from UA-cam itself, an there is no maximum limit of knowledge, hope you have subscribe too 🙏 so i can make more for supporter like you
Ha bhaiya data analytics ke bases par bnaiye vlogs
Jarur bhai apka support ho toh jarur hope apne subscribe kiya ho
Same flipkart qn was asked in my interview but i didnt know it comes under root cause analysis
Hey bro just discovered your channal, really helpful videos, I have studied CSE in Diploma & currently studying AIML 2nd year in BE... What should I focus now so that I could get a job like you in future...
do Internship, project to improve your skills and resume, hope you like the content and also have Subscribed the channel 🙏
@@Kedar_Bhai_Sunno yupp liked & subscribed..👍👍👍
And hoping to watch similar videos
At 3:40 what was the actual word "active companies" or "acta companies"?
AdTech Company
Can you please add english subtitles ? I would like to understand even if I m not indian
u staying ln lower parel??
Anna one small project work for a beginner can you do from intial stage to end stage entire data. how to clean and analyse it , and what are the tools are essential for it. Please make as soon as possible.
sure Will upload soon, Hope this information was helpful to you and hope you have also subscribe to the channel 🙏
get us some more ceat list ideas
Hi Sir,
I have been preparing for data analysis for past 4 months, I am
Applying to jobs but not getting shortlisted anywhere. I am a fresher.
Have patience till then try finding internship and start some project it will improve your skills and resume too. Also don’t forget to subscribe as we are very close to 5000 🙏🏻
Hello !!!
I'm from a non IT background and currently pursuing MA Economics.
Can i apply for data analysis field???
Is it mandatory to have a technical degree??
For data analyst it’s not mandatory, you can start your career in this and also for more such content please subscribe 🙏🏻
Please tell which type of project we made to add in our resume and how to search and get the internship in data analyst field.Please make a seprate video on this topic i think every one need the video on this topic who start there carrer in this field
Talking about project that totally your Call you can make any from data science field second for internship try from your college or from internshala, hope I answered all your questions and you also have Subscribe to our channel 🙏🏻
@@Kedar_Bhai_Sunno but in our college the company is not hiring for data analyst domain. So can you make any short or a long video for resume making it's really helpful for us.
I will surely
Ek data analyst ko bhut logo k samne Ppt presentation bhi dena hota hai kya, mai data analyst field m Jana chahta hu bhut mujhe ppt se bhut dar lagta hai because of my weak community skill in English.. should I enter into this field?
Aisa kuch nai hota hai
can you share your resources for sql, python , excel and visual tools
I mostly preferred from Wikipedia, UA-cam and some random search from Google, Do Subscribe so in next video i can cover more on this 🙏
@@Kedar_Bhai_Sunnook
Yes please share which resources we need to refer
Sir ye elon musk ki company ka interview mila ha soo muje batao ki mai kese fail ho jau
😂
How you prepare for aptitude?
Can you please share the resources or recommend vedios channels from where have you prepared for the data analyst .
Ok on your request I will next video on this topic, and if you really liked the content please subscribe for more 🙏🏻
@commonlyconfusedindian kindly share you resume format please,
as am looking for Data analyst role as a fresher.
Resume short listing me candidate ka education background dekh kr resume short list kiya jata hai kya?? Mene clg me Arts le li thi me arts background se hu to agr me Data analyst ki preparation kru to mujhe resume short listening ki problem aa skti hai kya Arts background ki vjh se plz answer in detail
wo totally company pe depend karta hai kisi ko colleges aur degree se matlab hota hai toh kisi ko sirf skills, par ek cheez aape depend hai wo hai like, share and subscribe
Greetings Brother, could you please vids in English as well? it would be very helpful. Cheers
currently I am doing Bsc.Cs ,can I apply for data analyst job??
Can you make a video on odd profile that want to get into data analyst for eg those that have less than 60 in 10 gr and graduation or maybe those that have multiple gap years or those with non relevant work experience what should be their strategy to get an interview it would be better if you could opnion of multiple that are working in your company on such profiles
Ok noted I will try to make such video by covering all the topics till then please subscribe 🙏🏻 so we can reach many people as possible
Bhaiya oracle sikh sakte h? Sal me.... Ya postrage or mysql me se koi ek
Kuch bhi chal sakta hai bus basic concept ana jaruri hai aur subscribe karna bhi jaruri hai hum 5000 ke bohot pass hai 👍🏻
plss bring data analyst roadmap
Understand the use of data >>> learn statistics to play with data >>. Learn excel and Sql to handle data then >> learn power bi or tableau to Represent the data, hope you liked the information please do subscribe as we are very close to 5000 subscribers 🙏🏻
Mostly Econometrics and stats part is asked
Depends
Bhai salary kitni milti hai aapko monthly and agar me data analyst ka course karu toh kitna salary milega as a fresher plz reply
Really Appreciate Your video!!!
I'm very new to this field. I've lifescience background. Recently I've joined Trinity for Data Analytics. Do you know is this course worth it!! Can you suggest me something as a fresher so that I can easily enter this field with job opportunities!!!
Kya beginners ko b iss level k prepare krna pdega yaa...ya sirf top level companies mei hi itni difficulty hoti h?
Mostly top level me aesa hota hai,
@@Kedar_Bhai_Sunno so beginners ko kin topics mei focus rkhna chaiya as per you so that kisi average lvl company mei hire ho sky.
How much you getting salary... Initial to now
Sir aptitude saare companies may puche jaate hain ? I mean direct technical round say start hota hai?
Direct bhi hota hai na technical round
@@Kedar_Bhai_Sunno thanks sir for your response , why don't you make a video best companies to work for in Canada as a data analyst , best of luck
I will make bro, Hope you have subscribe also ❤️
Sir.. Ap apka resume b share kariye please. Shortlisting k lye imp h ki cv achha frame kiya jae. Interviews me apne sb english language me answer diye the ya mixed english hindi??
I will share my resume in next video and talking about interview yes I gave it in English language only, hope this helped you and you also have subscribe for more such content 🙏🏻
I am also from a tier 3 college pursuing btech cse
I can fell you bro if you can also tell me then do Subscribe we are very close to 5000 subscribers 🙏🏻
Sir, what is your salary package?
Please make video in English or provide subtitles bro
helo brother, i am sincestudent 12th class math subject then i done BA gradution, subject English geoghraphy and milattry since then i done MA Economic, can i make deta analys, i want to do this course, Pleas Brother suggest me.🤎🙏
Bro i am non tech background nd I completed my data analyst course few days ago …but it will be no any calls for fresher …what will i do ?
Lakho bethe hai Ghar
Bro try don’t internship from internshala or try sending your resume to recruiter
can you suggest some resources
where we can practice for case study or root cause analysis questions
Try Searching it on google i really don't remember but there are some website which can tell you proper strategy to solve it, Hope this information was helpful to you and hope you have also subscribe to the channel 🙏
@@Kedar_Bhai_SunnoI need your Instagram or any ID I want to talk to you regarding my studies in Canada plz 🙏🙏
I have put my social account in description
Hello bhaiya
Can you please tell me as a fresher how can i start preparing for my data analyst job interview and what should be my resources
I have uploaded 2 more videos related to it please subscribe and go check it out
how to prepare and answer these logical puzzle questions?
For preparation search in google for logical puzzles
Can you tell in which best companies we can apply for data analytics job ?
Any MNC, Every MNC need a Data Analyst 🙏
Hi,
I'm a web developer at a company and I'm not enjoying my work hence I want to shift to data analytics domain as it interests me.
Your videos are very different from any interview experience I've seen so far on UA-cam, you just opened my eyes on what I'm missing.
Can you please recommend any courses, give roadmaps and make some videos on what a data analyst resume should look like.
Moreover I'm intrigued by how the questions were asked in third round. Can you make videos on that too, you can share some resources to practice case studies, guesstimates etc. Since data science is very rare in India, i haven't been able to find any quality content except your videos.
Your two videos have taught me more than 100s of data analytics interview experiences.
First try to understand the data>> then Learn EXCEL>> then SQL>> then Tableau or PowerBI >> then try to crack interview question >> then Repeat, in case study I will try to make another video And Please Subscribe the channel for more such information
@@Kedar_Bhai_Sunno data ko kese samghe🤔
bro you are good for sharing your interview experiance its very helpfull , and bro please make a video which mathematics topic is very important for data science and data analyst .
Sure I will make it soon, hope you Subscribed Too 🙏