How much time do consultants spend working with data on spreadsheets/powerpoints?
Overview of answers
Upvotes
Best answer
Most of it!
And the time you are not working with the data crunching numbers, you are:
- Working with the clients trying to get the cited data or validate it
- Presenting data-driven conclusions to clients or leadership
Hence, client management skills are equally important.
However, key thing is to be pretty confortable at least with Excel by the time you start, in order to survive -deadlines are super tight-.
Hope it helps!
Cheers,
Clara
Was this answer helpful?
Hello there,
Consulting's bread and butter is data-drifven problem solving, meaningt that as much as possible, each core issues identified and recommendations formulated need to be based on a certain logic supported by data.
As such, 70-80% of the time is spend on requesting, consolidating, analyzing, and pulling insights from data. Now, there are various kinds of data, numerical data in form of spreadsheets, observational data points, or anecdotes (non-numerical data which involves statements from various sources).
The rest are typically spent to interact and help your client couinterpart in their top-mind issues.
For some projects, more client handling is required, but still we spent the other times mostly to build a sound structure supported by tangible logics and data.
Hope it helps.
Kind regards,
Nathan
Was this answer helpful?
Hello,
As other experts said, it depends on the project and on the team. Usually in a team there is a responsible for the excel model and a responsible for the presentation. You will anyway spend on average 70% of the time with excel and powerpoint, half of that handling data.
Best,
Luca
Was this answer helpful?
Hi,
it strongly depends on the project, but they will be your basic tools. You are going to work with these at least 2 hours a day.
Best,
Antonello
Was this answer helpful?
Hi,
It really depends on the project. I would say that depending on the day / type of project you will spend 1-5 hours with the client. Rest is internal team brainstorming and coordination and excel / ppt. FYI the day can be 12-18 hours:)
Best
Was this answer helpful?
Related Cases
Expert case by Francesco
Topics:
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 di
... (Open whole case)
22.1k
Times solved
Advanced
Difficulty
Expert case by Francesco
Style:
Topics:
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)
5.2k
Times solved
Intermediate
Difficulty
Expert case by Ian
Style:
Topics:
Our client is Energy England, one of northern England’s largest electric utility companies. They were created over the past decade through an aggressive series of mergers of existing utility companies each specializing in a single energy generation source.
Recently, the CEO has embarked on
... (Open whole case)
3.2k
Times solved
Intermediate
Difficulty
