What're the tools that you like to use for data mining and why?
Senior Data Analyst Interview Questions
2,898 senior data analyst interview questions shared by candidates
which kind of clusterization you know?
a test for numerical reasoning stf
comment gérer un projet de data analyse ?
The interview was rescheduled 2 times just before the scheduled time. The interviewer asked 2 SQL questions. The 1st question, I solved by self-join but I explained to him, that we could solve it by lag and lead, and then he asked to me write code for lag and lead. I have written the same. Then for 2nd question, He asked me, if there were 2 tables, one table had detailed data ( very heavy ) and 2nd table had only some details. He said we can't run a query on Table 1 because it's too heavy. I have answered for both tables. He said give me more way, I said, I am not aware of it, could you please let me know. Then he suggested we join both tables and give aggregate conditions during the join and where clause. I was not sure, as per my experience we can't give aggregate conditions during the join and where clause, so I have written dry run code to validate the answer. select *from table_1 as t1left join table_2 as t2on t1.c1 > max(t2.c2) select *from table_1 as t1left join table_2 as t2on t1.c1 = t2.c2where t1.c1 > max(c2) At last, I said, as per my information these are against SQL fundamentals, I might have less experience but i am confident on my answer. Then the Interview was completed, HR was also in call during the interview. I forgot to ask 1 question, when you are saying we can't run a query on table_1 then why are we joining both table? Thanks.
1st round - Online test (coding + MCQs on data science) 2nd round - Technical interview. Questions related to your past work and projects. 3rd round - Technical interview. Questions on common ML algorithms, parameters, bias-variance, metrics, quant problems, statistics, probability etc.
Salary expectations, why Ikea, why this role, what data did I work with, background
How would you feel working at a fast-paced environment where decisions can change quickly?
How will you manage multiple stakeholders and reporting requests?
Describe the metrics that you worked with at X company (the one before my current one)
Viewing 2851 - 2860 interview questions