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

American Airlines Data Analyst Interview Questions

The questions to prepare for a American Airlines Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 3 drills · ~102 min
Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityAmerican Airlines
SQL Scalar Functions UseMedium

Tests SQL function knowledge and practical ability to apply scalar functions in queries.

database managementsqlAmerican Airlines
SQL Joins for Delayed FlightsHard

Tests multi-table join skills and translating business questions into SQL for flight delay analysis.

JoinsData AnalysissqlAmerican Airlines
SQL and Tableau FundamentalsMedium

Evaluates practical knowledge of querying and building analytics in Tableau.

sqlAmerican Airlines
Data Normalization PrinciplesMedium

Tests database design reasoning and ability to explain normalization tradeoffs.

database managementsqlAmerican Airlines
SQL Delete vs TruncateEasy

Tests understanding of SQL data manipulation semantics and when to use each command.

database managementData ManipulationsqlAmerican Airlines
SQL for Student Subject TotalsEasy
Practice
Recently asked
Practice drill

Use a join, SUM, GROUP BY, and HAVING to find students whose combined subject scores exceed 200.

sqlawsAmerican Airlines
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
Top Users by Region QueryMedium
Practice
Practice drill

Rank the top 10 ResMed myAir users in each region using joins, aggregation, and ROW_NUMBER().

Data AnalysissqlResmed
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership10 questions · ~80 min
Resolving Data Quality Under PressureMedium

Tests ownership of data quality issues, risk communication to leadership, and stakeholder management under business pressure.

Data QualityCommunicationLeadershipAmerican Airlines
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
Dashboards vs VisualizationsMedium

Assesses your understanding of analytics presentation and how to choose the right artifact.

dashboardsdata visualizationAmerican Airlines

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 20 questions plus 3 hands-on drills to finish this plan.