Do we use or expect an individual to know Statistical Tools Like python/R/VBA or any other in the consulting industry?

Hey there,

Typically for general / integrative consulting, no you are not expected to know how to use statistical tools. (It doesn't mean you can't use them if you know how and feel you can generate some interesting insights for yourself - but this is not the expectation). However, if you're role is a tech consulting role or data science related, there may be some expectation to know relevant coding or specialised software related to that role.

All the best

Hi Guneet,

I would be happy to share my thoughts on your question:

• Knowledge of statistical tools such as Python, R, or VBA can be advantageous, especially for data-driven roles that require robust analytical skills. However, it is certainly not required, nor is it necessarily advantageous, for generalist strategy consulting roles.

If you would like a more detailed discussion on how to best prepare for your upcoming interviews, please don't hesitate to contact me directly.

Best,

Hagen

hey!

In consulting, whether you're expected to know statistical tools like Python, R, or VBA depends on the role and the firm's focus. For traditional strategy consulting roles, proficiency in these tools is usually not required, as firms often have specialized teams, such as McKinsey's QuantumBlack or BCG's Gamma, to handle advanced analytics. However, familiarity with these tools can be a plus, particularly if you're applying for roles in data-driven consulting or specialized practices. Always tailor your application to the specific position! 😊

Alessa 

Hi,

In general, strategy consulting firms do not expect you to know Statistical tools or programming.

However, to be more specific, it  depends on the type of role and firm you are applying to. 

For example, if you are applying to a strategy consultant role, you are not expected to know these tools. However, if you are applying to an entry level role where you may be joining some of their analytical or implementation teams, then these skill set may be required. Additionally, some firms focus more on analytical and implementation projects over others.

So my advice would be to read the job description for the role you are applying to understand the responsibilities and requirements.

Feel free to reach out if you have more questions.

Thanks,

Soh

As others say, the short answer is no. Here are two skills that can help beyond advanced Excel skills: 1) Alteryx for cleaning up and manipulating large amounts of data on Excel; 2) visualization with Tableau or other tools.

If this is your skillset and an area you want to continue growing in, I would target the specialty businesses folks have called out or boutique firms that focus on advanced analytics. You won't be fulfilled with a high-level model on excel, if statistics and analytics is your jam :) 

No, not at all. In some rare cases, it can be an advantage and you may use it, but it's usually not necessary.

Hi there,

No. It can definitely help with the speed and exhaustiveness of your analysis but in my time at McKinsey I had maybe a few people on my teams who were proficient in those tools.

Other things are much more important!

Cheers,

Florian