159

Top Interview Questions

Sort: RelevancePopular Date

Jul 30, 2014
 Explain/define "Weighted Average".1 AnswerAn average in which each quantity to be averaged is assigned a weight. These weightings determine the relative importance of each quantity on the average. Weightings are the equivalent of having that many like items with the same value involved in the average.

Nov 21, 2014
 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?10 AnswersStep 1: Calculate profit (250 * 250 * 0.27 = 16875) Step 2: Calculate discount price (250 * 0.9 = 225) Step 3: Calculate price of chair (250 * 0.73 = 182.5) Step 4: Calculate profit margin ( (225 - 182.5)/225 = .19) Step 5: Calculate new conversion rate (225 * 0.19 * x = 16875) x = 395 395/50000 = 0.79% the new conversion rateThis 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%Scenario 1 Number of sales=50,000*.5/100 = 250. Revenue=250*250 = 62,500. Profit is 27%. Therefore 62,500 = 1.27*cost Therefore cost = 49,212.598. Profit = 62,500-49212.598 = 13,287.40. Cost of chair = 250/1.27 = 196.85 Scenario 2 Number of sales = 50,000*r/100 = 500*r (r is new converion rate) Revenue = 500*r*.9*250 Total cost = 500*r*196.85 Profit = 500*r(250*.9-196.85) = 13,287.40 500*r*(28.1496) = 13,287.40. Therefore r = 0.944. The first answer considers profit as margin (percentage of sales) which seems incorrect or needs to be clarifiedShow More ResponsesNumber 2 is wrong, number 1 is right. Just because revenues equal doesnt mean profits will equal - they sacrifice profits when they decide to give the saleDo they expect you to do this in your head, or will they give you pen/paper and a minute?July 9th Answer is the correct answer. It is not hard: Initial profit is = 50000 * 0.005 * 250 * 0.27 (No need for the calculator yet) After sale profit = 50000 * x * 250 * 0.01 * 0.27 (Still don't need the calc) The question asks for the conversion rate such that profit are the same before and after the sale, so... Initial profit = After Sale profit 50000 * 0.005 * 250 * 0.27 = 50000 * x * (250 - (250 * 0.01)) * 0.27 (divide through & cancel) 0.005 * 250 = x * 225 x = (0.005 * 250) / 225 x = 0.0056 or 0.56%You don't actually need to calculate anything other than the new conversion rate. Why? Look at the equation below: (customer sent = 50000) * (customer bought / customer sent = 0.005 conversion rate) * (revenue / customer bought = 250) * 0.27 (profit / revenue) gives (profit / customer sent). this should be equal to the one after discount. only (revenue / customer bought) changed -> it decreased 10%. therefore, conversion rate needs to increase by (1/0.9), which gives 5.56%.July 9 is correct. Nov 21 is incorrect.July 9 is wrong because the profit margin changes(As sale price changes, but the cost doesn't change)\$250 is the actual cost of the chair (profit not included) or the price listed？？

Aug 22, 2010
 Describe the different parts of an SQL statement1 AnswerI 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

Oct 28, 2011
 Whats the difference between inner join and outer join?1 AnswerInner 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

Apr 27, 2012
 You have a table called Order with Cust_ID, Order_Date, Order_ID, Tran_Amt. Select the top 100 customers with high spend over a year long period.3 AnswersSELECT Cust_ID FROM ( SELECT Cust_ID, SUM (Tran_Amt) FROM Order WHERE Order_Date between DATE_SUB( CURDATE() , INTERVAL 1 YEAR) AND CURDATE() GROUP BY (Cust_ID) ORDER BY SUM (Tran_Amt) DESC LIMIT 100) ; PS - I will suggest to replace the function CURDATE() and DATE_SUB( CURDATE() , INTERVAL 1 YEAR) with a date in number format for query performance. I don't think that we will executing the query more often.Select * FROM( Select Cust_id, Year, Totals, RANK() OVER (PARTITION by a.Year ORDER by a.Totals DESC) AS TopLimits FROM ( Select DISTINCT Cust_Id, DatePart(yy,Order_date) AS Year, SUM(Tran_Amt) OVER (Partition by a.Cust_id, DATEPART(yy,a.Order_date)) Totals FROM dbo.[Order] a ) a) b WHERE b.TopLimits <= 100 This is performs the top 100 for all the yearsSELECT TOP 100 Cust_ID, SUM(Tran_Amt) AS Total FROM Order WHERE Order_Date >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 12, Order_Date) ORDER BY Total DESC

Nov 4, 2014
 Questions about life work balance, pressure handling and math questions and brain teaser1 AnswerJust look through the interview tips on glass door and I think they covered a lot of questions they asked.

Mar 5, 2010
 Tell us about a boss that you didn't get along with and how you handled it.1 AnswerThe questions were really standard fare - nothing unexpected. The biggest barrier was the interviewers lack of knowledge of the BI system they were interviewing about.

Jul 15, 2013
 Give an example of a time when you influenced strategic decisions.1 AnswerPersonal narrative...