LTIMindtree Data Analyst Interview Questions and Answers for Experienced

Q1. Calculate avg value and standard deviation from given data
Ans. 
Calculate avg value and standard deviation from given data
• Calculate the average value by summing all data points and dividing by the total number of data points

• Calculate the standard deviation by finding the square root of the average of the squared differences between each data point and the mean

• Example: Data points - 5, 7, 9, 11. Average = (5+7+9+11)/4 = 8. Standard deviation = sqrt(((5-8)^2 + (7-8)^2 + (9-8)^2 + (11
Answered by AI
Add your answer
Q2. From given graph answer below questions
Add your answer

Q1. What is Primary key and foreign key?
Ans. 
Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.
• Primary key ensures each record in a table is unique

• Foreign key establishes a relationship between two tables

• Primary key can be a single column or a combination of columns

• Foreign key references the primary key of another table
Answered by AI
Add your answer
Q2. What is Artificial intelligence?
Ans. 
Artificial intelligence is the simulation of human intelligence processes by machines, especially computer systems.
• AI involves machines performing tasks that typically require human intelligence, such as visual perception, speech recognition, decision-making, and language translation.

• Examples of AI include virtual assistants like Siri and Alexa, self-driving cars, recommendation systems like Netflix's algorithm, and fa...read more
Answered by AI
Add your answer

Q1. Why did you choose Capgemini?
Add your answer

Q1. What are the different kinds of joins
Ans. 
Different kinds of joins include inner join, outer join, left join, and right join.
• Inner join: Returns only the rows that have matching values in both tables.

• Outer join: Returns all rows when there is a match in one of the 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 table.
Answered by AI
Add your answer
Q2. What is the difference between columns and measures in power BI
Ans. 
Columns are the fields in a dataset, while measures are calculations based on those fields in Power BI.
• Columns are the raw data fields in a dataset, such as 'Sales Amount' or 'Product Category'.

• Measures are calculations performed on columns, like sum, average, count, etc.

• Measures are created using DAX (Data Analysis Expressions) in Power BI.

• Columns are used for grouping, filtering, and slicing data, while measures are
Answered by AI
Add your answer
Q3. How can you remove duplicates in sql
Ans. 
Use the DISTINCT keyword in a SELECT statement to remove duplicates in SQL.
• Use the DISTINCT keyword in a SELECT statement to retrieve unique values.

• Example: SELECT DISTINCT column_name FROM table_name;

• Another way is to use the GROUP BY clause to remove duplicates.

• Example: SELECT column_name FROM table_name GROUP BY column_name;
Answered by AI
Add your answer

C, c++ , aptitude questions , statistics

Q1. Are you serving notice period
Ans. 
Yes, I am currently serving my notice period.
• Yes, I am in my notice period and will be available to start a new role after the required notice period.

• I am using this time to wrap up my current projects and ensure a smooth transition for my replacement.

• I am also open to discussing potential start dates with prospective employers.

• I am committed to fulfilling my responsibilities during this period and am prepared to hand
Answered by AI
Add your answer
Q2. How long is your notice period
Ans. 
My notice period is currently one month.
• Notice period is one month

• I am required to give one month's notice before leaving my current position
Answered by AI
Add your answer

Q1. Self introduction
Add your answer
Q2. Previous job experiences
Add your answer

Q1. Data Sceince related questions
Add your answer