Intelligence Interview Questions | Glassdoor

# Intelligence Interview Questions

739

Intelligence interview questions shared by candidates

## Top Interview Questions

Sort: RelevancePopular Date

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？？

### Manager - Business Intelligence at Baylor Scott & White Health was asked...

Jan 25, 2013
 The typical "difficult" question that comes up in Business Intelligence is (and I'm paraphrasing), "What's the best data warehouse solution?". 1 AnswerIt's a great question but analogous to asking, "What's the best house or the best car?". The answer depends on several factors. I'd start with requirements and budget and discuss what is possible within those parameters. If you watch "Property Virgins" on HGTV, the educational process is similar, as are the "buyers" perceptions.

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

Jan 23, 2011
 What reporting tools have you used? Actuate, Brio, Crystal Reports? How much experience have you had in scheduling jobs on Unix? Can you write XML and implement it?1 AnswerThe interviewer was interested in breath of experience rather than specific technical skill. Unix work with scheduling and XML skills are necessary, but not heavy (the same procedures are done over and over again). Emphasis was on selling yourself through experience.

### Associate Business Intelligence Analyst Developer at World Wide Technology was asked...

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

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.

Feb 23, 2012
 What is a Cartesian product?1 AnswerCross join returning all records and all fields within the query

Jul 26, 2016
 What is a clustered/non clustered index.2 AnswersI 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".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.