S&P Global Data Analyst Interview Questions, Process, and Tips for Freshers

Q1. Tell Me About Your Selfie
Add your answer
Q2. Explain Internship Expericence
Ans. 
Completed a 6-month data analysis internship at XYZ Company
• Worked on various data analysis projects to extract insights and trends

• Utilized tools such as Excel, SQL, and Tableau to manipulate and visualize data

• Collaborated with team members to present findings and recommendations

• Gained hands-on experience in data cleaning, data visualization, and statistical analysis
Answered by AI
Add your answer

Q1. Financial statements
Add your answer
Q2. EPS, Cost of Capital
Add your answer

Q1. 1) What Is IPO 2) Sides Of Balance Sheet 3) What Is Depreciation 4) Financial Statements
View 1 more answer
Q2. Tell Me About Yourself About Your Family Background & Education
Add your answer

Sure, here are some example coding questions for a data analyst interview:

1. **Data Cleaning**: Given a dataset with missing values in the "age" column, write a Python function using Pandas to fill in the missing values with the mean age.

2. **Data Manipulation**: Write a SQL query to retrieve the top 10 customers who made the highest number of purchases from a transactions table.

3. **Data Visualization**: Using Matplotlib or Seaborn, create a histogram to visualize the distribution of sales prices from a dataset of real estate transactions.

4. **Statistical Analysis**: Calculate the correlation coefficient between two numerical variables in a dataset using Python and explain what the result indicates about their relationship.

5. **SQL Queries**: Write a SQL query to find the total revenue generated by each product category from a sales database.

6. **Algorithmic Questions**: Write a Python function to find the median of a list of numbers without using any built-in functions for sorting.

These questions cover a range of skills commonly required for data analyst positions, including data cleaning, manipulation, visualization, statistical analysis, SQL querying, and algorithmic problem-solving.

Duration -1 hr
AGM related question.
equity calculation, derivatives, shares allocation, Accounting Knowledge.

Q1. Salary negotiation and they ask whether you'll be able to come to office on anchor days.
Add your answer