Related Posts
BCG final round interview in a week. Any tips on what to expect in a partner level conversation?
- how is it different than the round 1 experience?
- how important is the casing component? I'm doing pretty well, but not perfect. Friends have been eating me 8/10, with the need to improve structure and be more top down in my communication. I'm wondering what I can do to improve that in a week and if that will be a deal breaker on interview day?
Boston Consulting Group
More Posts
No FSW draw what's happening!?
Anyone planning to go out this weekend?
Anyone working as Patient Recruitment Assistant?
Is there any interview after probation period?
Earnings for next week.

Additional Posts in Data & Analytics Consultants
Has anyone else begun to resent data science?
New to Fishbowl?
unlock all discussions on Fishbowl.





Subject Expert
Comments don’t have any impact on the code you write. 🤣 🤣
I appreciate this joke so much more now 😂😂😂🥺
Well everyone I passed.
60 percent 😭😭.
I have 1 more round of interviews
Can you please tell if it was a live or take home?
Not on that, but I'll give you my sql checks...
Can you tell what the difference between a inner, left, right, and outer join?
How can I accidentally turn an outer join into an inner join?
If I put rownumher() and partition over why is the sort order important and what is the full syntax for that?
How many rows are there
How many nulls are there
Concatenate these two cells (heads up, there is at least one null value in the mix and the specification is intentionally vague to force you to ask me a question. You still have to solve it
How is this table skewed and what can I do to fix it if it is
Stored procedures!
Write a subselect to do the following...
Let's convert these strings to numbers or ask you to do datetime arithmetic on strings
50% puts you squarely in analytics. Not all those are necessary skills for analytics.
A buddy of mine passes people for his Spark test (PySpark, SparkSQL, and Scala) at a 34%. An assessment that you can't or shouldn't be able to complete tells me what your skill level is.
Find fun ways to sharpen skills. SQL murder mystery or Sololearn are fun.
Was that a take home test or a live test?