Mu Sigma Junior Data Analyst Interview Questions and Answers

Q1. What is the best experience you have in your professional career?
Add your answer

Q1. Case study on eCommerce
Add your answer

Round duration - 45 Minutes
Round difficulty - Medium

Q1. 
Find the Second Largest Element
Given an array or list of integers 'ARR', identify the second largest element in 'ARR'.
If a second largest element does not exist, return -1.
Example:
Input:
ARR = [2,...read more
Ans. 
Find the second largest element in an array of integers.
• Iterate through the array to find the largest and second largest elements.

• Handle cases where all elements are identical.

• Return -1 if a second largest element does not exist.
Answered by AI
Add your answer

Round duration - 20 Minutes
Round difficulty - Easy

It was a data set and my task was to find oit the different types of sales trend weekly, monthly, city wise and gender wise.

Q1. It was technical interview related to different types of tools and trchnology related, like differnt types of questions relatedcto ml, python, tableau, powerbi, excel and many more
Add your answer

Q1. It was another technical interview based on project and mid level tools and tecjnology related discussion
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. What is your family background?
Add your answer
Q3. Why should we hire you?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. How can you explain your work experience and describe how you can contribute to the organization?
Ans. 
I have extensive experience in analyzing data to provide valuable insights and drive decision-making. I can contribute by leveraging my skills to improve processes and optimize performance.
• I have worked with various data analysis tools and techniques to extract, clean, and analyze data sets.

• I have experience in creating visualizations and reports to communicate findings to stakeholders.

• I have a track record of identify...read more
Answered by AI
Add your answer

General aptitude questions and maths problems

Q1. About Sql, python and excel
Add your answer

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