The typical "difficult" question that comes up in Business Intelligence is (and I'm paraphrasing), "What's the best data warehouse solution?".
Want the inside scoop on your own company?
Check out your Company Bowl for anonymous work chats.
Check out your Company Bowl for anonymous work chats.
"Employers are looking for business intelligence managers with advanced problem-solving and analytical skills, in-depth knowledge of industry practices, and sufficient leadership experience to utilize data to provide solutions for business strategies to the company. When interviewing for this position, you may be asked about your experience with prior leadership positions, understanding of data management software, and knowledge of the industry you will be working in."
The typical "difficult" question that comes up in Business Intelligence is (and I'm paraphrasing), "What's the best data warehouse solution?".
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.
Offering 20% discount increases sales by 25% - what's the impact on financials, operations, marketing
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?
- Tell us about your experience based on what is mentioned on Resume and questions related to that. - How to acquire new customers? - What are the area's and KPI that you would look at.
Run me through your CV?
I was asked to solve one puzzle question.
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?
Questions around stakeholder mgmt , process , hiring / firing