Business analyst Interview Questions in United States | Glassdoor.co.in

# Business analyst Interview Questions in United States

9,454

business analyst interview questions shared by candidates

## Top Interview Questions

Sort: RelevancePopular Date

15 Apr 2010

6 Oct 2013

11 Nov 2011

1 Aug 2017
 The company is losing 1 million subscribers every month. What are the possible reasons for losing subscribers? Given the company is losing subscribers at this pace, how long can the company continue, until it starts making loss?10 Answers25 MonthsApproximately 70 monthsHi, I actually interviewed for this case and I also got 70 months, whereas the interviewer said I was wrong and said the correct answer is 25 months.Show more responses25 monthsSupposing number of customers at break-even be x. (36x + 46x) = 9 billion. This gives 75 million as the number of customers. That says it lost 25 million customers which implies 25 years.12Bn Rev Per year 9BN cost per year Customer Loss per year = 1million *12 months = 12 million customers Revenue per customer per year = 36 + 7*12 = \$120 Each year, company looses 1.44BN. = (12 million *120) To make a loss, company must loose 3BN 3BN/1.44BN = 2.083 years 2.083 years = 25 months.25 months doesn't sound right... Revenue: \$12 billion Costs: \$9 billion Profit: \$3 billion Customer lost/month = 1 million Revenue lost/month = (36/12 + 7) = \$10 * 1 million = \$10 million Break even = \$3 billion / \$10 million = 300 months 300 months / 12 = 25 years The only way I can see 25 months is if we assumed Ad Revenue is Annual and CANNOT be broken down to month average/customer. In that case Annual Revenue/Customer = 36 + (7 *12) = \$120/customer Total lost revenue/month = 120 * 1 million = 120 million Breakeven = 3 billion / 120 million = 25 monthsUnfortunately, the answer is 25 months and I failed to come up with that figure as well. The calculation posted by anonymous listed below is the right approach: 12Bn Rev Per year 9BN cost per year Customer Loss per year = 1million *12 months = 12 million customers Revenue per customer per year = 36 + 7*12 = \$120 Each year, company looses 1.44BN. = (12 million *120) To make a loss, company must loose 3BN 3BN/1.44BN = 2.083 years 2.083 years = 25 months.36X+84X=9Bn 120X=9Bn ____ ___ 120 120 X= 75,000,000 36(75M)+84(75M)= 2.7Bn+6.3Bn=9Bn So, with 75M customers they would make 9Bn in revenue Since they currently have 100M customers, at 25 months their number of subscribers will be 75 million. 9Bn in costs/12= 750M in costs per month 3X+7X= subscription revenue per month 3(75)+7(75)= 225M+525M= 750M Costs to revenue would be 750M to 750M, so they would break even. In the 26th month, they would start having a loss 3(74)+7(74)= 222+518= 740M So 740M in revenue vs. 750 M in costsIf they're asking for a loss, it's 26 months. If they are asking when the venture is no longer profitable it is 25 months. From the verbiage it is not exactly clear

25 Aug 2010
 How would you deal with a stakeholder who was insisting that a complex process would be the ideal solution to an existing problem?7 AnswersI would explain to the stakeholder that the purpose of the Business Requirements elicitation meeting was designed to identify the business need not to design the solution.Great answer and exactly right!nice!!Show more responsesThank You!!!Try to present alternate possible process that you think is less complex. Patiently explain pros over the process insisted by stakeholder. Alternatively, try to make the stakeholder understand what would be the risk, challenges and cons of the process they are insisting. If they still do not agree, we will have to escalate or deal the discussion in presence of upper management.I would agreee with the first answer if we were told that the interaction occurred during a requirements meeting. What if the stakeholder was insisting while you were working on the solution? I agree that the answer should be to either propose the alternate solution and explain why it is the better approach.I would put down all the data in front of him and lay down the pros and cons of having that process. Previous to that I would do my homework and talk to developers to check if that’s even possible. Offer an alternate solution, If everything else fails, I will talk to higher management.

8 Feb 2012

1 Nov 2014

20 May 2012