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
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
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.
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.
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.
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 .......
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 RUclips 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 :)
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
Another tip I would include is: Confidence comes with experience. While there will always some level of anxiety related to doing a job interview, you'll find its greatly reduced if you have experience in the domain, tools, and technology associated with the role. This doesn't have to be exclusively work experience. It can be hours of SQL practice or several projects using Python. Employers are looking for people that can help them get work done. And if you have a lot of work you got done, you can come in with confidence that you will be someone of value to the company. Do not neglect this part. Get in the practice on tools and tech you will use, finish projects in the domain and industry you want to work in, and shamelessly post about it somewhere! Build confidence.
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!
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.
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.
@@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 🇮🇳🇮🇳
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 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”
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.
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
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.
😂😂 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.
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
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
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
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.
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!
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!
Select mistakes
From interviews
Where name = "Alex the Analyst"
Nice :D
I'm so proud I understood that as a mental health provider trying to make a data analyst pivot 😂
My favorite video yet! Made all these mistakes myself 😂
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!
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 😁
Thank you Alex! Your insight really helps me!
My pleasure!
Thanks for the technical questions links.
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 RUclips 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 :)
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
Very helpful, thanks a lot!!!
Thanks Alex!
Could you please make a video about how to find a remote junior data analyst job
Good idea! I'll look into that one
Got a phone screen tomorrow for a jr data analyst position lol hopefully it goes well
Another tip I would include is: Confidence comes with experience. While there will always some level of anxiety related to doing a job interview, you'll find its greatly reduced if you have experience in the domain, tools, and technology associated with the role. This doesn't have to be exclusively work experience. It can be hours of SQL practice or several projects using Python. Employers are looking for people that can help them get work done. And if you have a lot of work you got done, you can come in with confidence that you will be someone of value to the company. Do not neglect this part. Get in the practice on tools and tech you will use, finish projects in the domain and industry you want to work in, and shamelessly post about it somewhere! Build confidence.
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!
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.
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 🇮🇳🇮🇳
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
Hey Alex, you said it was going to be a link for interview questions, but I don’t see any.
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?
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 👍
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
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!
thx man!
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
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
Why the links in caption dont work!😢
Do we need to know about DSA for Data Analyst / Data Scientist Job
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.
Thank you! Please continue🙏, that was an amazing opportunity to learn from you.
You're most welcome! Thanks for watching!
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!
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?
❤❤❤❤
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
Alexxxxxx
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