Udaan Data Analyst Interview: Rounds, Questions and Preparation

What the job involves

As a Data Analyst at Indian unicorns and high-growth startups like Udaan, you will work closely with business, product, and operations teams to extract insights from large datasets, build dashboards, and support data-driven decisions. Day to day, you might query databases, clean data, run analyses, and present findings that directly impact growth, efficiency, and customer experience. The role demands strong SQL, Excel, and visualization skills, along with the ability to communicate complex data simply.

Role and Technical Knowledge

1. 1

   Explain the difference between WHERE and HAVING in SQL, with an example relevant to analyzing user orders.

   Strong answer clarifies that WHERE filters rows before aggregation, while HAVING filters after GROUP BY. Example: WHERE order_date > '2023-01-01' vs HAVING COUNT(order_id) > 10.

2. 2

   How would you use Excel to analyze a dataset of 10,000 rows of daily sales to find the top 5 products by revenue?

   Mention pivot tables, sorting, and formulas like SUMIFS. Show awareness of data cleaning and handling duplicates.

3. 3

   What is a JOIN in SQL? Describe a scenario where you would use a LEFT JOIN versus an INNER JOIN in a startup context.

   Explain that INNER JOIN returns only matching rows, while LEFT JOIN returns all rows from the left table. Scenario: analyzing all users and their orders, including users with no orders (LEFT JOIN).

4. 4

   How do you handle missing or null values in a dataset before analysis?

   Discuss options like deletion, imputation (mean/median), or flagging. Emphasize understanding why data is missing and its impact on analysis.

Practical Scenarios

1. 5

   You are asked to measure the success of a new feature launched on the app. What metrics would you track and how would you set up an A/B test?

   Cover key metrics like adoption rate, retention, conversion. Explain control vs treatment groups, sample size, and statistical significance.

2. 6

   Given a sudden drop in daily active users, how would you investigate the cause?

   Outline a structured approach: check data pipeline, segment by geography, platform, user cohort, and correlate with external events or releases.

3. 7

   You need to create a dashboard for the operations team to track order fulfillment efficiency. What charts and KPIs would you include?

   Suggest KPIs like order processing time, fulfillment rate, delivery delays. Use line charts for trends, bar charts for comparisons, and filters for regions.

4. 8

   How would you estimate the impact of a discount campaign on overall revenue?

   Discuss comparing pre- and post-campaign periods, using control groups if possible, and accounting for seasonality and cannibalization.

Behavioral and HR

1. 9

   Tell me about a time you used data to convince someone to change their decision.

   Use STAR method: describe situation, data you analyzed, how you presented it, and the outcome. Highlight communication and persuasion.

2. 10

   Why do you want to work as a Data Analyst at a high-growth startup like Udaan?

   Show passion for data-driven decision-making, eagerness to learn in a fast-paced environment, and alignment with the company's mission.

3. 11

   Describe a project where you had to learn a new tool or technique quickly. How did you manage?

   Emphasize adaptability, self-learning, and applying the new skill to deliver results. Mention specific resources or methods.

4. 12

   How do you prioritize multiple data requests from different stakeholders?

   Discuss assessing urgency, impact, and effort. Communicate timelines and manage expectations. Example: using a simple prioritization matrix.

Advanced Analytics and Problem Solving

1. 13

   Explain the difference between correlation and causation. How would you avoid mistaking one for the other in a business analysis?

   Clarify that correlation does not imply causation. Suggest using controlled experiments, regression with controls, or instrumental variables.

2. 14

   Write a SQL query to find the second highest salary from an Employee table.

   Use subquery with LIMIT/OFFSET or window function like DENSE_RANK. Show awareness of ties and null handling.

3. 15

   How would you detect and handle outliers in a dataset of delivery times?

   Mention statistical methods (IQR, Z-score) and business context. Discuss whether to remove, cap, or investigate outliers.

4. 16

   What is a funnel analysis? How would you apply it to an e-commerce checkout process?

   Define funnel stages (e.g., cart addition, address entry, payment). Identify drop-off points and suggest improvements based on data.