MetLife Data Analyst Interview Questions and Answers

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. Tell me about your self?
Add your answer
Q2. What is SQL and diffrent joins in SQL?
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Different joins in SQL include inner join, outer join, left join, and right join.
• SQL is a standard programming language for managing and manipulating relational databases.

• Different types of joins in SQL include inner join, outer join, left join, and right join.

• Inner join returns rows when there is at least one match in both tables.

• Ou...read more
Answered by AI
Add your answer
Q3. How to separate portion before @ and after @ from mail using python?
Ans. 
Use Python to separate portion before and after @ in an email address.
• Use the split() method to separate the email address into two parts based on the @ symbol.

• Access the parts using index 0 for the portion before @ and index 1 for the portion after @.

• Example: email = 'example@email.com'; parts = email.split('@'); before = parts[0]; after = parts[1];
Answered by AI
Add your answer
Q4. What is the rank, Dense Rank and Row Number?
Ans. 
Rank, Dense Rank, and Row Number are functions used in SQL to assign a ranking to rows in a result set.
• Rank function assigns a unique rank to each row based on the specified column values.

• Dense Rank function assigns a unique rank to each row without any gaps.

• Row Number function assigns a sequential integer to each row in the result set.
Answered by AI
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. 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. About job profile
Add your answer

Python coding , excel formulas and expertise required

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

More questions about my experience & reason to join.

Q1. In which situations what type of charts will be used
Ans. 
Charts are used to represent data visually. Different types of charts are used based on the type of data and purpose.
• Line charts for showing trends over time

• Bar charts for comparing values

• Pie charts for showing proportions

• Scatter plots for showing relationships between variables

• Heat maps for showing density or distribution

• Histograms for showing frequency distribution

• Box plots for showing distribution and outliers

• Gantt
Answered by AI
Add your answer
Q2. Few SQL Join questions
Add your answer