Data Science SQL Mock Interview - Analyze Marketing Channels

  Рет қаралды 9,602

Exponent

Exponent

Күн бұрын

Пікірлер: 13
@streambumper250
@streambumper250 Жыл бұрын
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
@chinedu99 Жыл бұрын
Ben is built different, no hesitation, its like he had done this before, what a beast
@shreyansbadjatya8906
@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.93
@LeoLeung.93 5 ай бұрын
12:35, can we basically get the min timestamp in the high_value subquery?
@its_me7363
@its_me7363 Жыл бұрын
Very helpful...Please do more of Data Engineering Mock Interview and sessions related to DE.
@ro87632
@ro87632 11 ай бұрын
This is very helpful. Thank you for sharing
@mz2888
@mz2888 Ай бұрын
In the last question (finding perc_high_value) what was the need to join with the first_session table ?
@rishabh_7k
@rishabh_7k Ай бұрын
can i get this dataset
@kaboyodaniel3630
@kaboyodaniel3630 Жыл бұрын
Nice session. Very helpful.
@tracyzhang7076
@tracyzhang7076 Жыл бұрын
Hey, for this episode interview question doc, Could you share? (add a link here)
@DasAndChill
@DasAndChill 4 ай бұрын
very helpful thank you.
@mattmatt245
@mattmatt245 Жыл бұрын
Why is the data in two separate tables ? It looks like a one to one relationship to me.
@braddavis8232
@braddavis8232 Жыл бұрын
Ben is a g
Complex Datasets with SQL (Data Scientist Mock Interview)
16:37
Analyze a User's Posts - Data Analyst SQL Mock Interview
51:33
It’s all not real
00:15
V.A. show / Магика
Рет қаралды 20 МЛН
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 148 МЛН
Try this prank with your friends 😂 @karina-kola
00:18
Andrey Grechka
Рет қаралды 9 МЛН
A/B Testing Interview with a Google Data Scientist
13:06
Jay Feng
Рет қаралды 40 М.
Three Tricky Analytics Interview Questions with Andrew
25:03
Jay Feng
Рет қаралды 82 М.
It’s all not real
00:15
V.A. show / Магика
Рет қаралды 20 МЛН