Get Active in Our Amazing Community of Over 455,000 Peers!

Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Case Partners to connect and practice with!

I have been asked to sanitise data in BCG second round using MS Office. Can anyone help?

BCG second round
New answer on Aug 13, 2019
2 Answers
2.0 k Views
Anonymous A asked on Aug 08, 2019

Overview of answers

  • Upvotes
  • Date ascending
  • Date descending
Best answer
Content Creator
replied on Aug 13, 2019
5+ Years at BCG & Kearney Dubai & Istanbul | 400+ Trainees | Free 15-min Consultation Call


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,


Was this answer helpful?
replied on Aug 09, 2019
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School


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.


Was this answer helpful?
Deniz gave the best answer


Content Creator
5+ Years at BCG & Kearney Dubai & Istanbul | 400+ Trainees | Free 15-min Consultation Call
Q&A Upvotes
123 Reviews
How likely are you to recommend us to a friend or fellow student?
0 = Not likely
10 = Very likely
You are a true consultant! Thank you for consulting us on how to make PrepLounge even better!