"Since you have indicated that the drop has been from the past few days and it is the sales drop.
Assumption 1: It is not a gradual decrease and something that has been seen in the last few days. My assumption is the e-commerce site is a google store site where google sells all the products.
At a very High-level the decline in sales
could be caused by customers buying less on the site, customer churn, or decline in new customers, higher cart abandonment rate, checkout process.
I would struc"
Dev S. - "Since you have indicated that the drop has been from the past few days and it is the sales drop.
Assumption 1: It is not a gradual decrease and something that has been seen in the last few days. My assumption is the e-commerce site is a google store site where google sells all the products.
At a very High-level the decline in sales
could be caused by customers buying less on the site, customer churn, or decline in new customers, higher cart abandonment rate, checkout process.
I would struc"See full answer
"Clarification:
Lender Focus: We'll cater to mortgage lenders, specifically smaller institutions or those specializing in a particular loan type (e.g., first-time homebuyer loans).
1. User Personas and Pain Points:
Create two user personas:
Persona 1: A loan officer at a small credit union overwhelmed with manual paperwork and slow communication with borrowers.
Persona 2: A loan manager at a company specializing in FHA loans, struggling with cumbersome pre-qualification"
Deepak V. - "Clarification:
Lender Focus: We'll cater to mortgage lenders, specifically smaller institutions or those specializing in a particular loan type (e.g., first-time homebuyer loans).
1. User Personas and Pain Points:
Create two user personas:
Persona 1: A loan officer at a small credit union overwhelmed with manual paperwork and slow communication with borrowers.
Persona 2: A loan manager at a company specializing in FHA loans, struggling with cumbersome pre-qualification"See full answer
"Inventory Service and Registration service can they be in SYNC always ?? The "experience layer" needs accessed by Hotel owners also ??? How does real time inventory come from all Hotels ???"
Anup S. - "Inventory Service and Registration service can they be in SYNC always ?? The "experience layer" needs accessed by Hotel owners also ??? How does real time inventory come from all Hotels ???"See full answer
System Design
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"!! FEEDBACK WELCOME !!
Clarify question
By art we mean visual art, e.g. paintings? - Yes
Is this a solution to create art on Instagram or to showcase existing art on Instagram? - Create art
Why build this, Engagement or Acquisition? - Engagement
Reframe: We want to increase Instagram engagement through creation and sharing of art with followers.
Talking about the space
The Internet has over time continuously reduced barriers to creative expression. From blogging to Twitter"
Apurv K. - "!! FEEDBACK WELCOME !!
Clarify question
By art we mean visual art, e.g. paintings? - Yes
Is this a solution to create art on Instagram or to showcase existing art on Instagram? - Create art
Why build this, Engagement or Acquisition? - Engagement
Reframe: We want to increase Instagram engagement through creation and sharing of art with followers.
Talking about the space
The Internet has over time continuously reduced barriers to creative expression. From blogging to Twitter"See full answer
"1 - Oder list of Kid Position and Sellers Positions (ascending)
2 - Implement a method to check distant 'e' for every kid pos (finding nearest seller and checking if sellerpos - currkid_pos < e, for all kid pos)
3 - Calculate mid from 0 to the 'max post' in between both kids and seller list: (max(max(k) -min(k), max(s) - min(s)))
4 - Perform binary search to find distance 'e' that satisfy step '2'"
Alejandro C. - "1 - Oder list of Kid Position and Sellers Positions (ascending)
2 - Implement a method to check distant 'e' for every kid pos (finding nearest seller and checking if sellerpos - currkid_pos < e, for all kid pos)
3 - Calculate mid from 0 to the 'max post' in between both kids and seller list: (max(max(k) -min(k), max(s) - min(s)))
4 - Perform binary search to find distance 'e' that satisfy step '2'"See full answer
"Prompt:
Define success of reels
How do I investigate if reels engagement is up by x, posts are down by y
Clarification:
What is reels: video experience on explore page, play page. Can have comments, likes etc.
Why was it launched: to promote engagement on the app, 'addictive sessions back to back.
Product goal: Increase in app time, drive stickiness.
Big picture: Instagram launched reels post tiktok style success, way to saving market share
Define success"
Geet B. - "Prompt:
Define success of reels
How do I investigate if reels engagement is up by x, posts are down by y
Clarification:
What is reels: video experience on explore page, play page. Can have comments, likes etc.
Why was it launched: to promote engagement on the app, 'addictive sessions back to back.
Product goal: Increase in app time, drive stickiness.
Big picture: Instagram launched reels post tiktok style success, way to saving market share
Define success"See full answer
"Would consider the following factors:
Customer demographic and preferences
Location of the warehouse and what's the local product trends
Seasonality and time of the year for trendy products
Balance of volume and margin products
Supply chain consideration
Competition analysis
Inventory turn over rate
eCommerce aspects of the inventory
Plus the following types:
Essential and groceries
Electronic and entertainment
Apparel and footwear
Home and lifestyle
Seasonal and promo"
onering2ruleall - "Would consider the following factors:
Customer demographic and preferences
Location of the warehouse and what's the local product trends
Seasonality and time of the year for trendy products
Balance of volume and margin products
Supply chain consideration
Competition analysis
Inventory turn over rate
eCommerce aspects of the inventory
Plus the following types:
Essential and groceries
Electronic and entertainment
Apparel and footwear
Home and lifestyle
Seasonal and promo"See full answer
"Being a marketplace, there are two users that Uber wants to satisfy: the rider and the driver. I think the ultimate success metric is related to how well riders and drivers get matched.
The ultimate goal for the rider is to get to their destination as efficiently as possible.
Some concerns for the rider may be
Matching with drivers
Minimizing waiting time waiting to be matched and waiting for the driver to arrive
Ease of pick-up and drop-off (ie. Driver coming from the opposite side of t"
Elisa L. - "Being a marketplace, there are two users that Uber wants to satisfy: the rider and the driver. I think the ultimate success metric is related to how well riders and drivers get matched.
The ultimate goal for the rider is to get to their destination as efficiently as possible.
Some concerns for the rider may be
Matching with drivers
Minimizing waiting time waiting to be matched and waiting for the driver to arrive
Ease of pick-up and drop-off (ie. Driver coming from the opposite side of t"See full answer
"Before diving into answering this, I would like to ask some clarifying questions -
High Level - What is the mission, goal, target for this year for WhatsApp?
Assumption answer - 10X growth in users
Do we have any road map where we can see it with more details?
Yes we wish, it is kind of all over the place
Do you know how far we have come from the start of the year to achieve that target?
Yeah we have done some progress but not much
Which quarter are we in?
1"
Umang S. - "Before diving into answering this, I would like to ask some clarifying questions -
High Level - What is the mission, goal, target for this year for WhatsApp?
Assumption answer - 10X growth in users
Do we have any road map where we can see it with more details?
Yes we wish, it is kind of all over the place
Do you know how far we have come from the start of the year to achieve that target?
Yeah we have done some progress but not much
Which quarter are we in?
1"See full answer
"Applying the STAR method to explain a time when I had to teach myself certain skills to meet project demands.
Situation : I was working for a medical devices company that didn't have CI-CD setup for its embedded software
Task : Build the entire CI-CD pipeline from scratch using the tools available within a month
Action : I had to learn Docker and other basic DevOps technologies to build this
Result : We were able to reduce build time by 70% and create a process for package manage"
Soutrik M. - "Applying the STAR method to explain a time when I had to teach myself certain skills to meet project demands.
Situation : I was working for a medical devices company that didn't have CI-CD setup for its embedded software
Task : Build the entire CI-CD pipeline from scratch using the tools available within a month
Action : I had to learn Docker and other basic DevOps technologies to build this
Result : We were able to reduce build time by 70% and create a process for package manage"See full answer
"The Doordash post-order experience is the part of the service that happens after the user has placed an order and is waiting for the delivery. This experience can be improved by providing more information, communication, and convenience to the user. Here are some possible ways to do this:
Provide real-time tracking and updates: Users want to know the status and location of their order, as well as the estimated time of arrival. By providing real-time tracking and updates, users can feel mor"
Anonymous Dove - "The Doordash post-order experience is the part of the service that happens after the user has placed an order and is waiting for the delivery. This experience can be improved by providing more information, communication, and convenience to the user. Here are some possible ways to do this:
Provide real-time tracking and updates: Users want to know the status and location of their order, as well as the estimated time of arrival. By providing real-time tracking and updates, users can feel mor"See full answer
"How do you find consecutive days for login (MySQL, SQL, date, subquery, MySQL 5.7, development)?
1
Follow
Request
Answer
More
All related (34)
Recommended
📷
Trausti Thor Johannsson
·
Follow
Been using MySQL for more than 16 yearsDec 27
There are functions like DATEDIFF but there are also BETWE"
Hayatu H. - "How do you find consecutive days for login (MySQL, SQL, date, subquery, MySQL 5.7, development)?
1
Follow
Request
Answer
More
All related (34)
Recommended
📷
Trausti Thor Johannsson
·
Follow
Been using MySQL for more than 16 yearsDec 27
There are functions like DATEDIFF but there are also BETWE"See full answer
"Form what I know I would state the following two points:
Only 20% of google's $180B revenue comes from non-ad revenue sources. Google Cloud is a big part of Google's revenue diversification efforts. Google cloud at $13B is still under 10% of total revenue.
Google cloud is at position 3 compared after Amazon AWS and Microsoft Azure. Typically only top 2 platforms take majority of stake in a lot of businesses.
Google Cloud's Goal: Become one of the top two Cloud platforms in the world by deep"
Venkateswara reddy K. - "Form what I know I would state the following two points:
Only 20% of google's $180B revenue comes from non-ad revenue sources. Google Cloud is a big part of Google's revenue diversification efforts. Google cloud at $13B is still under 10% of total revenue.
Google cloud is at position 3 compared after Amazon AWS and Microsoft Azure. Typically only top 2 platforms take majority of stake in a lot of businesses.
Google Cloud's Goal: Become one of the top two Cloud platforms in the world by deep"See full answer
"For a mature product, I would do the following -
Review the list of backlog items
Meet with stakeholders and business owners to verify the relevance (are they still valid? esp. for new feature request)
Break down the backlog list by a. Product improvements b. New features c. Operational Resiliency
Do a 70-30 split with New features+Product Imp =70%, Resiliency =30%
Prioritize by impact/scale and effort (team's capacity) by quarter
Revisit Quarterly
For a new product -
Start"
Amishr - "For a mature product, I would do the following -
Review the list of backlog items
Meet with stakeholders and business owners to verify the relevance (are they still valid? esp. for new feature request)
Break down the backlog list by a. Product improvements b. New features c. Operational Resiliency
Do a 70-30 split with New features+Product Imp =70%, Resiliency =30%
Prioritize by impact/scale and effort (team's capacity) by quarter
Revisit Quarterly
For a new product -
Start"See full answer
"I would start off by talking about the goals of this feature.
What's the goal of Instagram with blue check marks? What does it aim to achieve? For the purpose of this question, I am assuming that Instagram wants to verify celebrities/famous people/brands as the original profile that differentiates them from fake profiles or other fan groups. It's also to develop trust and credibility amongst Instagram users.
The mission of Facebook is to connect people across the globe. Instagram, which is a p"
Anonymous Shrimp - "I would start off by talking about the goals of this feature.
What's the goal of Instagram with blue check marks? What does it aim to achieve? For the purpose of this question, I am assuming that Instagram wants to verify celebrities/famous people/brands as the original profile that differentiates them from fake profiles or other fan groups. It's also to develop trust and credibility amongst Instagram users.
The mission of Facebook is to connect people across the globe. Instagram, which is a p"See full answer
"I will interpret the question as "focus on the next 5 years". I will also give a high-level helicopter view since I’m supposed to imagine I’m CEO of Shopify.
The mission of Shopify has always been to enable merchants and lessen the frictions in conducting commerce. Shopify is not an eCommerce company like Amazon, but a Tools and Infrastructure company like Stripe. Building tools and services for merchants are our core competencies.
When we think about the main problems that Merchants have"
Shen A. - "I will interpret the question as "focus on the next 5 years". I will also give a high-level helicopter view since I’m supposed to imagine I’m CEO of Shopify.
The mission of Shopify has always been to enable merchants and lessen the frictions in conducting commerce. Shopify is not an eCommerce company like Amazon, but a Tools and Infrastructure company like Stripe. Building tools and services for merchants are our core competencies.
When we think about the main problems that Merchants have"See full answer