Analist Interview Questions

108,182 analist interview questions shared by candidates

(In SQL, what would you do if you want to have two tables' information based on the column in the first table? Ex.Table A has 1000 unique rows, table B has 100 unique rows, the both have col = Name. I want to have all the cols in both A and B but only for the 100 rows in B.
avatar

Business Analyst

Interviewed at The Home Depot

3.7
Apr 25, 2016

(In SQL, what would you do if you want to have two tables' information based on the column in the first table? Ex.Table A has 1000 unique rows, table B has 100 unique rows, the both have col = Name. I want to have all the cols in both A and B but only for the 100 rows in B.

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

Business Analyst

Interviewed at Wayfair

3.1
Jun 11, 2018

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?

Viewing 291 - 300 interview questions

Glassdoor has 108,182 interview questions and reports from Analist interviews. Prepare for your interview. Get hired. Love your job.