Transport for London Data Analyst Interview Questions
The questions to prepare for a Transport for London Data Analyst interview. Questions from real interview reports rank first. Updated daily.
Explain how to assess and clean incomplete or inconsistent data before analysis.
Transport for LondonExplain how to validate SQL data before reporting, including null checks, duplicates, outliers, and aggregation reconciliation.
Transport for LondonExplain how SQL fits with data analysis and visualization tools, and when to use each in an analytics workflow.
Transport for LondonCalculate average completed-service delay per TfL line and time-of-day category.
Transport for LondonCalculate three-day rolling passenger entry averages for TfL stations using aggregation and window functions.
Transport for London
The Trade Desk
MercariFilter invalid game events and normalize event names using PostgreSQL string and null handling.
Quantium
Scopely
CarvanaApproach for handling missing, inconsistent, and duplicate data in a pipeline without breaking downstream analytics.
Transport for LondonExplain a complex ETL transformation you built, including the main challenges and how you handled them.
Transport for LondonSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Evaluates selection of statistical methods for time-based transport metrics and trend detection.
Transport for LondonAssesses understanding of Transport for London priorities and how you connect analysis to outcomes.
Transport for LondonEvaluates selection of statistical methods for passenger traffic trend detection.
Transport for London