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
Expertencase von Francesco
Themen:
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
... (Ganzen Case öffnen)
26,6 Tsd.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von Luca
Themen:
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
... (Ganzen Case öffnen)
15,2 Tsd.
mal gelöst
Schwierig
Schwierigkeitsgrad
Expertencase von Ian
Themen:
[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
... (Ganzen Case öffnen)
9,9 Tsd.
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.
... (Ganzen Case öffnen)
8,4 Tsd.
mal gelöst
Fortgeschritten
Schwierigkeitsgrad
Expertencase von Giulia
Themen:
Unser Kunde ist die Regierung eines imaginären Landes, das unter starken Protesten und Unruhen seiner eigenen Bevölkerung leidet. Der Kunde möchte den Grund für diese Proteste verstehen. In einem zweiten Schritt möchte der Kunde, dass Sie Verbesserungsvorschläge machen, um diese Proteste zu beenden.
... (Ganzen Case öffnen)
7,9 Tsd.
mal gelöst
Schwierig
Schwierigkeitsgrad
Content Creator
BCG | Kearney | 350+ trainees | 5+ years of experience in London, Dubai and Istanbul
688
Meetings
669
Q&A Upvotes
56
Awards
106 Bewertungen
Verwandte Produkte
Break Into Consulting - Strategy Consulting Firm's All-In-One von Alexandre
Break Into Consulting - Industry Overviews von Alexandre
Break Into Consulting - Frameworks I wish I knew von Alexandre
BCG Online Case Combo: Software Simulation von Francesco
BCG Online Case Secrets von Francesco
BCG Potential Test #2 von Gaurav
