Ipsos Data Analyst Interview Questions and Answers

Qus. Of multiple times

Coding the program

A train running at the speed of 60 km/hr crosses a pole of 9 seconds. what is hte length of train?

Print all prime numbers

Aptitudee,reasioning,maths

Coding was moderate 3 questiins will be given

Topic on politics for 5 members

Q1. Why mu sigma and diff bwten desicion and data science
Ans. 
Mu Sigma is a decision sciences and analytics company that focuses on solving complex business problems using data science.
• Mu Sigma is a company that specializes in decision sciences and analytics, using data science to solve complex business problems.

• Decision sciences involve making strategic decisions based on data analysis, while data science focuses on extracting insights from data using various techniques.

• Mu Sigma...read more
Answered by AI
Add your answer

Moderate level MCQ questions

Asked moderate level guesstimates and puzzles in 2 round

Q1. Sort array in python
Ans. 
Use the sorted() function to sort an array of strings in Python.
• Use the sorted() function with the array as input to get a new sorted array.

• You can use the reverse parameter to sort in descending order.

• You can use the key parameter to specify a custom sorting key.

• Example: sorted_array = sorted(array)
Answered by AI
Add your answer
Q2. Merge 2 arrays in python
Ans. 
Use the concatenate function from numpy to merge two arrays in Python.
• Import numpy library

• Use np.concatenate() function to merge the arrays

• Ensure both arrays have the same data type
Answered by AI
Add your answer
Q3. Sql to find 2nd highest salary
Ans. 
Use SQL query with ORDER BY and LIMIT to find 2nd highest salary
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 1,1 to skip the highest salary and get the second highest

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1
Answered by AI
Add your answer
Q4. Sql for running total
Ans. 
Running total in SQL is achieved by using window functions like SUM() with OVER() clause.
• Use SUM() function with OVER() clause to calculate running total.

• Specify the window frame with ORDER BY in the OVER() clause.

• Running total can be reset based on certain conditions using PARTITION BY in the OVER() clause.
Answered by AI
Add your answer

Q1. There is table which holds details of matches played between the countries in first 2 columns and who won the match in 3rd column. write a query to get no. of matches played by each team and no. of matche...read more
Ans. 
Query to get number of matches played and won by each team from a table of match details.
• Use GROUP BY clause to group the data by team name.

• Use COUNT() function to get the number of matches played by each team.

• Use SUM() function with a condition to get the number of matches won by each team.
Answered by AI
Add your answer