Swiggy Business Analyst Interview Questions, Process, and Tips

Hackerrank SQL questions and one case study question

Q1. SQL questions related to rank, dense rank, joins
Add your answer
Q2. Flipkart wants to replace its payment options from credit card to upi. so what will be the null and the alternate hypothesis for this. and what will be the metrics to check
Add your answer

Q1. Your uber rating is 4.2. for your first 80 rides. uber has started a new scheme where they give additional 10% of to those customers who have a rating of 4.5 and above. what is the minimum number of trips ...read more
Ans. 
The minimum number of trips required to achieve a rating of 4.5 is 20.
• To calculate the minimum number of trips required, we need to find the difference between the current rating and the desired rating.

• Since the desired rating is 4.5 and the current rating is 4.2, the difference is 0.3.

• Each trip contributes to the rating, so we need to divide the difference by the rating increment per trip.

• The rating increment per trip...read more
Answered by AI
View 5 more amswers
Q2. Flipkart's this week sales was lesser than last week. there was no schemes run by its competitors. so what metrics will you check and also come up with a framework for it
Add your answer
Q3. Myntra which is only offline now wants to make its presence offline. using myntra data, which city will it open the outlet
Add your answer

SQL And Excel Test with Intermidiate to Entry level questions

SQL Test with questions on Window fx and logic

Case on various company and there problems

Q1. Why revenue of Flipkart dropped 20% in December, Compared to November.
Ans. 
The drop in Flipkart's revenue in December compared to November can be attributed to seasonal factors, promotional activities, or changes in consumer behavior.
• Seasonal factors such as holiday sales in November leading to higher revenue compared to December

• Promotional activities like Black Friday or Cyber Monday driving higher sales in November

• Changes in consumer behavior, such as delayed purchases or reduced spending a
Answered by AI
Add your answer
Q2. Why you want to join Swiggy
Ans. 
I want to join Swiggy because of its innovative technology, fast-paced environment, and impact on the food delivery industry.
• Swiggy's cutting-edge technology and data-driven approach to food delivery excites me

• I am drawn to the fast-paced and dynamic work environment at Swiggy

• Swiggy's significant impact on the food delivery industry and its rapid growth potential are appealing to me
Answered by AI
Add your answer

SQL round - 6 problems 2 case studies

Q1. SQL #1 Self join
Add your answer
Q2. SQL #2 Window funciton
Add your answer

RCA for CTR drop in youtube

Mostly sql question asked, moderate level

Q1. Sql join and sub query
Add your answer
Q2. Window functions
Add your answer

SQL Test by HackerRank

Around SQL and Python and some questions on my work experience

Q1. How to handle Outliers
Ans. 
Outliers can be handled by identifying, analyzing, and deciding whether to remove or adjust them based on their impact on the analysis.
• Identify outliers using statistical methods like Z-score, IQR, or visualization techniques like box plots.

• Analyze the outliers to understand if they are due to errors in data collection or represent true anomalies.

• Decide whether to remove outliers if they are errors or adjust them if th...read more
Answered by AI
Add your answer
Q2. What is skewness and it's types
Ans. 
Skewness is a measure of the asymmetry of a distribution.
• Skewness indicates the lack of symmetry in a distribution.

• Positive skewness means the tail on the right side of the distribution is longer or fatter.

• Negative skewness means the tail on the left side of the distribution is longer or fatter.

• Types of skewness: Positive skewness, Negative skewness, and Zero skewness (symmetric distribution).
Answered by AI
Add your answer

One question was on Guesstimate and others were related to Problem solving