314,552 interview questions from 6,000+ companies.
Design a dashboard that connects campaign activity, funnel conversion, and acquisition efficiency to business outcomes.
Explain how to distinguish early directional metrics from outcome metrics, using a clear KPI framework tied to product decisions.
Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
Explain what a p-value means in hypothesis testing and how it relates to statistical significance.
Analyze where users drop off in a product funnel and identify the biggest conversion leak.
Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.
Define the metrics that show whether engagement in a core feature is improving.
Explain why correlation measures association, while causation requires evidence that changing one variable changes the other.
Reason about power analysis when planning an experiment and choosing sample size.
Reason about how to estimate causal effects in product settings when randomized experiments are not available.
Tests your ability to implement rolling-window credit metrics correctly in SQL.
Tests your ability to reason about interest-rate sensitivity and translate it into portfolio expectations.
Tests your ability to connect macro drivers to loan behavior and produce research that informs investors.
Tests your ability to translate a research question into a statistical model and validate assumptions.
Tests your product collaboration skills and your ability to translate research needs into analytics features.
Tests your end-to-end data prep and analysis workflow for loan-level research.
Tests your understanding of core credit risk components and how they map to outcomes.
Tests SQL performance, maintainability, and practical engineering habits for large datasets.
Tests your ability to compute time-based metrics efficiently using SQL window functions.
Tests your performance debugging and optimization skills for large-scale data analysis.
31 total questions
