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

Tiger Analytics Consultant Interview Questions

The questions to prepare for a Tiger Analytics Consultant interview. Questions from real interview reports rank first. Updated weekly.

34questions
~5htotal time
Track your progressSign up free to work through all 34 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions + 3 drills · ~94 min
Explain Full Outer vs Left JoinMedium

Explain how FULL OUTER JOIN and LEFT JOIN differ when reconciling customer records across systems.

JoinsData WranglingCase WhenTiger Analytics
Python Rolling Sales AverageMedium

Tests practical Python and data manipulation ability for time-based business metrics.

Data WranglingpythonTiger Analytics
Optimize Nested SQL QueryHard

Tests SQL performance tuning and reasoning about query execution efficiency.

SubqueriesPerformance TuningAggregationsTiger Analytics
Second Largest Salary QueryEasy
Practice
Practice drill

Use DENSE_RANK and a join to find the second-highest distinct salary among active CGS program employees.

sqlTiger AnalyticsCognizantAntra
Self-Join Manager Salary CheckEasy
Practice
Practice drill

Use a self-join to identify Tiger Analytics employees whose salaries exceed their direct managers.

SubqueriesJoinsSelf-JoinsNevada StaffingTiger Analytics
Analyze Customer Purchase Trends with Window FunctionsEasy
Practice
Practice drill

Calculate the monthly spending trends for customers using window functions and joins.

The Home DepotAvisoWorld Wide Technology
More SQL & Data Manipulation questions with a free account
2
Statistics & Probability3 questions · ~24 min
A/B Test Sample SizeMedium

Tests experimental design skills for achieving statistically reliable A/B test results.

Statistical SignificanceSample SizeA/B TestingTiger Analytics
Bayes Theorem for ClassificationMedium

Tests understanding of Bayes' Theorem and applying it to business classification decisions.

Bayesian ReasoningConditional ProbabilityTiger Analytics
More Statistics & Probability 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
Strategy3 questions · ~24 min
CPG Elasticity and Promo ModelHard

Tests strategy and modeling skills for promo optimization using pricing elasticity in CPG.

Business AcumenPricing StrategyTiger Analytics
Churn Analytical Solution StructureMedium

Tests end-to-end problem structuring for churn analytics and solution design.

ChurnProblem SolvingTiger Analytics
More Strategy questions with a free account
4
Behavioral & Leadership19 questions · ~152 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~8 min
Supply Chain Forecasting MetricsMedium

Tests ability to define measurable KPIs for forecasting outcomes in client supply chain contexts.

ForecastingKPIproject healthTiger Analytics
The finish line: interview-readyComplete all 34 questions plus 3 hands-on drills to finish this plan.