Zupee Data Analyst Interview Questions and Answers

Two datasets were shared. Complete freedom was given to derive different insights.

Q1. Basic SQL Questions on join, queries etc.
Add your answer

Q1. Final round with Technical and Analytics head with puzzle questions and basic know hows.
Add your answer

Q1. What is the difference between Union and Union all ?
Ans. 
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
• Union removes duplicate rows from the result set, while Union all includes all rows.

• Union sorts the result set, while Union all does not.

• Union is slower than Union all because it performs a distinct operation.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FRO
Answered by AI
Add your answer
Q2. Which query is more faster , joins or union?
Ans. 
Joins are generally faster than unions.
• Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

• Joins can utilize indexes on the columns being joined, which can improve performance.

• Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...read more
Answered by AI
Add your answer

Q1. Write a sql query
Ans. 
SQL query to retrieve employee names and their salaries from a table
• Use SELECT statement to retrieve data

• Specify the columns you want to retrieve (employee names and salaries)

• Specify the table name where the data is stored
Answered by AI
Add your answer
Q2. Formula of vlookup
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.
• VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

• The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...read more
Answered by AI
Add your answer

Sql and basic python

Q1. General question about data knowledge
Add your answer

Q1. Normal bargain for salary
Add your answer

Q1. Resume based questions on past experience
Add your answer
Q2. Case study based questions
Add your answer

Q1. Resume based questions,
Add your answer
Q2. Moderate SQL Coding question
Add your answer
Q3. Case study based questions
Add your answer

Q1. General HR related questions
Add your answer

Q1. Managerial & Aptitude questions
Add your answer

Q1. Managerial discussion about role & industry
Add your answer

Q1. Leetcode sql question
Add your answer
Q2. "Pandas and NumPy question."
Add your answer

60 minutes, math, reasoning, DSA

Q1. DSA and OOPS concepts
Add your answer

Q1. Reverse a string
Ans. 
Reverse a string by iterating through the characters and swapping them
• Create a function that takes a string as input

• Initialize two pointers, one at the beginning and one at the end of the string

• Swap the characters at the two pointers and move them towards the center until they meet
Answered by AI
Add your answer
Q2. Create a class for inheritance
Ans. 
Creating a class for inheritance in object-oriented programming
• Create a base class with common attributes and methods

• Create derived classes that inherit from the base class

• Use the 'extends' keyword in languages like Java or C++

• Override methods in the derived classes if necessary
Answered by AI
Add your answer

Basic DSA questions asked