Data Analyst • Behavioral • medium

Tell me about an analysis that changed a major business decision.

#Business Impact #Influence

Practice

Data Analyst • Behavioral • medium

How do you handle a situation where a stakeholder challenges your analysis?

#Stakeholders #Confidence

Practice

Data Analyst • Behavioral • medium

Describe a time you found an insight that was counterintuitive.

#Curiosity

Practice

Data Analyst • Behavioral • hard

Tell me about a time you had incomplete data but still needed to deliver analysis.

#Ambiguity

Practice

Data Analyst • Behavioral • medium

How do you prioritize analytical requests when multiple teams need you?

#Time Management

Practice

Data Analyst • Behavioral • medium

Describe a dashboard you built that was widely adopted. What made it successful?

#Visualization

Practice

Data Analyst • Behavioral • medium

Tell me about a time you discovered data quality issues mid-analysis. What did you do?

#Problem Solving

Practice

Data Analyst • Behavioral • easy

How do you ensure your analyses are reproducible?

#Reproducibility

Practice

Data Analyst • Coding • medium

Write a SQL query to calculate month-over-month revenue growth.

#Revenue #Growth Analytics

Practice

Data Analyst • Coding • hard

How would you build a cohort analysis for user retention in SQL?

#Cohort Analysis #Retention

Practice

Data Analyst • Coding • hard

Write a SQL query to find customers who made purchases in both January and February but not March.

#Set Operations

Practice

Data Analyst • Coding • hard

What is a funnel query? Write one for a 3-step user onboarding flow.

#Funnel Analysis

Practice

Data Analyst • Coding • medium

Explain window functions. Write a query using LAG() to compute day-over-day change.

#Window Functions

Practice

Data Analyst • Coding • hard

How would you detect anomalies in a daily revenue time series using SQL?

#Anomaly Detection #SQL

Practice

Data Analyst • Coding • hard

Write a SQL query to calculate the rolling 28-day average session duration per user.

#Rolling Average #Sessions

Practice

Data Analyst • Coding • medium

What is a pivot table in SQL? How would you implement it without native PIVOT support?

#Pivot #Data Transformation

Practice

Data Analyst • Coding • medium

How would you use pandas to compute a 7-day rolling average of sessions?

#Pandas #Time Series

Practice

Data Analyst • Coding • easy

Explain how groupby and agg work in pandas with an example.

#Pandas #GroupBy

Practice

Data Analyst • Coding • medium

How would you merge two large DataFrames efficiently in pandas?

#Pandas #Merging

Practice

Data Analyst • Coding • medium

Describe how to detect and handle outliers in a dataset using Python.

#Outliers #Data Cleaning

Practice

Data Analyst • Coding • easy

Write Python code to load a CSV, clean missing values, and compute summary statistics.

#Data Cleaning #Pandas

Practice

Data Analyst • Technical • easy

Explain the difference between a HAVING clause and a WHERE clause.

#SQL Basics

Practice

Data Analyst • Technical • medium

How do you handle timezone conversions in SQL analytics?

#Timezones #Analytics

Practice

Data Analyst • Technical • hard

Daily Active Users dropped 15% yesterday. Walk me through how you'd investigate.

#Root Cause Analysis #Metrics

Practice

Data Analyst • Technical • medium

What is customer lifetime value (LTV)? How would you calculate it?

#LTV #Retention

Practice

Data Analyst • Technical • easy

Explain the difference between DAU, WAU, and MAU. Which is most useful and when?

#Engagement #KPIs

Practice

Data Analyst • Technical • medium

How would you measure the success of a new feature launch?

#Feature Success #Metrics

Practice

Data Analyst • Technical • easy

What is ARPU (Average Revenue Per User)? How do you segment ARPU analysis?

#ARPU #Revenue

Practice

Data Analyst • Technical • hard

Explain the concept of attribution modeling. What are last-click vs multi-touch models?

#Marketing Analytics

Practice

Data Analyst • Technical • medium

How would you build a dashboard to monitor e-commerce funnel health?

#Visualization #Funnel

Practice

Data Analyst • Technical • hard

What metrics would you use to measure the health of a marketplace?

#Marketplace #Supply & Demand

Practice

Data Analyst • Technical • easy

What is net promoter score (NPS)? How do you analyse NPS trends?

#NPS #Customer Satisfaction

Practice

Data Analyst • Technical • hard

How would you measure the impact of a pricing change on revenue?

#Pricing #A/B Test

Practice

Data Analyst • Technical • hard

Explain how you'd set up an A/B test to validate a new checkout flow.

#A/B Testing #Statistics

Practice

Data Analyst • Technical • hard

What sample size do you need for an A/B test? How do you calculate it?

#Sample Size #Power

Practice

Data Analyst • Technical • hard

A/B test shows p=0.04, but the effect size is tiny. Would you ship?

#Practical Significance #Decision Making

Practice

Data Analyst • Technical • medium

What is a novelty effect in experimentation? How do you account for it?

#Novelty Effect #Bias

Practice

Data Analyst • Technical • hard

How do you handle multiple metrics in an A/B test (metric tradeoffs)?

#Multiple Metrics #Tradeoffs

Practice

Data Analyst • Technical • medium

What makes a good data visualization? Walk me through your design principles.

#Design #Communication

Practice

Data Analyst • Technical • medium

How would you explain statistical significance to a non-technical product manager?

#Storytelling #Statistics

Practice

Data Analyst • Technical • easy

What tools do you use for dashboarding? Compare Tableau, Looker, and Metabase.

#Tableau #Looker

Practice

Data Analyst • Technical • easy

How do you choose between a bar chart, line chart, and scatter plot?

#Charts #Design

Practice

Data Analyst • Technical • medium

Describe your process for creating an executive-level analytics presentation.

#Executive Reporting

Practice

Meta

The Interview Loop

Recruiter Screen (30 min)

Technical Loop (3-4 Rounds)

Interview Question Bank

Tell me about an analysis that changed a major business decision.

How do you handle a situation where a stakeholder challenges your analysis?

Describe a time you found an insight that was counterintuitive.

Tell me about a time you had incomplete data but still needed to deliver analysis.

How do you prioritize analytical requests when multiple teams need you?

Describe a dashboard you built that was widely adopted. What made it successful?

Tell me about a time you discovered data quality issues mid-analysis. What did you do?

How do you ensure your analyses are reproducible?

Write a SQL query to calculate month-over-month revenue growth.

How would you build a cohort analysis for user retention in SQL?

Write a SQL query to find customers who made purchases in both January and February but not March.

What is a funnel query? Write one for a 3-step user onboarding flow.

Explain window functions. Write a query using LAG() to compute day-over-day change.

How would you detect anomalies in a daily revenue time series using SQL?

Write a SQL query to calculate the rolling 28-day average session duration per user.

What is a pivot table in SQL? How would you implement it without native PIVOT support?

How would you use pandas to compute a 7-day rolling average of sessions?

Explain how groupby and agg work in pandas with an example.

How would you merge two large DataFrames efficiently in pandas?

Describe how to detect and handle outliers in a dataset using Python.

Write Python code to load a CSV, clean missing values, and compute summary statistics.

Explain the difference between a HAVING clause and a WHERE clause.

How do you handle timezone conversions in SQL analytics?

Daily Active Users dropped 15% yesterday. Walk me through how you'd investigate.

What is customer lifetime value (LTV)? How would you calculate it?

Explain the difference between DAU, WAU, and MAU. Which is most useful and when?

How would you measure the success of a new feature launch?

What is ARPU (Average Revenue Per User)? How do you segment ARPU analysis?

Explain the concept of attribution modeling. What are last-click vs multi-touch models?

How would you build a dashboard to monitor e-commerce funnel health?

What metrics would you use to measure the health of a marketplace?

What is net promoter score (NPS)? How do you analyse NPS trends?

How would you measure the impact of a pricing change on revenue?

Explain how you'd set up an A/B test to validate a new checkout flow.

What sample size do you need for an A/B test? How do you calculate it?

A/B test shows p=0.04, but the effect size is tiny. Would you ship?

What is a novelty effect in experimentation? How do you account for it?

How do you handle multiple metrics in an A/B test (metric tradeoffs)?

What makes a good data visualization? Walk me through your design principles.

How would you explain statistical significance to a non-technical product manager?

What tools do you use for dashboarding? Compare Tableau, Looker, and Metabase.

How do you choose between a bar chart, line chart, and scatter plot?

Describe your process for creating an executive-level analytics presentation.

Difficulty Radar

Meet Your Interviewers

The "Standard" Interviewer

Unwritten Rules