Cclyticx Services Data Analyst Interview Questions and Answers for Experienced

Q1. I have finished Btech in Cse AI&ML taken datascience course looking for job
Add your answer

NLP is my favorite subject. Is relatated medical and sign language. I have done reseach with mechien learning and AI TOOLS used for problem solving approach.

A group discussion was conducted on data-based management regarding Mr. Adani's food industry products in the state of Gujarat and their exports to other countries, utilizing data analytics.

Q1. How to perform Set Actions, LOD's
Add your answer

Q1. Explain difference between joins
Add your answer
Q2. What is your area of intrest
Add your answer

Q1. Write a code to determine average salary wrt location
Ans. 
Code to calculate average salary based on location
• Create a dictionary to store salaries based on location

• Calculate average salary for each location using the dictionary

• Return the average salaries for each location
Answered by AI
Add your answer

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