A simple walkthrough of how real consulting projects run, who does what and what students should learn to be job-ready today.
Imagine this: a large retail company calls a consulting firm because “sales are falling.” When a team from McKinsey, BCG or Bain walks in, the first job is not solving the problem. It is redefining it.
Is it falling demand? Poor pricing? Bad store locations? Weak marketing? Supply chain issues? In consulting, this stage is called problem structuring. A typical project starts with:
- A Partner who owns the client relationship
- A Project Leader (PL) who runs the day-to-day work
- 2-4 Associates/Analysts who actually do the analysis
In the first week, the team builds something called an issue tree. Think of it as breaking a big vague question into smaller answerable pieces. Example: “Why are sales falling?” becomes:
- Are fewer people visiting stores?
- Are customers buying less per visit?
- Are prices too high or too low?
This is where Excel and PowerPoint quietly enter the story. No fancy AI yet. Just structured thinking. This is exactly what you will be expected to do in internships. Not solve everything. Just break messy problems into smaller, logical pieces.
The Work Is Mostly Data and Deadlines
Once the problem is clear, the real grind begins. Consulting is not about big ideas every day. It is about turning data into decisions. A typical 6-8 week project looks like this:
Week 1-2: Understand and frame the problem
- Talk to client teams
- Collect internal company data
- Define what to analyze
Week 3-5: Analysis phase
This is where analysts spend most of their time:
- Cleaning messy Excel data
- Running basic analysis (growth rates, comparisons, trends)
- Building simple models
For example:
- Comparing store performance across cities
- Analyzing customer segments
- Looking at pricing vs competitors
According to industry estimates, consultants spend 60-70% of their time on data analysis and slide creation, not strategy thinking. Tools used:
- Excel (still the most important tool)
- PowerPoint (for communicating ideas)
- SQL (for pulling data, sometimes)
- Python (in more advanced teams)
- AI tools like ChatGPT (increasingly used for summarizing data, drafting slides and brainstorming)
Week 6-7: Synthesis
This is the most important step. You move from “we analyzed 100 things” to “these 3 insights actually matter.” Example:
- Footfall dropped 20% in Tier-2 cities
- Pricing is 10% higher than competitors
- Online competitors are taking share
The Output Is a Story, Not Just Analysis
Consulting is primarily about telling the clearest story. The final output is usually a slide deck presented to senior management. Example recommendations might be:
- Reduce prices in selected categories
- Shut down underperforming stores
- Invest in online channels
Each recommendation is backed by analysis, but presented simply. This is where many students struggle. They think “if I do good analysis, I’m done.” But in reality, if analysis is not communicated clearly, it has no value. This is why PowerPoint is as important as Excel.
AI then comes into the picture. AI is not replacing consultants. It is changing how they work. For example:
- Summarizing 50-page reports in minutes
- Generating first drafts of slide decks
- Cleaning and categorizing data
- Brainstorming hypotheses
A recent McKinsey estimate suggests generative AI could automate 20-30% of current consulting tasks, especially repetitive ones. But the core job remains:
- Structuring problems
- Interpreting results
- Communicating decisions
Practical Takeaways for Students
If you are aiming for consulting or any business role, here is what actually matters.
- Learn to structure problems: Practice breaking big questions into smaller parts. Case interviews test exactly this.
- Get comfortable with Excel: You do not need advanced finance models. But you must:
- Clean data
- Use formulas
- Create simple charts
- Learn how to present ideas clearly: Start using PowerPoint seriously:
- One idea per slide
- Simple charts
- Clear headlines
- Use AI as a helper: AI outputs must always be verified and refined.Use tools like ChatGPT to:
- Summarize reports
- Draft slides
- Generate ideas
- Focus on clarity, not complexity: In real projects, the best work is not the most complicated. It is the most understandable.
Consulting looks glamorous from the outside. Inside, it is structured thinking, disciplined analysis and clear communication. If you can learn those three skills early, you will not just crack consulting. You will perform better in almost any business role.
Stay connected with us to explore endless opportunities at Praxis Business School!
Visit our website at https://praxis.ac.in/ to learn more about our programs, admissions, and campus life. For any queries, feel free to reach out to us at https://praxis.ac.in/contact-us.
Follow us for the latest updates, insights, and success stories.
We look forward to connecting with you!