Swiggy Business Analyst Interview Questions, Process, and Tips for Experienced

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 issues...read more

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

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_sum FR