Tech Mahindra Data Analyst Interview Questions, Process, and Tips

It was a good experience

Q1. Introduce yourself
Ans. 
I am a data analyst with 5 years of experience in analyzing and interpreting complex data sets to drive business decisions.
• 5 years of experience in data analysis

• Skilled in analyzing and interpreting complex data sets

• Strong ability to drive business decisions through data-driven insights
Answered by AI
Add your answer
Q2. Qualification Did
Add your answer

Q1. This is a very good experience
Add your answer
Q2. Self introduction and development
Add your answer
Q3. Excel related questions
Add your answer
Q4. Dashboard related questions
Add your answer
Q5. Project related questions
Add your answer

Q1. All questions done
Add your answer

Q1. How to add months to current date using SQL funtions
Ans. 
You can add months to the current date in SQL using the DATEADD function.
• Use the DATEADD function in SQL to add months to the current date

• Specify the number of months to add and the date part (in this case, 'month') as parameters

• Example: SELECT DATEADD(month, 3, GETDATE()) will add 3 months to the current date
Answered by AI
Add your answer

MySQL , Power Bi, Tableau, Advance Excel, Python.

MySQL Coding from in data base Workbench 8.0

Q1. Data analyst in profile by technical around test
Add your answer

Q1. Introduce yourself
Add your answer
Q2. What is outliers
Ans. 
Outliers are data points that significantly deviate from the rest of the dataset.
• Outliers are extreme values that are either much higher or lower than the majority of the data.

• They can occur due to measurement errors, data entry mistakes, or genuine anomalies in the data.

• Outliers can have a significant impact on statistical analysis and may need to be identified and handled appropriately.

• For example, in a dataset of st...read more
Answered by AI
Add your answer
Q3. How you deal the outliers
Ans. 
Outliers are dealt with by identifying them, understanding their cause, and deciding whether to remove or transform them.
• Identify outliers using statistical methods like z-scores or box plots.

• Understand the cause of outliers by examining the data and considering external factors.

• Decide whether to remove outliers if they are due to data entry errors or transform them if they represent valid but extreme values.

• Use techni...read more
Answered by AI
Add your answer

Q1. Related to project
Add your answer
Q2. Tell us about project
Add your answer