Interview with BCN (Bain)
Hi folks,
Just finished up with my 1st round of interview at bain capability network, gurgaon. Wanted to share the experience if it helps anyone.
My background: MBA (DMS,IIT Delhi) with 5 yoe in healthcare domain.
Role: customer excellence, coe-coro
Interview:
Technical interview.
Questions were basic, was asked about alteryx, python, sql.
Q. In python/sql 2 tables, customers and orders table. how would you get 2nd highest ordered tablets by any customer.
Q. Different types of joins and significance
Q. Join vs union vs append in alteryx, how to apply and when to use
Q. What is xgboost, difference between regression, xgboost when to use what
Q. Difference between vlookup, xlookup and index match, when to use what
Guesstimates:
- Total number of new laptops sold in kndia in 2026
- Monthly revenue for a small pharmacy in cyberhub, Gurgaon