Goldman Sachs Data Analyst Interview Questions and Answers for Freshers

Questions related to quantitative aptitude , Logical reasoning , Data Interpretation and English Comprehension . The level of the questions asked will be moderate anyone can easily crack the interview test . But try to be good in any two of the above mentioned topic so that you can clear it easily,

Q1. Advance level sql and excel question will be asked first but they are only asked to check your knowledge even if you answer them correctly it won't guarantee you of getting placed . The main part of the in...read more
Add your answer
Q2. SQL : - Question related to advance level sql like windows function.
Add your answer
Q3. Excel :- Difference between vlookup and Index(Match)
Ans. 
VLOOKUP searches for a value in the first column of a table and returns a corresponding value in the same row. INDEX/MATCH uses two functions to look up a value based on its position in a table.
• VLOOKUP only searches for values in the first column of a table, while INDEX/MATCH can search for values in any column.

• INDEX/MATCH is more flexible and efficient for large datasets.

• VLOOKUP is easier to use for simple lookups wit...read more
Answered by AI
Add your answer

Q1. Dep related questions
Add your answer
Q2. Difference between preference and equity shareholders
Ans. 
Preference shareholders have fixed dividends and priority over equity shareholders in case of liquidation, while equity shareholders have voting rights and residual claim on assets.
• Preference shareholders receive fixed dividends before equity shareholders.

• Preference shareholders have priority over equity shareholders in case of liquidation.

• Equity shareholders have voting rights in the company.

• Equity shareholders have a...read more
Answered by AI
Add your answer

Q1. Capital budgeting & cash flow statement
Add your answer

Q1. Fundamentals, financial statements
Add your answer
Q2. Project details, intrests
Add your answer

Q1. Introduction . project
Add your answer
Q2. General information , Finance knowledge
Add your answer

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
Ans. 
Questions related to finance and accounting
• IPO stands for Initial Public Offering, which is the first time a company's stock is offered to the public

• Balance sheet has two sides - assets and liabilities & equity

• Depreciation is the decrease in value of an asset over time due to wear and tear or obsolescence

• Financial statements include income statement, balance sheet, and cash flow statement
Answered by AI
View 1 more amswer
Q2. Tell Me About Yourself About Your Family Background & Education
Add your answer

Easy Aptitude to start with

Python & SQL programming questions

Q1. Python question
Add your answer
Q2. SQL query question
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