Tell me about a time you've had to prioritize competing requests. How did you handle the situation?
Senior Data Analyst Interview Questions
2,892 senior data analyst interview questions shared by candidates
I was asked basic SQL questions on joins and select queries. Some questions on window functions like lag and lead.
**This is the literal question verbatim** Suppose we’re investigating the average number of daily ad impressions per user. For example, if 100 users had 10 ad impressions each two days ago and 50 different users had 40 ad impressions each yesterday than the average daily ad impressions per user would be 20 across those two days: Now suppose you have an impressions table where each row represents impression details. The columns are as follows: + country string (the country the user is from) + date date (the date the impression happened on) + user_id int (the id of the user) + impressions int (impression count) 1.) What is average daily ad impressions per user for only US users
Time series question on logs of data
How would you conduct an A/B test to understand how well a promotion performed when added to this part of the product page on Nordstrom.com?
How do you handle multiple stakeholder priorities?
To provide ab test, theory of probability tasks, SQL
Question from the past experiences
Experience Projects Work style, culture, teamwork Past responsibilities Technical experience Proposal experience Past companies Details about specific government programs and CMS
the excel questions mostly required V-LookUps
Viewing 221 - 230 interview questions