Get AmbitionBox App
Faster and better experience!
AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Swiggy Business Analyst Interview Questions and Answers
11 Interview questions
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).
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 ...
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
DDL is used to create, modify, and delete database objects like tables, indexes, etc.
DML is used to insert, update, delete, and retrieve data from the database.
Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP ...
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
What people are saying about Swiggy
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.
Rolling sum query adds up a specified number of rows in a table based on a given condition.
Use the OVER() function to specify the window frame for the rolling sum.
Specify the number of rows to include in the window frame using ROWS BETWEEN.
Use ORDER BY to specify the order of rows in the window frame.
Example: SELECT column1, SUM(column2) OVER (ORDER BY column1 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_s...
Steps involved in analyzing decrease in sales for a particular area
Identify the time period for which sales have decreased
Analyze the sales data for the area and compare it with previous periods
Identify any external factors that may have contributed to the decrease in sales
Conduct customer surveys to identify any issues with products or services
Analyze competitor activity in the area
Develop a plan to address the i...
SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.
Use AVG function to calculate mean waiting period
Subtract ordered time from delivered time to get waiting period
Filter data by driver ID and delivery partner
Group by delivery partner
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS...
Types of SQL joins and their minimum and maximum possible rows.
Types of joins: Inner, Left Outer, Right Outer, Full Outer, Cross
Minimum rows: Inner - 0, Left/Right Outer - 1, Full Outer - 0, Cross - product of rows
Maximum rows: Inner/Left/Right/Full Outer - product of rows, Cross - product of rows
Swiggy Business Analyst Interview Experiences
25 interviews found
Anonymous
Selected
I appeared for an interview in Aug 2024.
The questions were related to Data Interpretation/Logical Reasoning and general aptitude.
(3 Questions)
- Q1. Questions related to SQL queries, window functions, 2-3 sql queries had to write
- Q2. Statistics related questions, left skewed, right skewed etc.
- Q3. Questions related to basics of ML
A company wants to open a new store, what would the factors you would consider.
A ride sharing company wants dynamic pricing in place of flat pricing, what factors you would consider.
(2 Questions)
- Q1. General Project and HR related questions.
- Q2. Things you want to improve in swiggy and metrics to measure and evaluate them.
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.
(2 Questions)
- Q1. Introduction and explain any one of the projects plus what was the analytics you used
- Ans.
Implemented a project to optimize marketing campaigns using predictive analytics
Developed a predictive model to identify the most effective marketing channels
Utilized data from past campaigns to train the model
Used techniques such as regression analysis and decision trees to analyze the data
Generated insights on customer behavior and preferences to improve campaign targeting
- Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
8 sql questions
1 hard, 4 easy and 3 medium
(5 Questions)
- Q1. Tell me about yourself. Your responsibilities in current role.
- Ans.
I am a Business Analyst with experience in data analysis, process improvement, and stakeholder management.
Analyze data to identify trends and insights
Improve business processes through automation and optimization
Manage relationships with stakeholders to gather requirements and ensure project success
- Q2. SQL based basic questions. Output of left join and inner right join
- Q3. Any notable project you’ve done which made any remarkable change in business
- Ans.
Implemented a data analytics project that optimized inventory management, resulting in a 20% reduction in costs.
Analyzed historical sales data to forecast demand and optimize inventory levels
Implemented a new inventory management system based on data-driven insights
Collaborated with cross-functional teams to ensure successful implementation
Monitored key performance indicators to track the impact of the project
- Q4. Difference between DDL and DML
- Ans.
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
DDL is used to create, modify, and delete database objects like tables, indexes, etc.
DML is used to insert, update, delete, and retrieve data from the database.
Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP TABLE...
- Q5. How null behaves in different types of joins
- Ans.
Null behaves differently in different types of joins in SQL
In INNER JOIN, rows with NULL values are excluded from the result set
In LEFT JOIN, rows with NULL values from the left table are included in the result set
In RIGHT JOIN, rows with NULL values from the right table are included in the result set
In FULL OUTER JOIN, rows with NULL values from either table are included in the result set
Skills evaluated in this interview
Aniket Joglekar
I applied via Company Website and was interviewed in Jan 2024. There were 3 interview rounds.
Hackerrank SQL questions and one case study question
(2 Questions)
- Q1. SQL questions related to rank, dense rank, joins
- 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
(3 Questions)
- 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 ...
- 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...
- 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
- Q3. Myntra which is only offline now wants to make its presence offline. using myntra data, which city will it open the outlet
Selected
I applied via Approached by Company and was interviewed in Mar 2024. There were 4 interview rounds.
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
(2 Questions)
- 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...
- 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
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
SQL round - 6 problems 2 case studies
(2 Questions)
- Q1. SQL #1 Self join
- Q2. SQL #2 Window funciton
RCA for CTR drop in youtube
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
Mostly sql question asked, moderate level
(2 Questions)
- Q1. Sql join and sub query
- Q2. Window functions
SQL Test by HackerRank
Selected
I applied via Company Website and was interviewed before Jan 2024. There were 3 interview rounds.
(1 Question)
- Q1. Quest on window function , joins, sql problems
If we add "add to cart" option directly from search bar on amazon/flipkart. would that be a good or bad decision.
(1 Question)
- Q1. Weakness, strength
I applied via Referral and was interviewed before Oct 2023. There were 3 interview rounds.
Around SQL and Python and some questions on my work experience
(2 Questions)
- 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...
- 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).
One question was on Guesstimate and others were related to Problem solving
Skills evaluated in this interview
Swiggy Interview FAQs
Some of the top questions asked at the Swiggy Business Analyst interview -
The duration of Swiggy Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Swiggy Interviews By Designations
- Swiggy Business Analyst Interview Questions
- Swiggy Sales Manager Interview Questions
- Swiggy Fleet Manager Interview Questions
- Swiggy Assistant Store Manager Interview Questions
- Swiggy Store Manager Interview Questions
- Swiggy MIS Executive Interview Questions
- Swiggy Business Associate Interview Questions
- Swiggy Team Lead Interview Questions
- Show more
Business Analyst Interview Questions from Similar Companies
Swiggy Business Analyst Reviews and Ratings
based on 22 reviews
Rating in categories
2-4 Yrs
₹ 5-22 LPA
2-3 Yrs
₹ 5-19.5 LPA
|
Delivery Boy
894
salaries
|  ₹0.4 L/yr - ₹5 L/yr |
|
Fleet Manager
664
salaries
| ₹2.5 L/yr - ₹6 L/yr |
|
Sales Manager
567
salaries
| ₹2.8 L/yr - ₹9 L/yr |
|
Assistant Manager
529
salaries
| ₹5.6 L/yr - ₹15 L/yr |
|
Assistant Store Manager
456
salaries
| ₹1.7 L/yr - ₹4.2 L/yr |
Eternal Limited
Dunzo
FoodPanda
Rapido
- Home >
- Interviews >
- Swiggy Interview Questions >
- Swiggy Business Analyst Interview Questions
