Adda 247 Data Analyst Interview Questions and Answers

A general apti round

Data analysis assignment

Q1. Sql questions askes
Add your answer

Q1. Product sense round
Add your answer

Q1. Culture fit round
Add your answer

Around sql/python and other da tools

Stats and probability with focus on puzzles

Q1. It is related to SQL, Python, and Excel
Add your answer
Q2. Not Remember the interview questions exactly
Add your answer
Q3. What is grouped by in SQL
Ans. 
In SQL, data is grouped by a specified column or expression using the GROUP BY clause.
• Data is grouped based on the values in the specified column or expression

• Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY to perform calculations on each group

• GROUP BY is often used in conjunction with the SELECT statement

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department
Answered by AI
Add your answer
Q4. List and dictionary differences
Ans. 
Lists are ordered collections of items, while dictionaries are unordered collections of key-value pairs.
• Lists are accessed by index, dictionaries are accessed by key

• Lists maintain the order of elements, dictionaries do not guarantee order

• Lists use square brackets [], dictionaries use curly braces {}

• Example: list - [1, 2, 3], dictionary - {'a': 1, 'b': 2}
Answered by AI
Add your answer
Q5. Lambda functions in python
Ans. 
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
• Lambda functions are defined using the lambda keyword.

• They are commonly used for small, one-time tasks.

• Lambda functions can take any number of arguments, but can only have one expression.

• Example: add = lambda x, y: x + y
Answered by AI
Add your answer

A general apti round

Data analysis assignment

Q1. Sql questions askes
Add your answer

Q1. Product sense round
Add your answer

Q1. Culture fit round
Add your answer

Around sql/python and other da tools

Stats and probability with focus on puzzles