Swiggy Business Analyst Interview Questions and Answers

The questions were related to Data Interpretation/Logical Reasoning and general aptitude.

Q1. Questions related to SQL queries, window functions, 2-3 sql queries had to write
Add your answer
Q2. Statistics related questions, left skewed, right skewed etc.
Add your answer
Q3. Questions related to basics of ML
Add your answer

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.

Q1. General Project and HR related questions.
Add your answer
Q2. Things you want to improve in swiggy and metrics to measure and evaluate them.
Ans. 
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...read more
Answered by AI
Add your answer

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.

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
Answered by AI
Add your answer
Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Ans. 
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.
Answered by AI
Add your answer

Q1. Starting from how joins work to advanced sql.
Add your answer
Q2. A question on case study
Add your answer

8 sql questions
1 hard, 4 easy and 3 medium

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
Answered by AI
Add your answer
Q2. SQL based basic questions. Output of left join and inner right join
Add your answer
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
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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
Answered by AI
Add your answer