Verabrede dich zum Casen über das Meeting-Board, nimm an Diskussionen in unserem Consulting Q&A teil und finde gleichgesinnte Interview-Partner:innen, um dich auszutauschen und gemeinsam zu üben!
Zurück zur Übersicht

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

2
2,3k
8
Schreibe die erste Antwort!
Bisher hat niemand auf diese Frage reagiert.
Beste Antwort
Deniz
Coach
am 13. Aug. 2019
5+ Years at BCG & Kearney Dubai & Istanbul | 600+ Trainees | 900K+ YouTube Views

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

Vlad
Coach
am 9. Aug. 2019
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School

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,

Ähnliche Fragen
Consulting
BCG Knowledge DIRECTOR SALARY
am 31. Mai 2024
Global
6
3,5k
Beste Antwort von
Florian
Coach
1400 5-star reviews across platforms | 600+ offers | Highest-rated case book on Amazon | Uni lecturer in US, Asia, EU
80
6 Antworten
3,5k Aufrufe
+3
Consulting
When can I expect to hear back from BCG Final/Decision Round for North America Intern
am 27. Juni 2024
Global
6
5,7k
Beste Antwort von
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
250
6 Antworten
5,7k Aufrufe
+3
Consulting
BCG First Round Behavioral
am 24. März 2025
Global
6
3,3k
Beste Antwort von
Lorenzo
Coach
IESE MBA | Bain&Co | OC&C | Private Equity | Consumer Goods
70
6 Antworten
3,3k Aufrufe
+3
Wie wahrscheinlich ist es, dass du uns einem Freund oder Kommilitonen empfiehlst?
0 = Nicht wahrscheinlich
10 = Sehr wahrscheinlich
Vielen Dank für dein Feedback! Deine Meinung hilft uns, PrepLounge noch besser zu machen.