Top 10 Swiggy Data Analyst Interview Questions 2025

Q 1. How to Write an SQL Query to Find the Top 5 Most-Watched Netflix Shows by Region?

ANS- Use GROUP BY, COUNT(), and RANK() or ROW_NUMBER() with a partition by region.

SELECT region, show_title, view_count
FROM (
  SELECT region, show_title, COUNT(*) AS view_count,
         RANK() OVER (PARTITION BY region ORDER BY COUNT(*) DESC) AS rank
  FROM viewing_logs
  GROUP BY region, show_title
) ranked
WHERE rank <= 5;

---

Q 2. How to Calculate Monthly Churn Rate Using Subscriber Data in SQL or Python?

ANS- Churn rate = (Subscribers lost during month) / (Subscribers at start of month)
In SQL:

SELECT 
  month,
  ROUND((churned_users * 1.0 / starting_users) * 100, 2) AS churn_rate
FROM monthly_subscriber_data;

In Python (Pandas):

df['churn_rate'] = (df['churned_users'] / df['starting_users']) * 100

---

Q 3. Best Method to Identify Peak Viewing Hours Per Day from Large Streaming Log Datasets?

ANS- Use EXTRACT(HOUR FROM timestamp) or DATEPART(HOUR, timestamp) to group by hour.

SELECT EXTRACT(HOUR FROM view_time) AS hour, COUNT(*) AS views
FROM streaming_logs
GROUP BY hour
ORDER BY views DESC;

---

Q 4. How to Analyze the Success of a Newly Released Netflix Series Using Performance and Engagement Metrics

ANS- Track:

Total hours viewed

Completion rate

Retention impact

Social sentiment

• Use Netflix’s engagement reports and compare against similar titles

Q 5. What Is A/B Testing and How to Evaluate a New Recommendation Algorithm?

ANS- Split users into control and test groups. Measure:

• Click-through rate
• Watch time
• Conversion rate Use statistical significance tests to validate results

Keywords: A/B testing recommendation system, Netflix algorithm evaluation

---

Q 6. How to Define and Measure a Strong User Engagement Metric for Netflix Streaming Behavior?

ANS- Use metrics like:

• Total watch time per session
• Completion rate
• Daily active users (DAU)
• Retention after 7/30 days Netflix’s North Star Metric: Hours watched per subscriber per month

Keywords: Netflix engagement metric, streaming behavior analysis

---

Q7. How to Estimate Daily Bandwidth Savings If Video Compression Improves by 15%?

ANS- Formula:
Savings = Total daily bandwidth × 0.15
Example:
If Netflix uses 1 PB/day → Savings = 150 TB/day
Use compression calculators to model impact

Q 8. How to Build a Power BI or Tableau Dashboard to Track Netflix Content Performance?

ANS- Include:

• Genre trends
• Watch time
• Completion rate
• Regional breakdown Use slicers, filters, and time-series visuals

---

Q 9. How to Present a Data-Driven Story Showing Which Genre Drives User Retention on Netflix?

ANS - Use:

• Retention curves by genre
• Engagement metrics
• Sentiment analysis Genres like drama and thriller often show higher retention

---

Q 10. What Data Insights Can Improve Netflix’s Content Recommendation System?

ANS- Use:

• User watch history
• Skip behavior
• Completion rate
• Collaborative filtering + ML models Netflix uses big data and predictive analytics to personalize recommendations