Swiggy Business Analyst Interview Questions, Process, and Tips

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.
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

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 answers
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