Airport Analysis

Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names while being used in different business areas.

> Objective

Paques Data Lake was used to identify the number of passengers landed at a certain time in several airports. It helps airlines have a better understanding of the individual passenger, identify patterns in his/her behavior, determine preferences and foresee future requests. By leveraging insights, airlines have the ability to make strategic decisions and differentiate themselves in the extremely competitive market.

> Data Source

Paques Data Lake took passengers data that contained destination, date, crew, and flight information (airlines, flight number, flight time) in CSV format.

> Solution

Paques Data Lake processed the airport data and identify numbers and passengers data that would arrive at a particular airport and at a certain time. There are 2 data sources used, detailed data from passengers and the flight of each plane operated within the operator’s jurisdiction. Both of these data were pre-processing and extracted based on the landing time in hour unit. Then, the data were correlated based on estimated flight time, flight code, airport destination. The data also aggregated by adding the type and number of passengers based on date, hours, airport destination, and terminal code of the airport.

As a result, the user will discover insights instantly and easily by using a Paques Studio (Graph Dashboard-visualization)

> Workflow

> Result

In this case, Paques could give the company an edge in data analysing with its ability to process large and complicated datasets, in parallel and distributedly. Paques helped to improve marketing efforts by collecting detailed data from individual customers. With the data collected, airlines were able to present special offers to targeted market. As a result, it increased the chances of getting a favourable response which enables airlines to measure how customers think and behave for future marketing activities and trend analysis.