Interview Questions

Steve M. - "def split_count(s): return 2**(len(s)-1) `"See full answer

Maliki U. - "Here is my implementation: select marketing_channel, AVG(purchasevalue) as avgpurchase_value from attribution group by marketing_channel order by avgpurchasevalue DESC ; There is no need to copy and past the line of code for calculating the average into order by, just Alias is enough because going by the order of execution in sql, Always, order by is executed after executing select clause."See full answer

Megha V. - "Assumptions, company, industry, external, customers, problems, solutions, metrics Company is microsoft, its vision is to help people and organization to achieve their full potential by increasing productivity . Task management - there are many products like notes, google task etc which exist but no one is market leader. A user had a list of tasks which she wants to complete by Y deadline and their is prirotization among these and could be categorized Task - start day, end day, estimated time to"See full answer

Abhi - "Thank you for the question - before I can begin, I would like to understand the question further. A. Clarification: I am the PM for overall Insta reels or any specific platform > Reels I am assuming we are evaluating the performance of the reels globally > Yes I will also assume that we are defining the current metrics / performance of reels and not specific to a new roll out. > yes B. Funnel - understanding the product To make sure I understand the product correctly, Re"See full answer

Michelle D. - "I'd first start with confirming my understanding with the interviewer of Spotify's key metric overall. For this exercise, my working assumption of Spotify's north star is time spent listening (TSL, for short), which can be measured daily, weekly, and monthly. As the PM for Discover Weekly, I want to improve Discover Weekly such that I positively impact TSL. As such, my goal is to increase minutes spent listening to Discover Weekly playlists. The primary metric I will want to track is minutes s"See full answer

Mitchell K. - "How technical and specific do you have to go when describing your past projects?"See full answer

Dev S. - "Clarfying questions : When we say a decrease in users adding the bank accounts. I would like to understand how the users making payments within Venmo I assume they are either using their credit cards/debit cards? I would like to understand why the Adding of Bank Accounts is integral to Venmo since the users are using the debit card and Credit Cards. My understanding is when the payments happen through debit cards rails Venmo pays higher interchange fees and to Reduces any losses incurred"See full answer

Anonymous Caribou - "Sales and Delivery app: Ask Clarifying questions: What all parts of the user journey does this app play a role in? All delivery notifications go through this app. Tesla while completing sales does ask its customer to download this app. Sales can be completely done through the app. Sales person at Tesla could be reached through app. App can be used to buy other peripherals for Tesla. Success Metrics: Revenue: \# of car sales completed through the delivery app. \# of peripheral"See full answer

Aimable - "."See full answer

Ilnur I. - "I can try to summarize their discussion as I remembered. Linear regression is one of the method to predict target (Y) using features (X). Formula for linear regression is a linear function of features. The aim is to choose coefficients (Teta) of the prediction function in such a way that the difference between target and prediction is least in average. This difference between target and prediction is called loss function. The form of this loss function could be dependent from the particular real"See full answer

Nithesh S. - "First, let us start with the mission of Amazon: “We strive to offer our customers the lowest possible prices, the best available selection, and the utmost convenience.” Alignment of recommendations system with Amazon's mission: Suggesting recommendations to the users would be a part of this mission as it would allow users to buy things on their mind for the lowest cost in market (may or may not be true). They might get better prices if they order adjacent items together. For example, i"See full answer

Alina G. - "SELECT upsellcampaignid, COUNT(DISTINCT trans.userid) AS eligibleusers FROM campaign JOIN "transaction" AS trans ON transactiondate BETWEEN datestart AND date_end JOIN user ON trans.userid = user.userid WHERE iseligibleforupsellcampaign = 1 GROUP BY upsellcampaignid `"See full answer

Anonymous Condor - "Yes, I need to compare the first half of the first string with the reverse order of the second half of the second string. Repeat this process to the first half of the second string and the second half of the first string."See full answer

Sumeet R. - "Got a very different answer than everybody. I seem to be off here. But here goes ..will appreciate feedback Clarifying ..all human population in US and not just working population? Yes US Population: ~300Mn Segmenting Population. 0-19 - 75M 20-40- 75M 41-60 - 75M 60-80- 75M 80-100 - 5 Mn Removing 80 segment as stay at home and not eligible for commuting Revised Table 2-19 - 75M 20-40- 75M 41-60 - 75M 60-80- 75M Out of this employable audience that is has"See full answer