Driving airport retail growth
through integrated
commercial reporting and analytics.
How an airport deployed a comprehensive data solution spanning retail, property, and duty free — putting timely insights into the hands of decision-makers and connecting passenger behaviour directly to revenue outcomes.
Reporting that answered ‘what’ — never ‘why’.
Airport retail performance is shaped by passenger behaviour, lease structures, location constraints, and duty free dynamics like nationality, destinations, and airline activity. Reporting answered what happened but not why — passenger-segment spend was invisible, nationality and route impact on conversion was unknown, intramonth volatility was unanticipated, and property, retail, and finance teams worked through separate lenses. Decisions were reactive, based on lagging monthly indicators.
From fragmented reporting to integrated commercial intelligence.
BI3 delivered a comprehensive suite of Power BI dashboards that consolidate retail, property, passenger, and duty free data into a single trusted view — giving stakeholders a shared evidence base for faster, data-driven decisions.
Retail & property overview — the commercial baseline
A single-source-of-truth view delivering total sales, revenue, spend per square metre, PSR, and occupancy cost ratios with prior-period comparisons across the entire estate.
Sales recovery vs passenger recovery
Directly compares retail sales recovery against passenger volume recovery, identifying outperformers and laggards by category and tenant — enabling evidence-based discussions with airlines and retailers.
Duty free passenger-led intelligence
Sales linked to passenger volumes across departures and arrivals with strike rate, PSR, ATV, and top nationality, product, and destination breakdowns — exposing where revenue is being earned and where conversion is being left on the table.
Nationality intelligence (confidential IMMI PAX)
Granular passenger spend profiling by country — PAX counts, sales contribution, PSR, strike rate, and ATV by nationality, with PCP benchmarks — revealing which cohorts over- and under-index against peers.
Intramonth monitoring & early warning
Date-range selectable views that track PSR, ATV, and strike rate against budget mid-period — turning month-end surprises into operational control with the same granularity available at any point in the month.
Top 25 airline–brand matrix
A single matrix connecting airline flows to brand PSR outcomes — enabling strategic airline-retail collaboration, evidence-backed concession decisions, and reliable forecasting based on route or airline mix shifts.
Power BI at the centre. Built for commercial control.
A modular Power BI platform integrating retail sales, property leases, passenger volumes, confidential IMMI data, and duty free performance — including product, brand, nationality, and airline-level analytics — into a single trusted view that enables proactive, evidence-based decisions across the airport commercial estate.
Reporting transformed into a commercial control capability.
One commercial truth
Single integrated view of retail, property, duty free, and passenger data — shared across executives, finance, retail, and property teams.
Passenger spend profiling
Granular intelligence by nationality, destination, airline, product, and brand — exposing exactly where revenue is earned and where it is missed.
Intramonth control
Real-time visibility against budget mid-month — replacing end-of-month surprises with operational decisions taken on current data.
Dashboard modules
Modular Power BI suite spanning retail, property, sales recovery, duty free, nationality, intramonth, and airline–brand intelligence.