1.SQL String Aggregation
2.SQL Window Function
3.Simple SQL Aggregation
4.Follow-up Approaches for a Case Study
5.SQL Code Modification for Dashboard Creation
6.Measuring the Effect of Incentive Coupons Using Randomized Experiment
7.Analyzing the Impact of Coupons on Consumer Behavior
8.Case Study Analysis
9.SQL Query Writing
10.SQL Error Identification
11.Access Control System Coding Problem
12.Additional Analysis and Considerations for Launch Decision
13.Impact on Unit Economics from Launching Variant to All Customers
14.How do we assess the reliability of these findings?
15.What can we learn from the experiment tests, and what do you recommend?
16.Left Join with Where Clause vs Inner Join
17.Window Function with Sorting and Handling Ties
18.Identify a product that appears only once in a table
19.Significance of Changes in Order Rate and Value Per Order
20.Marketplace Case Study
21.SQL Query Challenges
22.Investigating a Sudden Drop in Revenue
23.Investigating Shopper Retention Experiment
24.Experiment Results Analysis and Recommendation
25.Operations Research Concepts
26.ETA Prediction Model Discussion
27.Model Choice for Hierarchical Taxonomy Classification
28.Gradient Boosting Machines
29.Unsupervised vs Supervised Methods
30.Feature Preparation and Importance
31.Discuss the approach to Fraud Detection
32.Profit Per User Estimate Under Ultrafast
33.Ultrafast Delivery Impact Analysis
34.Revenue Investigation Approach
35.Simple SQL Questions
36.Evaluate the use of OLS for estimating treatment effect in an experiment with right-skewed data, and discuss the proposal of using a log transformation before applying OLS.
37.What’s the difference between the chosen model and xgboost?
38.Choose a ML model and describe to me step by step in an easy-to-understand language
39.Tell me about a time where a simple statistical method doesn’t work and you use a more advanced method to solve the problem
40.SQL Problem Solving
41.Calculate Point Estimate with Ultrafast
42.Estimate Lift in Orders Per User
43.Investigate Revenue Decrease
1. SQL String Aggregation
Using the provided tables, demonstrate how to perform string aggregation in SQL.
2. SQL Window Function
Using the provided tables, demonstrate how to use a window function in SQL to calculate a percentage figure.
3. Simple SQL Aggregation
Given three simple tables that are not related to carrots and include toy data and schema, use PostgreSQL to answer simple aggregation questions. There are no trick questions involved. The tasks include simple aggregation, group by, and order by operations without the use of where conditions.
4. Follow-up Approaches for a Case Study
What follow-up approaches would you suggest for a case study after measuring the effect of incentive coupons? Consider aspects like assumptions check for causal inference and exploring heterogeneity by clustering users to see which group is more sensitive to coupons.
5. SQL Code Modification for Dashboard Creation
How would you modify SQL code to create a dashboard that summarizes data at the aggregate level?
解锁更多真题，请点此 登录 篱笆帮
高频题（0）
