早上刚面完,分享一下。
sql
product catalogue 题
难点在于理解题目和会建立quantile based distribution。例如postgresql中的approx_percentile() function 和如何利用这个function的output作为cutoff point去categorise每个entity into each quartile
case
context: 公司给广告主们建了个统一的产品(广告)catalogue,便于管理what and when to promote
为什么要推出product catalogue for business owner (i.e. advertisers) -> why some business like/dislike the idea?
what are the metrics to evaluate whether the catalogue as a product is useful?
how to evaluate its impact -> randomised exp
没有特别难的点 重要的是clarify context 和 start from motivation/objective
祝大家好运!