Business analyst Interview Questions in United States
business analyst interview questions shared by candidates
Top Interview Questions
Business Analyst at Capital One was asked...
You have 3000 bananas at point A, which is 1000 feet removed from point B. You must move as many bananas to point B, but you can only carry 1000 bananas at any time, and traveling 1 feet requires you to eat 1 banana. You can drop off bananas at any point between A and B, and pick them up later. 31 Answers500 bananas 500? How? Could you pls explain? Don't worry it...got it Show more responses Not very clear formulation of problem . I move V (in thousand) bananas on L feets., what I get in point L 1.V-L/V Or 2.(V-L) In first case I spend 1/V moving on 1 feet, but in second energy do not depend of load. Sorry my Error not 1/v but V and not (V-L/V) but (V-V*L) how do you mathematically formulate it? I mean I see how it's 500 from intuition. But, if I were to approach the problem from a purely mathematical way, how would I formulate it? @Shilpa, Could you share what you found? Thanks! It's not 500. Not sure if correct but I calc 666. It should be around 666 bananas. How did you arrive at 666? let us say you move x feet before you drop your bananas and then go back to point A, and let's say you pick 1000 bananas first time. You eat x bananas when you get to point x, and since you need go back to Point A, you will keep another x bananas, then you drop 1000-2x bananas at point X, next time suppose you pick y bananas, when you get to point X, you will eat y-x bananas, and pick former dropped 1000-2x bananas, all these bananas add up to 1000, so we got y-3x+1000=1000, that's y-3x=0. Since we can pick max 1000 bananas, so max y is 1000, x is 333, that is say, we can go as far as 333 feet and then we must go back. since after we get to point b and don't have any more bananas for us to go back to point A, seems 333 is the answer 1000-2x+1000-2x+1000-x=2000 x=200 (first stop point @ 200 feet) 1000-2y+1000-y=1000 y=333 (second stop point @ 533 feet) so you can move 1000-(1000-533)=533 to Point B. Hey ltss587ATgmailDOTcom - I understand how you got to 1000-2x+1000-2x+1000-x (3000-5x) which is effectively number of banas left at Point X. Why did you equate it to 2000? what is the rationale to it? Also how did you get the second equation? 1000-2y+1000-y=1000 Wei - In your equation, though it makes sense, but u didnot go back the third time to pick up the 1000 bananas. At this time, y-3x=0., you still have a 1000 bananas left? Could you please explan. I really appreciate it. Show more responses Hey G It goes like this 1000-2x+1000-2x+1000-x=2000 ( equate it to 2000 because after this u will wont need to go back third time as the maximum u can carry will be over in two time) x=200 (first stop point @ 200 feet) 1000-2y+1000-y=1000 ( equate it to 1000 because after this u will wont need to go back second time as the maximum u can carry will be over once y=333 (second stop point @ 533 feet) so you can move the remaining 1000 distance in (1000-533)=533 to Point B. So 533 bananas left sorry guys its 833 bananas You have to do it a foot at at time to max out You'll have to carry 3 loads until you eat 1000 bananas so 3x = 1000 or x = 333 ft. next you have to carry 2 loads until you eat the next 1000 bananas so 2x = 1000 or x = 500 ft. Now you have exactly 1000 bananas left so only one load fo the remaining 167 feet this gives you 833 bananas left. It is 333 bananas!!! 833 is the maximum left and best explanation. Do it on a number line. Maximize each load and trip. The second step must be 2 trips closest to the goal ending with 1000 bananas because there be one final trip at maximum load the shortest distance. So stops at 333+500+167 gets the most product moved at least cost. Logistics. Technically this isn't really asking anything. Technically you don't have to eat any bananas. If you move them less than a foot each time, you don't have to eat any bananas. 3000, pickup 1000 bananas and walk 1/2 feet, go back get another 1000 and put them @ 1/2 ft location and then get the rest bunch. 833 is correct. Starting at 1000 feet mark. Carry 1000 bananas drop 999 at 999 foot mark. Go back and bring 2*1000 similar way and drop at 999 ft. Now you have 3*999 bananas at 999 feet. Keep doing this until 3*x exceeds 1000. You are now at 666 foot mark with 1998 (3000-334*3) bananas. Now do two trips and drop bananas at each foot traveled. At 177 (833) foot mark you will have 1000 bananas. Now you will loose 177 bananas to end Show more responses Incomplete question but this is making the presumption that the answer required is 'what is the largest number of bananas I get get to point B'? Te answer is 2 You must eat one banana per foot traveled. Whether forward or backwards, a foot is still a foot, so a banana must be eaten. If I take 1000 bananas and drop 334 of them off after 333 feet, I will have just enough to get back to point A. I grab another 1000. I walk 333 feet, arriving with 667 bananas. I pick up 333 of those I left the first time, leaving one, and walk another 333 feet. I reach the 666 feet mark with 667 in my possession. I leave two there. One my way back, I must pick up the remaining banana from the 333 foot mark in order to get back to point A. (665+1) I pick up the remaking thousand. At 666 feet, I have 334 left. I pick up the 2 that I left there, then eat the 334 necessary for me to reach point B. I have 2 left I grab the remaining 1000. I reach the 666 mark with 334 bananas. I take the one I left there. I walk 334 feet, arriving at point B with a single banana Sorry for the fat fingers in my answers! I ate too many bananas and was feeling ill, lol Second apology. Somehow seems as if my response sequence got messed up. I'll try this again! I must eat a banana whether traveling to or from point A. I take 1000 and walk 333 feet I arrive with 667 and leave 334 of them I get back to point A empty handed and grab another 1000. At 333 feet, I take 333 of those I left the first time, resuming my journey with 1000 bananas. I walk to the 666 feet mark arriving with 667. I leave 2 and head back with 665 in my possession. I pick up the one I left at the 333 point mark and make it back to point A empty handed. The last thousand is enough fuel to get me from A to B, so I arrive at point B with the two bananas I had left at 666 feet. The answer is 2 The answer can be googled, they offer a generalized form. For this particular example it is 533 3000. Since the direction of the distance between point A and point B is not specified, we can assume point A is at a higher elevation than point B. We can then either 1) slide the bananas down the slope from point A to point B if we assume the their is a slope with a low enough coefficient of friction, or 2) assume that Point A is directly above point B and simply drop the bananas. Since in both scenarios we do not have to move, there is no need to eat any bananas. (Note: for the second scenario, the problem does not specify the condition the bananas should be in when they arrive at point B.) One or more comments have been removed. |
Business Analyst at Deloitte was asked...
Behavioral: what is the similarity between a milk carton and a plane seat 13 AnswersI believe the answer to that question demonstrate a reasoning ability, and thought process. Looking at the two cases starting with a plane seat; plane seats are meant for comfort and support. Comfort in the sense as to soothe uneasiness in the travel. Support: to hold you in place, aligning to the motion of the plane. Second, a milk carton has more to do with support than comfort because milk are inanimate. I wouldn't think milk carton is made of the same material as plane seat because of the calculated risk involved, and value of the product: human life versus milk content. So, it has more to do with support; so that both don't fall out of place. Duh... Both are a little squishy! Both can float! Show more responses Its a silly question and it deserve a silly answer as well. Answer: both have flat bottom ..... Both have expiration date. If they are not sold/used by the expiration date/flight time, they are useless Both are designed for efficient transportation They are both designed to be lightweight, which translates into saving on transportation costs and energy. They both are designed to hold things safely. They both are designed to fit the maximum 'product' in a given area.(milk cartons are square so you can fit more in a fridge than round bottles) They both have tons of federal regulation regarding their design and how they hold their respective contents. The contents of both have extremely low margins and often serve as loss leaders. ie milk is sold cheap to get customers in to buy other goods and seats are sold cheap to get customers to buy other goods like ryan air. The cost for both are a small proportion of the total price. They both are designed in a very utilitarian manner, but also have luxury versions. paper cartons vs glass milk bottles and coach vs first class seats Indirect complimentary objects that came with the purchase of a product! Those objects are both necessary for the sale of milk, and a flight. The customer is not considering those two objects when they are making their purchase. *Admittedly a seat on a flight has more importance than the carton Packaging is the first line of attack to product segmentation, first vs economy, carton vs glass. They both can both be filled or empty Both are in an aisle. One or more comments have been removed. |
Business Analyst at Capital One was asked...
Let's say we're playing Russian roulette. The revolver has SIX barrels, THREE of which contain bullets. I give you two options: A. Spin, shoot. Spin, shoot. Spin, shoot. (For a total of three times). B. Spin once and pull the trigger twice. Which option would you pick and why? 15 AnswersA. Your chances of surviving are (3/6)*(3/6)*(3/6) = 1/8. B. Your chances of surviving are 1/3. Therefore, you want option B. Correct me if I'm wrong but aren't the chances of surviving scenario B based on conditional probability...the probability you survive the second trigger pull given that you have already survived the first... (3/6)*(2/5)/(3/6)= 40% chance of survival I forgot to add a crucial part of the question in my original post, which is that you know that the three bullets are right next to each other. Thus, the first spin determines whether you survive, and there are two out of the six chambers that are safe to "land on," hence 1/3. In my original wording of the question, I think your chances of survival would just be (3/6)*(2/5) = 1/5. Show more responses You should have a basic knowledge of credit card concepts, e.g. credit limits, balances, interest rates. The interviewer will be happy to explain any uncommon terms that they use during the case (e.g. I wasn't familiar with the term "utilization ratio" and my interviewer was happy to tell me what it meant). You don't need to know about the crazy derivatives or anything like that. Put it this way: The interviewers won't penalize you if you ask them what a particular term means during a case. However, if they ask you what consumers might care about in choosing a credit card or bank, you should be able to name basic concepts such as the ones above. this problem is conditional probability because previous events effect probability of current. If the chambers are loaded with 3 bullets at random: % of survival = 3/6 * 2/5 *1/4 = 5% chance of shooting 3 blanks consecutively. If the bullets are in 3 consecutive chambers, then your % drastically changes. 50% chance on first shot. If blank, then you know that 3 permutations are no longer available: chamber 123,612, 561. Therefore chamber 5 has a 66% chance to contain a bullet chamber 6 has a 33% chance to contain a bullet chamber 2 has a 33% chance of containig the bullet chamber 3 has a 66% chance to contain a bullet chamber 4 must contain a bullet Chance of dying with 3 consecutive shots if the bullets have to be consecutive is 0.5*0.666*0.333 = 11% --Spin-shoot-spin-shoot-spin-shoot: We are selecting a random barrel each time (50% chance of containing a bullet) Probability of surviving = (1/2)*(1/2)*(1/2) = 1/8 = .125 --Spin-shoot-shoot First chamber has 50% chance of containing bullet. If we survive the first shot, there are still 3 bullets (2 blanks) left, but only five remaining chambers Probability of surviving = (1/2)*(2/5) = 2/10 = .2 .2 > .125, so the second option is safer. Martin is right except for the last part. It would be Probability of surviving = (1/2)*(2/3) = .33 This is because if you survived the first shot you are in 3 of the possible blank chambers that are all next to each other. If you first shot blank #1, you will move and shoot blank #2 next. If you shot blank #2 first, you will move and shoot blank #3 next. If you shot blank #3 first, you will move and shoot the first bullet (1/3 chance of getting bullet conditional on surviving the first shot). Given then you survived the first shot with 50% chance, you started in one of those blank chambers. And since the blanks are adjacent to each other (since the bullets are all adjacent), your chances will be 2/3 for survival. And 1/2*2/3 = 1/3 None of them, I want to live. How about we just not play Russian roulette. rather not play Show more responses I choose option C, never point a firearm at anything you are not willing to destroy. One or more comments have been removed. |
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 Months Approximately 70 months Hi, 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 responses 25 months Supposing 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 months Unfortunately, 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 costs If 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 |
Business Analyst at PwC was asked...
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 responses Thank 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. |
How do you give about giving a presentation without preparation or knowledge of the subject? 6 AnswersJob description said NOTHING about giving presentations nor did anyone offer that this would be a quality expected of a BA when directly asked about it (if so, I would have prepared an adequate response). That information was deliberately withheld from me in an effort to trip me up in the formal interview. I'd answer this by saying that these were actually two different questions - how one feels about giving a presentation on something you have knowledge about but on the fly, versus how one feels about giving a presentation about which one lacks knowledge. Clearly, the first situation would be preferable. I guess you could see it that way, but it wasn't that way at all. By virtue of the fact that they wouldn't move on to the next topic/question after it was answered, it was clear to me that this was a question intended to disqualify/trip me up. Show more responses Personally, I would say that this question isn't about giving presentations; it's about how you handle uncomfortable situations that can arise in business with little warning. How do you give a presentation on a subject you know little about? Don't give a speech, instead, utilize a roundtable discussion method to bring any knowledge the audience might have into the discussion in the hopes that the group's knowledge will help to make the presentation more fruitful and beneficial for everyone. Often, interview questions are not about specific job responsibilities, but rather about skills they are looking for in potential candidates. A basic template for presentation is responding to this set of questions: What, Why, Where, When, Who, and How? Some people add How much? To be honest , I would just play it off . I would use all my knowledge and understanding of the topic and say it . If I don’t know nothing , then I don’t say nothing . Easy you shouldn’t be forced to give a presentation with a lack of knowledge, that is plain dumb . Don’t play yourself . It’s better not to say nothing and just excuse your self : |
Business Analyst at Google was asked...
Design an evacuation plan for the building 7 AnswersLet's assume the building is 5 stories. Those on the first floor should exit through both the main doors as well as the emergency exits to avoid congestion. On the upper floors, emergency stairs should be used and elevators avoided as in the case of a fire can malfunction or too many people may crowd it causing it to also fail b/c of being overweight. It is important to train the people before an emergency on how to act in a situation. Panic is one of the main concerns and people must know the plan beforehand and act in a calm, collected way. If this is at the mountain view location, a earthquake is common and it is important to get out of the building as quickly as possible and stay away from any objects that could potentially fall. Regulations differ depending on where you are, but: if you're not a licensed engineer or architect, you don't design an evacuation. You draw up a brief and rough plan, and you take it to them and let them do the work. Here's what to bear in mind to make their lives easier: a) Two fire exits- one nearest to fire hazard rooms (eg. kitchen, mechanical room, etc.) and one nearest to the room with the highest number of people in it at any given time (eg. office). b) Design spaces that are farthest away from either exit to have the most direct paths to egress with the fewest obstacles. This goes right down to configuring furniture orientation- open-plan offices should have a V or T-shaped configuration that is longest at the top, widest at the farthest end. Interior designers are your friend here. c) The basement is your friend in most - NOT ALL - cases. Have emergency elevators that are exclusively sealed in the basement except when needed for egress. Have 'panic rooms' that are bunkers where you wait for help. Have stairwells with ADA waiting spaces on each floor and a telecom-it's normal practice for firefighters to check those areas first when finding people to rescue. d) Have clear instructions and maps to egress throughout the building. They should be visible to firefighters as well as visitors and regular workers or residents. e) Higher occupancy buildings with lower rating walls and doors and windows should be equipped with sprinklers. Depending on where you are and what the building codes are, the above may vary. But invest money in a licensed architect or engineer and let them do what they're good at. Show more responses I'd go for slides... Seems like a fun and easy way to exit a buliding I may say: Firstly, study the building plan and layout in order to see the flow/route that could be the most convenient path to get out. Secondary, design the sign / map/ device / accessories including doorknobs to be easy to understand right away what it is and how to use it. Then schedule evacuation training for people who live/work in the building. If evacuation needs action, they would lead people to evaluate easily. The people within the building must learn all the drills and in addition to all the answers to this question the evacuation plan will only work if everyone cooperates and learns to layout of the building. I understand the evacuation may be done without notice which is why it is never too early or late to ask about the safety features. One or more comments have been removed. |
Business Analyst at Amazon was asked...
If you have two SQL database tables that are not joined together, how would you create another table to join them. 6 AnswersPretty simple question Lets say we have two tables Person and Other school - each person is student in the school, since you need to join those two tables, you need common column to share and hence forth you find the key to join. Inner Join - join table to bring records common in both the tables Outer Join - Bring results besides the ones that are common or rather bring distingushed results (uncommon) in two tables I'll write here inner join using MS- SQL Question has three part - create another table , join the reults and then populate the reults -- Create the resulting table Create Table Result { string name; } -- Join to table and insert into result table - Assuing two table person and school has common column name INSERT INTO RESULTS --whatever be the join result will populate the result table select name from Person Inner join School -- used inner join here ON person.Name= School.Name -- used the key to join -- now lets pull up the results by querying resut table Select Name from Result -- Questions resolved :-) create new table mean that -> the tables are not connected, they don't have a common column but they complete each other. they have many to many relationship mean that new table will have 2 columns (this is one option :-) ), and the both are they primary keys of both tables, so they will be presenting the both tables, and they will be primary keys and foreign key for the connecting_tables at the same time. so table 1 and table 2 are called the look up tables and the connection_table called the bridge table. so the sql code will look something like that : create table connecting_tables( id_toPresent_1st_table int(12) NOT NULL, // the variable type and length should be the identical to the variable type and length of the primary key in the 1st table id_toPresent_2st_table int(12) NOT NULL, // the variable type and length should be the identical to the variable type and length of the primary key in the 2st table //both are primary keys. PRIMARY KEY(id_toPresent_1st_table, id_toPresent_2st_table), //both are foreign keys. CONSTRAINT fk_table_1 FOREIGN KEY (id_toPresent_1st_table_Id) REFERENCES table_1(table_1_Id), CONSTRAINT fk_table_2 FOREIGN KEY (id_toPresent_2st_table_Id) REFERENCES table_2(table_2_Id) ); SELECT A.id,B.id, INTO bridge_table --New table is created FROM A,B WHERE A.id = B.id Show more responses Wondering anyone have tried Rooftop Slushie? I've found it useful so far but not sure if it's worth it to make payment. (rooftopslushie.com) CREATE table table_name as SELECT * FROM table1 JOIN table2 USING (pk); One or more comments have been removed. |
Business Analyst at CGI was asked...
3 light bulbs and 3 light switches, the lights are upstairs and the switches are downstairs. With no extra help, and no one else around, by making one trip how do you figure out which light goes to which switch? 5 AnswersLights produce heat the longer they run. So turn one switch on, wait an (period of time). then turn another switch on, and go look at the lights. The light that is not running is the obvious switch that hasn't been flipped. The next step is to feel the lights, whichever light might be warmer, is the first switch to be flipped because it has been on longer. This leaves the second flipped switch with the remaining light bulb. The answer given assumes that the lights were all off in the beginning. This assumption might not be correct. In second case, see the positions. If they all are on, switch off two immediately. Wait for some time, enough to ensure the switched off lights are cool to touch. Then switch on one of them. Now make the trip. The one bulb that is off, is for switch flipped off but never turned back on. Touch the remaining two, the hotter one was the one never turned off and the glowing but not hot is the third. You give the combinations and they can be handled in similar way. Show more responses Turn on two light bulbs. Wait a minute. Turn off one of the switches remembering which one you switched once, twice (on then off), and none. Go upstairs. The one on is the switch you left on. Feel the two bulbs that are off. The one warmer is the on-then-off switch while the cooler one is the switch you never touched. I would place my laptop or tablet in a central location upstairs with all doors open and a facetime to my phone on. I could then turn on each light one by one and see which area lit. The heat methods mentioned above could work as well but that would assume they are the same wattage, were cool prior, etc. |
Business Analyst at BP was asked...
If a client told you they wanted to make a rock, what question would you ask first 6 AnswersIntersting question! First I would ask what cost range and then time frame. Then, I would proceed and ask what size, what shape/dimensions, weight, what purity, specification in terms of defects and then ask what is the end use of this rock. Hmm, I disagree with the last answer. I'd start with the question regarding the end use. Sometimes a client thinks that the rock is the solution to the problem with out knowing all the options available to them. It could be that what they're really looking for is a door stop. How will you put this rock to use Show more responses "Sell me the rock". You need to make a product that sell. It doesn't matter what it is but if you market it properly you can sell anything. Why do you want to make a rock? What for? One or more comments have been removed. |
See Interview Questions for Similar Jobs
- Analyst
- Senior Business Analyst
- Software Engineer
- Consultant
- Financial Analyst
- Management Trainee
- Associate
- Data Analyst
- Associate Consultant
- Assistant Manager
- Research Analyst
- Senior Analyst
- Senior Software Engineer
- Project Manager
- Senior Consultant
- Software Developer
- Manager
- Product Manager
- Associate Analyst
- Research Associate