Business Interview Questions
101K
Business interview questions shared by candidates
50,000 shoppers with a 0.5% conversion rate for a chair that costs $250. Wayfair makes a 27% profit. Next, 50,000 shoppers will get a 10% discount. What is the conversion rate they must achieve to achieve the same profits as before?
13 Answers↳
This is incorrect Old revenue = 50000*250*.005=250*250 New revenue with conversion rate r% = 50000*r*250*.9 = old revenue = 250*250 r = .55% Less
↳
July 9 is wrong because the profit margin changes(As sale price changes, but the cost doesn't change) Less
↳
The new conversion rate is 0.944, Profit from case 2 = $16,875 and the third part, if this scenario actually occurred I would give a 10% discount (with the new conversion rate .944%) because the overall profit margin would remain same i.e. $16,875 Less
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↳
Thank You!!!
↳
nice!!
↳
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
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
What would you do to grow our business. How would someone know this if they were not from that industry.
3 Answers↳
The COO or what ever he's calling himself was a joke. He knew very little of the business and wanted everyone out of the firm that realized he was an insecure buffoon. The owner needed a son more than a leader. Less
↳
Out of the box thinking ideas come to people who are not from that business. Also the ideas that worked in other industries that we can use here. Less
↳
I would examine your 80/20 and profit margins and make determinations of where we were wasting our time and focus on the 80/20. The COO could not tell me event when I was hired what these were and he labeled himself as a numbers guy. What a joke. Less
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
Describe the different parts of an SQL statement
2 Answers↳
SELECT for which columns to include in the result, (tables must be present in the FROM clause), can also include aggregates like COUNT(), SUM(), AVG() FROM for which tables to select rows/attributes from WHERE which is used to filter rows based on a given criteria with comparisons (=, !=, , and keywords LIKE and BETWEEN), INNER JOIN and LEFT/RIGHT OUTER JOIN to combine data across multiple tables ORDER BY DESC/ASC to specify ordering of a specific column name GROUP BY to group data based on the tables passed HAVING to filter rows based on an aggregate used in the SELECT statement that cannot be used with the WHERE clause Less
↳
I described a simple statement: Select (Name all columns from tables or use * for all) From (table name(s)) Where (any conditions, join statements ect) Group By / Order By to sort or aggregate the data Less
Tell me about a time you used analysis to make a business-critical decision. Walk me through the analysis and outcome.
2 Answers↳
So is this a kind of Leadership Principle questions? Thank you for sharing your experience. Wondering have you tried Rooftop Slushie for your interview prep? I saw some posts similar with your experience - which are really useful for me so far. rooftopslushie.com Less
↳
I analyzed the output of all the machines on our factory sales floor and determined what the bottleneck machines were. I put in a request to purchase more of the bottleneck machines. The new machines alleviated the bottleneck in production, drastically speeding up the total output of the factory in the process. Less
What markets do you think Cisco should get into and why?
2 Answers↳
Webex: extend product and bring out a competing product for zoom, whatsApp. They have the technology, just need a data-center to support that free app scale. It will double their stock in 1-2 years. Less
↳
Cisco is already touching the SMB and consumer segment, esp. with its managed services. Public TelePresence at a low enough price would be extremely attractive to consumers in less developed areas. With Cisco's experience in using games to promote its products, offering game hosting as a managed service is not such a big leap. Less
What is a clustered/non clustered index.
2 Answers↳
I explained how a clustered index was in sequential physical order on disk and a non clustered index used pointers or a hash table for index lookup. I started to explain the advantages/disadvantages of each index type but the two guys interviewing me just seemed so confused and lost. I think I would have been better of simply saying "it makes lookup faster". Less
↳
I explained how a clustered index was in sequential physical order on disk and a non clustered index used pointers or a hash table for index lookup. I started to explain the advantages/disadvantages of each index type and how I would use them. Less
Whats the difference between inner join and outer join?
2 Answers↳
Specified in the WHERE clause, joins simply combine data from multiple tables in the result. INNER JOIN, the most common, returns the rows for which the given ON condition is satisfied for both tables. LEFT/RIGHT OUTER JOIN statements return all the rows from the specified table regardless if there is a match in the unspecified table, with the matching rows specified in the ON condition in the unspecified table. Less
↳
Inner Join returns values where the key between the two tables are the same, and values are present in both tables. Outer Join returns the Values from both tables, based on the key, even if there is not any data the joining table. If not value is available, then NULL is returned for that specific Row Data based on the Key Less