I was asked basic SQL questions on joins and select queries. Some questions on window functions like lag and lead.
Senior Data Analyst Interview Questions
3,090 senior data analyst interview questions shared by candidates
**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
Experience Projects Work style, culture, teamwork Past responsibilities Technical experience Proposal experience Past companies Details about specific government programs and CMS
Question from the past experiences
the excel questions mostly required V-LookUps
Technical Case study to solve real life business problems
Viewing 231 - 240 interview questions