Stirring Minds Data Analyst Intern Interview Questions and Answers

Q1. Basic of sql and excel
Add your answer
Q2. What is joins and types oj joins
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

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

• RIGHT JOIN returns all rows from the right table and the matched rows from the left t...read more
Answered by AI
Add your answer

Manager round general questions about joining

Q1. Tell about yourself
Add your answer

Some basic sql questions

Q1. How many spheres can be accomadated in a bus if dimensions provided?
Ans. 
The number of spheres that can be accommodated in a bus depends on the dimensions of the bus and the size of the spheres.
• Calculate the volume of the bus using its dimensions

• Calculate the volume of a sphere using its radius

• Divide the volume of the bus by the volume of a sphere to get the maximum number of spheres that can fit
Answered by AI
Add your answer

Q1. Introduction about ourself,what's is meant by data entry?
Ans. 
Data entry involves inputting information into a computer system or database.
• Data entry is the process of entering information into a computer system or database

• This can include typing in text, numbers, or other data

• Accuracy and attention to detail are important in data entry

• Examples of data entry jobs include entering customer information into a CRM system or inputting survey responses into a database
Answered by AI
Add your answer
Q2. Pick one topic and say it for two minutes
Ans. 
The benefits of remote work
• Remote work allows for greater flexibility and work-life balance

• It can save time and money on commuting

• Remote work can increase productivity and job satisfaction

• It can also benefit the environment by reducing carbon emissions

• Examples of successful remote work companies include Buffer and Zapier
Answered by AI
Add your answer

Q1. What was your past salary
Ans. 
I prefer not to disclose my past salary as it is confidential information.
• It is not appropriate to ask about past salary during an interview

• Focus on discussing the candidate's qualifications and fit for the role

• Salary expectations can be discussed during negotiation phase
Answered by AI
Add your answer
Q2. What is the number of experience
Ans. 
The number of experience refers to the amount of time a candidate has spent working in a particular field or role.
• Experience can be measured in years, months, or even specific projects completed.

• Candidates may have varying levels of experience based on their previous roles and responsibilities.

• Experience can also include any relevant certifications or training completed.

• For example, a candidate may have 5 years of expe...read more
Answered by AI
Add your answer

Q1. Multiple questions asked to me
Add your answer

Q1. Multiple questions asked to me
Add your answer

Q1. About yourself and current job role
Add your answer
Q2. Market awareness etc
Add your answer

Q1. What is your profile all about currently and how many people are under you.
Ans. 
I am currently working as an Assistant Manager in a retail company, overseeing a team of 10 employees.
• Currently working as an Assistant Manager

• In charge of a team of 10 employees

• Responsible for supervising daily operations

• Providing guidance and support to team members

• Monitoring performance and providing feedback

• Implementing strategies to improve productivity

• Handling customer complaints and resolving issues

• Collaborating
Answered by AI
Add your answer

Q1. Tell me about my self and some challenges were given
Add your answer

Q1. What skills do you have
Add your answer
Q2. Past company experience
Add your answer

Q1. Where do you look yourself
Add your answer
Q2. How soon can you join
Add your answer