Business Intelligence Manager Interview Questions

212 business intelligence manager interview questions shared by candidates

As memebers of the analytics team, we responsible for supporting all of Yammers other teams including Product dev & Eng, marketing, sales, Customer engagement and Exec team. Pick one of these teams and explain the problems it has and some ways you might go about solving them using data.
avatar

Business Intelligence Manager

Interviewed at Yammer

3.9
12 Apr 2013

As memebers of the analytics team, we responsible for supporting all of Yammers other teams including Product dev & Eng, marketing, sales, Customer engagement and Exec team. Pick one of these teams and explain the problems it has and some ways you might go about solving them using data.

Was asked to write queries for two problems - Q. Table: Customer_orders customer_id order_id order_day  123        27424624    25Dec2011  123        89690900    25Dec2010  797        12131323    25Dec2010  876        67145419    15Dec2011  Write SQL for customers who placed orders on both the days, 25th Dec 2010 and 25th Dec 2011? Customer_id order_id     order_datetime  1234         4141-4814     25/12/2010:06:15:00  1234         4141-4815     25/12/2010:06:20:00  1234         4141-4816     25/12/2010:06:41:00  1234         4141-4817     25/12/2010:06:50:00  8153         2525-1414     26/12/2010:07:13:00  8153         2525-1415     26/12/2010:13:10:10  Let's say I can combine two orders that are placed by the same customer within 20 mins of each other, what % of orders can be combined.
avatar

Business Intelligence Manager

Interviewed at Amazon

3.5
6 Sept 2018

Was asked to write queries for two problems - Q. Table: Customer_orders customer_id order_id order_day  123        27424624    25Dec2011  123        89690900    25Dec2010  797        12131323    25Dec2010  876        67145419    15Dec2011  Write SQL for customers who placed orders on both the days, 25th Dec 2010 and 25th Dec 2011? Customer_id order_id     order_datetime  1234         4141-4814     25/12/2010:06:15:00  1234         4141-4815     25/12/2010:06:20:00  1234         4141-4816     25/12/2010:06:41:00  1234         4141-4817     25/12/2010:06:50:00  8153         2525-1414     26/12/2010:07:13:00  8153         2525-1415     26/12/2010:13:10:10  Let's say I can combine two orders that are placed by the same customer within 20 mins of each other, what % of orders can be combined.

You have 50 coins that add up to $1. You go into a coffee shop to buy coffee that is $1. The shop has a policy that if you are a penny short, you can still get the coffee. You're about to pay and you drop one coin. What is the probability that you can still get a coffee?
avatar

Business Intelligence Manager

Interviewed at Yammer

3.9
10 Aug 2013

You have 50 coins that add up to $1. You go into a coffee shop to buy coffee that is $1. The shop has a policy that if you are a penny short, you can still get the coffee. You're about to pay and you drop one coin. What is the probability that you can still get a coffee?

You're playing a game with a friend where some third party flips a fair coin. You can choose a sequence of either Heads, Heads, Tails or Heads, Tails, Heads. Your friend gets the remaining sequence. Whoever's sequence occurs first wins. Which do you pick?
avatar

Business Intelligence Manager

Interviewed at Yammer

3.9
11 Aug 2013

You're playing a game with a friend where some third party flips a fair coin. You can choose a sequence of either Heads, Heads, Tails or Heads, Tails, Heads. Your friend gets the remaining sequence. Whoever's sequence occurs first wins. Which do you pick?

Viewing 1 - 10 interview questions

Glassdoor has 212 interview questions and reports from Business intelligence manager interviews. Prepare for your interview. Get hired. Love your job.