Myntra Business Analyst Interview Questions and Answers

Q1. Write a sql querry about mom growth channel wise
Ans. 
SQL query to analyze month-over-month growth by channel, focusing on sales data.
• Identify the relevant tables: sales, channels, and dates.

• Use the SUM function to aggregate sales by channel and month.

• Calculate growth using the formula: (current month sales - previous month sales) / previous month sales.

• Example SQL query: SELECT channel, MONTH(date) AS month, SUM(sales) AS total_sales FROM sales_data GROUP BY channel, mon...read more
Answered by AI
Add your answer
Q2. Pdp drop is there what all you analyse
Ans. 
Analyzing a drop in PDP involves examining various factors affecting performance and identifying root causes.
• Review historical data to identify trends and patterns in PDP performance.

• Analyze customer feedback to understand potential dissatisfaction or issues.

• Evaluate marketing strategies to see if changes have impacted PDP.

• Investigate operational changes that may have affected product delivery or quality.

• Conduct compet...read more
Answered by AI
Add your answer

Written test, asked to write queries on paper for given questions

SQL queries based on e-commerce platform. Warehouse and data modelling related questions.

How to improve delivery system and logistics in e-commerce platform?

Q1. Given a table and asked to perform all kinds of joins
Ans. 
Understanding different types of SQL joins to combine data from multiple tables effectively.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the right table and matched re...read more
Answered by AI
Add your answer