curology DA面经 SQL【求米】
13891
看地里关于marketing analytics方向的面经不多，来给提供点数据点
面得三番一家药妆化妆品公司，商业模式主要是订阅式。海投拿到的面试
职位是偏user insight方向的data analyst
第一轮HR电面：
问背景，基础BQ和相关项目（偏marketing analytics）
why this company？
How do you know this position?
第二轮tech round：
面试官是senior DA，介绍了自己和组的情况
3道SQL
tabl1
id, firstname, last name, created_date
table2
date, userid, was _paused, first_subscribe_date
table3
userid, event_date, page_url, page_refer_url
Q1: 找出通过xxx网站来的，并且创建账号在6月的订阅者总量
Q2: return the number of users who have created an account since Feb1, and the percentage of those users who are currently subscribed and have never paused their subscription.
Q3: returns the average number of days subscribed for previously subscribed users who have churned. assume that churned users do not re-subscribe
题本身都不难，但是表的设计不太一样，需要和面试官clarify每个column的意义，不然后两道很容易写跑偏，我就是这么跪的......
希望对大家有帮助，求米~~~~~~~~~
面得三番一家药妆化妆品公司，商业模式主要是订阅式。海投拿到的面试
职位是偏user insight方向的data analyst
第一轮HR电面：
问背景，基础BQ和相关项目（偏marketing analytics）
why this company？
How do you know this position?
第二轮tech round：
面试官是senior DA，介绍了自己和组的情况
3道SQL
tabl1
id, firstname, last name, created_date
table2
date, userid, was _paused, first_subscribe_date
table3
userid, event_date, page_url, page_refer_url
Q1: 找出通过xxx网站来的，并且创建账号在6月的订阅者总量
Q2: return the number of users who have created an account since Feb1, and the percentage of those users who are currently subscribed and have never paused their subscription.
Q3: returns the average number of days subscribed for previously subscribed users who have churned. assume that churned users do not re-subscribe
题本身都不难，但是表的设计不太一样，需要和面试官clarify每个column的意义，不然后两道很容易写跑偏，我就是这么跪的......
希望对大家有帮助，求米~~~~~~~~~
- 11
1条回复