i
BCG
Filter interviews by
I applied via campus placement at SRM university (SRMU) 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().
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 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
Top trending discussions
I was interviewed in Dec 2024.
I am a data analyst with a background in statistics and experience in analyzing large datasets.
Background in statistics
Experience in analyzing large datasets
Proficient in data visualization tools like Tableau
Strong problem-solving skills
Excellent communication skills
I would rate myself a 4 out of 5 in SQL proficiency.
Proficient in writing complex SQL queries
Experienced in optimizing database performance
Familiar with data manipulation and analysis functions
Comfortable working with large datasets
I use Power BI to analyze and visualize data for insights and decision-making in my work.
Connect to data sources to import data
Transform and clean data using Power Query Editor
Create relationships between different data tables
Design interactive reports and dashboards
Use DAX formulas for calculations and measures
Share reports with stakeholders and collaborate on insights
I applied via Naukri.com and was interviewed in Dec 2024. There were 4 interview rounds.
Set of questions on english , aptitude , all are at easy level
Sql basics and some query questions
Different types of joins in SQL are inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Full outer join: Returns rows when there is a match in either table
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.
HAVING is used with GROUP BY to filter groups based on aggregate functions results
WHERE is used to filter rows based on conditions
HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY
Example: SELECT department, AVG(salary) FROM employees GROU...
I applied via Newspaper Ad and was interviewed in Aug 2024. There were 3 interview rounds.
Three sections are there 1) Aptitude Test 2) SQL 3) DSA
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
DSA stands for Data Structures and Algorithms
Sorting is the process of arranging data in a particular order
Arra...
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
Developed predictive models to forecast customer behavior and optimize marketing strategies
Conducted market research to identify trends and opportunities for growth
Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
based on 5 interviews
2 Interview rounds
based on 4 reviews
Rating in categories
Consultant
551
salaries
| ₹25 L/yr - ₹93.5 L/yr |
Senior Associate
419
salaries
| ₹24 L/yr - ₹50 L/yr |
Analyst
164
salaries
| ₹7 L/yr - ₹21.5 L/yr |
Project Lead
159
salaries
| ₹40 L/yr - ₹120 L/yr |
Senior Analyst
147
salaries
| ₹10.2 L/yr - ₹31.4 L/yr |
McKinsey & Company
PwC
Bain & Company
Deloitte