Recent Data Analyst Interview Questions

George P. - "North Star - Monthly Recuring Revenue No of new signup churn/retention CAC"See full answer

George P. - "breakdown the questions from Top- Down or sum up from bottom-ip Identify KPI and North star metrics Identify and analyze cohorts and segments Transform data to actionable insights"See full answer

Katherine B. - "For ROI for strategic bets, we want to evaluate short term and long-term returns on our investment as well as ensuring we have quantitative and qualitative milestones to measure progress towards the long-term goal. For quantitative evaluation, I would first outline resource investment from upfront capital investment, infrastructure resourcing and clearly capture the opportunity cost of the investment. Then I would set leading success indicators, and business metrics over the timeline of the inv"See full answer

Katherine B. - "We have detailed monitoring and meetings dedicated to discussing the health of the conversion business. When I’ve seen drops in the conversion rate, the first thing I do to diagnose the issue is to work backwards through the conversion funnel. For example, if I see a drop in user adoption rates, I will evaluate if there are any product experiments that could be negatively affecting adoption. Likewise, was there a technical outage that could have caused a drop? Segmentation and cohorting is also"See full answer

Katherine B. - "Before jumping into solutions, I’d want to first understand the feature launch’s objectives: what metrics were we trying to move and how did those top-line metrics perform. In an ideal scenario, we’d A/B test the feature so we can statistically measure metric performance over the existing features. If we weren’t able to A/B test, we would evaluate performance using pre-post on our key metrics we’re aiming to move, as well monitor funnel performance. Likewise, I’d make sure that engagement, ado"See full answer