I have been asked to sanitise data in BCG second round using MS Office. Can anyone help?
Overview of answers
Upvotes
Best answer
Hi,
When doing the sanitization, you are typically asked to do two main things:
- Change the numbers by 10-20%, so that it is not too off, and still sounds realistic. While doing this, you need to make sure that numbers speak to each other. For instance, there may be 2 different graphs which use the same data points (say total market size). You need to make sure that you change market size once, and reflect the changes in both graphs
- Change product/client names. There are three ways to do this, which depend on what your project leader wants:
- Put X, Y, Z or company 1, company 2, company 3 etc.
- Include additional names (e.g. if this is a chart about 5 fast-food chains, add a couple more names to the graph)
- Change names completely (e.g. replace McDonald's with Burger King etc.)
I hope this helps,
Deniz
Was this answer helpful?
Hi,
If you can't do this task most probably the position is not for you. Your day to day job (I assumed you are applying for one of the data science roles) will require these skills as soon as you start.
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 disadv
... (Open whole case)
28.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
... (Open whole case)
15.9k
Times solved
Advanced
Difficulty
Expert case by Ian
[PLEASE NOTE: This is a technically difficult case and should only be completed by those coming in as a Technology specialist, i.e. recruiting for McKinsey Digital, BCG Platinion, etc.]Our client is a multinational oil and gas company. While they are vertically integrated and have upstream, midstrea
... (Open whole case)
11.0k
Times solved
Advanced
Difficulty
Expert case by Ian
Style:
Problem definition: Our client is Korean Car Parts (KCP), a multi-national original equipment manufacturer (OEM) of car parts based in Korea. They've recently seen a decline in profits and have brought us in to understand how to address this falling profitability.
... (Open whole case)
8.9k
Times solved
Intermediate
Difficulty
Expert case by Giulia
Style:
Our client is the government of an imaginary country which is suffering from strong protests and riots by its own population. The client would like to understand the reason for these protests. In a second step, the client wants you to make suggestions for improvement to end these protests.
... (Open whole case)
8.4k
Times solved
Advanced
Difficulty
Content Creator
BCG | Kearney | 350+ trainees | 5+ years of experience in London, Dubai and Istanbul
716
Meetings
678
Q&A Upvotes
58
Awards
109 Reviews
Related Products
Break Into Consulting - Strategy Consulting Firm's All-In-One by Alexandre
Break Into Consulting - Industry Overviews by Alexandre
Break Into Consulting - Frameworks I wish I knew by Alexandre
BCG Online Case Combo: Software Simulation by Francesco
BCG Online Case Secrets by Francesco
BCG Potential Test #2 by Gaurav
