"Evaluate how much the issue affects the sprint goal and timeline. If it blocks the main goal, it needs to be prioritized.
Discuss the issue with the team.
Analyze the root cause of the issue. Is it because of unclear requirements or a design flaw? You may need to re-prioritize tasks.
If the issue is serious enough to delay or change the sprint goal, communicate the updates to stakeholders and manage their expectations.
Keep an eye on the solution’s progress and adjust your plans a"
Hamzeh J. - "Evaluate how much the issue affects the sprint goal and timeline. If it blocks the main goal, it needs to be prioritized.
Discuss the issue with the team.
Analyze the root cause of the issue. Is it because of unclear requirements or a design flaw? You may need to re-prioritize tasks.
If the issue is serious enough to delay or change the sprint goal, communicate the updates to stakeholders and manage their expectations.
Keep an eye on the solution’s progress and adjust your plans a"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.
"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
"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
"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
"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
"Context - I joined a large public-facing service as a PM midway through its development.
Situation - Due to the SOPs of the company the team already had a metrics framework. That included your standard DAUs, Retention and Acquisition Metrics
Concern -
As SOP metrics were publicly accepted, the team did not internalise what success actually means to the product they are developing, as the actual value was not being encapsulated in the framework
This was evident in the show and tells as the"
Umang S. - "Context - I joined a large public-facing service as a PM midway through its development.
Situation - Due to the SOPs of the company the team already had a metrics framework. That included your standard DAUs, Retention and Acquisition Metrics
Concern -
As SOP metrics were publicly accepted, the team did not internalise what success actually means to the product they are developing, as the actual value was not being encapsulated in the framework
This was evident in the show and tells as the"See full answer
"The interviewer hinted that a two-tower recommender system might be a suitable approach, using user history to embed users and pages separately and train on view or interaction data.
Instead, I proposed a different approach that I felt was more aligned with how knowledge is structured in Confluence:
I designed a system using a graph database to model the relationships between Confluence pages. Each page is a node, and edges represent content-based references. For example, when one article"
Clayton P. - "The interviewer hinted that a two-tower recommender system might be a suitable approach, using user history to embed users and pages separately and train on view or interaction data.
Instead, I proposed a different approach that I felt was more aligned with how knowledge is structured in Confluence:
I designed a system using a graph database to model the relationships between Confluence pages. Each page is a node, and edges represent content-based references. For example, when one article"See full answer
"Overall, a successful Netflix viewing session requires that the user was able to find a piece of content that they loved watching. Now, to break this down, how we might define this:
-Time browsing (from app open to content played)
-Satisfaction
--> inferred satisfaction: did user complete watching the piece of content?
--> explicit: did the user rank that they loved the content (2 thumbs up)?
The way I would evaluate a new Top Picks ML feature would be to implement an A/B test as follows:
Te"
Henry H. - "Overall, a successful Netflix viewing session requires that the user was able to find a piece of content that they loved watching. Now, to break this down, how we might define this:
-Time browsing (from app open to content played)
-Satisfaction
--> inferred satisfaction: did user complete watching the piece of content?
--> explicit: did the user rank that they loved the content (2 thumbs up)?
The way I would evaluate a new Top Picks ML feature would be to implement an A/B test as follows:
Te"See full answer
"Clarifying Questions:
Do we want to target a particular geography or location or should it be done globally? Assume global
Is there any particular platform and device we are targeting (App/web) or should it be cross platforms? Cross platforms
Can I think about it as Product led solutions or do you want to consider marketing alternatives as well? Let's start with Product led solutions & later if time permits, we can touch on the marketing side as well
Are there any constra"
Hashmina H. - "Clarifying Questions:
Do we want to target a particular geography or location or should it be done globally? Assume global
Is there any particular platform and device we are targeting (App/web) or should it be cross platforms? Cross platforms
Can I think about it as Product led solutions or do you want to consider marketing alternatives as well? Let's start with Product led solutions & later if time permits, we can touch on the marketing side as well
Are there any constra"See full answer
"Clarify:
I will assume that misinformation includes posts, videos and pictures and that sources could be Groups/ Pages and Individuals.
High level structure: Mission, Information funnel and drop-off points, Metrics & Trade-offs, Mitigations
Mission/ Strategy: Facebook's mission is to bring the world closer together and empower people to build community. Reliable information is key to fostering a healthy community. In light of recent world events and public sentiment, it is important f"
Ash J. - "Clarify:
I will assume that misinformation includes posts, videos and pictures and that sources could be Groups/ Pages and Individuals.
High level structure: Mission, Information funnel and drop-off points, Metrics & Trade-offs, Mitigations
Mission/ Strategy: Facebook's mission is to bring the world closer together and empower people to build community. Reliable information is key to fostering a healthy community. In light of recent world events and public sentiment, it is important f"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
"Design a product for gardeners.
Assumptions / Clarifying questions -> What ? -> Why ? TAM -> Mission for Meta -> Business Goal ->
User segmentation ( P) -> Painpoints (P) -> Solutions ( P -rice) ->NSM -> Risks -> Summarize
Assumptions :
New
Embedded ( **) onto a Blue app
Is there a timeline ( 1 Year )
Region ( Pilot small users group )
What : Practice of cultivating food , flowers , decorated plants in controlled environment backyard , greenhouse , front yard
etc
Why"
Rani Y. - "Design a product for gardeners.
Assumptions / Clarifying questions -> What ? -> Why ? TAM -> Mission for Meta -> Business Goal ->
User segmentation ( P) -> Painpoints (P) -> Solutions ( P -rice) ->NSM -> Risks -> Summarize
Assumptions :
New
Embedded ( **) onto a Blue app
Is there a timeline ( 1 Year )
Region ( Pilot small users group )
What : Practice of cultivating food , flowers , decorated plants in controlled environment backyard , greenhouse , front yard
etc
Why"See full answer
"I used the GAME method.
Started first with defining the product and setting the mission and goal for Zoom. Stated that the product grew in popularity in 2020-2021 for both business and personal use, but since lockdown ended, shifted to business use. Goal is to effortlessly and seamlessly connect people anywhere. Focused on the business use case and stated Zoom makes revenue through contracts signed with various enterprises. Due to maturity of the product and business focused, said it make"
Jeffrey F. - "I used the GAME method.
Started first with defining the product and setting the mission and goal for Zoom. Stated that the product grew in popularity in 2020-2021 for both business and personal use, but since lockdown ended, shifted to business use. Goal is to effortlessly and seamlessly connect people anywhere. Focused on the business use case and stated Zoom makes revenue through contracts signed with various enterprises. Due to maturity of the product and business focused, said it make"See full answer
"We'll consider cost-effectiveness, environmental impact, convenience, and scalability. Here are key metrics and trade-offs to consider:
Cost Metrics
Operational Costs: Compare the direct costs associated with operating each mode of transit, including vehicle maintenance, fuel or energy, and driver salaries.
Subsidization Level: Assess how much subsidy each option requires per ride or per passenger to remain free or low-cost to employees.
Cost Efficiency: Analyze the cost p"
Siddhant S. - "We'll consider cost-effectiveness, environmental impact, convenience, and scalability. Here are key metrics and trade-offs to consider:
Cost Metrics
Operational Costs: Compare the direct costs associated with operating each mode of transit, including vehicle maintenance, fuel or energy, and driver salaries.
Subsidization Level: Assess how much subsidy each option requires per ride or per passenger to remain free or low-cost to employees.
Cost Efficiency: Analyze the cost p"See full answer