How to join two sql tables and the difference between a union and join.
Senior Data Analyst Interview Questions
2,902 senior data analyst interview questions shared by candidates
How would you handle being in a mission-critical position? (The job was in the Admissions Office -- hitting their enrollment targets is crucial to the University.)
What would be your preference: Quantitative work or selling/writing?
dataset was given which was only text and was asked what could be done with this. what if i provide you with classes how your overall approach will change and how will you present it to a non technical client?
do you know window function and what is difference between dense rank and rank
difference between all the joins
What is your experience as DA
Are you able to help drive strategic direction, provide supporting analysis and work with the customer?
So they asked me about the work experience that I have had.
I had to put together a metric for a Supply Quality score (sounds more complicated than what it is) by using available data on performance (could use internet data, too). I also had to answer advanced level SQL questions. After this it was mainly behavior questions. At one point there was also a case study where I had to understand the logic of profit increase if hotels dropped their prices last minute and they received more bookings.
Viewing 141 - 150 interview questions