Business Interview Questions

153,406 business interview questions shared by candidates

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

Given the company forms a partnership with Hulu. The subscription fee is $2 per customer per month and ad revenue is $3 per customer per month, for additional customers. Hulu has 50 million subscribers and the adoption rate is 20%. How will this affect the company? How long can the company last without making loss?
avatar

Senior Business Analyst

Interviewed at Capital One

Aug 1, 2017

Given the company forms a partnership with Hulu. The subscription fee is $2 per customer per month and ad revenue is $3 per customer per month, for additional customers. Hulu has 50 million subscribers and the adoption rate is 20%. How will this affect the company? How long can the company last without making loss?

Viewing 71 - 80 interview questions

Glassdoor has 153,406 interview questions and reports from Business interviews. Prepare for your interview. Get hired. Love your job.