i
BCG
Filter interviews by
Prepaid refers to expenses paid in advance for future benefits, while advance paid is a payment made before receiving goods or services.
Prepaid expenses are recorded as assets until they are used, e.g., prepaid insurance.
Advance payments are often made for services or goods not yet received, e.g., a deposit for a rental.
Prepaid expenses are amortized over time, while advance payments may be settled upon receipt of...
Management consulting involves advising organizations on strategy, operations, and performance improvement to enhance efficiency and effectiveness.
Strategic Planning: Consultants help businesses define their long-term goals and develop strategies to achieve them, such as market entry strategies.
Operational Improvement: They analyze and improve internal processes to increase efficiency, like streamlining supply cha...
The 'is' operator checks if two variables point to the same object in memory, while '==' checks if the values of the two variables are equal.
Use 'is' to check if two variables reference the same object in memory
Use '==' to check if the values of two variables are equal
Example: a = [1, 2, 3]; b = a; a is b will return True, a == b will also return True
Django applies migrations to the database using the 'manage.py migrate' command.
Django tracks changes to models and generates migration files accordingly.
The 'manage.py makemigrations' command creates migration files based on model changes.
The 'manage.py migrate' command applies the generated migration files to the database.
Migrations help keep the database schema in sync with the changes in Django models.
What people are saying about BCG
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().
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 colu...
Custom Django admin commands can be written to perform specific tasks in the Django admin interface.
Create a management/commands directory inside your Django app directory
Create a Python file for your custom command inside the management/commands directory
Define a class that extends BaseCommand and implement the handle method to execute the command logic
Register the custom command in the Django admin interface by ...
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 ...
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 have a strong academic background in data analysis and practical experience in various projects, enhancing my analytical skills.
Completed a Bachelor's degree in Statistics, where I learned data collection and analysis techniques.
Interned at XYZ Company, where I analyzed sales data to identify trends, resulting in a 15% increase in sales.
Proficient in tools like Excel, SQL, and Python for data manipulation and vi...
I applied via Campus Placement
The journey at IIM Lucknow has been challenging and rewarding.
IIM Lucknow has provided me with a rigorous academic curriculum and exposure to diverse perspectives.
The case study method of teaching has helped me develop critical thinking and problem-solving skills.
I have also had the opportunity to participate in various extracurricular activities and events, which have helped me develop my leadership and teamwork abili...
The client is a bank in UAE looking to expand to South Asia and seeks your advice on the same.
[Please note that I stands for Interviewer and C stands for Candidate]
C: Asked clarifying questions ranging from the objective, timeline, past experience of expansions, if any, current operations, target audience etc.
I: Briefed about the above, mentioning that the banks major clients in UAE are corporates, dealing in international transactions.
C: Asked if the target audience is to be the same or can be different and proposed to concentrate on India.
I: You may focus on India as the target. What factors would you evaluate for different regions and businesses to be targeted?
C: Since it was established that the Indian market was to be entered, confirmed whether an evaluation of India as a country was required.
I: Assume India is the best possible country to go ahead with. Let us focus on the business plan.
C: Evaluated the banking industry and confirmed if the related regulations and requirements could be met by the client. Inquired regarding competition and the presence in international transactions space.
I: Please consider the actual scenario of banking industry in India and evaluate the competition accordingly.
C: Given the presence of MNCs and the export intensive software & IT industry, concluded existence of aggressive competition. Also, differing nature of transactions compared to Oil and Gas industry would also be a barrier preventing the client from using the expertise gained earlier.
I: Valid point. What could be the other alternatives the client has?
C: Suggested targeting Indian origin employees from the middle east countries with their families in India. As they would require assistance with money transfers, deposits, withdrawals, etc., this space could be the point of focus.
I: Sounds good, Which parts of India do you think should be looked at?
C: Suggested the South-Indian states with special focus on Kerala with reasons for the same.
I: Good case, lets end it here. Can you summarize the case for me?
C: Summarized the case and exchanged pleasantries.
Client is a cloth manufacturer with presence in Europe and South Asia facing growth issues due to the pandemic. Help them.
[Please note that I stands for Interviewer and C stands for Candidate]
C: Confirmed the exact timeline and was told it is a real time scenario. Asked other scoping questions such as the operations, difference in Europe and other regions.
I: Europe is primarily used for high end fabric processing and the Asian manufacturing units are for the medium and low end
C: Inquired regarding competition and was given to understand that the one major competitor was facing similar low growth rates while the other players experienced a fall in revenues.
I: What according to you could be the different strategies to improve revenue numbers?
C: Suggested reduced pricing and entering unexplored geographies considering promotion and marketing actions would not garner additional demand due to the pandemic.
I: Let us explore them further.
C: Initiated with price reduction and suggested parallelly targeting reduction in costs to be able to sustain margins. Discussed how the same could be achieved and I presented a few ideas for the same exploring each section of the production and supply chain.
I: What factors would you consider for choosing a location and the strategy to be adopted for that particular location to increase sales?
C: Bifurcated the solution offered into two using Ansoff matrix i.e. 1) New product in existing markets like Asia and Europe with price/product modifications, 2) Exploring new countries where the client currently does not have any presence.
Discussed briefly on each of the two.
I appeared for an interview in Jan 2025.
The 'is' operator checks if two variables point to the same object in memory, while '==' checks if the values of the two variables are equal.
Use 'is' to check if two variables reference the same object in memory
Use '==' to check if the values of two variables are equal
Example: a = [1, 2, 3]; b = a; a is b will return True, a == b will also return True
useEffect is used for side effects in functional components, while useState is used for managing state.
useEffect is used to perform side effects in functional components, like data fetching, subscriptions, or manually changing the DOM
useState is used to manage state in functional components, allowing the component to re-render when the state changes
Example: useEffect can be used to fetch data from an API when the compo...
Authentication in RestApi involves verifying the identity of users before granting access to resources.
Use tokens (JWT) for authentication
Implement OAuth for secure authentication
Utilize session management for user authentication
Implement two-factor authentication for added security
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
Asked coding questions on Python and SQL
Python - find longest non repeating substring
SQL - join and window function
Develop a production-grade application in Python that analyzes data and provides answers to questions based on the dataset.
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
Django applies migrations to the database using the 'manage.py migrate' command.
Django tracks changes to models and generates migration files accordingly.
The 'manage.py makemigrations' command creates migration files based on model changes.
The 'manage.py migrate' command applies the generated migration files to the database.
Migrations help keep the database schema in sync with the changes in Django models.
Hoisting in JavaScript is the behavior where variable and function declarations are moved to the top of their containing scope during the compilation phase.
Variable declarations are hoisted to the top of their scope, but not their assignments.
Function declarations are fully hoisted, meaning they can be called before they are declared.
Hoisting can lead to unexpected behavior if not understood properly.
Create a full stack application in 3 days.
I applied via Walk-in and was interviewed in Dec 2024. There were 3 interview rounds.
BCG offers a challenging and innovative work environment with opportunities for growth and development.
BCG is known for its cutting-edge technology and innovative projects
Opportunities for professional growth and development
Strong company culture focused on collaboration and teamwork
Resolving code merge issues in Git involves understanding conflicts and using tools to manage them effectively.
Identify conflicts: Use 'git status' to see which files have conflicts.
Manual resolution: Open conflicted files and look for conflict markers (<<<<<<<, =======, >>>>>>>) to resolve them.
Use merge tools: Tools like 'kdiff3' or 'meld' can help visualize and resolve confl...
I expect a collaborative environment, opportunities for growth, and a commitment to quality in software development.
A supportive team culture that encourages open communication and collaboration, like regular team meetings to discuss challenges.
Opportunities for professional development, such as access to training programs or workshops to enhance my skills.
A focus on quality assurance processes, ensuring that the softw...
I applied via Approached by Company and was interviewed in Apr 2024. There were 4 interview rounds.
Contained only mcq questions related to maths and reasoning
Use Floyd's Cycle Detection Algorithm to detect two loops in a linked list.
Initialize two pointers, slow and fast, both starting at the head of the linked list.
Move slow pointer by one step and fast pointer by two steps in each iteration.
If they meet at some point, there is a loop. Reset one pointer to head and move both by one step until they meet again to find the start of the loop.
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 Naukri.com and was interviewed in Jun 2024. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Custom Django admin commands can be written to perform specific tasks in the Django admin interface.
Create a management/commands directory inside your Django app directory
Create a Python file for your custom command inside the management/commands directory
Define a class that extends BaseCommand and implement the handle method to execute the command logic
Register the custom command in the Django admin interface by addin...
I appeared for an interview in Mar 2025, where I was asked the following questions.
Some of the top questions asked at the BCG interview -
The duration of BCG interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 99 interview experiences
Difficulty level
Duration
5-7 Yrs
Not Disclosed
Gurgaon / Gurugram,
Delhi/Ncr
9-11 Yrs
Not Disclosed
Consultant
676
salaries
| ₹36 L/yr - ₹65 L/yr |
Senior Associate
435
salaries
| ₹30 L/yr - ₹50 L/yr |
Project Lead
183
salaries
| ₹64.6 L/yr - ₹114.2 L/yr |
Analyst
180
salaries
| ₹11.9 L/yr - ₹20 L/yr |
Senior Analyst
158
salaries
| ₹17.1 L/yr - ₹28 L/yr |
McKinsey & Company
PwC
Bain & Company
Deloitte