Swiggy Business Analyst Interview Questions, Process, and Tips

Focus on SQL and case studies related to Swiggy's business

Q1. Didn't reach to that point
Add your answer

8 SQL questions with increase in complexity and 1 case study

Q1. SQL and Statistics screaning
Add your answer

Q1. Business case studies, guess estimates, little technical
Add your answer

Q1. Complete profile screaning, Checking if candidate is suited for the role, case studies, guess estimates
Add your answer

Q1. Why sudden job change plan
Add your answer
Q2. Why Swiggy and what values did you see before applying
Ans. 
I chose Swiggy for its innovative technology, market leadership, and growth potential.
• Swiggy's cutting-edge technology in the food delivery industry stood out to me

• The company's strong market presence and leadership position were appealing

• I was impressed by Swiggy's rapid growth and expansion in the market

• Swiggy's customer-centric approach and focus on quality service were values I admired
Answered by AI
Add your answer

Q1. Ques.1 How many delivery boy have called customers more than 5 times?
Ans. 
The number of delivery boys who called customers more than 5 times is not provided.
• Data on the number of delivery boys who called customers more than 5 times is missing.

• Need to gather data on the number of delivery boys and their call logs.

• Analysis can be done once the data is available.
Answered by AI
View 5 more answers
Q2. Question 2. Count distinct uniques names from the table
Ans. 
To count distinct unique names from a table, use the SELECT DISTINCT statement with the name column.
• Use SELECT DISTINCT to retrieve unique names

• Specify the name column in the SELECT statement

• Example: SELECT DISTINCT name FROM table_name

• Store the result in an array of strings
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Prepare well for SQL, you have to be strong in SQL. Questions related to SQL and A/B testing were asked.

Q1. Can you write a query to calculate the rolling sum?
Ans. 
Query to calculate rolling sum
• Use window functions like SUM() OVER() in SQL

• Specify the window frame to define the range for the rolling sum

• Example: SELECT date, value, SUM(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FROM table_name
Answered by AI
Add your answer

Basic SQL questions

Q1. SQL python and basic statistics
Add your answer

Problem solving case studies, analytics cases

Q1. Hiring manager round, general HR questions and resume based questions
Add your answer