Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Interview Partners to connect and practice with!
Back to overview

Apart from excel which tools/softwares do consultants use?? Like SQL or tableau or anything else??

7 Answers
600+ Views
20
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Florian
Coach
on May 30, 2024
1400 5-star reviews across platforms | 600+ offers | Highest-rated case book on Amazon | Uni lecturer in US, Asia, EU

Hi Guneet,

If you are in strategy consulting it's mostly

  • Excel
  • PowerPoint

and rarely Alteryx and Tableau.

For every more advanced task, you are usually outsourcing the analytical work to internal analysts/support staff.

Cheers,

Florian 

Agrim
Coach
on May 30, 2024
BCG Dubai Project Leader | Elite Prep to dominate interviews | 10 years in Consulting + M&A | Free prep plan

Hi Guneet, the basics are always Excel and PowerPoint.

In PowerPoint - consultants also use ThinkCell and Efficient Elements.

Tools like Tableau / PowerBI / Alteryx / SPSS - are used - but seldom.

For project management - tools like Slack and Trello are used - depending on the organisation.

Other tools can include some proprietary systems - such as BCG Key.

Oliver
Coach
on May 30, 2024
Former BCG interviewer (75+ interviews for associates, consultants and MBA hires) | I will make your practice perfect

Hi,

Consultants frequently use:

  • Excel
  • Powerpoint

Less frequently (and heavily case dependent):

  • Tableau
  • PowerBI
  • Alteryx

Best,

Oliver

on Jun 05, 2024
Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer

Hi,

Everyone has made the point that excel and powerpoint are the basics. 

Beyond that on the job - you may end up using specific tools or software depending on 

  1. The needs of the project
  2. The availability of internal expertise
  3. Project budget (i.e. maybe you end up learning a tool because doesn't make sense to pay someone else to do it)

Nowadays more collaborative tools are being used - like Miro for whiteboarding etc. 

Alberto
Coach
on May 31, 2024
Ex-McKinsey Partner | Most experienced coach (15 years exp, +2.000 real interviews) | 95% success rate

Don't forget pen a paper :)

Pedro
Coach
on Jun 01, 2024
Bain | EY-Parthenon | Private Equity | Market Estimates | Fit Interview

SQL not really.

Tableau and Alteryx, it can happen. But you may spend 2 years in consulting and never touch any of these.

What you need is Excel and Powerpoint. And for the other, if necessary, you'll get training (by the way, they are fairly simple).

on May 31, 2024
#1 rated MBB & McKinsey Coach

Excel and Powerpoint are really the bread and butter. 

Slack is super popular as a teams communication tool. 

Tableau and Alteryx once you get into data science AA projects.

But that's about it. 

Most of the work is cognitively fancy, not technically fancy.

Best,
Cristian

Similar Questions
Consulting
Do consultants use AI for PowerPoint or excel or anywhere in the Process??
on Aug 24, 2024
Global
7 Answers
1.4k Views
Top answer by
Nilay
Coach
Former McKinsey Sr Engagement Manager | Trained McKinsey interviewer (100+ interviews, 500+ coaching sessions)
49
7 Answers
1.4k Views
+4
Consulting
Differences between the roles in McKinsey and Bain
on Apr 22, 2024
Global
5 Answers
1.8k Views
Top answer by
#1 rated MBB & McKinsey Coach
61
5 Answers
1.8k Views
+2
Consulting
Common Pitfalls to avoid on the job
on Jan 27, 2025
Global
6 Answers
800+ Views
Top answer by
Sol
Coach
FREE 15 MINUTE INTRO | 3 years experience |100+ coached case studies | Oliver Wyman, S& and SKP (London)
75
6 Answers
800+ Views
+3
How likely are you to recommend us to a friend or fellow student?
0 = Not likely
10 = Very likely
Thanks for your feedback! Your opinion helps us make PrepLounge even better.