Chubb Data Analyst Interview Questions and Answers

All the questions are based on the MCQ , and the syllabus is covered python SQL Power BI

Some questions from the Pandas Data Frame scenario based

Q1. Ask about work and coding
Add your answer

Q1. Basic Excel function
Add your answer
Q2. Scenario based questions
Add your answer

More questions about my experience & reason to join.

First round will be aptitude test

Q1. Why should I hire you
Ans. 
I have a strong analytical background, excellent problem-solving skills, and a proven track record of delivering actionable insights.
• I have a degree in data analytics and relevant work experience

• I am proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• I have successfully completed projects where I identified trends and patterns in data to drive business decisions
Answered by AI
Add your answer
Q2. Tell me about your self
Add your answer

Q1. Salary expectation
Add your answer
Q2. Position of the candidate
Add your answer

Q1. What is your Age
Add your answer

Q1. What is unit testing?
Add your answer

Q1. Type of sql Joints
Ans. 
SQL Joins are used to combine rows from two or more tables based on a related column between them.
• Types of SQL 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 tab...read more
Answered by AI
Add your answer
Q2. Write DAX for create data modeling on inactive relationship?
Ans. 
Use DAX to create data modeling on inactive relationship in Power BI.
• Use USERELATIONSHIP function to create an inactive relationship between two tables.

• Specify the relationship between the tables and the columns to be used in the relationship.

• Use CALCULATE function along with USERELATIONSHIP to perform calculations using the inactive relationship.
Answered by AI
Add your answer

Duration - 60 Minutes
Topic - Advance DAX, Joints using DAX, all except all

Q1. Self introduction
Add your answer

Q1. Job role in current organization.
Add your answer
Q2. What do you know about DB DC
Ans. 
DB DC stands for Defined Benefit Defined Contribution, which are types of retirement plans.
• DB DC plans are types of retirement plans offered by employers.

• Defined Benefit (DB) plans provide a specific benefit upon retirement based on a formula, such as years of service and salary.

• Defined Contribution (DC) plans involve contributions from both the employee and employer, with the final benefit depending on the investment ...read more
Answered by AI
Add your answer

Q1. Whats is supervised learning
Ans. 
Supervised learning is a type of machine learning where the model is trained on labeled data to make predictions or decisions.
• Uses labeled data for training

• Predicts outcomes based on input features

• Examples include regression and classification algorithms
Answered by AI
Add your answer
Q2. What is unsupervised learning
Ans. 
Unsupervised learning is a type of machine learning where the model is trained on unlabeled data without any predefined output labels.
• No predefined output labels are provided for the training data

• The model must find patterns and relationships in the data on its own

• Common techniques include clustering and dimensionality reduction

• Examples: K-means clustering, Principal Component Analysis (PCA)
Answered by AI
Add your answer