And if this is the case, which programs would you recommend getting comfortable with (R, Python, Stata, etc.)? I am thinking about generalist roles at MBB and not data analytics.
Is it important to master statistical programs such as Python before joining MBB?


Hello!
No, honestly, not at all. Of course it´s a nice to have, but as a generalist, I never used Python -is true that my colleages with a very very strong mathematical or programming backgorund got envolved in very analytcal engagaments, in which they used it-.Â
However, if there is one thing I wish I had done before joining McKinsey, that would have been Excel. It can really be a game changer, so I would really focus on that (more than pptx, industry knowledge, etc., that are nice-to-have, but not deal breakers).
Excel skills are part of the core skill-set of consultants, and it´s great that you want to practice them. PFB a list of the most popular commands:
Basic operations: SUM, SUMPRODUCT
Text transformations: CONCATENATE, LEFT, RIGHT, & operator,
Connecting different datasets: VLOOKUP, HLOOKUP, INDEX(MATCH(),MATCH())
Conditional-based operations: SUMIF, COUNTIF, SUMIFS, COUNTIFS, COUNTA
Learn how to analyze data using Pivot Tables
There are plenty of online materials:
Microsoft Support: https://support.office.com/en-us/excel
Kubicle: https://kubicle.com/personal (go for the 7 days free trial - Excel for Business Analytics)
Hope it helps!
Cheers,
Clara

Hi,
It's not. Make sure you are a pro in Excel / PPT.Â
However, one thing to understand is that consultants love so-called "Spikes" - your unique strengths. If you have Python and can code, and if you apply it on projects - this will give you an opportunity for faster growth
Best

Not important at all!
You will never use data analytics in generalist consulting.
That said, having R, Python, Stata, etc. on your resume helps a lot (I have it on mine). It shows recruiters you can problem-solve, work with numbers, etc.
Furthermore, it is an excellent skillset to pair with strategic thinking, if you're looking at a career after consulting (again, a path I have taken).
That said, for the specific purposes of doing your job well at MBB, you do not need data analytics tools. You will really only use PowerPoint, Excel, Alteryx, and sometimes Tableau.

Hi there,Â
I confirm, there is no real need, but surely it can be useful for you.Â
Cheers, GB

The answer is no. You will be a generalist, while specialized skills such as those are usually handled by specialists. Â
That being said, the deeper an understanding of data science and data analytics you possess, the better more effective you’ll be and the better you’ll be able to work with such specialists. So it’s a very valuable thing to know.
Hope this helps,
Allen

I think it helps to be honest. BAs that had the skill were in much higher demand and also had a greater impact. Is it necessary? No. Will it set you apart? 100%
I would recommend:
- VBA
- Python
- Tableau
Best,
Udayan

Hi there,
I agree with Allen and Ken, you won’t need to know any programming language as a generalist.
You will mainly use Excel and PowerPoint. Knowing how to work with macros is a nice-to-have but not strictly required.
For some projects, Alteryx and Tableau may be useful as well.
Best,
Francesco

Hey there,
Absolutely no need.
From a McK perspective, you would have a ton of supporting resource if you would ever have to deal with Python et al.
As the first line of defense, there is the Global Helpdesk, which you should contact 5 minutes after you have been trying to figure out something (from Excel upward). If it gets more complex, there are all different kinds of teams to book for support over a few hours up to the duration of the engagement. Your role would then be more of a translator between analytics and the client.
I am sure BCG and Bain have similar resources.
Cheers,
Florian

Hello,
Not at all, mastering powerpoint and excel is more than enough for your analysis. A nice add-one would be Alteryx and Tableau (especially for BCG offices) but you will have training dedicated on that.
Best,
Luca

Not needed but learning Python for your own good can be very helpful. I learnt it over the last 2 years and have found myself really enjoying it and coming across as more credible in machine learning/AI related disccussions plus this is the future I think- I dont see how not having such skills in future will be an option.
There are some really good courses on Udemy and you can pace yourself too.Â

There's definitely no need to know any programming languages as a generalist. On top of Excel, you will only use Alteryx and Tableau of which there is always remote analytical support available.

Agree. No need to learn that before joining, but it might be helpful every once in a while.Â
It might give you a bit of an advantage in the CV screening stage. All firms are aiming at increasing the share of their teams that ar edigitally skilled and demonstrating that you have some prior experience in data science or more advanced statistical fields might give you a few points.Â

Hi, I confirm no programming skills are required for generalist roles in MBB
Best,
Antonello

Nice to be able to code in Python or ASM or C++ or Excel Makros, but no need for it. Do not forget that you will spend most of your time either in Excel, PPT, and always around people. I d much rather focus on that.
Read / work through:
keith ferrazzi - never eat alone (the bible on how to build and maintain professional relationships)
Bain - profit from the core
Bain - Lessons from PE that any company can use
Familiarize yourself with top-nodge slides of the firm you join as quickly as possible - no need to re-invent the certain design and design elements of every slide you do - there are proven templates that are used over and over again for good reason
Know how excel works - and how to create a client-friendly and colleague-friendly workbook! Most excels look messy, have no error controls, are intranspartent and lack commentary. This is the best way to leave a bad impression with more tenured consultants ....
Best,
Denis
Â










