Vedantu Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Data Analyst at an Indian unicorn or high-growth startup like Vedantu works on product, growth, and business problems using data. Day to day, they write SQL queries, build dashboards, run experiments, and share insights with product, marketing, and operations teams. The role is fast-paced and requires translating ambiguous questions into clear analyses that drive decisions.

Role and Technical Knowledge

1. 1

   What is the difference between a primary key and a foreign key in SQL, and why does it matter when joining tables?

   A strong answer defines both, explains uniqueness and referential integrity, and gives an example of joining a users table with an orders table.

2. 2

   How would you explain A/B testing to a product manager who is not technical?

   Cover random assignment, control vs treatment, one primary metric, and how to decide significance without jargon.

3. 3

   What are DAU, MAU, and stickiness, and how would you use them to evaluate an EdTech app like Vedantu?

   Define each metric, explain stickiness as DAU/MAU, and suggest how a low stickiness might indicate a need to improve daily engagement features.

4. 4

   When would you use a window function instead of a GROUP BY in SQL?

   Explain that window functions keep row-level detail while aggregating, useful for running totals, rankings, or comparing each row to a group average.

Practical Scenarios and Case Questions

1. 5

   Daily active users on a learning app dropped by 15 percent last week. How would you investigate this?

   Suggest checking data pipeline issues first, then segment by platform, geography, user cohort, and feature usage to isolate the cause.

2. 6

   You have data on student watch time and test scores. How would you find out if watching more videos leads to better scores?

   Discuss correlation vs causation, possible confounders like prior ability, and suggest a controlled experiment or regression with controls.

3. 7

   A marketing team wants to know which channel brings the most valuable users, not just the most users. What metrics would you use?

   Mention retention rate, conversion to paid, lifetime value, and cost per acquisition, and explain why raw sign-ups can be misleading.

4. 8

   How would you design a dashboard for a teacher success team to monitor student engagement?

   Focus on key metrics like weekly active students, assignment completion rate, and time to first doubt resolution, with filters by class and subject.

Behavioural and Situational Questions

1. 9

   Tell me about a time you used data to solve a problem in a college project or internship.

   Use the STAR method, highlight the data source, your analysis method, and the measurable outcome or decision it influenced.

2. 10

   Describe a situation where you had to explain a technical finding to a non-technical person.

   Show how you simplified the insight, used a visual or analogy, and checked for understanding without being condescending.

3. 11

   You are given a messy dataset with many missing values and no documentation. What do you do?

   Explain a step-by-step approach: profile the data, quantify missingness, decide on imputation or exclusion, and document assumptions.

4. 12

   Tell me about a time you received critical feedback on your work. How did you respond?

   Demonstrate openness, a specific action you took to improve, and the positive result that followed.

HR and Company Fit

1. 13

   Why do you want to work as a data analyst at a high-growth startup like Vedantu instead of a large established company?

   Connect your desire for fast-paced learning, broad ownership, and direct impact on product decisions to the startup environment.

2. 14

   Where do you see yourself in three years as a data analyst?

   Show a realistic growth path, such as deepening product analytics skills or moving toward data science, while staying grounded in the role.

3. 15

   How do you keep your SQL and analytics skills sharp outside of coursework?

   Mention online practice platforms, personal projects, Kaggle, or open datasets, and give a concrete example of recent learning.

4. 16

   What do you know about the EdTech sector and the challenges companies like Vedantu face?

   Discuss user retention, content personalization, and the shift to hybrid learning, showing you have researched the sector beyond surface level.