"Analytics as a career route was to problem solve and think out of the box , where I would be able to inculcate a data-driven thinking to finding solutions.
Establishing a foundation and end to end analytical methodologies for giving recommendations for actionable outcomes useful for internal and external teams relying on these observations.
Learning the procedure of how to source unstructured data and clean, impute, introduce variables to build impactful inferences."
Aishwarya J. - "Analytics as a career route was to problem solve and think out of the box , where I would be able to inculcate a data-driven thinking to finding solutions.
Establishing a foundation and end to end analytical methodologies for giving recommendations for actionable outcomes useful for internal and external teams relying on these observations.
Learning the procedure of how to source unstructured data and clean, impute, introduce variables to build impactful inferences."See full answer
"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
"Design an alarm clock for blind people
Clarifying question:
Does it have to be a physical product or software? Your call
Do I need to think about the long-term implications of the product from a strategy perspective or a single product? single product
What are the metrics this company will focus on? Engagement
What industry are we in? (start-up, google/Amazon, etc) - Startup
What do we mean by blind? - ppl who cannot see anything, or people who still have sense of"
Manu G. - "Design an alarm clock for blind people
Clarifying question:
Does it have to be a physical product or software? Your call
Do I need to think about the long-term implications of the product from a strategy perspective or a single product? single product
What are the metrics this company will focus on? Engagement
What industry are we in? (start-up, google/Amazon, etc) - Startup
What do we mean by blind? - ppl who cannot see anything, or people who still have sense of"See full answer
"Since there is a need for the data to be accurate and consistent without any latency to allocate a spot, can't the data be synchronously synced to replicas after every write as the number of writes are not many per min, instead of read lock phenomena
Let me know if i am on a wrong thought here."
Chitapuram N. - "Since there is a need for the data to be accurate and consistent without any latency to allocate a spot, can't the data be synchronously synced to replicas after every write as the number of writes are not many per min, instead of read lock phenomena
Let me know if i am on a wrong thought here."See full answer
Engineering Manager
System Design
+2 more
🧠Want an expert answer to a question? Saving questions lets us know what content to make next.
"I have 2 product feedbacks. I think it has been mentioned by many users of the platform.
Provide a text summary of the videos so that we do not have to watch through the whole interview practice
Actually comment if the interview was good or not, currently we do not really know if the answer given is of high quality
"
Kai H. - "I have 2 product feedbacks. I think it has been mentioned by many users of the platform.
Provide a text summary of the videos so that we do not have to watch through the whole interview practice
Actually comment if the interview was good or not, currently we do not really know if the answer given is of high quality
"See full answer
" logo
Contact
Interview Preparation
Application Process
Career Advancement
Onboarding and Orientation
Common Interview Questions
Dashboard Creation Interview Questions and Answers
Dashboard Creation Interview Questions and Answers
What is a dashboard?
Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"
Ankit kumar S. - " logo
Contact
Interview Preparation
Application Process
Career Advancement
Onboarding and Orientation
Common Interview Questions
Dashboard Creation Interview Questions and Answers
Dashboard Creation Interview Questions and Answers
What is a dashboard?
Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"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
"To analyze a year-over-year (YoY) slowdown in transactions, you should start by understanding the context, segmenting data, identifying potential drivers, and then formulating actionable recommendations. This involves a structured approach that includes a thorough examination of the data, both internally and externally.
Understand the Context:
Define "transactions":
What specific transactions are being analyzed (e.g., website purchases, in-store purchases, total transactions)?
Timeframe:
Sp"
Ankit kumar S. - "To analyze a year-over-year (YoY) slowdown in transactions, you should start by understanding the context, segmenting data, identifying potential drivers, and then formulating actionable recommendations. This involves a structured approach that includes a thorough examination of the data, both internally and externally.
Understand the Context:
Define "transactions":
What specific transactions are being analyzed (e.g., website purchases, in-store purchases, total transactions)?
Timeframe:
Sp"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
"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
"-- Write your query here
select
id,
(case
when p_id is null then 'Root'
when pid in (select id from treenode_table)
and id in (select pid from treenode_table) then 'Inner'
else 'Leaf' end) as node_types
from treenodetable
order by 1;
`"
Anonymous Roadrunner - "-- Write your query here
select
id,
(case
when p_id is null then 'Root'
when pid in (select id from treenode_table)
and id in (select pid from treenode_table) then 'Inner'
else 'Leaf' end) as node_types
from treenodetable
order by 1;
`"See full answer
"The addition of an intermediate "sanitization" ML is something Neeraj used in the Uber Eats design and again seems kind of outside the scope here and redundant. This can simply be built into the AI response model to save a step. It's not clear what benefit this step provides, and he basically said we should have it "just because it would be good" and there's no concrete reasoning why to include it.
Adding a Kafka queue to handle the thumbs-down ratings? For what purpose do you need a queue othe"
Robert H. - "The addition of an intermediate "sanitization" ML is something Neeraj used in the Uber Eats design and again seems kind of outside the scope here and redundant. This can simply be built into the AI response model to save a step. It's not clear what benefit this step provides, and he basically said we should have it "just because it would be good" and there's no concrete reasoning why to include it.
Adding a Kafka queue to handle the thumbs-down ratings? For what purpose do you need a queue othe"See full answer
"Good Discussion on the distributed messaging queues (Complex topic with lot of nuances)
Liked the mind-map style drawing of requirements and metrics capture
Touched on different types of queue styles (point to point, pub-sub, fan-out/fan-in)
Storage and WAL usage was interesting
Some distributed queue challenges that could be helpful to highlight / expand are:
Message guarantee / semantics - Ordering of messages across different servers
Replication
Master slave architecture or Pe"
Karthik R. - "Good Discussion on the distributed messaging queues (Complex topic with lot of nuances)
Liked the mind-map style drawing of requirements and metrics capture
Touched on different types of queue styles (point to point, pub-sub, fan-out/fan-in)
Storage and WAL usage was interesting
Some distributed queue challenges that could be helpful to highlight / expand are:
Message guarantee / semantics - Ordering of messages across different servers
Replication
Master slave architecture or Pe"See full answer
"First I'd like to clarify the definition of reactions and confirm that it's same as what exists today.
Definition: Reactions provides users the ability to provide richer expression beyond 'like'
Business goal: Since this is a mature product, the business goal is to improve user engagement
Product goal: Bring people closer together by letting people provide more accurate sentiment to the community based on the content
Personas: 1. Content creator 2. user using reactions
**Li"
P R. - "First I'd like to clarify the definition of reactions and confirm that it's same as what exists today.
Definition: Reactions provides users the ability to provide richer expression beyond 'like'
Business goal: Since this is a mature product, the business goal is to improve user engagement
Product goal: Bring people closer together by letting people provide more accurate sentiment to the community based on the content
Personas: 1. Content creator 2. user using reactions
**Li"See full answer
"Notes from the Video.
1-1s are two way feedback. Important tool to discuss things that are not possible in group setting
feedback to employee by manager
feedback to manager by employee
Feedback to employee can vary by the type of performer the employee is
(a) high performer
(b) meets expectations
(c) under performing
Dos and Don't
Avoid project discussion as they can be obtained else where. Focus on feedback to employee. Unless there is a critical project item to be d"
Adib M. - "Notes from the Video.
1-1s are two way feedback. Important tool to discuss things that are not possible in group setting
feedback to employee by manager
feedback to manager by employee
Feedback to employee can vary by the type of performer the employee is
(a) high performer
(b) meets expectations
(c) under performing
Dos and Don't
Avoid project discussion as they can be obtained else where. Focus on feedback to employee. Unless there is a critical project item to be d"See full answer