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 am applying for an internship at BCG India. The JD entails data sanitisation. What does this mean? Is it complicated?

New answer on Jul 28, 2019
3 Answers
1.3 k Views
Anonymous A asked on Jul 27, 2019

The first round is a WebEx interview with 2 knowledge analysts. What can be expected?


Overview of answers

  • Upvotes
  • Date ascending
  • Date descending
Best answer
Content Creator
replied on Jul 28, 2019
Ex-McKinsey EM | Experienced interview coach (1,000+ sessions) | Discount on 1st session | LBS MBA

Hi there,

Data sanitisation, just means obfuscating the names, data and figures so that no-one could infer the client name and actual data from the deck. Generally done when a project deliverable is uploaded to the knowledge management platform. Nothing too complex, but requires some attention to detail.

Good luck with your application!

Was this answer helpful?
Anonymous updated the answer on Jul 28, 2019

Hi there,

Is this an internship for a generalist consultant role, or something more technical? If it is the former, data sanitisation should be some basic tasks such as cleaning up data so it's in a consistent format, removing corrupted or unrelevant data, collapsing and summarizing data based on certain criteria. If the internship is for a more technical role, then it's probably a different story. Data sanitisation will be done at a much larger scale using more complicated tools.

Basically, consultants sometimes receive messy data, from sources like a client or a third-party market research company, for example. The data has to be cleaned up first before it can be fed into Excel, R, Tableau or some other software for data analysis. The data sanitisation you see on the job description essentially describes that cleaning process.

Hope this helps.


EDIT: Ben is correct that data sanitisation refers to removing confidential, sensitive or client-identifying info from data. I misunderstood the context when first replied.


Was this answer helpful?
Anonymous A on Jul 27, 2019

Hi, thanks for your response. I have been told that my PowerPoint skills should be good. I think basic MS office will be used. The intern will be part of the Knowledge team.


Anonymous on Jul 27, 2019

Please refer to Ben's reply.


replied on Jul 28, 2019
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School


Depends on the role:

  • If the role is data science, this means cleaning all personal information
  • If the role is in the research dept - can be some sanitized benchmarking of different players
  • It might be also some internal needs like sanitizing the presentations for knowledge purposes


Was this answer helpful?
Anonymous A on Jul 28, 2019

hi, Yes. I believe that presentations will be sanitised.

Ben gave the best answer


Content Creator
Ex-McKinsey EM | Experienced interview coach (1,000+ sessions) | Discount on 1st session | LBS MBA
Q&A Upvotes
8 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!