Blenheim Chalcot Data Analyst Interview Questions and Answers

Q1. Basic SQL questions
Add your answer
Q2. Statistical questions
Add your answer

Difficult aptitude, had to solve a lot of problems in 2 hrs

GD topic was "online vs offline education "

Q1. SQL question on self join
Add your answer
Q2. Guesstimate on number of cars sold in delhi
Ans. 
Approximately 1.5-2 million cars are sold in Delhi annually.
• Consider population of Delhi (approx. 20 million)

• Assume car ownership rate (approx. 10%)

• Factor in replacement rate and new buyers
Answered by AI
Add your answer

8 python coding
With 2 aptitude

Game based assessment.
More than 8 games need to play

Q1. Questions from python and also from SQL. SQL is must to place LatentView. Some projects related questions
Add your answer
Q2. How many joins are in SQL what is lamda function in python Difference between tuples and list
Ans. 
Answering questions related to SQL joins, lambda function in Python, and difference between tuples and lists.
• There are four types of joins in SQL: inner join, left join, right join, and full outer join.

• Lambda function is an anonymous function in Python that can take any number of arguments, but can only have one expression.

• Tuples are immutable and ordered collections of elements, while lists are mutable and ordered col...read more
Answered by AI
Add your answer

Get questions from all topics and medium level questions

They give one topic and provide one minute for thinking its overall 30 min discussion

Q1. Total technical rounds 1)basic resume questions, python and sql questions. 2)same round 1 but a little bit extra dose 3) managerial round
Add your answer
Q2. List, tuple, oops concept. joins from sql
Add your answer

Q1. Why latent view why analytics best achivemnts
Ans. 
Latent view and analytics are essential for data-driven decision making. My best achievement is developing a predictive model for customer churn.
• Latent view helps to uncover hidden patterns and insights in data that are not immediately apparent.

• Analytics provides a systematic approach to analyzing data and extracting meaningful insights.

• My best achievement is developing a predictive model for customer churn that helped
Answered by AI
Add your answer

It was easy to approach!

Discussions about common topics like boon or bane to society

Asked about the scenarios

Q1. Technical round related to skills and resume
Add your answer

Q1. Discussions regarding work culture and compensations
Add your answer

Q1. All basic concepts of pthon sql and ml
Add your answer

Apptitude, tecncal, cognitiive

It comprised basic verbal,quants and logical questions of average difficulty.

This is an easy round to get through if you have a strong command of the English language and are able to speak confidently.Very general topics asked.

Q1. Basic Machine Learning questions ( as I mentioned it in my resume)
Add your answer
Q2. Testing how you would be able to apply those concepts to real world scenarios
Add your answer
Q3. Generic logical puzzles
Add your answer
Q4. Basic python programs (3 to 4 questions)
Add your answer

Q1. Asked more about projects mentioned in resume.
Add your answer
Q2. Tested basic business sense and awareness.
Add your answer

A game round comprising logical puzzles and games.

Q1. Tell me about yourself ( standard intro)
Ans. 
I am a data analyst with a strong background in statistics and programming.
• Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• Experienced in analyzing large datasets and identifying trends and patterns

• Skilled in creating reports and presentations to communicate data-driven insights

• Strong problem-solving and critical thinking skills

• Ability to work collaboratively in cross-funct...read more
Answered by AI
Add your answer
Q2. Asked more about the roles of teammates in group projects listed in resume.
Add your answer
Q3. Asked more about myself and whether I could manage the commute to their office
Add your answer

Multiple sections on cognitive ability, quant and logical reasoning.
1 coding question

Easy
50% went to next round

Q1. Technical: SQL, DBMS, Basic programming questions- palindrome, fibonacci, discussion on projects and internships
Add your answer
Q2. Difference between UNION and UNION ALL
Ans. 
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
• UNION merges the results of two or more SELECT statements and removes duplicates.

• UNION ALL merges the results of two or more SELECT statements without removing duplicates.

• UNION is slower as it has to remove duplicates, while UNION ALL is faster.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column...read more
Answered by AI
Add your answer
Q3. Types of SQL commands
Ans. 
SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
• SELECT: retrieves data from a database

• INSERT: adds new records to a table

• UPDATE: modifies existing records in a table

• DELETE: removes records from a table

• CREATE: creates a new table, view, or index

• DROP: deletes a table or index
Answered by AI
Add your answer

Q1. Common HR questions
Add your answer