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

American Express Global Business Travel Financial Analyst Interview Questions

The questions to prepare for a American Express Global Business Travel Financial Analyst interview. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 11 questions + 1 drill · ~106 min
Merge Client Revenue with Lookup DefaultsEasy
Practice

Merge client lists with historical revenue using lookup-style joins and null handling.

JoinsData WranglingAggregationsAmerican Express Global Business Travel
Monthly Spend by Region and CategoryEasy
Practice

Aggregate March 2024 Egencia booking spend by region and travel category using GROUP BY and TO_CHAR in PostgreSQL.

PivotData WranglingAggregationsAmerican Express Global Business Travel
Top Spending Clients Per RegionMedium
Practice
Practice drill

Rank American Express GBT corporate clients by fiscal-year spend using joins, aggregation, and ROW_NUMBER.

JoinsRankingAggregationsAmerican Express Global Business Travel
More SQL & Data Manipulation questions with a free account
2
Statistics & Probability10 questions · ~87 min
Period-over-Period Supplier Cost ChangeEasy

Calculate period-over-period percentage change in supplier costs and assess whether the increase is meaningful using summary statistics.

VarianceExpected ValueAmerican Express Global Business Travel
Quarterly Revenue Trend ForecastingEasy

Forecast next quarter revenue using a linear time-trend regression and compute a 95% prediction interval for financial planning.

RegressionExpected ValueTime SeriesAmerican Express Global Business Travel
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
Metrics11 questions · ~96 min
Analyze Travel Volume TrendsMedium

Assesses your capability to analyze drivers and patterns in travel demand data.

Lagging IndicatorsLeading IndicatorsTime SeriesAmerican Express Global Business Travel
Investigate Supplier Cost IncreasesMedium

Assesses your ability to diagnose cost drivers and explain changes in financial results.

Lagging IndicatorsKPIsDiagnosisAmerican Express Global Business Travel
More Metrics questions with a free account
4
Strategy11 questions · ~96 min
Supplier Economics for TravelHard

Evaluates your ability to model and interpret supplier economics for corporate travel partnerships.

EstimationCompetitive AnalysisPricing StrategyAmerican Express Global Business Travel
More Strategy questions with a free account
5
Finance & Accounting4 questions · ~35 min
Analyze Department Budget OverrunMedium

Assesses your variance analysis approach for departmental budgeting issues.

Financial AnalysisAmerican Express Global Business Travel
More Finance & Accounting questions with a free account
6
Behavioral & Leadership3 questions · ~26 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions plus 1 hands-on drill to finish this plan.