Ipsos Market Research Intern Interview Questions and Answers

Q1. Tell me about you
Add your answer
Q2. Basically every question asked is related to you given project
Add your answer

I waa given telecom market in indua

Assignment in excel with proper presentation

1 easy sql and 1 easy python for 55 min

1 easy python and very hard sql for 1 hr 50 min

Q1. Mainly they focused on the answers you have written on round 2 and basic sql and pandas in python
Add your answer
Q2. 1) write a join 2) implement left join using pandas
Ans. 
Answering a question on writing a join and implementing left join using pandas for Data Analyst role.
• To write a join, we need to identify the common column(s) between two tables and use the JOIN keyword in SQL.

• Example: SELECT * FROM table1 JOIN table2 ON table1.common_column = table2.common_column

• To implement left join using pandas, we can use the merge() function with how='left' parameter.

• Example: pd.merge(table1, tab
Answered by AI
Add your answer

1 hr exam it is easy to crack

Logical Reasoning & Aptitude test, Grammar test.

Q1. You are given some EAN number, bases on that you have to find details of the product and answer the questions.
Add your answer
Q2. 1. Introduction 2. Questions about Prior work experience.
Add your answer

Basic aptitude questions of quant and reasoning and general english

Case study of varies products asked around 15-20 which were easy to attempt

Q1. About yourself, practical knowledge, family, data related,etc.
Add your answer
Q2. What is sql. Excel formulas
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Excel formulas are used for performing calculations and data analysis in Microsoft Excel.
• SQL is used to retrieve, insert, update, and delete data from databases.

• Excel formulas are written using functions and operators to perform calculations and manipulate data.

• SQL example: SELECT * FROM customers WHERE age > 30;

• Excel formula example...read more
Answered by AI
Add your answer

Normal aptitude questions

Q1. Interview with manager
Add your answer

There will be MCQ Questions. They will ask you to use internet and answer the questions.
They want to check your research skills.

Q1. If you are a fresher then you can easily clear the interview, Hr will ask normal questions about yourself and about your education background.
Add your answer