there was a case study you had to do
Strategy And Analytics Interview Questions
200 strategy and analytics interview questions shared by candidates
SQL assessment, live Excel assessment, then typical behavioral questions, like walking through a project and asking what sort of work styles you have
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.
Explain a complex project you've had like you would to your mom or grandma
How have your dealt with working with colleagues/seniors you haven't gotten on so well with?
Give me a time when...
Q1) Why do want to work for PA? Why this particular Role? Why you are a good candidate ? Career aspirations ? Q2)In pa we believe in achieving success through aspirations,collaboration. Tell us a time when you showed teamwork or collaboration? What was it? What was the outcome/success?
I'm afraid I can't answer this.
Quantitative case studies which test mental math, knowledge of financial concepts, and strategic thinking found in case preparation books
Mock situation where you needed to help a client decide where to expand their business in the US.
Viewing 191 - 200 interview questions