Chubb Senior Data Analyst Interview Questions, Process, and Tips

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. 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

Q1. KPIs used in the project
Ans. 
Key Performance Indicators (KPIs) are metrics used to evaluate the success of a project.
• KPIs are specific, measurable, achievable, relevant, and time-bound metrics used to track progress towards project goals.

• Examples of KPIs in a data analysis project could include data accuracy, completion time, client satisfaction, and cost savings.

• KPIs help in monitoring and improving the performance of the project team and ensurin
Answered by AI
Add your answer

Q1. Number of rows and columns that can be uploaded in Power BI
Ans. 
Power BI allows uploading up to 1 million rows and 1,500 columns in a dataset.
• Power BI allows uploading a maximum of 1 million rows in a dataset.

• Power BI allows uploading a maximum of 1,500 columns in a dataset.

• Exceeding these limits may result in performance issues.
Answered by AI
Add your answer

Q1. Describe your weakness and strengths
Ans. 
My weakness is overthinking, but my strengths include attention to detail, problem-solving skills, and strong analytical abilities.
• Weakness: tend to overthink situations, which can sometimes lead to indecision

• Strengths: attention to detail, able to identify patterns and trends, strong problem-solving skills, excellent analytical abilities
Answered by AI
Add your answer

Basic 10 apti question

Basic 5 python question

Basic 5 SQL question

Q1. They asked two python program.
Add your answer

Q1. They asked one SQL question
Add your answer

Q1. Just question based on my resume.
Add your answer

Q1. Regularizaion, model improvemnts
Add your answer
Q2. Hyperparameter tuning
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Tell me a time when you had to deal with a failure, how you tackled it
Add your answer

Q1. Explain feature engineering process in ML modelling
Ans. 
Feature engineering is the process of selecting and transforming relevant features from raw data to improve model performance.
• Identify relevant features based on domain knowledge and data exploration

• Transform features to improve their quality and relevance

• Create new features by combining or extracting information from existing features

• Select the most important features using feature selection techniques

• Iterate the proc
Answered by AI
Add your answer
Q2. Explain classification models I used and why
Ans. 
I have used logistic regression and decision tree models for classification.
• Logistic regression is a linear model used for binary classification.

• Decision tree is a non-linear model used for multi-class classification.

• Logistic regression is simple and easy to interpret while decision tree can handle non-linear relationships.

• I chose these models based on the nature of the data and the problem at hand.
Answered by AI
Add your answer

Q1. Explain Tableau Dashboard actions
Ans. 
Tableau Dashboard actions allow users to interact with the data and visualizations by clicking on specific elements.
• Dashboard actions can be used to filter data, highlight specific data points, or navigate to other dashboards.

• There are four types of actions in Tableau: filter, highlight, URL, and parameter.

• For example, a user can click on a bar chart to filter the data in a related table or click on a map to highlight ...read more
Answered by AI
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