Business Analyst Interview Questions

Himanshu G. - "To model ROI for a product launch, the first step is to define the timeline you're targeting Example 6 months post-launch, 1 year, or even 5 years. Tip: Start with a 1-year ROI projection to estimate near-term returns, and build a 3-year projection to evaluate growth and scalability. ROI is essentially the net return over that period: Profit=Revenue (within timeline)−Total Cost (from project start) Total Cost includes both fixed and variable costs incurred since t"See full answer

Madina A. - "I’d assess a new feature launch by first checking if it achieved the goal we set before launch, whether that’s driving engagement, monetization, or retention. I would look at adoption and usage to see if users are discovering and repeatedly using it, the impact on the main KPI we targeted, and guardrail metrics to ensure there’s no negative effect on core product health like retention, crashes, or satisfaction. Ideally I would measure this through an A/B test or phased rollout and complement the"See full answer

Harish K. - "Swiggy could implement to increase the average order value (AOV) on its platform: 1. Smart Recommendations and Upselling: Personalized suggestions: Leverage data to recommend items based on past orders, popular choices, and trending items in the user's area. Upselling prompts: When a user adds an item to their cart, suggest related or higher-value items (e.g., "Would you like to add a side of fries with that?" or "Upgrade to a large for just ₹X more"). Bundle deals: Offer c"See full answer

Tim F. - "One project that stands out involved building a customer segmentation dashboard for our marketing team using Power BI. The goal was to help them target campaigns more effectively by segmenting customers based on purchase behavior and demographics. Early in the project, I noticed significant data quality issues in the source tables coming from our CRM system. There were missing values in key fields like customer age and region, duplicate customer IDs, and inconsistencies in how product categories"See full answer

Catherine T. - "We want sales to grow, in order to have a growth in revenue. And customer usage as well as it allows to see if our product lead more engagement from our users. So to be able to see this overall evolution I would make a line chart for both : Sales : with month on x-axis and sales revenue on y-axis Customer Usage : with month on x-axis and a KPI allowing to measure customer usage (nblogins or nbsessions or nbgamesplayed, ... depending on the industry) on y-axis Moreover, after knowing th"See full answer

Anonymous Giraffe - "this is not a helpful interview, she seems so unprepared, confusing, unable to netting it out :("See full answer

Seth W. - "As always, I'd start this discussion by asking a couple clarifying questions. In particular, I'd like to learn more from the interviewer about what "not pulling as hard" looks like. Does it mean: lower code output relative to the rest of the team lower velocity per sprint in terms of story points less participation in code reviews minimal participation in meetings and ceremonies Or perhaps it's a combination of these. As others have pointed out, I'd also want to confirm that I am not ma"See full answer

Maryam G. - "At one of my project, I worked on a project where we needed to collect data from different sections of a large factory and deliver it to a third-party company responsible for predictive analytics on product quality and production levels. The challenge was that each department had different data types and structures, and in many cases, direct connections were restricted due to strict security policies. My responsibility was to design and implement a solution that could gather all these heterogene"See full answer

Akash D. - "Investigation clear understanding the true cause"See full answer

Himanshu G. - "First, I would start by defining what growth means in the context of this new feature whether it's user acquisition, engagement, retention, or revenue. Next, I’d identify clear KPIs that directly align with that growth goal. For example, if the feature aims to improve engagement, I’d track metrics like daily active users, session duration, or feature adoption rate. Once the KPIs are in place, I’d run an A/B test comparing user behavior with and without the feature. This would be followed by de"See full answer

Himanshu G. - "First, I’d start by checking the alignment of each idea with our core business goals. If any idea doesn't directly contribute to those goals, I’d deprioritize or eliminate it upfront. Next, I’d use a scoring model like RICE (Reach, Impact, Confidence, Effort), especially because effort is a critical factor when resources are limited. This gives us a structured and quantifiable way to rank the ideas. Once we have a prioritized list based on scores, I’d take it a step further and evaluate key as"See full answer

Alex C. - "I would have been destroyed on this."See full answer