Intelligence Operations Specialist Interview Questions

1,390 intelligence operations specialist 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?
avatar

Business Intelligence Analyst

Interviewed at Wayfair

3
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?

Q1) Find the number of unique days each employee worked Emp Id Task Id Start date End date 1 1 Monday Wednesday 1 2 Monday Tuesday 1 3 Friday Friday 2 1 Monday Friday 2 1 Tuesday Wednesday Hint: Calendar day table or date dimension table Calendar_day Calendar_day_of_week Calendar_year Calendar_month 1900/01/01 Wednesday (3) 1990 1 Q2) How many customers placed orders every month? Table 1: Customer Date customer_id order_id units country 2019/07/01 A 112 5 US 2019/07/02 A 211 4 US 2019/08/02 B 511 4 EU 2019/09/01 C 322 1 JP 2019/09/01 C 322 2 JP 2019/08/05 A 378 6 US 2019/09/10 A 456 7 US
avatar

Business Intelligence Engineer

Interviewed at Amazon

3.5
Mar 15, 2020

Q1) Find the number of unique days each employee worked Emp Id Task Id Start date End date 1 1 Monday Wednesday 1 2 Monday Tuesday 1 3 Friday Friday 2 1 Monday Friday 2 1 Tuesday Wednesday Hint: Calendar day table or date dimension table Calendar_day Calendar_day_of_week Calendar_year Calendar_month 1900/01/01 Wednesday (3) 1990 1 Q2) How many customers placed orders every month? Table 1: Customer Date customer_id order_id units country 2019/07/01 A 112 5 US 2019/07/02 A 211 4 US 2019/08/02 B 511 4 EU 2019/09/01 C 322 1 JP 2019/09/01 C 322 2 JP 2019/08/05 A 378 6 US 2019/09/10 A 456 7 US

Along with the usuals, he asked "If it's 11:20 on an Analog clock, what is the angle between the two hands?" (note: that includes the slight rotation of the hour hand between the hours). I got it wrong three times, but he didn't care. He said he just had to ask because it was required.
avatar

Business Intelligence Engineer

Interviewed at The Church of Jesus Christ of Latter-day Saints

4.5
Sep 14, 2016

Along with the usuals, he asked "If it's 11:20 on an Analog clock, what is the angle between the two hands?" (note: that includes the slight rotation of the hour hand between the hours). I got it wrong three times, but he didn't care. He said he just had to ask because it was required.

Viewing 1 - 10 interview questions

Glassdoor has 1,390 interview questions and reports from Intelligence operations specialist interviews. Prepare for your interview. Get hired. Love your job.