Top 20
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

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 + 2 drills · ~97 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 and Tableau FundamentalsMedium

Evaluates practical knowledge of querying and building analytics in Tableau.

sqlAmerican Airlines
Fast Data Visualization LibrariesEasy
Practice

Summarize quick-use visualization libraries with a left join, conditional filtering, and aggregate metrics.

analytics toolsData ManipulationData AnalysisAmerican 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
Data Normalization PrinciplesMedium

Tests database design reasoning and ability to explain normalization tradeoffs.

database managementsqlAmerican Airlines
SQL for Student Subject TotalsEasy
Practice
Practice drill

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

sqlawsAmerican Airlines
Rolling Average Flight DelaysMedium
Practice
Practice drill

Calculate each airport's seven-day rolling average flight delay using date-based aggregation and window functions.

Window FunctionsDate FunctionsData ManipulationAmerican Airlines
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership10 questions · ~86 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 · ~9 min
The finish line: interview-readyComplete all 20 questions plus 2 hands-on drills to finish this plan.