All questions tagged analytics - Consulting Q&A - PrepLounge.com

Hi!

What do you mean by analytics? Is it data scientists / financial modeling experts?

Usually, it's the part of the research department or a dedicated data science team. McKinsey in the US and UK has a separate data science company in addition to in-house analytics

The selection process is similar (3-4 cases) + usually an additional data analytics exercise (can be solved in Excel / Tableau)

Best

I would suggest you to look into the industry focus, project types, and working approaches of these two companies.

Hi Patrick,

I have some colleagues working at advanced analytics at BCG. While it is a separate entity compared to Gamma, they may know the process a bit better. Just PM me for details.

Best,

Deniz

When I interviewed at GAMMA I got both business case interviews and technical case interviews. Business case interviews are as usual. Technical case interviews have the same structure with fit and Q&A, but includes a more technical case. E.g. our client is a grocery store chain who would like our help developing personalized promotions in their loyalty program. Typically you would then discuss defining the problem, what data you want and have, which models you would use, and how you would validate and test your model. I prepared by imagining problems like this for different companies, as well as by looking at past Kaggle competitions.

HI,

1- I would not say that... Several variables that are not under your control here (and that does not necessary link to your performance): office need, period of the year, specific HR plan for the office and for the year ...

2- Not at all. All the consulting firm are now introducing Data science roles that are proper consulting roles. The business need is changing and the clients require always more specific competences in digital, analytics ... Usually the DS consultants are worling with normal consultants in particular cases where the "digital" is much more relevant/ needed. More than a second class, I would say that it is the class of the future!

3- Im not super sure about this... but you cna probably check online. I believe they have a parallel track with a similar consulting career (similar seniority and pay)

4- Usually a DS consultant will take the interview... it can be related to the tool you can use (tableau, alterix ...) and the specific programming/ IT competences you have. I suggest you also to reach out some employees of that specific office... maybe they can help you understanding more deeply the office need and the type of cases they are currently doing. Clients from different geographies can have complete differnt levels of "digital need" and you want to make sure your competences are aligned with what they are looking for

Best Luck for the next steps!

Not a direct answer to your question, but make sure you are very comfortable with the math. 10-15 minutes/day on caseinterviewmath.com for example, will go a long way; this website will rank you per accurracy and speet against all other applicants - and the good news is you improve very quickly, just a few days typically.

PrepLoung also has solid math material btw. Make sure also to differentiate well between "percent" and "percentage point"; mixing the two up will show you as lacking rigor and may cause you to get mixed up quickly.

As to the case piece itself, don't forget to quantify: why? when? how much? + trends of course.

Hi,

Not sure if I understood your question correctly, however the best source of cost structures will be:

1) Cases - you simply solve 50-70 cases and get a broad knowledge of different industries, common pitfalls and questions. The key here - find good partners who already had case interviews with MBB companies

2) Company reports, equity reports, IB roadshow docs - usually have a good overview of company and industries. The most useful sources to understand what's going on with the companies

3) HBS cases - quite useful, but not sure if lot's of them available publically. Probably worth buying

4) Books - one good book about airlines with numbers and industry analysis can give you all needed industry knowledge. Just use the Kindle search

5) News, Industry blogs

You may approach cost-related problems in the following way:

1) Operational math problems. (e.g. Should we increase the speed of the elevator or just buy a second one? How should we reduce the queues? How should we increase the output of a factory?).

Structuring:

• Usually, you have to look at the process. Even the most complicated systems have the inflows and outflows

The key concepts that you have to learn:

• Capacity and utilization (both machine and people)
• Cycle time, Throughput time, Little's Law
• How the does lowest cycle time influence the production? (Lead time = cycle time of the slowest process)
• How can we mitigate the bottlenecks with low cycle time? (Buffer, Parallel process, speeding up)

2) Cost cutting cases

Structuring:

• What is the cost composition and what are the biggest costs
• Benchmarking of the biggest costs to find the improvement potential
• Process improvements to meet the benchmarks
• Costs and benefits of the proposed initiatives

The key concepts that you have to learn:

• Internal / external benchmarking
• Idle time
• Core processes (usually are optimized) and the supporting processes (usually are cut)
• Math structures (Frequency of operations * time per operation)
• Other useful structures (e.g. people - process - technology)

3) Bottleneck cases (e.g. Huge write-offs in the meat store or bottleneck on the bridge)

Structuring:

You draw a value chain and go through it to find a bottleneck.

E.g. for the meat write-offs it will be:

• Supplier issues (packaging, meat quality, warehousing)
• Transportation (Length, fridges)
• Store (Refrigerators in the warehouse, in-store fridges, demand for the meet)

Feel free to reach me for further help with these cases.

Best

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:

1. Review excel shortcuts – in the long run can save you a lot of time
2. Never use the Hide function for cells – rather use the Group function
3. Get used to do multiple backups in case anything goes wrong
4. Always double check formulas before delivering the file – most of the time at the beginning you will find mistakes that could hurt your credibility
5. 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