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

Air Culinaire Worldwide Data Analyst Interview Questions

The questions to prepare for a Air Culinaire Worldwide Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

17questions
~2htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 2 drills · ~55 min
Analyze Customer Purchase Trends with Window FunctionsEasy
Practice

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

Air Culinaire Worldwide
SQL for Data ExtractionEasy

Tests practical SQL skills for extracting and preparing data for analysis.

SubqueriesData WranglingCTEsAir Culinaire Worldwide
SQL Query for Customer DataEasy

Tests ability to write targeted SQL queries for customer-level analysis.

JoinsData WranglingAir Culinaire Worldwide
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Contact Center Agent Performance MetricsHard
Practice
Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData ModelingADP
More SQL & Data Manipulation questions with a free account
2
Pipelines4 questions · ~35 min
Implementing Items in D365Medium

Tests understanding of ERP data changes and how they flow into downstream reporting.

ToolsETLData ModelingAir Culinaire Worldwide
Troubleshooting ERP Data IssuesMedium

Tests diagnostic process for resolving ERP data problems affecting analytics.

InfrastructureToolsQualityAir Culinaire Worldwide
Validating ERP Data Before ReportingMedium

Tests controls and validation techniques to prevent reporting errors from ERP extracts.

ETLData ModelingQualityAir Culinaire Worldwide
More Pipelines 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
Metrics3 questions · ~26 min
Menu Item Sales Impact AnalysisHard

Tests analytical approach to measure incremental sales impact from menu changes.

KPIsCausal InferenceDiagnosisAir Culinaire Worldwide
Designing Forecasting ReportsHard

Tests ability to structure forecasting reports using appropriate metrics and assumptions.

KPIsLeading IndicatorsDiagnosisAir Culinaire Worldwide
More Metrics questions with a free account
4
Behavioral & Leadership6 questions · ~52 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 17 questions plus 2 hands-on drills to finish this plan.