Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Dunzo Team. If you also belong to the team, you can get access from here

Dunzo Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Dunzo MIS Analyst Interview Questions and Answers

Updated 2 Aug 2023

Dunzo MIS Analyst Interview Experiences

2 interviews found

MIS Analyst Interview Questions & Answers

user image Anonymous

posted on 20 Oct 2022

I applied via Company Website and was interviewed in Sep 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(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)
Round 3 - One-on-one 

(1 Question)

  • Q1. Questions based on previous work experience (internships), personal life, one guesstimate

Interview Preparation Tips

Topics to prepare for Dunzo MIS Analyst interview:
  • SQL
  • Case Studies
Interview preparation tips for other job seekers - Prepare well for SQL using Ankit Bansal's YouTube videos, case studies also there are many resources. Know your old projects and experiences well.

MIS Analyst Interview Questions & Answers

user image Anonymous

posted on 2 Aug 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 2022. There were 3 interview rounds.

Round 1 - Coding Test 

Hackerrank test of SQL, excel and tableau

Round 2 - Technical 

(1 Question)

  • Q1. Question on joins and simple problems
Round 3 - Technical 

(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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Should be strong in SQL

Skills evaluated in this interview

MIS Analyst Interview Questions Asked at Other Companies

asked in Swiggy
Q1. 1.what do you know about Swiggy and it's business model. 2.simple ... read more
asked in Swiggy
Q2. Write a query to find out students has greater than 80 marks and ... read more
Q3. How to start VBA code and what sub and what is sub called
asked in RBL Bank
Q4. Except excel what do you know Vba or python
Q5. How far have you the knowledge of Managing And it's systems..

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed before Dec 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1.what do you know about Swiggy and it's business model. 2.simple SQL queries 3. Vlookup.
  • Ans. 

    Swiggy is an Indian food delivery company that operates through a website and mobile app.

    • Swiggy was founded in 2014 and is headquartered in Bangalore, India.

    • It partners with local restaurants to provide food delivery services to customers.

    • Swiggy's business model is based on charging a commission fee from the restaurants for every order placed through their platform.

    • It has expanded to over 500 cities in India and has ov...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not join as MIS in Swiggy. Work of MIS will be just copy paste nothing else. Join only if you have financial problems. Here you can't get any hike nor they will make permanent.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Dec 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Aptitude Test 

Basic attitude test conducted first.

Round 3 - One-on-one 

(5 Questions)

  • Q1. Questions related to Advanced MS Excel, Basic SQL Queries.
  • 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
  • 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...

  • Answered by AI
  • 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...

  • Answered by AI
  • 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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Work on MS Excel & SQL Queries
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Asking about ur self introduction and work experience

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Technical 

(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]).

  • Answered by AI
  • 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
  • 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
  • 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
Round 2 - Technical 

(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...

  • Answered by AI
  • 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
  • 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'

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Swiggy MIS Analyst interview:
  • EXCEL FUNCTIONS
  • SQL JOINS
  • SQL CLAUSES
Interview preparation tips for other job seekers - Prepare well for advance excel and google sheet function and formulas Theoretically as well as practically.
also prepare deep from SQL basic to advance.

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: it was a basic test, CAT level questions and can be easily cleared
Tips: keep your cool, don't panic
Duration: 60 minutes
Total Questions: 60

College Name: IIT BOMBAY

Analyst Interview Questions & Answers

Ola Cabs user image Satyam Mudaliar

posted on 18 Sep 2015

Interview Preparation Tips

Round: Test
Experience: English was unpredictable.. Maths was easy but it will be good if you have practice, logical reasoning requires practice but are interesting
Tips: Leave english comprehensions for the end.. Do not waste too much time on one question even if it appears easy.. attempt the paper in the order of your comfort and mark every questions in case of NO negative marking
Duration: 60 minutes

Round: HR Interview
Tips: Smile!! And think before speaking anything, else you may contradict your own point.. Prepare "Tell me about yourself" well and guide your interview by focusing on your strongest point, you may face more questions on that point.. refer to 64 HR questions book

Round: Stress Interview
Tips: If they are giving you stress, that means they like you.. Relax!! Do not get nervous, thats what they want to check.. Think for the solution to the problem normally, you know you can crack it (Stress interview may be a part of HR, technical, case or any other interview.. you may have to make it out yourself)

Skill Tips: ""
Skills: Puzzles, Speaking skills, Aptitude, guesstimates, Case solving, presentation skills
College Name: IIT Bombay

Business Analyst Interview Questions & Answers

Ola Cabs user image Vishnuvardhan Reddy Kotte

posted on 21 Feb 2015

Interview Questionnaire 

3 Questions

  • Q1. Give some quantifiable factors you can use to rate( for comapny's purpose) among a repository of cab drivers we have?
  • Ans. 

    Quantifiable factors to rate cab drivers for company's purpose

    • Customer ratings and feedback

    • Number of completed trips

    • Average trip duration

    • Percentage of on-time pickups

    • Accident and traffic violation history

    • Vehicle cleanliness and maintenance

    • Driver punctuality and professionalism

  • Answered by AI
  • Q2. If you are on the selection committee of BCCI what would be your criterion for choosing between Yuvraj Singh and Stuart Binny for the World Cup squad?
  • Ans. 

    The criterion for choosing between Yuvraj Singh and Stuart Binny for the World Cup squad would be based on their recent performance, fitness, and team balance.

    • Evaluate recent performance of both players

    • Assess fitness levels of both players

    • Consider team balance and required skill sets

    • Analyze pitch and weather conditions of the tournament

    • Take into account the opposition teams and their strengths and weaknesses

  • Answered by AI
  • Q3. Some questions on programming (Pseudo Codes )

Interview Preparation Tips

Round: Test
Experience: There were questions on general aptitude like work and time, probability, and some questions were on data interpretation, coding and decoding, etc., most of the questions were very simple...but I felt the data interpretation questions to be a bit tricky (completely my opinion though).. ON THE BASIS OF THIS TEST THEY SHORTLISTED ROUGHLY 15 OUT OF 150 (again a rough figure)
Tips: Manage your time wisely...start with the type of questions you feel comfortable...try to attempt all the questions....improve your speed while practicing.
Duration: 45min minutes
Total Questions: 45

Round: Test
Experience: We were given 3 questions to solve in 30 min duration.Later we were told to walk them through our solution . Two of them were on probability(one random variables and the other on basic probability) and one was on estimating the area of an irregular figure , given some tools.
Tips: Get all the doubts regarding the questions clarified .As you have to explain your solution, it would be helpful if you could pen down all the steps clearly ( as it shows them that your thought process is an organised one). Use pictorial representation if needed. When they propose some other method be open to it and be open to any method they propose and be clear with the method you adopted. Even if you didn't arrive at the final answer, try to communicate your idea on solving the problem( most of the times they will listen to what you say).
Duration: 30min minutes
Total Questions: 3

Round: Other Interview
Experience: They were basically looking for quantifiable factors...so think of some quantifiable factors like the number of Times they are available to you in a day and the number of service providers they engage with. etc.,
For the second question again use quantifiable factors which make sense.
Tips: They patiently listened to what I said . So, be calm and don't be in a haste.

Skill Tips: Be a bit quick while solving the Aptitude questions....Know about the company before you go in for the interview process....No need of any prior knowledge in R language ...They just tested my Willingness to learn new things.
Skills: Aptitude Skills, Communication Skills, Structured thought process, Out of the box thinking, Basic programming skills ( very basic)
College Name: IIT KANPUR

Business Analyst Interview Questions & Answers

Paytm user image Rockey Maheshwari

posted on 8 Sep 2015

Interview Preparation Tips

Round: Test
Experience: It was a test of moderate level.

20 ques in 20 min.

Basic focus was speed and accuracy.

Tested calculation speed.
Tips: Try to decide which ques to answer and which ones to leave.

Its very important not to get stuck in any 1 ques and waste time. MOVE ON!
Duration: 20 minutes
Total Questions: 20

Round: Technical Interview
Experience: Hi ! i dont remember the question but I do remember that they were easy.

The interviewers are there to test you not to embarrass you. or humiliate you.
They dont expect you to answer every ques so no need to get frustrated if you get a couple of them wrong.
Tips: Go easy...
If you dont know answer to a ques , dont panic,. They are willing to qive you points for your approach.

General Tips: Relax at all times
Skill Tips: Just practice. Whenever you are on facebook solve a couple of brain teasers.


Skills: Aptitude
College Name: DTU
Motivation: Good Future prospects!
Contribute & help others!
anonymous
You can choose to be anonymous

Dunzo Interview FAQs

How many rounds are there in Dunzo MIS Analyst interview?
Dunzo interview process usually has 3-4 rounds. The most common rounds in the Dunzo interview process are Technical, Resume Shortlist and One-on-one Round.
How to prepare for Dunzo MIS Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Dunzo. The most common topics and skills that interviewers at Dunzo expect are Management, SQL Queries, Analytical skills, Microsoft Applications and Networking.
What are the top questions asked in Dunzo MIS Analyst interview?

Some of the top questions asked at the Dunzo MIS Analyst interview -

  1. SQL joins differe...read more
  2. Two case studies - one dealing with root cause analysis, other with revenue sou...read more
  3. Basic SQL Questions on Joins, writing quer...read more

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

SALARIES

JUSPAY

INTERVIEWS

DISH TV

No Interviews

INTERVIEWS

Tata 1mg

No Interviews

LIST OF COMPANIES

Amadeus Media

Overview

SALARIES

Dunzo

Tell us how to improve this page.

Dunzo MIS Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5k Interviews
Flipkart Interview Questions
4.0
 • 1.3k Interviews
Paytm Interview Questions
3.3
 • 752 Interviews
Swiggy Interview Questions
3.8
 • 428 Interviews
BigBasket Interview Questions
3.9
 • 359 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 328 Interviews
Zomato Interview Questions
3.8
 • 312 Interviews
Zepto Interview Questions
3.5
 • 207 Interviews
Blinkit Interview Questions
3.7
 • 181 Interviews
View all
Dunzo MIS Analyst Salary
based on 5 salaries
₹5 L/yr - ₹9.5 L/yr
58% more than the average MIS Analyst Salary in India
View more details

Dunzo MIS Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

5.0

Skill development

3.0

Work-life balance

3.0

Salary

1.0

Job security

4.0

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Community Operations Specialist
116 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Store Manager
104 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Procurement Manager
104 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Delivery Boy
91 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Inward Executive
90 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Dunzo with

Swiggy

3.8
Compare

Zepto

3.5
Compare

Porter

3.9
Compare

Rapido

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview