Werde aktiv in unserer Community aus über 450.000 Gleichgesinnten!
Verabrede dich zum Casen über das Meeting-Board, nimm an Diskussionen in unserem Consulting Q&A teil und finde gleichgesinnte Case-Partner, um dich auszutauschen und gemeinsam zu üben!
I have been asked to sanitise data in BCG second round using MS Office. Can anyone help?
Übersicht der Antworten
Upvotes
Beste Antwort
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
War diese Antwort hilfreich?
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,
War diese Antwort hilfreich?
Verwandte Cases
Unternehmenscase von Bain & Company
Du erbst von deinem Großvater ein Weingut, die Old Winery, welche sich seit fünf Generationen in Familienbesitz befindet und bis ins 16. Jahrhundert datiert werden kann.Auf den elf Hektar der Old Winery werden konventionell, d.h. nicht biologisch betrieben und zertifiziert, je zur Hälfte weiße und r
...
Du erbst von deinem Großvater ein Weingut, die Old Winery, welche sich seit fünf Generationen in Familienbesitz befindet und bis ins 16. Jahrhundert datiert werden kann.Auf den elf Hektar de
...
(Ganzen Case öffnen)
117,9 T.
mal gelöst
Fortgeschritten
Schwierigkeitsgrad
Expertencase von Francesco
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
...
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 stude
...
(Ganzen Case öffnen)
31,6 T.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von 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
...
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, Espr
...
(Ganzen Case öffnen)
17,4 T.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von 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
...
[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 c
...
(Ganzen Case öffnen)
13,9 T.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von Ian
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.==========================
...
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 pro
...
(Ganzen Case öffnen)
11,3 T.
mal gelöst
Fortgeschritten
Schwierigkeitsgrad
Verwandte Produkte
Einstieg ins Consulting - All-in-One für Strategieberatungen von Alexandre
Einstieg in die Consultingbranche - Branchenübersichten von Alexandre
Einstieg ins Consulting - Frameworks, die ich gerne gewusst hätte von Alexandre
BCG Online Case Combo: Software Simulation von Francesco
BCG Online Case Secrets von Francesco
BCG Potential Test #2 von Gaurav
