Dunzo Data Analyst Interview Questions and Answers

Basic attitude test conducted first.

Q1. Questions related to Advanced MS Excel, Basic SQL Queries.
Add your answer
Q2. Count total no. of cities ?
Ans. 
The total number of cities cannot be counted without specific data or context.
• The total number of cities can vary depending on the country, region, or dataset being considered.

• One would need a list of cities or a specific area of focus to accurately count the total number of cities.

• For example, the total number of cities in the United States is different from the total number of cities in India.
Answered by AI
Add your answer
Q3. What is Index and Match ?
Ans. 
Index and Match are functions in Excel used to lookup values in a table based on specific criteria.
• Index function returns the value of a cell in a table based on the row and column number provided.

• Match function returns the position of a value in a range.

• Index and Match functions are often used together to perform more flexible lookups than VLOOKUP or HLOOKUP.

• Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will retur...read more
Answered by AI
Add your answer
Q4. What is Vlookup and Hlookup ?
Ans. 
Vlookup and Hlookup are functions in Excel used to search for a value in a table and return a corresponding value.
• Vlookup stands for vertical lookup and is used to search for a value in the first column of a table and return a value in the same row from a specified column.

• Hlookup stands for horizontal lookup and is used to search for a value in the first row of a table and return a value in the same column from a speci...read more
Answered by AI
Add your answer
Q5. How to calculate Vlookup?
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.
• Use the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• lookup_value is the value to search for in the first column of the table

• table_array is the range of cells that contains the data

• col_index_num is the column number in the table from which to retrieve the data

• range_lookup is optional and ca...read more
Answered by AI
Add your answer

Approx 30 questions which are to be solved in 1 hour. Questions include logical and mathematical questions along with basic ML and stats questions

Q1. Basic questions related to Python and SQL
Add your answer

Q1. Advance SQL questions and 1 case study
Add your answer

Q1. Basic ML questions and Business acumen questions
Add your answer

The aptitude questions were bit easy and there were questions about SQL, and also excel sheets.

Q1. Questions about sql
Add your answer

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer