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

Flexport Business Analyst Interview Questions

The questions to prepare for a Flexport Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByFlexport
Pivot Weekly Shipment TrendsEasy

Tests ability to transform shipment milestone data into weekly KPIs using pivot tables.

pivot tablesDate FunctionsData WranglingFlexport
Joining Milestone Datasets SafelyMedium

Tests SQL data cleaning, join logic, and handling messy logistics milestone data.

null handlingJoinsdata integrityFlexport
Top Delayed Routes by RegionMedium
Practice
Practice drill

Use a CTE and window ranking to find the top 3 routes with the highest average delay in each region.

Window FunctionsJoinsRankingCoca-Cola ConsolidatedAPL LogisticsFlexport
Goods at a Specific TimeMedium
Practice
Practice drill

Calculate goods on hand at each Flexport warehouse as of a timestamp using a CTE, LEFT JOIN, and conditional aggregation.

Flexport
Max Goods in WarehouseHard
Practice
Practice drill

Use cumulative window sums and CTEs to find each Flexport warehouse's maximum recorded inventory and its time interval.

Data AnalysisFlexport
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership8 questions · ~64 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~40 min
Diagnose Customs Delay SpikesMedium

Tests structured root-cause analysis using logistics and customs performance data.

Market TrendsEstimationProblem SolvingFlexport
Map Processes to Find BottlenecksMedium

Tests process mapping skills and ability to translate operational observations into actionable insights.

process improvementExecutionbottlenecksFlexport
Container Utilization MetricsMedium

Tests metric selection and trade-off reasoning for improving ocean freight efficiency.

Trade-offsKPIFlexport
Finance Concepts: Bad DebtsMedium

Evaluates your understanding of finance workflows and your ability to apply accounting rules to journal entries.

AccountingFlexport
Decide on New Warehouse FacilityHard

Tests strategic analysis design, data-driven decision-making, and operational planning.

Strategic PlanningCost-Benefit AnalysisMarket SizingFlexport

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