Dataford
Top 33
Prep plan
Updated weekly · Last refresh Aug 30

Andreessen Horowitz Strategy & Data Analyst Interview Questions

The questions to prepare for a Andreessen Horowitz Strategy & Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

33questions
~4htotal time
Track your progressSign up free to work through all 33 questions and resume where you left off.
Start practicing free →
1
StrategyStart here. 14 questions · ~112 min
Unit Economics for Consumer MarketplaceMedium

Tests your ability to model unit economics and interpret growth tradeoffs for venture investments.

CACDiagnosisLTVAndreessen Horowitz
Venture Fund Waterfall BuildHard

Tests your ability to model venture fund economics and distribution logic for Andreessen Horowitz-style funds.

EstimationTrade-offsRisk AssessmentAndreessen Horowitz
More Strategy questions with a free account
2
SQL & Data Manipulation4 questions + 3 drills · ~62 min
SQL Extract and Portfolio TrendsMedium

Tests your SQL skills for end-to-end data preparation and portfolio trend analysis.

JoinsData WranglingAggregationsAndreessen Horowitz
SQL Top Quartile YoY GrowthMedium

Tests SQL proficiency for cohort ranking and portfolio analytics.

Window FunctionsRankingAggregationsAndreessen Horowitz
SQL Join for Campaign and ConversionMedium
Practice
Practice drill

Join a16z campaign touches to conversions and calculate campaign reach, attributed conversions, and conversion rates.

JoinsData WranglingAggregationsAndreessen Horowitz
Rank Quora Acquisition ChannelsMedium
Practice
Practice drill

Use joins, a CTE, and aggregation to rank Quora acquisition channels by activated-user conversion rate.

JoinsRankingAggregationsHelloFreshArgo DataQuora
Rank Campaign Segments by ConversionMedium
Practice
Practice drill

Use joins, CTEs, aggregation, and ranking to find the highest-converting customer segment for a campaign.

JoinsGroup ByAggregationsArgo DataAndreessen HorowitzRippling
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Execution8 questions · ~64 min
Build Bulletproof Financial ModelsMedium

Tests your data hygiene practices and modeling robustness for high-stakes fund analytics.

Risk AssessmentData ModelingQualityAndreessen Horowitz
Narrate Complex Financial ConceptsEasy

Tests your communication clarity when explaining analytical results to broad stakeholders.

Trade-offsSuccess CriteriaRisk AssessmentAndreessen Horowitz
More Execution questions with a free account
4
Metrics7 questions · ~56 min
Tableau or Looker GP Performance DashboardsMedium

Tests your dashboard design and data storytelling for Andreessen Horowitz GP audiences.

KPIsLeading IndicatorsDiagnosisAndreessen Horowitz
Real-Time GP Investment DashboardMedium

Tests your ability to design decision-ready metrics and dashboards for Andreessen Horowitz GPs.

KPIsLeading IndicatorsDiagnosisAndreessen Horowitz
More Metrics questions with a free account
The finish line: interview-readyComplete all 33 questions plus 3 hands-on drills to finish this plan.