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?
Business Intelligence Specialist Interview Questions
6,923 business intelligence specialist interview questions shared by candidates
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.
probability of the product coming from location A is 0.8 and from location B is 0.6. What is the probability the customers will receive the product from location A or location B SQL - tested on different join , lead , lag, pivoting in sql , sub query, group by having, where, aggregate and think about how you would find outliers)
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?
Derive customer's account status as of month end for all the months in 2019. If for given month, there are more than one rows, pick the data from the latest date within the month. If for given month, there is no data, pick the data from latest date prior to the month You can use last_day function to get month ending date(Eg: last_day(01/01/2015) = 01/31/2015) customer_id event_date status credit_limit 1 1/1/2019 C 1000 1 1/5/2019 F 1000 1 3/10/2019 1000 1 3/10/2019 1000 1 8/27/2019 L 1000 2 1/1/2019 L 2000 2 1/5/2019 2500 2 3/10/2019 2500 3 1/1/2019 S 5000 3 1/5/2019 6000 3 3/10/2019 B 5000 4 3/10/2019 B 10000
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
1. What would you do the first few weeks on the job? 2. Would you rather be in a creative or hierarchical, structured environment? 3. What makes you different than other candidates? 4. Strengths and Weaknesses 5. What type of people do you work best with? 6. Describe yourself in 6 words.
Schemas - Sales (sales_id, date , customer_id, Product_id, purchase_amount): Product (P_id, P_Name, Brand_id,B_name) Top 10 products in year XXXX Top 10 products in each year List of customers whose total purchase increased from XXXX-XXXX but decreased from XXXX-XXXX. List of customers who bought both brands "X" & "Y" and at-least 2 products in each brand.
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
Question 5 : An ad campaign has a CPC = $0.5, a conversion rate = 3% and an average transaction value of $260.What is the Cost of Sales of the campaign (cost of the ad campaign divided by the revenues generated, in percentage)? Question 6 : With a margin on revenues of 13%, an average transaction value of $290 and a conversion rate = 0.7%, what is the maximum CPC an advertiser can afford without losing money (in dollar)? Question 7 : During his browsing, a user is randomly exposed to two ad banners A & B. Those two banners are equally likely to be shown. One and only one banner is shown per page. After two pages of browsing, what’s the probability that the user was shown only banners A (in percentage)? Question 8 : A/B Testing campaign: Measuring the impact of Criteo retargeting ads compared to a control group. Number of transactions on client site : • Group A exposed to Criteo banners 600,000 • Group B Control group not exposed 50,000a. b. What incremental revenues per user CompanyA has generated for the client advertiser (in dollar, rounded to the cent)? c. What total incremental revenues CompanyA has generated for the client advertiser? Total incremental revenue is simply the incremental revenue per user multiplied by the number of users exposed to Company A's retargeting. d. With $200.000 revenues following clicks on banners for group A (post click), what is the related post view (view through) effect in revenues generated by CompanyA campaign? View through effects on revenues are a bit tricky as they would require view through conversion tracking. A post impression visit that results in a transaction can be credited as a 'view through conversion'. If CompanyA is not tracking revenue on post-impression ('view through') visits, then you can estimate it by taking the average revenue per transaction - in this case $200,000 - and divide it by the number of post-click transactions in group A. This would give you the average revenue per transaction, often referred to as Average Order Value. You could then take the Average Order Value and multiply it by the number of view through conversions generated by Company A.
Viewing 1 - 10 interview questions