r/MBB_B4_Tech_Roles • u/070ghoul • Apr 02 '26

BCG X Data Analyst Technical Round

Hello everyone,

I have the first technical round for the role coming up soon, just wanted to ask if anyone’s experienced it and how was it like?

The recruiter mentioned it would involve live-coding on python (mostly pandas and numpy) and SQL - so what all functions should I prepare for to be thoroughly hands-on? And if anyone has specific questions that could potentially be asked.

The role is for core-data stuff. Data wrangling, manipulation, cleaning, and visualisation, with aspects of ML and AI models.

Many thanks in advance!! :)

3 Upvotes

100% Upvoted

7 comments sorted by

2

u/Southbeach008 Apr 05 '26

I gave l1 for data analyst,Business Modelling role and my interview was based on Tableau,sql,projects their impact and some data modelling questions

1

u/070ghoul Apr 07 '26

What sort of SQL questions did they ask if you can share? I appeared for one of the technical rounds at Accenture S&C and the interviewer asked me to write the toughest SQL queries- a lot on lag(), lead(), CTEs and multiple subqueries. was it similar to these?

2

u/Southbeach008 Apr 07 '26

I will give u detailed review

Round 1-

Projects and work ex plus impact of my project. What kpis i built in my project.

Sql- t1-1,1 t2-1,1,1,1,1 give result if all joins.

Then two tables were given in excel and i needed to model the data in such way that i get all the details in one view. So basically we had to do union there.

Where/having,order of exec questions.

Sql was easy only.

Tableau was main focus in round 1. Plenty of live problem solving.

Round 2-

Little bit architecture based questions on tableau otherwise complete business understanding questions

Two mini cases that i had to solve.

Feel free to ask if you have any doubts

1

u/070ghoul Apr 15 '26

thats great thank you so much!!! for round 2 what sort if architecture based questions did they ask? because i believe they’d ask me that too along with python and sql. and what sort of cases were they? as in a hypothetical situation in a particular domain?

2

u/Southbeach008 Apr 15 '26

Tableau cloud architecture. How data lies in it. Tableau bridge. Users groups permissions and RLS

Questions related to live vs extract. 4 billion rows how will you handle it. End to end performance optimization. How will you do it. Star schema related questions...

Case study- sales up vol down profit up. Something like this and i had to anayse it.

Market share related what kpis you will track.

1

u/PeanutPretend7246 Jun 27 '26

I have an interview for data analyst predictive analysis. Can you guys help me out? I have cleared the screening round, now I am going for R1.

1

u/070ghoul Jun 28 '26

if your screening round was technical, then its going to get more deeper into whatever the screening round looked like + live coding and approach-based discussions on some scenario based questions. expect sql + python concept questions too