Data Analyst | December 2020
Company: Nerd Wallet
Position: Data Analyst
How was the interview process? What was it like?
II. Considering the data available in these tables, what characteristics of user behavior would you want to examine in this dataset? Propose 3-5 theories you have about user engagement and describe how you would explore them.
What technical questions were asked?
What was one of your solutions?
select reg_date,reg_attribution,COUNT(DISTINCT user_id)/SUM(COUNT(DISTINCT user_id)) OVER (PARTITION BY reg_date) share
from (select LEFT(reg_ts,10) as reg_date, reg_attribution, user_id from Users) u
group by 1,2