Werde aktiv in unserer Community aus über 451.000 Gleichgesinnten!

Verabrede dich zum Casen über das Meeting-Board, nimm an Diskussionen in unserem Consulting Q&A teil und finde gleichgesinnte Case-Partner, um dich auszutauschen und gemeinsam zu üben!

Programming Skills for Strategy Consultants

Data Analysis MBB
Letzte Aktivität am 16. Jan. 2020
4 Antworten
5,8 T. Views
Anonym A fragte am 9. März 2019

I'm a soon-to-be ex-strategy consultant looking to transition into strategy roles in industry and as I've been searching new roles, I've began to notice internal strategy roles demanding data analysis tools like SQL.

I understand that an internal strategy team may not have the budget to develop its own data analytics team like an MBB firm and may want an all-in-one hire, but are we moving to a time when stategists will be expected to conduct their own data analyses? In 5-10 years for example, will technical skill like SQL be neccessary to perform the job of a strategy comsultant (or corporate strategist.)? Do I need to go learn to code? Please share your thoughts.

Übersicht der Antworten

Upvotes
  • Upvotes
  • Datum aufsteigend
  • Datum absteigend
Beste Antwort
Vlad
Experte
antwortete am 10. März 2019
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School

Hi,

  1. Most of the generalist consultants don't use SQL or Python.
  2. MBB firms have dedicated research people to run complicated models, programming and crunch big data
  3. 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"
  4. 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!

War diese Antwort hilfreich?
Guennael
Experte
antwortete am 10. März 2019
Ex-MBB, Experienced Hire; I will teach you not only the how, but also the why of case interviews

I'll second Vlad's comment. Programming skills arent about to be required (you will never be as good as a true developer), but having a decent understanding / being able to run simple queries is and will remain a differentiator.

Case in point: i have a former Goldman Sachs guy in my bus dev team today, and his knowledge of Tableau + coding skills arent enough for him to develop brand new reports, but make us semi-independent when we want a specific data point. As a result, he has huge value to not only my team, but also even to accounting and finace (who can't always get what they need from Big Data guys). Guess who woll be the first to get a recognition, salary bump or promotion?

War diese Antwort hilfreich?
Anonym antwortete am 10. März 2019

It very much depends on the industry.

In very industries with huge amount of data (Banking, Telecommunications) - advanced data analysis is beneficial, however in sectors goods producing sectors the amount of useful data is not so high and therefore data analytics is not that crucial

War diese Antwort hilfreich?
1
Clara
Experte
Content Creator
antwortete am 16. Jan. 2020
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

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

War diese Antwort hilfreich?

Vlad

McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
429
Meetings
12.233
Q&A Upvotes
127
Awards
4,9
186 Bewertungen