Capgemini Junior Data Analyst Interview Questions and Answers

Q1. Tell me about your Project
Ans. 
Developed a predictive model to forecast customer churn for a telecommunications company.
• Used machine learning algorithms such as logistic regression and random forest

• Performed data preprocessing and feature engineering to improve model accuracy

• Collaborated with business stakeholders to understand key factors influencing customer churn
Answered by AI
Add your answer

Q1. Personal information related questions and degree related with also details in medical device and pharmacovigilance
Add your answer

Q1. Mostly medical device questions and pharmacovigilance
Add your answer
Q2. Details about pharmacovigilance
Add your answer
Q3. Details about medical device
Add your answer
Q4. It was Abbott Diabetic Care, so question was like any brief idea about diabetes , types of diabetes
Add your answer

Q1. What are the available data types in sql
Ans. 
The available data types in SQL include numeric, character, date/time, and boolean types.
• Numeric data types include integer, decimal, and floating-point types.

• Character data types include char, varchar, and text types.

• Date/time data types include date, time, datetime, and timestamp types.

• Boolean data type represents true or false values.
Answered by AI
Add your answer
Q2. What are the joins available in SQL
Ans. 
Joins are used to combine rows from two or more tables based on related columns.
• INNER JOIN: Returns records that have matching values in both tables.

• LEFT JOIN: Returns all records from the left table and the matched records from the right table.

• RIGHT JOIN: Returns all records from the right table and the matched records from the left table.

• FULL JOIN: Returns all records when there is a match in either left or right tab...read more
Answered by AI
Add your answer
Q3. What is Power bi
Ans. 
Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities.
• Power BI is a Microsoft product used for data analysis and visualization.

• It allows users to connect to various data sources and create interactive reports and dashboards.

• Power BI offers a wide range of visualizations, such as charts, graphs, and maps, to present data in a meaningful way.

• Users can perfor...read more
Answered by AI
Add your answer

Quantitative, Verbal , numerical etc

Basic Programming questions

Q1. Reversing of String using C
Ans. 
Reversing a string in C using pointers and arrays.
• Use a pointer to the beginning of the string and another pointer to the end of the string.

• Swap the characters at the two pointers and move them towards each other until they meet in the middle.

• Repeat the process until the entire string is reversed.
Answered by AI
Add your answer

Tell about yourself ..?

Q1. About the projects that I have done .Regarding Sql
Add your answer

Basic Mathematics questions level at 10 class

Q1. Tell me about yourself!
Add your answer
Q2. What are your strengths and weekness?
Add your answer
Q3. How do you handle stress?
Add your answer
Q4. Define oscillation?
Ans. 
Oscillation is a repetitive variation, typically in a wave-like pattern.
• Oscillation refers to the repetitive movement or fluctuation around a central point.

• It can be seen in various phenomena such as pendulum swings, sound waves, and electronic signals.

• The frequency, amplitude, and phase are important characteristics of oscillation.

• Oscillation can be described mathematically using trigonometric functions like sine and
Answered by AI
Add your answer