Internshala Associate Data Analyst Interview Questions, Process, and Tips

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

Around sql/python and other da tools

Stats and probability with focus on puzzles

Medium level coding question

Q1. Intreview round asked about project mentioned in CV
Add your answer
Q2. Basic of reacts, opps question,sql queries
Add your answer

All the logical Qustions

Q1. They will ask you about dsa qustions
Add your answer

Q1. Tell me about your
Ans. 
I am a hardworking and enthusiastic individual with a passion for learning and making a positive impact.
• I have a strong work ethic and am always willing to go the extra mile to achieve my goals.

• I am a quick learner and enjoy taking on new challenges.

• I am a team player and believe in the power of collaboration to achieve success.

• I am passionate about making a positive impact in the world and strive to do so in everythin
Answered by AI
Add your answer
Q2. How active you are in your campus societies?
Ans. 
I am very active in my campus societies and have held leadership positions in multiple clubs.
• I have been a member of the debate club for 3 years and served as the president last year.

• I am also a member of the environmental club and have organized multiple events and campaigns.

• In addition, I am a part of the student government association and have helped plan and execute various campus-wide events.

• I believe being involv...read more
Answered by AI
Add your answer