AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Dunzo
Compare
Filter interviews by
Dunzo MIS Analyst Interview Questions and Answers
Dunzo MIS Analyst Interview Experiences
2 interviews found
Anonymous
I applied via Company Website and was interviewed in Sep 2022. There were 3 interview rounds.
(2 Questions)
- Q1. Basic SQL Questions on Joins, writing queries
- Q2. Two case studies - one dealing with root cause analysis, other with revenue sources of Dunzo (finding out where there revenue comes from, where their most costs occur)
(1 Question)
- Q1. Questions based on previous work experience (internships), personal life, one guesstimate
Interview Preparation Tips
- SQL
- Case Studies
Selected
I applied via LinkedIn and was interviewed before Aug 2022. There were 3 interview rounds.
Hackerrank test of SQL, excel and tableau
(1 Question)
- Q1. Question on joins and simple problems
(2 Questions)
- Q1. SQL and Tableau Fundamentals
- Q2. SQL joins difference
- Ans.
SQL joins are used to combine rows from two or more tables based on a related column between them.
Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left tab...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There were 2 interview rounds.
(4 Questions)
- 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]).
- 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;
- 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
- 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
(4 Questions)
- 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...
- 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.
- Q3. Group by and order By?
- 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'
Interview Preparation Tips
- EXCEL FUNCTIONS
- SQL JOINS
- SQL CLAUSES
also prepare deep from SQL basic to advance.
Skills evaluated in this interview
Subham Behera
Define CTE and how it works
I applied via Walk-in and was interviewed in Jun 2023. There were 2 interview rounds.
(1 Question)
- Q1. Self introduction and knowledge checking
(1 Question)
- Q1. SQL and Excel based questions
I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed in Nov 2024. There were 4 interview rounds.
Questions from arrays and strings and some aptitude questions
(2 Questions)
- Q1. How to merge 2 csv files
- Ans.
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
Open both CSV files in a software like Microsoft Excel.
Copy the data from one CSV file and paste it into the other CSV file.
Save the merged CSV file with a new name.
Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
- Q2. Basic questions on arrays
(1 Question)
- Q1. 3 reasons why u choose this company
- Ans.
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.
Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.
Company culture - I value a positive work environment and the...
(1 Question)
- Q1. Questions on python
Skills evaluated in this interview
(5 Questions)
- Q1. Basic Excel Questions
- Q2. Medium and Basic SQL Questions
- Q3. Resume based Question
- Q4. Case Study Questions
- Q5. Questions on Project
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Case study questions based on Logistics & Porter business.
- Q2. More Case study & porter business questions
(2 Questions)
- Q1. Some medium SQL Queries
- Q2. Some medium python codes
I applied via Recruitment Consulltant and was interviewed in Aug 2024. There was 1 interview round.
(2 Questions)
- Q1. Excel question: Unique and Sumif
- Q2. Quant questions
Ankith Shetty
(2 Questions)
- Q1. Tell me about yourself and about the current job profile in the existing company?
- Q2. What you know about Online business
- Ans.
Online business refers to conducting commercial transactions over the internet.
Online business allows companies to reach a global audience
E-commerce platforms like Amazon and eBay are examples of online businesses
Digital marketing plays a crucial role in promoting online businesses
Online businesses often use analytics to track customer behavior and improve sales
Online payment gateways like PayPal and Stripe facilitate
(2 Questions)
- Q1. About myself and current job profile
- Q2. Why you want to change the company
Dunzo Interview FAQs
Tell us how to improve this page.
Dunzo Interviews By Designations
- Dunzo Community Operations Specialist Interview Questions
- Dunzo Procurement Manager Interview Questions
- Dunzo Software Developer Intern Interview Questions
- Dunzo Inward Executive Interview Questions
- Dunzo MIS Analyst Interview Questions
- Dunzo Operations Associate Interview Questions
- Dunzo Sales Manager Interview Questions
- Dunzo Store Executive Interview Questions
- Show more
Interview Questions for Popular Designations
Dunzo MIS Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Dunzo MIS Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Community Operations Specialist
116
salaries
|  ₹2.6 L/yr - ₹4.3 L/yr |
|
Store Manager
104
salaries
| ₹3.8 L/yr - ₹7 L/yr |
|
Procurement Manager
103
salaries
| ₹3.5 L/yr - ₹7 L/yr |
|
Delivery Boy
91
salaries
| ₹0.5 L/yr - ₹4.5 L/yr |
|
Inward Executive
90
salaries
| ₹1.9 L/yr - ₹3.5 L/yr |
Swiggy
Zepto
Porter
Rapido
- Home >
- Interviews >
- Dunzo Interview Questions >
- Dunzo MIS Analyst Interview Questions
