Data Analyst Job Interview - Don't make these 7 mistakes
HTML-код
- Опубликовано: 30 июн 2024
- Got a data analyst / data scientist or other data professional interview coming up? Make sure you are not doing these 7 mistakes.
I had the fortune of attending over 40 interviews during the course of my life so far and I made these mistakes at one point or another. In this brief video, let me share these mistakes with you so you can be SUCCESSFUL in your journey.
The mistakes
===========
1) Giving impulsive answers
2) Not enough research
3) Using the same examples
4) All talk and no show
5) Being inflexible
6) Focusing too much on money
7) Being too hard on yourself
Video topics & timestamps ⏱👇
==========================
This video is meant to be watched from start to finish. But if you need to jump to a specific concept, please use below timestamps.
0:00 - The interview mistake #1 - Impulsive answers
0:49 - STAR methodology - explanation & example
1:56 - Mistake #2 - Not enough research
3:22 - Mistake #3 - Using same examples
4:34 - Mistake #4 - All talk and no show
5:39 - Mistake #5 - Being inflexible
6:27 - Mistake #6 - Focusing too much on money
6:37 - Mistake #7 - Being too hard on ourselves
9:00 - My best tip for doing well interviews
Videos on technical skills to help you in the interview
===========================================
1️⃣ 5 must have Data Analyst Skills - • 5 key skills you need ...
2️⃣ Data Modeling & Business Intelligence Jargon - Explained - • Top 20 Data & BI terms...
3️⃣ Beginner to PRO Data Analysis course with Excel - • Beginner to Pro FREE E...
B-roll used in the video:
===================
The stock video came from pexels.com and The Office show (Andy gets fired episode)
All the best for your interviews 👍👍👍
#InterviewTips 
Наука
Quote: "money is by product"
I like this quote. Tks Chandoo
This was a great video & reminder, Chandoo! Especially the reminder to not be too hard on ourselves. Loved the family guest stars! Thanks for the virtual mentorship!
Your channel is a gold finding. Every video I get more impressed!!
You teach so smoothly and beautifully.....🎉🎉🎉🎉🎉 You and your wife both are just amazing people 🎉🎉🎉 thank you sir..... Alot of respect and love from India
Our pleasure!
This tutorial is not only for Data Analyst even it is useful for any IT related job interview. Thank you 😊
It’s useful for all interviews with a tweak here and there. I am a mechanical engineer and a recruiter sent me some interview tips. Some of these Chandoo has mentioned including STAR, were on there
Yes... as I never attended other interviews, played safe with my research and narrative there. :)
Super Awesome video, the point that we work alot to say in the interviews but it's much better when we could show the work and talk more on that. Makes a lot of sense to me.
Top Notch Content, thanks for sharing these insights! All your videos are just perfectly edited and to the point. :)
Kudos to you. You're such a humble person. Learning a lot. Keep sharing my Guru!
I’ve always used STAR, but now something more to use. Thanks for the Triangle idea. New one for me.
Thanks for sharing your experience. great videos.. please keep it up. I get more clarity while watching your videos and like the way you explain things in a very relaxed manner...Looking forward for many videos like this.
Flexibility is a sticky point. I think being upfront is important. Honestly depends on your circumstances. Especially harder when you are a woman with a young family. Fortunately one good thing from COVID is flexible working hours and location so now it does make it a bit easier.
Thanks for the awesome stuff there.
You're really making difference in people's life.
Happy to hear that!
Articulate, Informative, Inspiring, revealing, thought provoking, realistic, impressive, insightful, and appealing. Thank you very much,. You have explained in an excellent manner.
The videos are really great 👍made by you. Keep it up. ⬆ Will be waiting for even more ✌🏻👌🏻
STAR concept is very useful. I have been using it unknowingly during meetings with prospective customers. However, I never knew about this terminology. I know about SMART goals though.
Really thank you so much for your wonderful experience to share with us.
Thank you Chandoo. It's very useful and more practical 👍
Great tips.. especially the last one... thank you
Very helpful.I am going to attend the interviews in upcoming months.I will surely apply your techniques for same.
Great stuff, all points covered. Thanks😊
Glad you enjoyed it!
Very Helpful stuff, nerve calming
Love the insights.
brilliant stuff Chandoo and your family contributions ... I had a year secondment offer and my option given was Chennai :D - Yes I used STAR - really focusing on the outcome the benefits that were realised. After every interview the first thing i would do is write down all the questions i was asked to learn from experience. My CV is written in an achievement style similar to STAR answers but condensed .
I always take notes during the interview. Great idea to write down the questions asked!
Thank you so much ..for sharing the informative video...
Very useful tips Chandoo.
I’m Jobless for the past 3.5 months and still counting… Trying my level best and hoping to have some positive outcome ASAP.
Just keep going. My first job I found after about a year of searching. Currently I am also jobless since May 2020 and looking for a mechanical engineer position near Pittsburgh
I will not give up and neither should you. It will happen, especially with these tips
@@patrickschardt7724 Thanks for your caring and kind words. ❤️ Wishing you too good luck with your job hunt.👍🏻
You are welcome Vinod. I wish you all the best in your job search.
best wishes for your job search. you will get it.
Thank You, Sir!!
🙏😊😇
good advice. i def feel it's a chance for me to suss them out as well. after all, they will be paying me for my work. my current job had a great process. at the time, i wasn't sure i needed to look yet. so i only applied to jobs that didn't waste my time filling information into their HR interface. i was leaning hard on old school resume. and my boss got 110 applications for this role from which he chose the ~10 best to phone interview and of those he'd pick the top ~3 to give data and see what they did with it. i'm not super cocky, but i know i'm good enough and different enough that i'd get the job if i got to the final 3. i was already in top 10% at that point. just hearing how he was testing potential hires made me want this job more. and the funniest part is i had changed my generic career identity on top of resume from data/sales analyst to brain conservationist. which is how i ended up on the top 10. hahaha. for a quirky person to find a quirky company, that worked. wouldn't do that if i was for sure hard focused seeking.
Awsome chando....Valuable info.....👌
Very understandable examples
Thanks for sharing such deep points.
My pleasure!
Very helpful video sir, thank you so much 🙂
You are welcome Shikhar...
STAR METHOD! oh boy this is pure GOLD since second 1, thanks a lot Mr. Chandoo
You are welcome Antonio...
Thanks for insights
Amazing .. Quite informative
really insightful tips..
You have amazing videos! I’m new to excel & can’t figure out how to extract my staff only from a large dataset. The file has 175K rows & staff in 3 columns. Can I extract just those rows with my team in the 3 columns?
Thankq brother!
Excellent chandoo
Just great 👍🏻
Dear Chandoo Garu, Thanking to you allowing us to get Excellent suggestions through your video
It's my pleasure
I should have watched this video weeks ago when I was doing interviews Lol... Great tips
I’m interviewing with Amazon next week. Hope this video helps!
You are awesome @chandoo👏👏
This is very helpful
Thank you
Thank You Sir ❤
thanks chandoo bhai, its realy a awsome video
Most welcome
Great advice! Thanks for the tips. Thumbs up!!
Glad it was helpful Wayne...
I am definitely going to use the STAR approach and the last tip for the coming internship. Thankyou sir.
All the best Girija...
@@chandoo_ Thankyou sir
awesome tips...learned a lot...
Glad to hear it!
one of the best channel in the youtube.
Very inspired...
I can say just one word - "Wonderful"
🙏 Thanks SIR
Thanks so the guidance 🙂🙂
You are welcome Arun...
Great tips chandoo
You are welcome Rodney.
Thank you...helpful
Glad it was helpful!
Nice
Really awesome Sir..
Thanks a lot
Helpful n prcatical...thanks
You are welcome
Thanks Chandoo.
You are welcome Swapnil... 😀
May I recommend the viewers to play "Happy Classical Music: Mozart, Vivaldi, Beethoven" on low volume as this video plays? its enhances the video and mood for those of us who feel a nervous about being interviewed like me😫 thank you for your great videos
Iam giving interviews since last two months..got two jobs but not thinking about money only ends up in low paying jobs. I think we should negotiate salary also when it comes to interviews and when they ask you how much are expecting
Superb👍
Thanks 🤗
Can you guide, which are the tools using as data analyst. It would help me alot
Thanks for the tips. One thing I have come across at an interview is that often the interviewer itself is not knowledgeable enough about the subject matter we discuss. For example, when speaking about Power Query/Power Pivot/Power BI very often it goes right over their heads! I cannot explain a value addition I have made via these tools where the systems are not that great. You run into blank faces when you try to explain them and how useful they are! The tools in Office 365 Excel like LET functions are no go areas!
Fantastic
Thank you so much 😀
Hi Chandoo, thank you for the valuable insights, I can surely relate to couple of the highly mistakes, especially being hard on myself. I have an interview scheduled where in the core area will be about my experience with a BI tool. I haven't done any heavy handed work with it like scripting or such, so how can I face such interviews where they require you to be an SME, but you had been a user throughout?
Thanks Sreekanth.
Why not be honest and tell them what you did in the previous role, how you can contribute in the new role. As a previous user of the reports, your perspective and ideas can be very valuable when you "switch" sides.
@@chandoo_ Thank you very much for your valuable advice, i will keep that in mind. Much appreciated.
Very thankful chandoooooo. I
You are welcome Pavan... 😀
Great Delivery Sir I have made some mistakes you mentioned in the video, Now I can see clearly.
Sir how can we show our works if its from our previous companies.? Should we have some dashboards build already even if we are going for an associate role?
For my interviews, I try to have a couple of examples & I excerpt the information. Meaning I replace any specific information for the company (e.g., employee names). It is easier to walk interviewers through a visual example sometimes.
Thanks Sudharshana... You can take screenshots, blur portions and use them. You can replicate them with made up data and use them as well.
I am going to have a junior workforce analyst interview. I have some experience working with SQL and MS Excel from my bachelor. Could you give me some tips or even anyone know how this interview gonna be like? There will be 2 parts the first is the interview and the second a 30-minute test in Excel, SQL and Math Logic, using multiple choice questions.
And please enlighten how we should apply the STAR technique if we are a fresher and learned Power BI through tutorials or while preparing for the Certification.
You can use the experiences gained during internships, voluntary projects or any freelance work.
Its very hard to find the people where u join ask or get the info why the people are exit, will the people are happy and satify there work..
Chando, I wish to meet you man, very nice attitude. Respect from pakistan 🇵🇰 bro
Thank you Rehan :)
Hi, Am coming from Manufacturing Background with 14 Years' experience. I Am fascinated with Data Analytics. Had created Dashboards & Programming in Advance Excel for our Production Operation Streamlining, Inventory Management & Production Planning. I would like to move my Career to Data Analytics. Can you please guide me on what will be the best path to Proceed?
Try looking for any data jobs in your industry / current workplace. This is the best way to transition. Also reach out to your colleagues (both current and ex) and see if any of them can refer you for a job in data / tech. If nothing works, apply for data jobs outside with a strong cover letter or find a consultant / agent to represent you. All the best.
Goood
@chandoo I want to be just like you.
Sir plz guide freshers for the Interview
Hello sir, I have never faced any interview in my life. I am graduated in 2022, Since after passing out , I learned technical skills on EXCEL SQL SAS POWERBI TABLEAU. I fell very nervous to atttend any interview, how to prepare for my interview and how should i remove nervousness for interview.
I can't get the managers to respond to feedback email requests. 😔
sir my all friends and know one got the job except me a
ia, fill very low
Dear sir
i am working in the garment manufacturing unit and i received orders for stitching and want to track all garments orders separately on excel
in which included
1.order making of received clothes
2.Customer details in order
2. give a specific number to the order automaticaly
3.recived time & completed time
I am waiting for your reply
Thank you very much
Thanks for the suggestion. Please use my Excel tracker video to understand how to make this. ruclips.net/video/e0s9xdx5FF8/видео.html
Sir I m ready to work for u.Could u please give this work for me then i will do it for u.
Hii sir I stat learning tools of data analyst can you tell me something how i describe my path?
Hii sir iam fresher
I just completed my Data analysis Course
Now I'm preparing For Interviews
Give Some Interview Tips. ☺
I dont understand how to make a project i belong to a completely different background😪. All i hv are certificates
For most of us we're breaching company confidentiality if we use examples from our work place and show it to a recruiter/future employer. And if I were an employer, I'd think seriously about hiring someone who didn't think twice about showing me confidential info. That might work for a contractor but not an employee. Not particularly good advice, very unprofessional.
How to negotiate
I make all 7 mistakes in one interview
if I use mobile to show my work interviewer can accept ?
That depends. Sure try it. But carry a few print outs or even your laptop so you can actually demonstrate rather than show some screenshots.
bro are from telugu states
Hello sir. I have registered for tata imagination Chllenge. Can you please suggest me some tips to win this challenge?
I can't. I don't know what that is.
Tip: you don't pass a serious interview with interview techniques. You only pass by showing knowledge of your field. If you don't have those skills and you pass anyway, then your new employer doesn't care about skills... welcome to hell in which you will be greeted by many clueless co-workers. ;-)
but there's no gender pay gap. was this meant to sarcastic
hmm.. Gender pay gap is present in pretty much all countries. Not sure what your reference point is.
@@chandoo_ my reference point is that there is a sizeable difference with fewer women than men working in the same profession due to lifestyle and gender preferences. if women were paid 77 percent of what men made then why do you not see companies reduce operating costs by hiring exclusively women?
Are you for real? That is not how it works.
As this is not the right platform discussing such a thing, may I suggest talking to a few women in your family / friends / local industry to see their perspective. Gender & lifestyle issues are not the main reason for the gap. I did extensive studies in this and worked with many local government organizations. There is bias everywhere.