S&P Global Lead Data Analyst Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
I am a Senior Data Analyst with 5+ years of experience in analyzing complex data sets and providing actionable insights.
• 5+ years of experience in data analysis

• Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• Strong problem-solving skills and ability to communicate findings to non-technical stakeholders
Answered by AI
Add your answer
Q2. Asked about recent project
Add your answer
Q3. Types of join in sql
Ans. 
Types of join in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: Returns rows when there is a match 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

• Full join: Returns ro
Answered by AI
Add your answer
Q4. Case when statement questions
Add your answer

DSA and ML, AI, Coding question

Q1. Case study which was easy
Add your answer

Q1. In depth questions on ML
Add your answer

Q1. Bio activities example
Add your answer
Q2. Adverse drug reaction
Add your answer

I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.

Q1. Explain the Project undertaken during the research and follow-up questions
Add your answer

Q1. Write pandas query to separate the names as first and last name from the full name. Drop the duplicate columns and also the missing values. Write output for the Python code. Write SQL query to retrieve t...read more
Ans. 
Answering questions related to data science concepts and techniques.
• Recall is the ratio of correctly predicted positive observations to the total actual positives. Precision is the ratio of correctly predicted positive observations to the total predicted positives.

• To reduce variance in an ensemble model, techniques like bagging, boosting, and stacking can be used. Bagging involves training multiple models on different ...read more
Answered by AI
Add your answer

Q1. Gen AI projects
Add your answer
Q2. Architecture of projects I worked
Add your answer

2hrs - sections include aptitude, machine learning, deep learning and two easy python coding questions

Q1. Resume scrutiny with projects and internships
Add your answer
Q2. How to measure 45 mins duration using two identical wires
Add your answer
Q3. Partition a round cake into eight equal parts within three cuts
Add your answer
Q4. 10 coins puzzle (5 heads up and 5 tails up)
Add your answer

It was MCQ in simple aptitude, python and SQL questions

Q1. Python coding and explaination
Add your answer
Q2. SQL coding and explaination
Add your answer

Q1. Case study based on data understanding
Add your answer

Q1. Behavioural and questions from my resume
Add your answer