"This is my first attempt at an estimation question, any feedback is appreciated.
I'd like to clarify if AirBNB's core services would include user reservations on its web/mobile platform on a per night basis. I'd also assume if we would to estimate the topline revenue (or gross merchandise sales) without factoring operational expenses and taxes. I'd also clarify if basing my estimation on revenue from its largest marketplace, US, is reasonable.
Population of US - 350 MM
Avg Household size - 2.5"
Saleel P. - "This is my first attempt at an estimation question, any feedback is appreciated.
I'd like to clarify if AirBNB's core services would include user reservations on its web/mobile platform on a per night basis. I'd also assume if we would to estimate the topline revenue (or gross merchandise sales) without factoring operational expenses and taxes. I'd also clarify if basing my estimation on revenue from its largest marketplace, US, is reasonable.
Population of US - 350 MM
Avg Household size - 2.5"See full answer
"It was like say we have a library A which has a library B as a dependency and so on, how would we determine in the dependency chain that whether there is a circular depedency?"
Chris R. - "It was like say we have a library A which has a library B as a dependency and so on, how would we determine in the dependency chain that whether there is a circular depedency?"See full answer
"Facebook’s mission statement is to build community, so any product related to movies that Facebook builds should have that in mind.
I’ll start by looking at the lifecycle of a movie and then some current pain points that people might have to think about opportunities for a movies product.
The lifecycle of a movie revolves around creation (script, filming, casting, acting), production, and distribution (streaming services vs theatres).
An idea for creation could be helping users collaborate or"
Elisa L. - "Facebook’s mission statement is to build community, so any product related to movies that Facebook builds should have that in mind.
I’ll start by looking at the lifecycle of a movie and then some current pain points that people might have to think about opportunities for a movies product.
The lifecycle of a movie revolves around creation (script, filming, casting, acting), production, and distribution (streaming services vs theatres).
An idea for creation could be helping users collaborate or"See full answer
"Assumptions:
We're looking only at a single large dealership in San Jose, per the question, not all large car dealerships
New cars already come with tires; the dealer does not have to purchase them separately
A couple of different ways I might approach this:
Approach 1: Estimate based on # cars serviced per day
Dealer intakes 10 cars for servicing per hour (based on anecdotal observation)
100 cars serviced per day (assuming service dept. open 10 hours per day)
Cars that need onl"
Andrew B. - "Assumptions:
We're looking only at a single large dealership in San Jose, per the question, not all large car dealerships
New cars already come with tires; the dealer does not have to purchase them separately
A couple of different ways I might approach this:
Approach 1: Estimate based on # cars serviced per day
Dealer intakes 10 cars for servicing per hour (based on anecdotal observation)
100 cars serviced per day (assuming service dept. open 10 hours per day)
Cars that need onl"See full answer
"SELECT
s.Sale_Date,
SUM(si.Quantity * si.SalePrice) AS TotalRevenue
FROM Sales s
JOIN SaleItems si ON s.SaleID = si.Sale_ID
GROUP BY s.Sale_Date
ORDER BY s.Sale_Date;
"
Bala G. - "SELECT
s.Sale_Date,
SUM(si.Quantity * si.SalePrice) AS TotalRevenue
FROM Sales s
JOIN SaleItems si ON s.SaleID = si.Sale_ID
GROUP BY s.Sale_Date
ORDER BY s.Sale_Date;
"See full answer
Data Engineer
Coding
+1 more
🧠Want an expert answer to a question? Saving questions lets us know what content to make next.
"At RTI while working on content-based recommender system on our ecommerce site, we received request from one of our distributor clients to make the system not only suggest products based on their purchasing history but also exclusively push higher priced items, regardless of their actual needs or demand patterns, it was challenging situation because it contradicted the primary purpose of our system, which was value based, patient centric product recommendations.
To understand in this situation i"
Vihari K. - "At RTI while working on content-based recommender system on our ecommerce site, we received request from one of our distributor clients to make the system not only suggest products based on their purchasing history but also exclusively push higher priced items, regardless of their actual needs or demand patterns, it was challenging situation because it contradicted the primary purpose of our system, which was value based, patient centric product recommendations.
To understand in this situation i"See full answer
"Clarifying Questions
Is the product a digital or physical marketplace? (Digital)
Are we building an educational platform, freelance platform, or marketplace? (Freelance platform)
Are we focusing on a specific geographical location? (India)
Will the platform involve online transactions? (Yes)
User Personas
Individual Gardeners: Self-employed gardeners offering their services.
Gardening Agencies: Organizations providing gardening services.
**Educational Institutio"
Preetham m P. - "Clarifying Questions
Is the product a digital or physical marketplace? (Digital)
Are we building an educational platform, freelance platform, or marketplace? (Freelance platform)
Are we focusing on a specific geographical location? (India)
Will the platform involve online transactions? (Yes)
User Personas
Individual Gardeners: Self-employed gardeners offering their services.
Gardening Agencies: Organizations providing gardening services.
**Educational Institutio"See full answer
"Questions:
Should we consider US or Global?
Is there any existing market insights/research around driverless cars adoption?
Can we assume that driverless car technology is production / public ready by 2025?
Is this focus on commercial or consumer use?
Assumption:
Let's look at US to start for our estimation since Driverless car regulation and adoption trend will probably differ per country
Let's also assume we want to estimate market size for driverless cars in 2025 for consume"
Mark - "Questions:
Should we consider US or Global?
Is there any existing market insights/research around driverless cars adoption?
Can we assume that driverless car technology is production / public ready by 2025?
Is this focus on commercial or consumer use?
Assumption:
Let's look at US to start for our estimation since Driverless car regulation and adoption trend will probably differ per country
Let's also assume we want to estimate market size for driverless cars in 2025 for consume"See full answer
"In our product portfolio there were many teams and we were almost 12 product managers interacting closely to deliver the entire product feature area. Situation was that we were frequently had defects come in which will result in defects pushed back and forth. Goal was to avoid this as SLA of defects was getting impacted immensely there were priority 2 defects which we were sitting for couple of weeks before being looked at.
There was a need to establish a triaging process. Along with my leaders"
Karthik T. - "In our product portfolio there were many teams and we were almost 12 product managers interacting closely to deliver the entire product feature area. Situation was that we were frequently had defects come in which will result in defects pushed back and forth. Goal was to avoid this as SLA of defects was getting impacted immensely there were priority 2 defects which we were sitting for couple of weeks before being looked at.
There was a need to establish a triaging process. Along with my leaders"See full answer
"Clarifying questions:
How much is the decline?
Since when have sales been declining?
Make sure that it has correlation with competition and not a premature assumption that can come from something internal (not external competition).
Is it all the stores? What is the variation in the dicline?
If you have stores that have 20% less sales vs some that are steady, it might be something related to the store experience specifically.
How does the decrease in sales compare to cities that ha"
Natalia N. - "Clarifying questions:
How much is the decline?
Since when have sales been declining?
Make sure that it has correlation with competition and not a premature assumption that can come from something internal (not external competition).
Is it all the stores? What is the variation in the dicline?
If you have stores that have 20% less sales vs some that are steady, it might be something related to the store experience specifically.
How does the decrease in sales compare to cities that ha"See full answer
"Let's imagine you want to open Google Maps, you type maps.google.com and hit Enter. Here is what happens:
You type maps.google.com into the address bar of your browser.
Browser completes the address, for example, maps.google.com → https://www.maps.google.com
[Address decoding] → browser breaks down the URL into parts
‘https://’: protocol → how the browser should connect to the website
Default is HTTP (Hypertext Transfer Protocol) which shows up as ‘ http:/"
Jasmin R. - "Let's imagine you want to open Google Maps, you type maps.google.com and hit Enter. Here is what happens:
You type maps.google.com into the address bar of your browser.
Browser completes the address, for example, maps.google.com → https://www.maps.google.com
[Address decoding] → browser breaks down the URL into parts
‘https://’: protocol → how the browser should connect to the website
Default is HTTP (Hypertext Transfer Protocol) which shows up as ‘ http:/"See full answer
"Understanding the problem:
What do we mean by email notification experience here? Is it the quantity of notifications or quality?- it's the quality of the experience i.e. how can we make the experience better & more user centric
How would you define enhance in this context?- here enhacement means improving the engagement with the emails resulting in more people viewing the photo/s on FB with email as source
Are we supposed to enhance the viewer's experience only or the creators as w"
Debajyoti B. - "Understanding the problem:
What do we mean by email notification experience here? Is it the quantity of notifications or quality?- it's the quality of the experience i.e. how can we make the experience better & more user centric
How would you define enhance in this context?- here enhacement means improving the engagement with the emails resulting in more people viewing the photo/s on FB with email as source
Are we supposed to enhance the viewer's experience only or the creators as w"See full answer
"What is Meta Quest, Horizon world VR game? Horizons worlds is a platform that lets creators build worlds where real people can come and interact. This could be a gaming world, a socializing world, a marketplace, immersive experience, etc.
Why would people want to use Horizon worlds: Because it isn’t possible to always visit all places in person
I know that Meta has been encouraging creators at this time because the Horizon’s worlds needs a lot of worlds for it to be interesting for customers
Cus"
Sandhya P. - "What is Meta Quest, Horizon world VR game? Horizons worlds is a platform that lets creators build worlds where real people can come and interact. This could be a gaming world, a socializing world, a marketplace, immersive experience, etc.
Why would people want to use Horizon worlds: Because it isn’t possible to always visit all places in person
I know that Meta has been encouraging creators at this time because the Horizon’s worlds needs a lot of worlds for it to be interesting for customers
Cus"See full answer
"As a Product Manager for Instagram Reels, understanding Meta's investment in this product requires considering the broader competitive landscape, primarily TikTok, and Instagram's monetization strategy through ads. The focus on Reels is a strategic move to capture a share of the short-form video market, increase user engagement, and drive ad revenue.
Lets start with why Meta invested in Instagram reels
1. Competing with TikTok:
TikTok's explosive growth in the short-form video space pose"
R K. - "As a Product Manager for Instagram Reels, understanding Meta's investment in this product requires considering the broader competitive landscape, primarily TikTok, and Instagram's monetization strategy through ads. The focus on Reels is a strategic move to capture a share of the short-form video market, increase user engagement, and drive ad revenue.
Lets start with why Meta invested in Instagram reels
1. Competing with TikTok:
TikTok's explosive growth in the short-form video space pose"See full answer
"Awesome thanks for your question. Can I take a few seconds to write down some thoughts? - Sure
Okay I’m ready. So the way I’ll work through this problem is that first I’ll ask some clarifying questions, then I’ll dig into the why, starting with Facebook’s mission and competition and try to end up with a why for this product to exist. Then we will talk about users and will pick a user to focus on. We will then figure out which need to solve for the user given the product's why and the context we"
Jimmy K. - "Awesome thanks for your question. Can I take a few seconds to write down some thoughts? - Sure
Okay I’m ready. So the way I’ll work through this problem is that first I’ll ask some clarifying questions, then I’ll dig into the why, starting with Facebook’s mission and competition and try to end up with a why for this product to exist. Then we will talk about users and will pick a user to focus on. We will then figure out which need to solve for the user given the product's why and the context we"See full answer
"1. Understand the "Why" (Deep Dive) - Before jumping to solutions, as a PM needs to precisely understand why users are unhappy. NPS gives us a score, but not the reasons. (0 -4 weeks)
Analyze Feedback: Go beyond the score. What are Detractors (0-6) saying? What do Promoters (9-10) love?
Qualitative Research:(VOC- voice of the customer) Conduct user interviews, analyze support tickets, and observe product usage. Pinpoint specific pain points (e.g., slow p"
Vishnu G. - "1. Understand the "Why" (Deep Dive) - Before jumping to solutions, as a PM needs to precisely understand why users are unhappy. NPS gives us a score, but not the reasons. (0 -4 weeks)
Analyze Feedback: Go beyond the score. What are Detractors (0-6) saying? What do Promoters (9-10) love?
Qualitative Research:(VOC- voice of the customer) Conduct user interviews, analyze support tickets, and observe product usage. Pinpoint specific pain points (e.g., slow p"See full answer
"First, lets dive deeper into the question. I would ask -
What are the top challenges facedtoday?
What user segments work well, and what do we want to focus on?
What do we know about competitors, and what can we learn from them?
What user flows have the highest engagement in VR today?
Are we focusing on consumer use cases or enterprise?
Are we tackling activation or retention, or do we want to increase engagement?
To build a strategy here I would target this from four differe"
Anonymous Minnow - "First, lets dive deeper into the question. I would ask -
What are the top challenges facedtoday?
What user segments work well, and what do we want to focus on?
What do we know about competitors, and what can we learn from them?
What user flows have the highest engagement in VR today?
Are we focusing on consumer use cases or enterprise?
Are we tackling activation or retention, or do we want to increase engagement?
To build a strategy here I would target this from four differe"See full answer
"Context:
While working as a Senior Systems Engineer at Indra on a project for BBVA, I was primarily responsible for building ETLs and optimizing data pipelines using Spark and Scala.
Action:
During a critical deployment phase, our QA lead had to leave unexpectedly due to a personal emergency. With no one available to manage testing coordination, I volunteered to step in — even though it wasn’t my formal responsibility. I quickly reviewed the test cases, communicated with stakeholders, an"
Otto yhoda A. - "Context:
While working as a Senior Systems Engineer at Indra on a project for BBVA, I was primarily responsible for building ETLs and optimizing data pipelines using Spark and Scala.
Action:
During a critical deployment phase, our QA lead had to leave unexpectedly due to a personal emergency. With no one available to manage testing coordination, I volunteered to step in — even though it wasn’t my formal responsibility. I quickly reviewed the test cases, communicated with stakeholders, an"See full answer
"App I Don’t Like: Electrify America
What Electrify America Is Supposed to Do
Electrify America is an app designed to help electric vehicle (EV) owners locate, access, and pay for fast-charging stations across the U.S. The app provides real-time station availability, allows users to initiate and monitor charging sessions, and offers membership plans for discounted rates. Ideally, it should enable a seamless charging experience, especially for long-distance travelers relying on i"
fuzzyicecream14 - "App I Don’t Like: Electrify America
What Electrify America Is Supposed to Do
Electrify America is an app designed to help electric vehicle (EV) owners locate, access, and pay for fast-charging stations across the U.S. The app provides real-time station availability, allows users to initiate and monitor charging sessions, and offers membership plans for discounted rates. Ideally, it should enable a seamless charging experience, especially for long-distance travelers relying on i"See full answer