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