i
BCG
Filter interviews by
Clear (1)
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
ALL() removes all filters from the specified column or table.
ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.
Example: ALL('Table') would remove all filters on the 'Table' in the query context.
Example: ALLSELECTED('Column') would remove filte...
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
COUNT() counts only cells with numerical values.
COUNTA() counts all non-empty cells, including text and errors.
Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
I applied via Campus Placement and was interviewed in Jun 2024. There were 2 interview rounds.
I have a strong background in data analysis, with experience in utilizing various analytical tools and techniques to derive insights from data.
I have a degree in Statistics and have completed multiple data analysis projects during my academic career.
I am proficient in using programming languages such as Python and R for data analysis.
I have experience working with SQL databases and extracting data for analysis.
I have s...
SQL window functions are used to perform calculations across a set of table rows related to the current row.
Window functions operate on a set of rows related to the current row, known as a window.
They can be used to calculate running totals, ranks, averages, and more.
Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), SUM(), AVG(), and LEAD().
I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.
Basic quant questions with some questions on ML. 2 python questions based on data processing.
List is an ordered collection of elements with duplicates allowed, while set is an unordered collection of unique elements.
List maintains the order of elements, while set does not guarantee any specific order.
List allows duplicate elements, while set does not allow duplicates.
List is accessed by index, while set is accessed by value.
Example: List - [1, 2, 3, 1], Set - {1, 2, 3}
Concat is used to combine data along a particular axis, while merge is used to combine data based on a common key.
Concatenation is done along an axis (rows or columns) in pandas, while merging is done based on common columns or indices.
Concatenation is a simple operation that just appends data, while merging involves combining data based on a key.
Concatenation can be done even if the data does not have common columns, ...
I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.
4 rounds of coding ml questions
BCG interview questions for designations
Nice Topics and easy questions
1 hour and nice experience
How is world evolving
What people are saying about BCG
I was interviewed in Aug 2017.
I was interviewed before Dec 2020.
Round duration - 120 Minutes
Round difficulty - Medium
Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...
The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.
Read the number of test cases 'T'
For each test case, encode the 'SECRET_INFORMATION' and then decode it
Compare the decoded string with the original 'SECRET_INFORMATION'
Print 'Transmission successful' if they match, else print 'Transmission failed'
Round duration - 60 Minutes
Round difficulty - Medium
Given an array Arr
consisting of N integers, your task is to find the equilibrium index of the array.
An index is considered as an equilibrium index if the sum of elem...
Find the equilibrium index of an array where sum of elements on left equals sum on right.
Iterate through the array and calculate prefix sum and suffix sum at each index.
Compare prefix sum and suffix sum to find equilibrium index.
Return the left-most equilibrium index or -1 if none found.
Round duration - 50 Minutes
Round difficulty - Easy
Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company
Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.
I applied via Walk-in and was interviewed before Jun 2020. There was 1 interview round.
I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.
I applied via Recruitment Consulltant and was interviewed before Jul 2021. There was 1 interview round.
I worked on a data visualization tool for tracking sales performance.
The tool was built using Tableau and SQL.
It allowed users to view sales data by region, product, and time period.
Users could also create custom dashboards and reports.
The tool helped identify trends and opportunities for improvement.
I collaborated with the sales team to ensure the tool met their needs.
based on 5 interviews
2 Interview rounds
based on 4 reviews
Rating in categories
Consultant
535
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
421
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
164
salaries
| ₹0 L/yr - ₹0 L/yr |
Project Lead
159
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
147
salaries
| ₹0 L/yr - ₹0 L/yr |
McKinsey & Company
PwC
Bain & Company
Deloitte