Dunzo MIS 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

Asking about ur self introduction and work experience

Q1. Rank Function Application in Google Sheet?
Ans. 
Rank function in Google Sheets is used to assign a rank to a value in a list based on its order.
• Rank function is used to determine the rank of a value in a list.

• It can be used to rank values in ascending or descending order.

• The syntax for the rank function is RANK(value, range, [is_ascending]).
Answered by AI
Add your answer
Q2. Joins From SQL?
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer
Q3. Order Of query execution in SQL?
Ans. 
The order of query execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
• FROM: Specifies the tables from which data will be retrieved.

• WHERE: Filters the rows based on specified conditions.

• GROUP BY: Groups the rows based on specified columns.

• HAVING: Filters the groups based on specified conditions.

• SELECT: Retrieves the columns specified in the query.

• ORDER BY: Sorts the result set based on specified column
Answered by AI
Add your answer
Q4. Write a query to find out students has greater than 80 marks and from English subject?
Ans. 
Query to find students with over 80 marks in English subject
• Use SELECT statement to retrieve data

• Filter the results using WHERE clause for marks greater than 80

• Include condition for English subject using AND operator
Answered by AI
Add your answer

Q1. When we use having clause ?
Ans. 
HAVING clause is used in SQL to filter groups based on specified conditions after GROUP BY clause.
• HAVING clause is used with GROUP BY clause to filter groups based on specified conditions.

• It is used to filter the results of aggregate functions like COUNT, SUM, AVG, etc.

• It is used to apply conditions to groups, similar to WHERE clause which applies conditions to individual rows.

• Example: SELECT department, AVG(salary) FR...read more
Answered by AI
Add your answer
Q2. Aggregate Function Application?
Ans. 
Aggregate functions are used to perform calculations on groups of rows in a table.
• Aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• They are commonly used in SQL queries to summarize data.

• For example, you can use SUM to calculate the total sales for a specific product.

• Another example is using AVG to find the average salary of employees in a department.
Answered by AI
Add your answer
Q3. Group by and order By?
Add your answer
Q4. Write a query employes join between such dates?
Ans. 
Use a SQL query with JOIN to retrieve employees between specified dates.
• Use the JOIN keyword to combine data from two tables

• Specify the date range using the WHERE clause

• Example: SELECT * FROM employees e JOIN dates d ON e.date = d.date WHERE d.date BETWEEN '2022-01-01' AND '2022-12-31'
Answered by AI
Add your answer