Worked at a big four for over 3 years however do not feel comfortable about my analyical/excel skills. Any idea on what type of analysis (strategy) consultants at a MBB perform? Should I refresh also my statistical know how? Thank you all for your great help!
In preparation to my job at Bain I would like to improve my analytical skills. Any advice on how to improve these?
Overview of answers
Upvotes
Best answer
Hi Anonymous,
I would assume you are referring to the actual job at Bain. In general there is no statistical analysis that should be performed in a strategy-consulting job (unless you have a background in statistics and they specifically hired you for that reason). As for excel, you will be mainly required to use two functions, vlookup and pivot tables. Of course, if you know macros and advanced formulas, that would also help, but likely not be necessary.
Besides that, below you can find some other general tips useful for excel:
- Review excel shortcuts – in the long run can save you a lot of time
- Never use the Hide function for cells – rather use the Group function
- Get used to do multiple backups in case anything goes wrong
- Always double check formulas before delivering the file – most of the time at the beginning you will find mistakes that could hurt your credibility
- Prepare drafts to show/ align with your supervisor before doing actual analysis – otherwise you may end doing very complicated things that will turn useless
Hope this helps,
Francesco
Was this answer helpful?
Hi,
I would concentrate on getting the right financial modelling skills and presenting your analysis in Power Point.
1) Financial modeling - the best course I know is Training The Street. Take Financial Modeling, Valuation, Maybe LBO. Also, learn the basic statistics tools
2) Power Point - Google for MBB presentations and try to replicate them. Search for tips and tricks in books / internet in parallel. Plus read "Say it with charts" and "Pyramid Principle"
And finally - take a long vacation before starting your job;)
Good Luck!
Was this answer helpful?
Hi - is this in reference to recruiting? Case interviews at MBB don't have a direct excel or analytical component per se.
In reference to the actual job, there is tons of excel analytical work. The majority of it is finding inferences from client data that we use to solve the problem. Happy to talk more in detail (currently work at Bain & Co.) via direct message.
Was this answer helpful?
Hello!
After +5 years of candidate coaching and university teaching, and after having seen hundreds of cases, I realized that the economic-related knowledge needed to master case interviews is not much, and not complex. However, you need to know where to focus! Hence, I created the guide that I wish I could have had, summarizing the most important economic and financial concepts needed to solve consulting cases, combining key concepts theorical reviews and a hands-on methodology with examples and ad-hoc practice cases.
It focuses on 4 core topics, divided in chapters (each of them ranked in scale of importance, to help you maximize your time in short preparations):
· Economic concepts: Profitability equation, Break even, Valuation methods (economic, market and asset), Payback period, NPV and IRR, + 3 practice cases to put it all together in a practical way.
· Financial concepts: Balance sheet, Income statement/P&L and Performance ratios (based on sales and based on investment), +1 practice case
· Market structure & pricing: Market types, Perfect competition markets (demand and supply), Willingness to pay, Pricing approaches, Market segmentation and Price elasticity of demand, +1 practice case
· Marketing and Customer Acquisition: Sales funnel, Key marketing metrics (CAC and CLV) and Churn, +1 practice case
Feel free to PM me for disccount codes for the guide, and I hope it helps you rock your interviews!
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.1k
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
Content Creator
#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success (➡ interviewoffers.com) | Ex BCG | 10Y+ Coaching
4,522
Meetings
44,965
Q&A Upvotes
392
Awards
1618 Reviews
