Goldman Sachs Data Analyst Interview Experience :


SQL:

1. Calculate the average salary for each department from the table.
2. Write a SQL query to display the employee’s name along with their manager’s name using a self-join on the ‘employees’ table, which contains ‘emp_id’, ‘name’, and ‘manager_id’ columns.
3. Find the most recent hire for each department (solved using LEAD/LAG functions).
4. Write a query to retrieve the nth highest salary from the Employees table, which has ‘EmployeeID’, ‘Name’, and ‘Salary’ columns.

Power BI:

1. What is meant by Filter context in DAX?
2. Explain the process of implementing Row-Level Security (RLS) in Power BI.
3. Describe the different types of filters available in Power BI.
4. What’s the difference between the ‘ALL’ and ‘ALLSELECTED’ functions in DAX?
5. How would you use DAX to calculate total sales for a specific product?

Python:

1. Create a dictionary, add elements, update a specific entry, and print the dictionary sorted by key in alphabetical order.
2. Identify unique values from a list of numbers and print how many times each value occurs.
3. Find and print the duplicate values in a list of numbers, along with their frequency.

Hope this helps you 😊