Top 5 Data Analyst Interview Mistakes
ฝัง
- เผยแพร่เมื่อ 1 มิ.ย. 2024
- Stop making these Data Analyst Interview Mistakes!
I would consider myself a seasoned professional in this regard. I have made so many mistakes in interviews! Hopefully in this interview I can identify some that you may need to work on. Make sure to be fully prepared for that next interview!
Alex The Analyst Shop - teespring.com/stores/alex-the-analyst-shop
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- bit.ly/3hhX4LX
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON
Patreon Page - / alextheanalyst
Every dollar donated is put back into my channel to make my videos even better. Thank you all so much for your support!
____________________________________________
Websites:
GitHub: github.com/AlexTheAnalyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for
0:39 Not coming up with Examples and stories (e.g leadership)
1:22 Not Researching about the company
1:47 Not preparing for the technical questions (Most likely SQL, sometimes Python)
2:35 Not asking questions during/after the interview
3:44 Not telling the truth in your interview
4:24 Not dressing professional in an interview
Select mistakes
From interviews
Where name = "Alex the Analyst"
Nice :D
What has worked really well for me in the past is asking about the background of the interviewer. It seems like a weird question, but it can be a really nice change of pace for a recruiter and it can be very helpful information if a potential future colleague is interviewing you! One time a recruiter went off on a full tangent and afterwards said they enjoyed a lovely conversation; what followed was him constantly going the extra mile for me and landing a pretty awesome position in 3 weeks or so
That's true! not a bad thing to ask at all!
Hi when you ask about the background what kind of questions should i that be? Thank you in advance
When it comes to the technical questions, you may also want to be familiar with self-joins. I've heard that having to know what a self-join is or even maybe even having to do a self-join as a coding challenge with SQL during an interview is common.
My favorite video yet! Made all these mistakes myself 😂
Yeah, that's one mistake I made. I was asked the difference between "WHERE" and "HAVING" and to describe the different types of JOINs, I failed that one. Hadn't practiced SQL beforehand.
Joins was a huge one for me that I kept missing in interview questions!
I got asked a lot of questions on leadership, working in a group/team, conflict resolution, and making mistakes (or major failures) during almost all of my interviews. Thankfully, I could think on my feet and come up with an answer almost immediately! But I'll definitely prepare for such questions from now on.
Just to add on, maybe one more point could be to know your resume in and out. The last thing you'd want is the interviewer to ask "So why don't you tell me about xyz thing that you've written on your resume", and you've completely forgotten about that project (or whatever the interviewer is asking for) and end up giving some vague answer. It just leaves a bad impression.
Very true! Good addition!
Hey! I just found your channel and subscribed, love what you're doing!
I like how clear and detailed your explanations are as well as the depth of knowledge you have surrounding the topic! Since I run a tech education channel as well, I love to see fellow Content Creators sharing, educating, and inspiring a large global audience. I wish you the best of luck on your TH-cam Journey, can't wait to see you succeed! Your content really stands out and you've put so much thought into your videos!
Cheers, happy holidays, and keep up the great work :)
Thank you! Please continue🙏, that was an amazing opportunity to learn from you.
You're most welcome! Thanks for watching!
Thanks for the technical questions links.
Very helpful, thanks a lot!!!
Thank you Alex! Your insight really helps me!
My pleasure!
Thanks Alex!
Hi Alex,
You always amaze me when you upload right video at the right time...i am in pursuit of getting a new job .....and here surprising me with relevant video....thank you very much .......
Haha glad to hear it! Thanks for watching 😁
Love your videos man, I'm excited to study this at uni soon
Love your name 👍
Good morning Alex, Thanks for sharing top data analyst interview mistakes to us.
You’re most welcome! Thanks for watching!
thx man!
Got a phone screen tomorrow for a jr data analyst position lol hopefully it goes well
Hey Alex, you said it was going to be a link for interview questions, but I don’t see any.
Hi Alex, I have my interview this Monday. This is my first data analyst interview. I am freaking out. I have watched all of your videos on SQL, Tableau, Excel and made projects alongside. I have practiced a lot but I don't feel confident. I feel like I'm forgetting everything I studied. What should I do?
Thanks for the tips btw
How did it go
How was your technical round interview?? Wheather it was easy or tough
Lying during an interview starts with the lies on your resume/cover letter.
Some interviewers can be funny, they'll leave questions on data analysis and ask you questions about the company.
Could you please make a video about how to find a remote junior data analyst job
Good idea! I'll look into that one
Do we need to know about DSA for Data Analyst / Data Scientist Job
Do the recruiters expect us to write complex sub queries for entry level data analyst job roles
I would hope not! Haha 99% of entry level jobs will not expect you to do that
How much SQL do you believe is required for an entry-level position?
I would say if you know up to joins, unions, and can use the group by well then you should be good. I have a few videos on this subject talking specifically about what you should know!
last one is a good one, shirt always mandatory altho interviewers tend to wear pijamas if they work from home
For people who speak English as a second language, its common to stop for a second and think of the right word. Does that throw the interviewer off?
You are the best, Thank you for short and sweet video's, excellent information
Thank you man! So glad to hear it was helpful! :D
For somebody who wants to become an analyst, should they learn Python or SQL or both? Is one language enough?
Salvos a staple and is a must. Python is great to learn and is very useful, but doesn’t need to be learned right away. I would check out my Data Analyst Skills Path video where I talk about this in depth 👍
I want to become a healthcare data analyst. I am graduating with a BS in Heath information management. I also want to continue my education, should I finish my AS in Business Administration and go for a BS Business Administration or go for a MS in healthcare informatics. ? Are they unnecessary?
If you’re sure about healthcare informatics masters would be the most beneficial. With that being said you can always get a bachelors degree and then get some experience and see if you priorities change.
@@AlexTheAnalyst thank you for the advice! I think that is the best route! Appreciate you content! Amazing and very useful information!
It was very helpful video. But I to get a job or internship ship as an entry level. Because I'm about to finish my bachelor and I'm still looking for this. And I'm from India and there different scenarios of interview and other stuff.
Glad to hear it! I wish you the best of luck in your job search!
@@AlexTheAnalyst and I'm also very thankful for video that you have made on SQL both SQL beginner and SQL intermediate are very helpful..and waiting for future video...thnx love from India 🇮🇳🇮🇳
Why the links in caption dont work!😢
Do you know where we can find a list of commonly asked SQL questions?
I actually have a video on this if you’re interested - I know a lot of other channels that have similar things. I would search “SQL technical interview questions”
@@AlexTheAnalyst thank you! I’ll search your videos for this
How formal should the dress be? I mean very often I just see some interviewers so dressed up that they look a hitman or a con.
😂😂 for men I recommend at a least a nice button down tucked in. I normally wear a blue suit and tie at the most if I think it’s appropriate. For a girl a nice blouse and at the most a blue blazer or nice dress.
@@AlexTheAnalyst Thank you for the advice!
It doesn't matter how casual the potential work place is nor workplace for which you're applying. Always dress a step up for your interview. If you think they wear jeans and tshirts, go business casual. If research shows a business casual environment, buy a suit.
I have an interview tomorrow for a data analyst position. I am confident in my technical answers, but what will kill me is my nervousness.
Did you get the job?
my timestamp
0:35 - story for leader, work in tem, over problem
1:25 - do research for company
1:50 - technical ready (sql python)
2:30 - study websites
3:05 - there are many questions
❤❤❤❤
Alexxxxxx
I mean... I could dress professionally... But I'm 400lbs... Doesn't matter how nice the clothes are, they won't look nice on my beanbag chair body... Lol
😂 A good sense of humor goes a long way though - definitely not an interview mistake there lol
one of my rules for life: "Tell the truth - or, at least, don’t lie" Jordan Peterson.
I like that 😁
Quite generic insights, nothing specific and no example/ sample answers given