In a data analyst interview, employers ask questions that help ascertain your level of technical skills, including familiarity with data analysis software, data analysis terminology, and statistical methods. Interviewers may also use guesstimate questions to learn about your problem-solving skills and creative thinking.
Expect to get an easy SQL question but to be extremely fast in handling it. They will expect you to receive a few tables and go over all their descriptions (20~ terms), write the JOINs etc. as if you were previously familiar with all of their variables and tables in advance. So the key here is to be extremely fast because the rest is super easy and basic.
Tell me about a time when...
*Technical statistical questioning.
What was the mistake you had made? What was the thing you regret? Why you applied for this position?
I was asked several technical questions regarding practical application of SQL and my ability to write queries.
When I interviewed 11 years ago there were no difficult questions since the job market was better back then.
How do you handle problems at the work place?
The database consists of five tables that store information about gym members, check-ins, personal details, and interviews. You need to solve a murder case by analyzing the database with two pieces of information about the witnesses.
Q: Describe UNION and UNION ALL (I heard ON due to misinterpretation of the interviewer's accent)
Can we use WHERE and HAVING together in one query?
Viewing 1191 - 1200 interview questions