Top 5 Data Analyst Interview Mistakes

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

[@ppppppp7282]

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

[@gangaadhikari9491]

Select mistakes From interviews Where name = "Alex the Analyst"

[@AlexTheAnalyst]

Nice :D

[@Holt196]

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

[@AlexTheAnalyst]

That's true! not a bad thing to ask at all!

[@yasuke8209]

Hi when you ask about the background what kind of questions should i that be? Thank you in advance

[@donnelly5757]

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.

[@vishesharora2352]

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.

[@AlexTheAnalyst]

Very true! Good addition!

[@brothermalcolm]

My favorite video yet! Made all these mistakes myself 😂

[@jonathannali7682]

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.

[@AlexTheAnalyst]

Joins was a huge one for me that I kept missing in interview questions!

[@Vintagetube310]

Thanks for the technical questions links.

[@kulzhans.1144]

Thank you! Please continue🙏, that was an amazing opportunity to learn from you.

[@AlexTheAnalyst]

You're most welcome! Thanks for watching!

[@pana71]

Thanks Alex!

[@empowercode]

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 KZbin 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 :)

[@danielchong4081]

Very helpful, thanks a lot!!!

[@Alex-tq4jd]

Love your videos man, I'm excited to study this at uni soon

[@AlexTheAnalyst]

Love your name 👍

[@pramcharannaidu2509]

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 .......

[@AlexTheAnalyst]

Haha glad to hear it! Thanks for watching 😁

[@raissaloretta442]

Thank you Alex! Your insight really helps me!

[@AlexTheAnalyst]

My pleasure!

[@RudraChannel123]

Good morning Alex, Thanks for sharing top data analyst interview mistakes to us.

[@AlexTheAnalyst]

You’re most welcome! Thanks for watching!

[@wildgorilla1205]

thx man!

[@ElPapelMan]

Got a phone screen tomorrow for a jr data analyst position lol hopefully it goes well

[@davidil2147]

Hey Alex, you said it was going to be a link for interview questions, but I don’t see any.

[@JongeloEntertainment]

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.

[@AhmedSayed-ki3fm]

Could you please make a video about how to find a remote junior data analyst job

[@AlexTheAnalyst]

Good idea! I'll look into that one

[@lingaharishkumaril7933]

Do we need to know about DSA for Data Analyst / Data Scientist Job

[@harkaur2912]

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

[@willviruet1187]

How did it go

[@ishikaraj9739]

How was your technical round interview?? Wheather it was easy or tough

[@alandavid5045]

Do the recruiters expect us to write complex sub queries for entry level data analyst job roles

[@AlexTheAnalyst]

I would hope not! Haha 99% of entry level jobs will not expect you to do that

[@alejandroj5249]

last one is a good one, shirt always mandatory altho interviewers tend to wear pijamas if they work from home

[@danelston9317]

How much SQL do you believe is required for an entry-level position?

[@AlexTheAnalyst]

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!

[@raymellon9572]

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.

[@AbhishekSharma-hy4nl]

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]

Glad to hear it! I wish you the best of luck in your job search!

[@AbhishekSharma-hy4nl]

@@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 🇮🇳🇮🇳

[@venkatrap5733]

You are the best, Thank you for short and sweet video's, excellent information

[@AlexTheAnalyst]

Thank you man! So glad to hear it was helpful! :D

[@isaacrivera3322]

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?

[@AlexTheAnalyst]

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.

[@isaacrivera3322]

@@AlexTheAnalyst thank you for the advice! I think that is the best route! Appreciate you content! Amazing and very useful information!

[@2Addictive]

For somebody who wants to become an analyst, should they learn Python or SQL or both? Is one language enough?

[@AlexTheAnalyst]

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 👍

[@joshi1q2w3e]

Do you know where we can find a list of commonly asked SQL questions?

[@AlexTheAnalyst]

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”

[@joshi1q2w3e]

@@AlexTheAnalyst thank you! I’ll search your videos for this

[@iqrajavaid2613]

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?

[@Tech4Ma]

Why the links in caption dont work!😢

[@aynurseyfullazade786]

Alexxxxxx

[@arielleung3917]

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.

[@AlexTheAnalyst]

😂😂 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.

[@arielleung3917]

@@AlexTheAnalyst Thank you for the advice!

[@froilanemeliano6551]

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

[@R_nold_v]

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.

[@tasnubaanika2425]

Did you get the job?

[@mizomint4197]

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

[@AlexTheAnalyst]

😂 A good sense of humor goes a long way though - definitely not an interview mistake there lol

[@mohammedbouchcoucha890]

one of my rules for life: "Tell the truth - or, at least, don’t lie" Jordan Peterson.

[@AlexTheAnalyst]

I like that 😁

[@AlexLin]