Holy cow. If you assign this to me as a task I can probably finish it in a day with some googling, trial and error, etc But doing this right away during an interview? I would have freaked out completely. This guy just nailed it, and the tips are super helpful. Thanks for sharing!
@chinedu99 Жыл бұрын
Ben is built different, no hesitation, its like he had done this before, what a beast
@shreyansbadjatya8906 Жыл бұрын
Shouldn't the average_purchase_value consider only those sessions where a purchase was made? (rows with purchase_value > 0). The conversion rate of each marketing_channel is creating a bias in this metric.
@LeoLeung.935 ай бұрын
12:35, can we basically get the min timestamp in the high_value subquery?
@its_me7363 Жыл бұрын
Very helpful...Please do more of Data Engineering Mock Interview and sessions related to DE.
@ro8763211 ай бұрын
This is very helpful. Thank you for sharing
@mz2888Ай бұрын
In the last question (finding perc_high_value) what was the need to join with the first_session table ?
@rishabh_7kАй бұрын
can i get this dataset
@kaboyodaniel3630 Жыл бұрын
Nice session. Very helpful.
@tracyzhang7076 Жыл бұрын
Hey, for this episode interview question doc, Could you share? (add a link here)
@DasAndChill4 ай бұрын
very helpful thank you.
@mattmatt245 Жыл бұрын
Why is the data in two separate tables ? It looks like a one to one relationship to me.