Analista Interview Questions in United States

77K

Analista interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Capital One
Data Analyst was asked...November 8, 2010

Case interview: basic business problem (if product X costs Capital One $4.00 per unit, with a $800 sunk cost, and we charge X amount of dollars along with a $10 annual fee, how many do we need to sell to break even, etc). Followed by a longer discussion of more complex problems that the situation might entail.

7 Answers

Actually, to correct the above response, if the selling price for 1 product is $794 (to cover the cost price of the product itself ($4) ), only 1 quantity needs to be sold. ($794 + $10) = ($800 + $4). Less

How is it possible to answer this without knowing the selling price per product? # of quantities to sell in order to breakeven depends on how much the selling price per product is? Since the selling price says X, you can sell it for $790 and breakeven by just selling 1 product ($790 per product + $10 annual fee (assuming it's per product)). But I may be misunderstanding the information provided. Any feedback? Less

Erin - it probably shouldn't be. The Revenue side should be (unit price + 10) * number of units sold. Dapo has assumed that unit price and number of units sold is the same since the letter X is used to describe both variables. That might be correct, but it would be an odd quirk of the question - I'd bet that you can ask what the unit price is. Less

Show More Responses
PwC

How would you deal with a stakeholder who was insisting that a complex process would be the ideal solution to an existing problem?

7 Answers

nice!!

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. Less

Show More Responses
Whole Foods Market

How do you give about giving a presentation without preparation or knowledge of the subject?

6 Answers

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. Less

A basic template for presentation is responding to this set of questions: What, Why, Where, When, Who, and How? Some people add How much? Less

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 : Less

Show More Responses
Google
Data Analyst was asked...December 23, 2012

If you have 10 bags of marbles with 10 marbles each and one bag has marbles that weigh differently than the others, how would you figure it out from one weighing

6 Answers

Assume all marbles are from 10g and the heavier one is 11g Take 1 marble from bag1 ,2 from bag2, 3 from bag3, 4 from bag4, 5 from bag5, 6 from bag6, 7 from bag7, 8 from bag8, 9 from bag9,10 from bag 10..and weigh them together Let it be W. So if bag5 contains the heavy marbles The total weight (W) will be 10+20+30+40+55+60+70+80+90+100 = 555. where as if all were of 10g it should have been 550. meaning the bag which is heavy will always be MeasuredWeight - 550 Mathematically if bag X is the one which is heavy, X can be found using one weighing of sample (W) - (N(N+1)/2) Less

Terribly worded question; you never specified that we are given the normal and heavy weights. Without that information, the votes up solution here doesn’t work. Less

Using a series sum [N(N+1)/2], will not work in this case, as we've not been provided with enough specifics (such as "whats the standard weight of the marbles?). In fact any solution dependent on summed weight will have overlapping solution space and fail. Consider if the standard weight is 10 ounce per marble, and bag 1 is the exception at 12 ounce per marble, for a total weight of 552. Now consider if bag 2 is the exception at 11 ounce per marble - also for a total weight of 552. There is no way to distinguish between the two cases. Given the setup, if appears the interviewer did expect the answer to use some variation of summed series, and I suspect the poster has paraphrased the question and missed some key language - and as best I can tell is not solvable as stated. Google will expect you to provide a generalized solution that can be automated, so the "add the bags one at a time", while simple and clever, would probably not be acceptable as a "weigh only once" solution, and if accepted would be a lesser answer as it does not provide a code-able business solution. Less

Show More Responses
Wolters Kluwer

In an environment of layoffs and restructuring, how do you keep your team motivated?

4 Answers

Be open and honest if their roles are in jeopardy. Understand their concerns and answer their questions as best you can. If you do not know, say so. Keep them busy, and involved in important work. Less

Mo on g ok ok lfNikki

Stay positive, and focus on the work at hand. Keeping busy on important work helps people realize what they are doing is important. An ideal mind is the devil's.... well, you know the old saying. Be sure the physical environment is welcoming. In summer, raise the blinds, clean the common areas of papers and clutter. You will be amazed how much better things look when you take 10 short minutes a day to make the physical environment look better. The sun is out, blue skies, and maybe it's not so bad here. Let people vent. If you are not holding 1-on-1 meetings, then start. Hear people out. Be honest about what you can talk about. Don't sugar coat anything, but give those more junior to you some context and a bigger view. Sure some people will be laid off, but most will remain. Opportunity to do different things will become available. Sure you will work harder, but you will learn, growth, and build your reputation for having a level head in complex times. Lastly, have a plan. Know what you will do as a manager if you have to layoff 1,2 or 3 people. Know how the work will move around. This will allow you act quickly and decisively should things come to that. Having a manager who looks in charge because they already thought it through will go a long way. Less

Show More Responses
Enova

If you have a 5*5*5 cubic, what is the outside surface area?

3 Answers

Its surface area...not volume .So answer should be 6*(5*5)

Looking at the first answer makes me doubtful about what a cubic means. If its a cube only, then the answer should be 6*(5*5), as mentioned above. Less

The simplest answer will be 5*5*5-3*3*3=98

Capital One

You own a Beach souvenier shop that sells primarily 4 items. Calculate Profit per month. What are some issues you could forsee in your revenue streams? After additional information is given, calculate seasonal income.

2 Answers

Being told to calculate profit is always a tricky scenario, especially for an analysts perspective. You want to be clear about the profit they actually want calculated. Remembering that profit, in base form, is going to represent anything after that break even point. Simply put, as the owner, your salary is going to be configured into the operating costs. So, let's say your operating cost is 100k a year and this includes your salary, then any dollar made after 100k is "profit". However, this does not totally detail other forms of profit, such as economic profit. This is where you are measuring and analyzing missed and made opportunities versus the profit you brought in. So, one issue you could foresee in your revenue stream is that carrying a 5th product may increase opportunity costs, but potentially the 5th item causes the 4th item to sell at a higher rate as they're often sold in conjunction. Studies show, for example, that a person that buys a beach volleyball is not likely to buy a volleyball net. But those that buy a beach volleyball are 3x as likely to buy a portable air pump. I don't mean to over think it, but you'll notice there's four items that are being sold. You own a business that is contingent about the seasons of the year, which there are also four. To me this speaks directly to the significance of weather in your business and this is not something the employer would want you to miss. Issues in revenue streams here would be a lack of product adjustment due to weather. To me, in an instance like this, if an employer asks you such a soft, information less question, you are doing yourself a disservice if you do not start asking them questions about what they want. Be sure to clarify if they're asking you to calculate profit or forecast profit. Less

From an analyst’s perspective, simply being told to calculate profit can be a tricky demand, especially in an interview setting. You want to be clear about the profit they actually want calculated. Remembering that profit, in base form, is going to represent anything after the break-even point. Simply put, as the owner, your salary is going to be configured into the operating costs. So, let's say your operating cost is 100k a year, and this includes your salary, then any dollar made after 100k is "profit". However, this does not totally detail other forms of profit, such as economic profit. This is where you are measuring and analyzing missed and made opportunities versus the profit you brought in. So, one issue you could foresee in your revenue stream is that carrying a 5th product may increase operating costs; but potentially, the 5th item causes the 4th item to sell at a higher rate as they're often sold in conjunction. Studies show, for example, that a person that buys a beach volleyball is not likely to buy a volleyball net. But those that buy a beach volleyball are 3x as likely to buy a portable air pump. I don't mean to over think it, but you'll notice there's four items being sold. You own a business that is contingent upon the seasons of the year (also four). To me this speaks directly to the significance of weather in your business and this is not something the employer would want you to miss. Issues in revenue streams here would be a lack of product adjustment due to weather. To me, in an instance like this, if an employer asks you such a soft, information less question, you are doing yourself a disservice if you do not start asking them questions about what they want. Be sure to clarify if they're asking you to calculate profit or forecast profit. Also, any time someone asks you what issues could arise in revenue streams, immediately think SWOT. Strength, Weaknesses, Opportunities, Threats. Always think SWOT when heading into any BA or PM position. It will quickly allow you to analyze almost any situation. Less

J.P. Morgan

How do you manage project timelines with change requests?

1 Answers

To do time estimations on the change request and then you swap something that is in scope for the change being requested. Less

Osage Bio Energy

How to calculate the NPV of a new opportunity

1 Answers

haha, NPV is basic for a Financial Manager, If you wanna do it exactly you have to llok at expected interest rate for your period, then calculate the Cash flow of future years ,then discount them by geometrical average of interest rate. Less

Domino's

How do you know when you have enough documentation?

1 Answers

Too much documentation has never been an issue in projects I've worked on in the past. I feel there's enough when, at a glance, new people coming into the project can be caught up quickly. The way I write my stories allows QA to build an easily readable Cucumber test suite that serves as documentation on features, and I let developers create their own documentation on project set up. Other documentation may include mockups and flow charts but are primarily used for estimation and feature building. Less

Viewing 1 - 10 of 77,103 Interview Questions