Hey guys, new here (and new to consulting). I've got an interview with Oliver Wyman in Brazil and now have to do an online test focused on data analysis process/tools (they said programming) and a GMAT like test. They both supposed to be 15 questions each.
I'm not used to python, sql and stuff (I learn fast tho) how should I prepare?
Back to overview
7
South America
Programming/Data Analysis + GMAT test - OW FSQA
3
200+
Be the first to answer!
Nobody has responded to this question yet.
Hi there,
If you haven't already done so, I'd take these two steps:
- Reach out to the recruiter to get a better understanding of the format of the interview and what they are testing for. Ask them whether they would recommend any materials to prep with.
- Reach out to recent hires (<1y of tenure) and have an online coffee chat with them to understand how they prepared for the interview and what was most helpful for them
That should already give you a much stronger understanding as what to prep for. Otherwise, the risk is boiling the ocean.
Best,
Cristian
Congrats on the OW FSQA invite. Quick prep guide.
Data Analysis test. Focus on SQL basics (SELECT, WHERE, GROUP BY, JOIN, aggregates), Python pandas (filtering, groupby, merge), Excel (VLOOKUP, pivot tables), basic stats, and chart interpretation. Use Mode Analytics SQL Tutorial, DataCamp pandas course, and Kaggle for fast learning.
GMAT-like test. Drill percentages, ratios, growth rates, weighted averages, word problems, and chart interpretation. Use GMAT Official Guide or GMAT Club. 30 to 45 minutes daily for 2 weeks.
Always time yourself, both tests are time-pressured.
If you genuinely need more time to prep, ask the recruiter for an extension. Better than failing.
Good luck.
hey
The test is very doable even if you’re not a programmer. The “programming/data analysis” part is usually light: simple Python basics (loops, lists, reading a table), SQL logic (SELECT, WHERE, GROUP BY), and interpreting small datasets, more reasoning than coding. The GMAT‑style part is classic quant + logic: percentages, ratios, word problems, patterns. The fastest prep is: learn minimal Python (print, if, for, basic pandas), review SQL fundamentals, and do a few GMAT‑style practice sets to get your speed up. You don’t need to be a developer, they’re testing how you think, not how you code.
Best, Alessa
