Intelligence analyst Interview Questions | Glassdoor

Intelligence analyst Interview Questions

1,235

intelligence analyst interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

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?

17 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%

One or more comments have been removed.
Please see our Community Guidelines or Terms of Service for more information.

Describe the different parts of an SQL statement

2 Answers

What is a clustered/non clustered index.

3 Answers

One or more comments have been removed.
Please see our Community Guidelines or Terms of Service for more information.

Whats the difference between inner join and outer join?

2 Answers

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 Answer

Explain/define "Weighted Average".

1 Answer

The typical "difficult" question that comes up in Business Intelligence is (and I'm paraphrasing), "What's the best data warehouse solution?".

1 Answer

Basic SQL questions. Describe a join to a non-technical person. How do you handle a query that does not perform quickly? They want to know that you can use 'explain plans', which I currently do not use (I'm still entry level). Select all customers who purchased at least two items on two separate days. Given a table with a combination of flight paths, how would you identify unique flights if you don't care which city is the destination or arrival location.

12 Answers

Wayfair is going to send 2 different catalogs to their customers. One of the catalogs costs 50 cents to make and is 50 pages long. The conversion rate for the catalog is 5% and each customer brings in 315 dollars. The second catalog costs 95 cents to make, is 100 pages long and each customer brings in 300 dollars from it. The profit margin is 30%. What should the conversion rate for the second catalog be to make at least the same amount of profit as the first one. After you find the conversion rate for the second one, there is a second part of the problem. Wayfair is planning to make a new catalog which is going to cost 10 cents more than the 100 page one. The more expensive catalog is going to be sent out to 20% of the customers while the remaining 80% are going to get the 100 page one. Assume the same 30% profit margin and 300 dollar profit from each customer. What should the conversion rate for the new catalog be in order to receive the same profit at the end?

11 Answers

SQL question - Table1 year| month| order_id| seller_id| book| quantity| prices 2008|June| 1|888|HP| 2| 2000 2008|June| 1|888|LoTR| 1| 1000 2009|July| 2|999|HP| 1| 1000 Q1. find avg quantity of books solder for every order_id every year? Q2. find max units of books sold for every order_id

6 Answers
110 of 1,235 Interview Questions