注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
回报地里 说说我的square 面经
面试三轮, 第一轮 电面 主要是 ab testing 和选kpi 问题大概是和square small business revenue 有关 看revenue 分business 的类型 测试
第二轮 简单的sql 具体不太记得了 主要是sub query case when
. From 1point 3acres bbs
第三轮 题目如下 ,我自己觉得答得还可以 题目也不难 主要是让你写python pandas 画图 分析趋势 ,不料面试官是个老中 大卫 冯 ,前面的几轮老外都过了, 这个第二天通知说不match,他们已经找到别人了,哎, 个人觉得被黑了 ,也许我可能面的不好自己不知道吧
[size=12.800000190734863px]Prompt:
You are the new analytics partner for a monthly subscription-based SaaS product. After you join, your Product Manager would like you to investigate Monthly Recurring Revenue (MRR) for the product. She/He has a feeling that it is not growing as much as expected in the last month..
You are pointed to a table that contains subscription information but are not told the specifics about the data design. For analysis you are permitted to use any tool yotd> |
| 055E29N6K4DNH 7/30/16 active 90 casual_use 95017 |
| 055E29N6K4DNH 10/24/16 active 210 casual_use 95017 |
| 055E29N6K4DNH 11/25/16 active 210 casual_use 95017 |
| 055E29N6K4DNH 10/28/16 active 210 casual_use 95017 |
| 055E29N6K4DNH 11/17/16 active 210 casual_use 95017 |
| 055E29N6K4DNH 2/4/16 active 90 casual_use 95017 |