Large airport

Simulate and optimise airport charges

Starting point

  • Simulation of various fee scenarios taking into account many variables such as noise and pollutant emissions, noise classes, night and other surcharges
  • All information is represented in Excel, which led to issues with data quality and consistency
  • Due to the large data volumes, opening the Excel file took five minutes, and the simulations could no longer be represented in Excel

Procedure

  • Implementation of Alteryx technologies as a "data pump" and "analytics turbo," as well as Tableau as the visualization layerDevelopment of models for the scenario modeling of fees
  • Best-practice coaching and knowledge transfer
  • "Help to help itself": After a short project phase, the customer can operate autonomously
 

Features/Project outcome

  • Alteryx accelerates workflows immensely. Huge data volumes are no longer a problem
  • Scenario building and comparison are reliably possible within minutes
  • A large number of models can be calculated in a very short time
  • The team can respond flexibly to new requirements

Customer benefits

  • The optimised calculation of fees provides the airport with legal certainty, especially regarding the "non-discrimination" of the involved airlines and other stakeholders
  • In a short time, an unlimited number of scenarios can be modeled
  • Significantly improved data quality and consistency
  • Thanks to the increase in the corresponding fees, noise and pollutant emissions are further reduced
 
Sascha Mertens | Senior Manager / Authorised Officer