Dubai Airports uses Tableau to identify new revenue streams and maintain “clockwork operations”

Now, most of these old manual processes have been completely automated, saving hundreds of man-hours a month. Data is staged in SQL server databases, prepped in Alteryx and then connected directly to Tableau, where it can be refreshed at the click of a button. Once a new dashboard is built, it never needs to be manually updated or maintained again. Employees can access it whenever they want, making them self-reliant and enabling them to correctly answer their own questions and analytics needs for the first time. We have over 13 different teams using Tableau in this way, including: Finance, Capacity Planning, Operations, Engineering Services, Investment Planning and more.
Tableau’s emphasis on visual analytics - particularly mapping - also makes key trends and patterns in the data significantly easier to see, such as new flight destinations that are quickly growing in popularity. Having that visual sense of markets makes complex analytics much easier to understand. Tableau is designed to make the most of geographical data, so you can get to the “where” as well as the “why.” Out-of-the-box geocoding and rich interactive maps make geospatial analysis available to everyone, without the need for specialised software.

The core objective of the Business Development team is to bring new airlines and activity into the airport. Doing so requires building an effective business case that demonstrates passenger needs are going unmet. For example, we identified significant traffic flows of passengers who were flying indirectly to Dubai via other hubs. This insight helped us find and create new market opportunities for passengers who were previously unserved.
Finding these insights used to take a huge amount of number crunching, but now we can explore the data via an automated Tableau dashboard, which is updated with ticketing information from the International Air Transport Association (IATA) database every month. We can easily explore the data on a global heatmap to see the latest trends. This approach gives us the evidence we need to create compelling airline proposals in a matter of hours, when previously it would take days of manual analytics work.

Our airports operate 24 hours a day, seven days a week, whereas many others have a certain offline or curfew period. As such, our scheduling needs to run smoothly round the clock. One of the biggest threats to this is bad weather, which can quickly cause major disruption. Fortunately, we can use Tableau to mitigate the worst effects. When the meteorology department issues a weather warning, we analyse our planned schedule for the affected period and identify airlines operating multiple flights to/from the same destination within this window. We then work with these airlines to proactively reschedule or cancel flights and consolidate the demand with fewer flights to minimize the impact of such disruption whilst maintaining connectivity and customer service standards.

The last six months have been very challenging for the whole aviation industry, with travel and tourism hit particularly hard. Like many others, we’ve focused on managing expenses as efficiently as possible, closing facilities where necessary to make OPEX savings and keep costs as low as possible. Tableau is helping us to closely monitor the market recovery and inform key decisions regarding the reopening of facilities as and when passenger confidence returns.