Analytics Manager Interview Questions

2,071 analytics manager interview questions shared by candidates

Base data: - 140000 hours/week, evenly distributed - President club members work 45% weekday and 10% weekend - Customers per hour: 1.0 / weekday, 1.5/weekend - Prez club convert 20% of customers to buyers -21,100 cars per week across all locations are sold each week -All consultants work 40 hours a week A) How many hours do Prez club associates work each weekday & weekend? (45000 for all weekdays, 4000 weeekends) B) How many hours do non-prez club associates work? (55,000 for all weekdays 36000 for all weekends) C) What is the conversion rate for non-prez associates? (Ends up being 10%) D) How many cars are sold by Prez and non prez club members each week / weekend E) If we make the prez club evenly distributed across the week (7,000 hours/day) what can we expect the difference in sales to be? F) Final answer is ~ a 2.5% increase in sales, which they would like you to point out is a significant increase to the bottom line. They do not want you to discuss the potential for cherry picking days, morale hits, or other externalities. You may be able to bring this up after the fact, but they want you to hit on the bottom line first.
avatar

Manager, Product Strategy & Analytics

Interviewed at CarMax

3.5
Jul 1, 2021

Base data: - 140000 hours/week, evenly distributed - President club members work 45% weekday and 10% weekend - Customers per hour: 1.0 / weekday, 1.5/weekend - Prez club convert 20% of customers to buyers -21,100 cars per week across all locations are sold each week -All consultants work 40 hours a week A) How many hours do Prez club associates work each weekday & weekend? (45000 for all weekdays, 4000 weeekends) B) How many hours do non-prez club associates work? (55,000 for all weekdays 36000 for all weekends) C) What is the conversion rate for non-prez associates? (Ends up being 10%) D) How many cars are sold by Prez and non prez club members each week / weekend E) If we make the prez club evenly distributed across the week (7,000 hours/day) what can we expect the difference in sales to be? F) Final answer is ~ a 2.5% increase in sales, which they would like you to point out is a significant increase to the bottom line. They do not want you to discuss the potential for cherry picking days, morale hits, or other externalities. You may be able to bring this up after the fact, but they want you to hit on the bottom line first.

Viewing 2021 - 2030 interview questions

Glassdoor has 2,071 interview questions and reports from Analytics manager interviews. Prepare for your interview. Get hired. Love your job.