Analytical Interview Questions

Gk K. - " can we use blomfilters to check existing usernames? and if both are creating at a time, like both are choosing some abcd , here system checks whether user with that name exists or not. so while checking , it will add an entry on redis (example) with this name as key and obtain lock using some distributed lock. , it will lock on that name. (like seat booking in bookmyshow) with some TTL value. so this check will happen once user enters his interest username and also while submit .. 2 times che"See full answer

Rika S. - "Let's start by understanding Google's goals with Search. Google Search is by far the #1 search engine, capturing 70% of the search market. There are probably two reasons why Google would bid to maintain its place as the default search engine on Firefox: the first, Firefox is a popular web browser, with many users, and Google wants to retain the large user base who search on Firefox. Second, Firefox users tend to be more privacy oriented than users of other browsers, therefore Google wants to c"See full answer

Kevin S. - "The question given is intentionally very open ended. As the key phrases used are "air travel" which can encompass all parts of the journey not just the airport or flight experience & "improve the perception" which doesn't necessarily require fixing the problem (although you'd hope that was part of the conclusion). In addition, the constraints of time (1-year) and resources ($10M) means you must be very prescriptive. As such I think it'd be important to ask the following clarifying questions"See full answer

Krishnan S. - "I would start with few clarifying questions for the investigation and diagnosis of the problem. Timing and volume: For how long is the peak surge being noticed? Past few days / weeks / months? Clarify about 'certain times'. Is it weekday Morning (Peak), Morning (off peak), Afternoon, Afternoon (peak), Evening (peak), Evening (off peak) or weekend? Do we info on vehicle type that have the most volume? Cars, trucks, commercial vehicles, etc., Location and convenience of the gas st"See full answer

Aekagra S. - "Clarified whether this drop is observed in a particular geography or with a particular demography or devices. Then moved to the analysis of any bugs or flow broken or any defects. If not then talk about any competitor launching a product or feature in a similar category. If yes then double down on that or else speak about any political or marketing campaign that's been launched or any negative news about Facebook. What-Why analysis and concluded with a possible cause."See full answer

Scarlett S. - "(This is debugging, then trade off question) WAU and email open rates can be influencing each other, especially an email opened and then clicked could lead to an active user, but it doesn't necessarily mean that they have correlations or be the only reason causing changes. The approach So we definitely need to look at each cause of Why MAU goes up, and why email notification open rates go down, then develop some hypothesis on for proper cause, I'd love to gather some info to narr"See full answer

Ian S. - "Clarifying questions: What are we defining as "participation"? Does it include creating a live stream? Or is it just viewing a stream? Engaging (commenting/reacting) with other viewers during a live stream? ["Participation" = Watching, commenting, or reacting to a live stream as it's being broadcast, not during replays] Are these live streams from major broadcasters expecting large audiences? Or individuals making use of live broadcasting from their phones? [Across the board] "See full answer

Parag - "Clarify Retention for which side of the platform - advertisers, groceries/shops, shoppers, users? - Assume Is there any specific event or trend driving retention down or we’re looking in general to overall improve from current state? - Assume Is this tied to any particular geography or region? - Assume Is this tied to any specific persona within our 4 sided platform? - Assume Are we changing the definition of retention (time, frequency, others)? - Assume no Goal - Improve the use"See full answer

Coach - "Product "XYZ" explain what it is and which audience it is serving. Goals Ease the anxiety Offer the most comprehensive perspective of Cloud Engagement Democratize Upsell Insights Business Review Deck Slide #1: NPS - Now, Trend & Insights + Call To Action: FYI & solicit feedback Slide #2: User Engagement Update - DAU, WAU, MAU, Actions Completed + Call To Action: FYI & solicit feedback Slide #3: Partnership Update - Share new cross org collabor"See full answer

Anil K. - "Acquisition New sign-ups for Google Drive Service Google Drive app installs Activation Number of users with at least one file since sign-up Paid Google Drive Users Engagement DAU, MAU Sessions, Frequency Time spend Files accessed per session Task completion - sharing file, setting up automatic back up etc. Retention % Repeat Users % Users Churning out Google App Uninstalls Referral Inviting"See full answer

Christopher K. - "Amazon is releasing a product recommendation carousel. Q1. How would we approach this launch with executive leadership? Q2. How would you obtain the data to find out if you should launch and what sample size should your testing batch be for an A/B test scenario? Clarifying Questions What is the current goal for the product recommendation - Increase sales How does the current product recommendation view look like on the home page - A mosaic list view Are there any existing custome"See full answer

Anonymous Goat - "Comprehend the Situation: I like DownDog, the fitness app. It's my favorite, because it allows me to select on demand different exercises ranging from Yoga, HIIT, Cardio etc with the ability to modify time, voice, background music, intensity etc. I will use the down dog app as an example to discuss user drop-off. Customer: It is designed for casual users who wants to do exercise at gym or home Customer's Needs: This app helps users quickly choose and select the on demand quick exercises ("See full answer

Smriti G. - "Product -> Self service Portal North Star Metric-> No. of proposal downloaded Problem-> 15% Decrease in Proposal downloads RCA-> System Health check-> Bugs, errors in pages during session, site crashed, server inavailability, new feature was introduced which made it difficult for user to navigate. If there was problem of server in-availability, is load balancer working fine/server is not available? If problem was with feature-> What feature was introduced? do an A/B test with older feature Fu"See full answer

M N. - "Let's look at what the goal is- why we want to understand customer satifaction, and understand what actions our users take where we collect user feedback and then figure out the metrics that track these feedback touch points to understand cust satisfaction. Goal: To understand more about customer satisfaction and loyalty with the product to understand any gaps and understand where we stand with the competition, beyond the engagement, retention and revenue metrics. Actions: We have different"See full answer

Sonam S. - "Are support tickets % an increase or an absolute increase? (Assuming absolute increase) Is the dashboard showing an increase in tickets accurate? Categories tickets Geographic area? Product area? Operational area? Seasonality? Type of ticket - Debug tickets or Help me how to do x (Did we have an influx of new customers joining? ) What type of customers ( new or existing, age with the company, history) 3"See full answer