So they asked me about the work experience that I have had.
Sr Data Analyst Interview Questions
3,090 sr data analyst interview questions shared by candidates
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.
Ownership of Dashboards. Tools worked on (Tableau, Power BI, SQL Server) Related relevant technologies- SQL joins, python. In my 2 rounds I was also asked about the other work experience to understand my client handling skills and understanding of data
Simple statistical questions that are designed for junior interviews: What is skewness, what would explain the order from left to write mean median and mod
How you handle missing data
they gave you a case study and ask how you solved it
DDL and Performance tuning questions.
What experience do you have building machine learning models?
There was an unexpected math test after the PST which was difficult for someone who has not done permutations and whatnot in a while.
I really enjoyed this case: given a particular dataset, complete a series of analytical tasks into the data, and draw some conclusions from it. Most importantly, how would the conclusions and action items change if presenting to the actuarial team, or the operations team, or the customer success team, or to leadership.
Viewing 151 - 160 interview questions