Analytical Interview Questions

Ivan B. - "At Facebook, you notice a sudden spark in DAUs in Indonesia — how would you determine the cause of this? I'd like to clarify a few things before starting to brainstorm root causes to hopefully narrow down the number of possibilities if you don't mind? - Not at all, please go ahead... Over what time frame has this spark occurred? - DAU's have sparked over the past 3 weeks. Thank you! Next, what are we qualifying DAU as? Is it simply just a user opening the app at least once during the"See full answer

Divya K. - "You will need to start from Browser and go all the way up to Analytic systems and methods. Everything needs to be covered"See full answer

Exponent - "This question is a Diagnosis Question. Let's follow the template for answering Diagnosis Questions: Ask clarifying questions List potential high level reasons Gather context (with TROPIC method!) Establish a theory of probably cause Test theories Give a potential solution Summarize Ask Clarifying Questions Before we begin, it's important to ask clarifying questions if necessary. This question is quite straight forward so we may not have ma"See full answer

Prasad M. - "The first aspect to review before any task is who is/are the ultimate 'owner' for this job? The next thing to consider is 'repetitiveness' of the job itself. The job can be simple or complex. For simple and the ownership factor align with my team... then that task is delegated. If the job is complex and the team ultimately owns the task, then I provide careful support to guide in the right direction."See full answer

Varun J. - "Timeline and trends analyze period when the CTR was down Check external factors Seasonality and holidays Competitive factors Industry-wide changes Ad performance analysis Ad copy Product feed quality Pricing Promotions and discounts Audience targeting and segmentation Specific demographics? User segment? Device across mobile, desktop, and tablet Ad placement and auction insights Anything changed with ad placement?"See full answer

Isnadea soraya R. - "untuk mengurutkan daftar angka secara efisien saya akan menggunakan aplikasi pengolah angka yaitu excel dengan rumus rumus untuk mempermudah dan mempercepat pengurutan daftar angka"See full answer

Shubh T. - "Clarifying Qns: Note: How do we define DAUs? Let's say it's open ended and based on general engagement (watch time, comments, etc.) Did the watch time went down and comments went up for the same videos or are we saying total watch time and total comments on Youtube? (Total) I am assuming we are not including Youtube Live videos because those are typically live chat 1000’s of comments for a single video. (Correct) Do we know if these two could be independent problems not correlated wit"See full answer

Exponent - "You should be able to identify this as a Measure Success question. These kinds of questions are used to test your analytical skills, as well as your ability to track project progress post-launch. Recall the strategy for tackling them methodically and thoroughly: Ask clarifying questions State the goal of the feature / product Behavior Mapping / UX Flow Mapping Provide criteria to prioritize metrics Prioritize metrics Summarize Let's begin! Ask cl"See full answer

Exponent - "This is a Diagnosis Question. The goal of Diagnosis questions is to test whether the interviewee is organized and logical in their product approach. It also tests whether the PM is exhaustive in causes for decreases and whether they provides realistic solutions to the problem. Let's follow the Diagnosis Question formula: Ask clarifying questions Propose high level reasons for a drop Gather context (TROPIC) Establish a theory of probable cause Test theories "See full answer

Michelle B. - "I would analise it in some macro and micro aspects and then evaluate those, and think abou an release strategy. First considering the macro aspects that are: what is the main business goal and is the product addressing it? what is the user value and how the product is working towards this? And by last, what is the success metric, and how likely the product as it is, is in the way of accomplish it? Then, if those macro aspects are on track, I would go for a second round of analysis, to ev"See full answer

Jiin S. - "I would firstly see what's the trend of the sales by monthly, daily, and yearly to see when was the decline started and what happened during that time. I would also look at the sales by different customer or product segmentation to see what segment had the most decline in sales. Then, I would make some hypothesis where like for this age range customers with this product segment had a decline in sales due to XXX and we would increase the sales by YYY with this new feature. Then I would design the"See full answer

Tanshi T. - "How many people are using the shuttle service? what are the stops for the service? What time does the shuttle service run? How many people are driving versus the shuttle service? "See full answer