Filter interviews by
Enhancing Swiggy's user experience and operational efficiency through targeted improvements and measurable metrics.
Improve delivery time: Measure average delivery time and set a target to reduce it by 15% over the next quarter.
Enhance customer support: Track response time and resolution rate of customer queries, aiming for a 90% satisfaction score.
Expand restaurant partnerships: Monitor the number of new restauran...
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 ...
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).
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
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 ...
Calculate cumulative sum of cost using SQL with window functions for a given table.
Use the SUM() function with OVER() clause for cumulative sum.
Example: SELECT cost, SUM(cost) OVER (ORDER BY date) AS cumulative_cost FROM expenses;
Ensure proper ordering to get accurate cumulative results.
You can partition data if needed using PARTITION BY clause.
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 spend...
Myntra should analyze customer data, sales trends, and demographics to choose the best city for its offline outlet.
Analyze customer demographics: Identify cities with a high concentration of Myntra's target audience, such as young professionals.
Sales trends: Look at online sales data to find cities with the highest sales volume, indicating strong brand presence.
Competitor analysis: Evaluate cities where competitor...
Analyzing Flipkart's sales drop requires examining various metrics and frameworks to identify underlying issues.
1. Sales Trends: Compare daily sales data from this week to last week to identify specific days with significant drops.
2. Customer Traffic: Analyze website/app traffic to see if there was a decrease in visitors, indicating potential issues in attracting customers.
3. Conversion Rate: Check if the conversi...
Formulating hypotheses for Flipkart's payment option transition from credit cards to UPI.
Null Hypothesis (H0): There is no significant difference in transaction success rates between credit card and UPI payments.
Alternate Hypothesis (H1): UPI payments have a significantly higher transaction success rate compared to credit card payments.
Metrics to check: Transaction success rate, average transaction time, customer ...
I appeared for an interview in Aug 2024.
The questions were related to Data Interpretation/Logical Reasoning and general aptitude.
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.
Enhancing Swiggy's user experience and operational efficiency through targeted improvements and measurable metrics.
Improve delivery time: Measure average delivery time and set a target to reduce it by 15% over the next quarter.
Enhance customer support: Track response time and resolution rate of customer queries, aiming for a 90% satisfaction score.
Expand restaurant partnerships: Monitor the number of new restaurant sig...
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.
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
Calculate cumulative sum of cost using SQL with window functions for a given table.
Use the SUM() function with OVER() clause for cumulative sum.
Example: SELECT cost, SUM(cost) OVER (ORDER BY date) AS cumulative_cost FROM expenses;
Ensure proper ordering to get accurate cumulative results.
You can partition data if needed using PARTITION BY clause.
I appeared for an interview in Apr 2025, where I was asked the following questions.
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
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
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
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...
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
I applied via Company Website and was interviewed in Jan 2024. There were 3 interview rounds.
Hackerrank SQL questions and one case study question
Formulating hypotheses for Flipkart's payment option transition from credit cards to UPI.
Null Hypothesis (H0): There is no significant difference in transaction success rates between credit card and UPI payments.
Alternate Hypothesis (H1): UPI payments have a significantly higher transaction success rate compared to credit card payments.
Metrics to check: Transaction success rate, average transaction time, customer satis...
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...
Analyzing Flipkart's sales drop requires examining various metrics and frameworks to identify underlying issues.
1. Sales Trends: Compare daily sales data from this week to last week to identify specific days with significant drops.
2. Customer Traffic: Analyze website/app traffic to see if there was a decrease in visitors, indicating potential issues in attracting customers.
3. Conversion Rate: Check if the conversion ra...
Myntra should analyze customer data, sales trends, and demographics to choose the best city for its offline outlet.
Analyze customer demographics: Identify cities with a high concentration of Myntra's target audience, such as young professionals.
Sales trends: Look at online sales data to find cities with the highest sales volume, indicating strong brand presence.
Competitor analysis: Evaluate cities where competitors hav...
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
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...
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
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
SQL round - 6 problems 2 case studies
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
SQL Test by HackerRank
I applied via Company Website and was interviewed before Jan 2024. There were 3 interview rounds.
If we add "add to cart" option directly from search bar on amazon/flipkart. would that be a good or bad decision.
Top trending discussions
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.
based on 25 interview experiences
Difficulty level
Duration
based on 22 reviews
Rating in categories
2-4 Yrs
₹ 5-22 LPA
2-3 Yrs
₹ 5-19.5 LPA
Delivery Boy
895
salaries
| ₹0.4 L/yr - ₹5.1 L/yr |
Fleet Manager
656
salaries
| ₹2.6 L/yr - ₹6 L/yr |
Sales Manager
570
salaries
| ₹2.8 L/yr - ₹9.5 L/yr |
Assistant Manager
509
salaries
| ₹5.6 L/yr - ₹14.2 L/yr |
Store Manager
466
salaries
| ₹2.4 L/yr - ₹7.2 L/yr |
Eternal Limited
Dunzo
FoodPanda
Rapido