Preparation for Data Business Case Interviews

The interviewer says: "Our client wants to enter the Spanish beer market. Should they do it?" What should you clarify first?. The client's current market share. The number of beer brands in Spain. Define what “doing it” means for the client, such as increasing revenue, profit, market share, or growth. The average price of beer in Spain.

You are asked: "How can this company increase profitability?" Which approach demonstrates the strongest initial structure?. Immediately analyze employee salaries because costs are usually the main problem. Break profitability into revenue and costs, then investigate the relevant drivers within each. Start by looking at the company's largest customer. Build a dashboard containing every available KPI.

Profitability framework Which decomposition is most useful when investigating a decline in profit?. Profit = Customers × Employees. Profit = Revenue − Costs. Profit = Market Share × Population. Profit = Price × Competitors.

You are estimating the annual revenue opportunity for a new beverage. Which sequence is generally the most logical?. Population → potential customers → purchase frequency → quantity purchased → price. Population → potential customers → market share → quantity purchased → price. Population → purchase frequency → potential customers → quantity purchased → price. Population → potential customers → purchase frequency → market share → price.

You estimate that: Spain has 40 million adults. 75% consume beer. The average beer consumer drinks 100 beers per year. The average price is €2 per beer. What is the estimated annual market value?. €6 billion. €4 billion. €8 billion. €8 billion.

A market is worth $500 million annually. Your client currently has a 10% market share. If the market grows by 20% and the company's market share remains unchanged, what will its revenue be?. $50 million. $60 million. $100 million. $120 million.

A product sells for $100 and has a variable cost of $60. What is its gross margin percentage?. 40%. 60%. 66.7%. 160%.

A new product has: Fixed costs = $2 million Selling price = $50 Variable cost per unit = $30 Approximately how many units must be sold to break even?. 40,000. 66,667. 100,000. 150,000.

Hypothesis-driven analysis You suspect that a company's declining revenue is caused by customers buying fewer products. What is the strongest next step?. Analyze transaction volume, units per customer, purchase frequency, and trends over time to test the hypothesis. Compare transaction volume and purchase frequency with competitor benchmarks before testing the hypothesis. Investigate customer purchasing behavior while simultaneously reviewing pricing, product mix, and customer retention trends. Develop recommendations to increase customer purchases while gathering supporting data.

A graph shows that revenue increased by 15% while profit decreased by 10%. Which conclusion is most defensible?. The company became more profitable because revenue increased. Costs or other margin drivers may have increased enough to offset revenue growth. Customer demand definitely decreased. The company should immediately increase prices.

A client wants to enter a market with three major competitors. The largest competitor has 60% market share, while the other two have 20% each. What is the most important interpretation?. The market appears concentrated, which may indicate barriers to entry, competitive advantages, or strong customer loyalty that require further investigation. The client should focus primarily on matching competitors' prices to gain market share. The market structure suggests growth opportunities are limited because market share distribution is uneven. The client should prioritize acquiring smaller competitors before considering direct entry.

A market is growing at 15% annually, but entering it would require significant investment and the client's expected profit margin is only 3%. What should you do?. High growth makes the opportunity attractive, but profitability and investment requirements must also be evaluated. Low margins suggest caution, but a final recommendation depends on expected returns, competitive dynamics, and strategic fit. The client should prioritize market entry because growth often improves future profitability. The investment requirement is the primary factor and should outweigh all other considerations.

A company's revenue declined 12%. Your analysis shows: Price increased 5%. Number of customers decreased 15%. Average units per customer increased 2%. What should be investigated NEXT?. Whether customer losses were concentrated in specific segments, products, or regions. Whether prices should be increased further. Whether average units per customer can continue growing indefinitely. Whether all revenue metrics should be treated equally.

A company launches a premium version of an existing product. Premium-product sales are strong, but sales of the original product decline significantly. What should you investigate?. The premium product may be cannibalizing existing sales. The product launch may have shifted customer preferences toward a higher-priced option. The company has successfully increased total profitability. The percentage of premium-product buyers who previously purchased the original product.

A company has experienced declining overall customer retention. What is a strong analytical approach?. Analyze retention trends across customer segments to identify where losses are concentrated. Compare retention performance against industry benchmarks and competitors. Evaluate whether recent product or pricing changes affected customer behavior. Review customer satisfaction and engagement metrics over the same period.

The interviewer gives you limited information and says: "Take a look at this opportunity and tell me what you think." Which behavior is strongest?. Ask targeted questions to clarify the objective, key constraints, and the most important uncertainties. Develop an initial hypothesis based on the available information and begin testing it with the interviewer. Start by building a high-level framework covering market, competition, customers, and financial considerations. Identify additional data that would be helpful before drawing a conclusion.

A subscription business charges $20 per month. Its average customer remains subscribed for 10 months, and the variable cost associated with serving that customer is $50 over the entire lifetime. Ignoring acquisition costs, what is the customer's approximate lifetime gross profit?. $50. $100. $150. $200.

At the end of a case, your analysis suggests that entering the market could be profitable, but the estimate depends heavily on an uncertain assumption about customer adoption. What is the strongest recommendation?. Recommend entering the market while clearly explaining the key assumption and the risks associated with it. Recommend conducting additional research on customer adoption before making a final commitment. Recommend a phased market entry to test adoption before scaling the investment. Recommend evaluating alternative growth opportunities alongside the market entry option.

Which is the strongest structure for presenting your conclusion?. Present the recommendation first, support it with key evidence, discuss major risks, and outline next steps. Present the most important findings first, then explain the recommendation and implementation considerations. Present multiple viable options, compare trade-offs, and conclude with the preferred recommendation. Begin with detailed analysis, summarize the evidence, and conclude with the recommendation.

You recommend that a company enter a new market. The interviewer asks: "What would have to be true for your recommendation to be wrong?" What is the interviewer testing?. Whether the recommendation depends on assumptions that may not hold. Whether other approaches could achieve similar results. Whether the available evidence is sufficient to support a decision. Whether additional information might change the analysis.