Automated airport passenger research with dynamic commentary

The airport passenger research relied on surveys run through SurveyMonkey, but the process for handling the survey data was entirely manual. Downloading, cleaning and integrating the data required significant effort and introduced the risk of human error.

The survey results also needed to be scaled to accurately represent the overall passenger population based on flight schedules and demographics, so that findings would be statistically valid.

Finally, the data had to be presented in a way that was both comprehensive and genuinely engaging for decision-makers, a third challenge on top of collection and scaling.

We implemented an automated data pipeline in Alteryx that pulls survey data directly from SurveyMonkey, then cleans, integrates and augments it by combining the survey results with flight schedules and Census data. This removed manual downloads, reduced the risk of errors and kept the data continuously up to date.

To ensure the results represented the passenger population, we developed an algorithm to scale responses based on flight schedules and passenger numbers, giving stakeholders confidence in the statistical validity of the findings.

We designed a suite of interactive Tableau dashboards that let users explore the survey results in detail.

The centrepiece was an infographic-style dashboard that auto-updates with new data and features dynamic, high-level commentary (narrative that responds to data changes and filtering) so stakeholders get immediate, actionable insight without manual interpretation.

The automated solution transformed the passenger research process. Manual data handling was eliminated, saving time and reducing errors.

Scaled, statistically valid survey data gave a more accurate picture of passenger behaviour and preferences.

The interactive dashboards let decision-makers quickly access and understand insights, enabling more informed decisions, while the dynamic commentary updated itself as the data changed.

The innovative, automated approach set a new standard for how the survey data is processed, analysed and presented, delivering faster turnaround with far less manual effort.