Пікірлер
@fazdatasciencetechcodingml5662 2 күн бұрын
True
@bondnatchapon 3 күн бұрын
Thanks for your info! I am on my path to this position!
@iqjayfeng 2 күн бұрын
I'm glad it was helpful for you, goodluck with your preparation. If you are eyeing up any particular companies for this role: www.interviewquery.com/companies might be helpful for you
@vrushabgaikwad5254 5 күн бұрын
It was 👍
@aznviet206 5 күн бұрын
his answers align with his current role
@harshitthakursingh4353 6 күн бұрын
Statical test Predictive model
@ZMSQLDATACorner-k3h 7 күн бұрын
Start with SELECT FROM WHERE GROUP BY HAVING ORDER BY DISTINCT TOP N OFFSET FETCH LIMIT ... FUNCTIONS... VIEWS... JOINS...SETS... CTEs ... TVC [UNION ALL] ... and the big one WINDOW FUNCTIONS... and read a good foundational book by say ITZIK BEN GAN... But it takes a LIFETIME to MASTER SQL... and this is true for every skill
@sunnydesai5837 8 күн бұрын
is it still possbile to claim the free year?
@iqjayfeng 7 күн бұрын
unfortunately the free year is not available anymore, but we do have a black friday sale coming up in a few days
@mightyiyi 8 күн бұрын
dude didn't mind the typos
@GunishaDutt 9 күн бұрын
For the easy question - wouldn’t it also be helpful to know how much is the deviation from expected revenue? And then to find out reason behind it, before proposing a solution?
@OZTutoh 9 күн бұрын
Am I dense or did you cut the video before the final query result was shown?
@humakhan5713 15 күн бұрын
Not much helpful
@tsvicky5208 15 күн бұрын
Are you a ml engineer?
@osenifabua1912 16 күн бұрын
Very helpful video, thank you🙏🏾
@afsana2595 20 күн бұрын
Great video.Thanks
@iqjayfeng 17 күн бұрын
Glad it was helpful!
@spinhero 21 күн бұрын
Great content man. May I suggest lowering the volume of the bg music though? I tried to listen during my commute but it was really hard 😅
@iqjayfeng 17 күн бұрын
Thanks for the suggestion, will do!
@yadavadvait 26 күн бұрын
amazing structure to the solution!
@iqjayfeng 23 күн бұрын
Thanks! We're glad it helped!
@kaustubhursekar9914 28 күн бұрын
I have not experienced an interview which is that specific in clarification from interviewer when asked questions. In my case, every time I asked interviewer in ACTUAL interviewer, she responded with "you can think of how you would like to go ahead. whatever.". The real world interview is very very vague and open ended, it is like you have to come up with truly convincing assumptions and build on that towards the end to give reasonable solutions.
@iqjayfeng 29 күн бұрын
Want to ace your data science interview? 🚀 85% of successful candidates practice with real interview questions. Explore the ones companies actually ask: www.interviewquery.com/questions?
@unknownpleasure858 Ай бұрын
한국에서 보고있습니다. 좋은 정보 감사드려요. Thanks❤
@hopeful-pessimist-7 Ай бұрын
Same can be said about the opposite case
@bluesky_10 Ай бұрын
Check your slack bro. Manager is looking for you 😂
@osamaelgendy7807 Ай бұрын
great approach actually
@iqjayfeng Ай бұрын
Thanks! We're glad you liked it!
@farisayidakwa7024 Ай бұрын
This is very helpful information, l am preparing for a technical interview next weekend, and this helped me be mindful of how I frame and answer questions, but around 15:00 into your video you begin to go way too fast, and because your mic is not tuned it was hard to hear what you were saying because it looked you were rambling and scrambling, but overall this really helped.. thanks
@iqjayfeng Ай бұрын
Best of luck! I hope I was able to improve my audio quality in my recent videos should you have seen them!
@Kuma117 Ай бұрын
The most useful video I have seen on SQL problem solving so far.
@iqjayfeng Ай бұрын
I'm glad it was helpful!
@andreipopescu1 Ай бұрын
bad camera constant panning
@nilakshirekhawar2861 Ай бұрын
what will be the online metric in this case ? reduction in reported or flagged items?also awesome explanation !!
@iqjayfeng Ай бұрын
Want to ace your data science interview? 🚀 85% of successful candidates practice with real interview questions. Explore the ones companies actually ask: www.interviewquery.com/questions?
@apamwamba Ай бұрын
CTE and WINDOW FUNCTIONS are a MUST
@vijayjayaraman5990 Ай бұрын
Good video, but he doesn't clearly explain why the lead analyst thinks that the lower engagement is due to the PYMN feature. Understanding that will help determine the right metrics for the A/B test.
@iqjayfeng Ай бұрын
That's a great point! It's important to understand the rationale before any plans or decisions!
@tanmaykumar3250 Ай бұрын
how one can practice these case interviews alone ? can I find some partner !
@iqjayfeng Ай бұрын
Hey! You might want to check out or mock interview sessions where you can practice with our very experienced coaches: www.interviewquery.com/mock-interviews
@sachinvarma5197 Ай бұрын
I want to become a ML Engineer too. How can I connect with you?
@iqjayfeng Ай бұрын
Try one of Interview Query's coaches: www.interviewquery.com/coaching
@seed157 Ай бұрын
I enjoyed the video, thanks for the effort, mate!
@DarkRaviForDeath Ай бұрын
any tips on interview prep if you're mostly focusing on getting an ML job at a startup?
@iqjayfeng Ай бұрын
Learn as much as you can about the startup and the industry they're in and how they apply ML
@iqjayfeng Ай бұрын
Want to ace your data science interview? 🚀 85% of successful candidates practice with real interview questions. Explore the ones companies actually ask: www.interviewquery.com/questions?
@Nuevavida0409 Ай бұрын
I still don’t understand actually now I’m more lost than before. How can you do math with letters I never felt so suppressed and surprised at the same time but thanks for the explanation
@shuangma2244 Ай бұрын
super cool contents. Checking on the website.
@hennadubey7392 Ай бұрын
Since the hypothesis states that PYMK feature reduces engagement for people with more friends, would this experiment be designed only to run for that segment? Also, how do we define people with 'more friends'. Is there a threshold?
@iqjayfeng Ай бұрын
Want to ace your data science interview? 🚀 85% of successful candidates practice with real interview questions. Explore the ones companies actually ask: www.interviewquery.com/questions?
@mahshidghasemi7933 Ай бұрын
Hey Jay, Thank you for all the helpful info you provided. I really enjoyed how you categorized different sections.
@iqjayfeng Ай бұрын
Glad it was helpful!
@GraceL0302 Ай бұрын
Really good video! Had a couple of data engineer interviews and they cover exactly what you described there
@iqjayfeng Ай бұрын
Glad it was helpful!
@CrossCulture-e5i Ай бұрын
Lot of solutions thrown out there, could've narrowed it down better
@nitinagarwal3574 Ай бұрын
This video is about data engineer IC and not data engineer manager, misleading title
@wanwoochang Ай бұрын
Nowhere in the title does it say this is for the Meta DE manager interview.
@godwintemperance7428 Ай бұрын
@iqjayfeng Thanks for this content. I want to transition to product analysis, can i have a guided learning plan? I am already a data analyst
@iqjayfeng Ай бұрын
Hey! You can checkout our coaching services here where we match you with seasoned professionals for personalized coaching: www.interviewquery.com/coaching
@some_dude1596 Ай бұрын
Where and how does voter suppression happen in the United States? I really don’t see it.
@edzebrowski3929 Ай бұрын
It happens when legal votes are offset by votes cast illegally. Non-citizens, phantom voters, etc. when Philadelphia shuts down counting, blocks observation windows and miraculously a 700,000 vote lead gets wiped out then you have voter suppression.
@sreechalasani9268 Ай бұрын
Every sentence ends in “right?” - right ?
@krishnanuvvala Ай бұрын
What kind of questions are asked in product sense round? Can you explain about product sense round? Is it behavioral round or different one?
@iqjayfeng Ай бұрын
Product sense rounds typically assess your ability to think strategically about products. They're distinct from behavioral rounds, focusing on product design, user needs, and metrics. You can check them out on Interview Query
@pratik903 Ай бұрын
So many things to learn from this video, such a nice explanation of concepts. Looking forward for more such videos. Thank you Eshan and team 👍
@iqjayfeng Ай бұрын
Most welcome!
@AndyHuynh-q7i Ай бұрын
Bruh this guy almost put me to sleep with his voice. Had to re-watch the beginning explanation of the question three times.
@iqjayfeng Ай бұрын
Want to ace your data science interview? 🚀 85% of successful candidates practice with real interview questions. Explore the ones companies actually ask: www.interviewquery.com/questions?