Mu Sigma Junior Data Analyst Interview Questions and Answers

Q1. What are the joins available in sql
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• INNER JOIN: returns only the matching rows from both tables

• LEFT JOIN: returns all rows from the left table and matching rows from the right table

• RIGHT JOIN: returns all rows from the right table and matching rows from the left table

• FULL OUTER JOIN: returns all rows from both tables

• CROSS JOIN: returns the Cartesian product
Answered by AI
Add your answer
Q2. Shown a case study and asked to answer it accordingly
Add your answer

General aptitude questions and maths problems

Q1. About Sql, python and excel
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Where do you see yourself in 5 years?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer

Easy to intermediate level questions

Q1. 1.Basic sql commands. 2. Basic to advance excel. 3.how was your past experience with company.
Add your answer
Q2. 4.why you left the previous organization?
Ans. 
Seeking new challenges and growth opportunities.
• Looking for a more challenging role to enhance my skills.

• Seeking career growth and advancement.

• Wanted to explore new industries and gain diverse experience.

• Company restructuring led to a change in job responsibilities.

• Relocated to a different city or country.

• Personal reasons or family commitments.

• Better work-life balance.

• Unfavorable work environment or culture.
Answered by AI
Add your answer

Critical question in maths

General topic about current situation

Q1. About ourselves and resume
Add your answer

It was aptitude Medium level

It is on Python and SQL easy level

Q1. With Hiring Manager
Add your answer
Q2. Case Study Questions around 3/4
Add your answer

Q1. Salary Discussion
Add your answer