Get top 3 salaries without using LIMIT
Data Analyst Intern Interview Questions
48,346 data analyst intern interview questions shared by candidates
In the first round, they asked me 2–3 Python questions, around 4–5 SQL questions (including joins and basic queries), and 1 aptitude-based question. In the second round, I was asked statistics and probability questions, followed by a complex Python coding problem which I was asked to solve live — but the interviewer had to leave midway and asked me to submit it via email instead.
if I have any money
Can you see a possible bug that could arise from this function? def add_to_list(value,my_list=[]): my_list.append(value) return my_list
How you manage a task that you have never done before
Are you able to work with overlapping of 4 to 5 hours with US timing?
Where are you from? From which country?
The questions were STAR questions speaking on past experiences as well as current experiences. I have a broad background, so it was natural to answer. Panels can be uncomfortable, but this was a very natural discussion more than a forced interview. The questions were technical as well as personal.
SQL whiteboard technical: Given 2 table schema of web traffic and orders and 5 questions on a sheet of paper. I don't remember all of them but it was a lot of get unique order ids and group by, a left join to combine orders with traffic.
How would you describe to a manager why it is important to have non-digital media if you could not track conversions accordingly
Viewing 2111 - 2120 interview questions
See Interview Questions for Similar Jobs
Data AnalystDeveloper InternResearch InternBusiness Analyst Summer InternData Scientist InternStatistics InternProject Manager InternProgrammer InternAudit InternData Entry AnalystData InternAnalyst InternQa Engineer InternAnalytics InternData Science InternBusiness Intelligence InternHardware Engineer InternActuarial InternQa Intern