Hey,
Do generalists MBB consultants use Python or Sql at all to build models, sort data, analyse data etc?
is this a skill worth learning?
Cheers,
Get Active in Our Amazing Community of Over 452,000 Peers!
Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Case Partners to connect and practice with!
MBB Consultants - Python/ SQL?
Overview of answers
Upvotes
Best answer
Can confirm that we don't use either at Bain - but we have an "advanced analytics group" that will help with big data/complicated analysis.
What we do use, to an increasing degree, are Tableau (data visualisation software) and alteryx (which is a "user-friendly" data analysis tool for large/complicated data sets). Alteryx has much of the functionality of Python (with less flexibility), but is designed to be used by non-techy people - see a demo here: https://www.youtube.com/watch?v=FptWsowYkIM
I do know that at Oliver Wyman Middle East they do teach the generalist consultants how to use SQL, and even have some training classes to use Python. The truth is that Excel is increasingly not sufficient to meet data crunching/processing needs, so firms need to evolve by moving towards more powerful tools.
Was this answer helpful?
Hi,
- Most of the generalist consultants don't use SQL or Python.
- MBB firms have dedicated research people to run complicated models, programming and crunch big data
- However, I've seen generalist who had this skill and used it as a spike. You can get amazing reviews for the project if you can code or analyze big data. It's always good when people know you as a guy "who can do these automated dashboards"
- Longterm I think SQL will be a must skill for consultants. They are already starting to use Tableau, etc on a regular basis. SQL is next
Best!
Was this answer helpful?
No! Python/SQL is not used by generalist consultants. This is the domain of data scientists, which are more and more supporting day-to-day work of the project teams (on- and off-site) in firms like McK and BCG.
Cheers, Sidi
Was this answer helpful?
Hi,
I agree with Vlad - most of the generalist consultants don’t use SQL or Python, however if you have this skill this may indeed get you great reviews.
BUT (I’ve seen this not in MBB but in other firms - it may be true for MBB however): You do run the risk of becoming THE SQL / Python guy, who is staffed on purpose on projects where these skills are needed. So if you decide to learn this skill and specialise in it, make sure you either like becoming the expert or actively address this issue with your staffer.
Best
Was this answer helpful?
Hello!
In McKinsey, we used Excel 99.5% of the cases -the Advance Analytics hub took care of the more difficult stuff-.
In Amazon however, people regularly know SQL on top of Excel.
Hope it helps!
Cheers,
Clara
(edited)
Was this answer helpful?
Related Cases
Company case by Bain & Company
Style:
You have inherited the “Old Winery” from your grandfather, a winery that 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 a conventional way, i.e. they
...
You have inherited the “Old Winery” from your grandfather, a winery that has been family-owned for five generations and can be dated back to the 16th century.Half of the eleven hectares are
...
(Open whole case)
118.3k
Times solved
Intermediate
Difficulty
Expert case by Francesco
Our client is SmartBridge, a nonprofit educational institution offering face-to-face tutoring services. The client operates in the US.The mission of SmartBridge is to help as many students as possible to complete studies and prevent that they drop from the school system, in particular in disadv
...
Our client is SmartBridge, a nonprofit educational institution offering face-to-face tutoring services. The client operates in the US.The mission of SmartBridge is to help as many stude
...
(Open whole case)
31.6k
Times solved
Advanced
Difficulty
Expert case by Bernard
The COVID-19 pandemic has killed millions of people worldwide and led to devastating economic impact. A vaccine is one of the biggest hopes for stopping the pandemic. The World Health Organization (WHO) is working with multiple stakeholders to ensure groups at higher risk of becoming infec
...
The COVID-19 pandemic has killed millions of people worldwide and led to devastating economic impact. A vaccine is one of the biggest hopes for stopping the pandemic. The World Hea
...
(Open whole case)
18.3k
Times solved
Advanced
Difficulty
Expert case by Luca
Espresso Whatelse is an Italian company that produces coffee and espresso machines since 1908. It is the Italian market leader and has a strong presence overall in Europe. In 2019, Espresso Whatelse has increased its revenues but it has seen declining profit margin.Your client wants to understa
...
Espresso Whatelse is an Italian company that produces coffee and espresso machines since 1908. It is the Italian market leader and has a strong presence overall in Europe. In 2019, Espr
...
(Open whole case)
17.4k
Times solved
Advanced
Difficulty
Expert case by Francesco
Style:
Our client is a BlissOttica, an Eyewear Manufacturer that is looking to reach a 10% increase in profits. How would you help our client?
Our client is a BlissOttica, an Eyewear Manufacturer that is looking to reach a 10% increase in profits. How would you help our client?
(Open whole case)
13.6k
Times solved
Intermediate
Difficulty
