Expert with best answer


100% Recommendation Rate

53 Meetings

470 Q&A Upvotes

USD 319 / Coaching

Is life as an analyst/associate consultant etc, if you cut through the marketing noise about client exposure, really just being a data slave in excel?

Anonymous A asked on Sep 14, 2018 - 4 answers
4 answers

  • Upvotes
  • Date ascending
  • Date descending
Best Answer
Benjamin replied on Sep 14, 2018
ex-Manager - Natural and challenging teacher - Taylor case solving, no framework
Book a coaching with Benjamin

100% Recommendation Rate

53 Meetings

470 Q&A Upvotes

USD 319 / Coaching


as explain by Elias, this depends on the combi project / team / self positionning, which can make the day to day job as analyst completely different. Let me describe here several project situation you could face as analyst to give you an idea :

  • Project situation 1 : analytics intensive

This corresponds to the situation you described, where appart the client facing dedicated to data collection, you'll spend you time crunshing data on excel. Depending on your performance, you will receive data on the analysis to perform or decide on your own.

  • Project situation 2 : market research intensive

Assume you're working on due diligence project. Your tasks will most likely be dedicated to gather marker data et understand how the market is structured. To do that, you will either perform calls to internal expert, cold to calls to industry expert, reports review, and finally you will have to synthesis this data. So depending on the data you gather this could be / or not excel intensive in case the data you're gathering is more qualitative

  • Project situation 3 : client interaction intensive

Some project such as PMO (project management office) require lots of client interaction and project management skills. You may only use excel to keep tracking of the project but not for data crunching.

  • Project situation 4 : acting as "next grade"

Depending on the staffing available, and you current progression in the firm, you will be exposed at some the next grade responsibilit, and believe me this is not only about excel

To conclude, even if some project are lesst data intensive, keep in mind that in a junior position within a strategy consulting firm you should expect some heavy data computation project at some point.

Hope this helps


updated his answer on Sep 14, 2018
Experienced strategy consultant, now running own consulting business
Book a coaching with Elias

2 Meetings

301 Q&A Upvotes

USD 149 / Coaching

Short answer: It depends...

It depends on:

  • Your project: Some projects are extremely interactive, some are just number-crunching in a windowless room in the basement. Sometimes you work with people on all levels of the organisation (making exposure more likely), sometimes you work directly for the board, investors or other top execs (making exposure a lot less likely). Also politics come into play. If someone with influence at your client's (investors, worker's council, supervisory board...) is pissed that management is spending tons of money on consultants, you might want to keep that door shut. Also in tough restructuring programs you may want to keep a low profile (I've had projects where we were told to dress down to not stand out and maybe be a target of physical violence or other attacks from somebody who may just have been laid-off and is blaming us (rightly, in some cases) for it.
  • Your team & your mananger: Some project managers will encourage client interaction, some will shield you from it. If you're severely understaffed, you'll get more time in the sun (and the moon ;-) ) and be thrown into situations above your paygrade, then in a solid team setting with sufficient resources.
  • YOU: If you are great at client interaction, building rapport and relationships and are a kick-ass presenter you'll be trusted to do more of it. If you are not yet good at these things, you'll get less of it. I know colleagues who were entrusted to do management presentations one or two years into the job because they knew their shit and they were brilliant at it. I also know senior project managers who were never allowed to do important client meetings alone. They were great project managers and brilliant minds, just more than just a bit socially awkward. And, last, but not least: Do you ask for it? If during your development talks you make it a key point to ask for projects with more client exposure, you'll get them eventually. Just don't screw it up, then ;-)

So there is no general answer. You'll do a lot of data slaving for sure, but chances are you'll also get your shot at the spotlight.


replied on Sep 19, 2018
Ex-MBB, Experienced Hire; I will teach you not only the how, but also the why of case interviews
Book a coaching with Guennael

99% Recommendation Rate

264 Meetings

1,246 Q&A Upvotes

USD 269 / Coaching

No - you will also be a PowerPoint Monkey. We've all been there.

Srsly - the experience is fantastic and preps you for a multitude of various roles in the 'real world'.

replied on Sep 15, 2018
Bain & Company | University of Cambridge | CV/Resume writing | 770 GMAT
Book a coaching with Alessandro

100% Recommendation Rate

66 Meetings

813 Q&A Upvotes

USD 149 / Coaching

Agreed with Benjamin and Elias - it really does vary so much. I've been on cases where Excel was the focus, but also on cases where I basically never used Excel and was in client meetings 5+ hours a day. Part of this is up to chance, and part of it is your choice (i.e. pushing for specific types of staffing to meet your development goals).

Related BootCamp article(s)

Getting Up to Speed

In order to repeatedly demonstrate prerequisite skills under the pressure of a real case interview, you need to learn the basics and practice cases.

Interviewer-Led vs Candidate-Led cases

Case Interviews can be led by the candidate or by the interviewer: In Candidate-led cases the main challenge is the structure. In Interviewer-led cases the main challenge is to adapt quickly

Related case(s)

Bain case: Asian lubricants producer

Solved 104.2k times
4.7 5 27503
| Rating: (4.7 / 5.0)

LubricantsCo, a very successful Asian premium producer of lubricants in their native region, would like to further increase their revenue and profit. The product range ranges from lubricants in the automotive sector (e.g. motor and gear oil) to industrial applications (e.g. fats, heavy-duty oils). ... Open whole case

Bain Case: Old Winery

Solved 40.7k times
4.4 5 1058
| Rating: (4.4 / 5.0)

You have inherited the “Old Winery” from your grandfather, a winery which has been family owned for five generations and can be dated back to the 16th century. Half of the eleven hectares are used to grow white grapes, the other half to grow red grapes. They are grown in the conventional way, i.e. ... Open whole case

McKinsey Questions

Solved 33.3k times
4.5 5 835
| Rating: (4.5 / 5.0) |
Difficulty: Intermediate | Style: Fit interview | Topics: Personal fit

Tell me of a situation where you had an opinion and no one seemed to agree with you. What was your goal when you decided to join university / work / clubs / a sports team? Did you have a goal that you were not able to reach? What did you do? What do you want to be remembered for and how are you a ... Open whole case

BCG Questions

Solved 22.9k times
4.5 5 201
| Rating: (4.5 / 5.0) |
Difficulty: Intermediate | Style: Fit interview | Topics: Personal fit

What arouses your interest when you are working / studying / doing another activity (from the CV)? Tell me of a time where you had no idea what you were doing. When did you use an uncommon approach to do something? Have you ever had responsibility for other people? Tell me of a situation where y ... Open whole case

Bain Questions

Solved 22.1k times
4.6 5 278
| Rating: (4.6 / 5.0) |
Difficulty: Intermediate | Style: Fit interview | Topics: Personal fit

Tell me about a difficult situation you had to cope with. Tell me of a task which you didn’t like doing and explain why you performed it nevertheless. Why do you do things? What do you like doing most / What is your favorite hobby? Walk me through a situation where you showed leadership skills. Open whole case