Dataford
Dataford
Top 18
Prep plan
Updated weekly · Last refresh Oct 17

Affine Consultant Interview Questions

The questions to prepare for a Affine Consultant interview. Questions from real interview reports rank first. Updated daily.

18questions
~3htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 2 drills · ~46 min
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingAffine
SQL Window FunctionsMedium

Evaluates your ability to use advanced SQL features for analytics and data transformations.

Window FunctionssqlAffine
Design a Retail Star SchemaHard

Tests your ability to model dimensional data for analytics use cases in a consulting context.

fact tablesstar schemadimensionsAffine
Window Functions for Second HighestMedium
Practice
Practice drill

Use a window function to return each customer's second-highest distinct transaction amount.

Window FunctionsData ManipulationRankingAffine
Second-Highest Per GroupMedium
Practice
Practice drill

Use a window function to find the second-highest distinct transaction value for each client department.

Window FunctionsData ManipulationRankingAffine
2
Behavioral & Leadership10 questions · ~87 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~43 min
R, Statistics, and SQLMedium

Tests your practical foundations in statistical analysis and querying for consulting work.

statisticssqlAffine
Investigate Profit DropHard

Tests structured problem solving and analytical thinking to diagnose business performance issues.

Business AcumenprofitabilityDiagnosisAffine
Optimize Slow Power BI DashboardsHard

Tests performance tuning skills for Power BI and large-scale data modeling.

Performance Tuningpower biData ModelingAffine
Estimate EV Charging MarketHard

Tests market sizing frameworks and quantitative reasoning for business strategy work.

EstimationBusiness AcumenMarket SizingAffine
Handle Messy Historical DataMedium

Tests data quality triage, pragmatic delivery, and stakeholder-focused analytics execution.

deliveryData QualityProblem SolvingAffine

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 18 questions plus 2 hands-on drills to finish this plan.