THE WINNING SOLUTION TO ALWAYS HAVE AN INTELLIGENT STRATEGY
OVERVIEW
The Business Intelligence (BI) refers to a new generation of systems aimed at enabling users to gather, provide access to, and analyze data and information about their company operations. The new Business Intelligence technologies are used to improve the timeliness and quality of information, and enable managers to be able to better understand the position of their firm as in comparison to its competitors. Forecasts and what if analysis driven by domain managers can help companies have a more comprehensive knowledge of the factors affecting their business, such as metrics on sales, production, internal operations, enabling organizations to make more informed business decisions. To face new challenges of the information society in the airport industry, Software Design has dedicated a specific development line to the decision support solutions aimed at: optimizing airport resources efficiency and productivity analysing historical data and trends; improving airport revenues through detailed analysis of passenger flows and the identification of choices that increase at maximum passenger traffic reducing at the same time airport infrastructure congestion; improving communication among airport operators, staff and company management. Software Design, integrating the competence in airport transportation and in Business Intelligence expertise, is able to translate strategic objectives in operative solutions. The methodological approach used by Software Design for the creation of the airport BI solutions is based on a common Kernel, around which, new functional upgrades are conceived. The Kernel, named ABI, is a complete and scalable system characterised by a data model open to host, without impact on the basic solution, new specific extensions.
BENEFITS
Through the BI instruments, airport managers can achieve the following advantages:”to valorise airport resources through an optimized use that arises from the integrated analysis of historical data”
“improve airport profitability through detailed analysis of passenger flows and identification of strategic choices aimed at maximizing traffic”
“build multi-year comparative analyzes” “analyze the cause / effect relationships”
“improve communication between operators and company management” “improve levels of empowerment in middle management”
SOLUTION COMPONENTS
DECISION SUPPORT SYSTEM
The main areas of decision support to which ABI aims to provide answers are:
- definition of strategic trends
- forecast and development of traffic
- identification of investment plans
- resource productivity
- budget of resources and more
The Airport Business Intelligence system is made up of different datamart and related analyzes to support any type of airport stakeholders and departments.
The ABI, based on the datamarts to be distributed, can exploit a number of AOSnice framework modules, such as:
Airport desktop; User Manager; Contract / service manager; Airport Traffic Manager, ResourceBrain, eCommerce Tools, ShopView, ArrivalMonitor, AirportFlow.
THE SYSTEM MODULES
The construction of a company data warehouse that can display all the data of a company is an ambitious plan very difficult to achieve.
The data warehouse is made up of a series of departmental data, called data mart. For each datamart there is a series of analysis dimensions able to specialize and optimize the performance of data queries.
Data marts belong to two different types of airport subjects: authority, management.
The ABI data warehouse is populated from operational data relating to air traffic, handling services, claims and accidents.
Datawarehouse population capabilities natively access operational databases through a configuration environment that defines the structure of data sources and population policies.
In addition, a staging repository is used to minimize the impact on operating systems during the process of data processing that allows postponing the organization and aggregation of data.
The modular structure of the data warehouse allows it to be easily extended with additional datamts capable of supporting new analyzes.
The ABI analysis system consists of transactional data acquisition components and a Business Intelligence subsystem that deals with both the DataWarehouse database population and the Querying and Reporting functions.
Includes the following modules:
Datawarehouse: is the global information repository. In the creation of the data warehouse, performance data regarding the retrieval of information rather than data relating to data sizing was preferred. The data warehouse is composed of a series of Datamarts, each specialized for a specific type of information. The system provides Datamarts for the analysis of aircraft and passenger traffic for statistics and “What if analisys”.
Data population: data import function in the DataWarehouse database. Data import into the data warehouse is processed periodically on the basis of a frequency policy or at the explicit request of the operator. The frequency of import could be different for groups of homogeneous information and could be configured according to the specific needs of the end users.
Reporting: a set of reports and queries developed in the Crystal Reports environment that show the most important data in different views. The exact list of reports can be agreed with the customer during the customization phase of the system and would reflect all the analysis and check requirements at the airport. The reports become interactive thanks to the “Drill Down” functions that allow a detailed graphical navigation.
Web Launcher: the application takes care of the final presentation of the data paid in reports and graphs on the WEB. Only authorized managers can access the reports and indicate the criteria for selecting data to be applied through simple visual interfaces.
DATA PUMPING
The main areas of decision support to which ABI aims to provide answers are:
- definition of strategic trends
- forecast and development of traffic
- identification of investment plans
- resource productivity
- budget of resources and more
The Airport Business Intelligence system is made up of different datamart and related analyzes to support any type of airport stakeholders and departments.
The ABI, based on the datamarts to be distributed, can exploit a number of AOSnice framework modules, such as:
Airport desktop; User Manager; Contract / service manager; Airport Traffic Manager, ResourceBrain, eCommerce Tools, ShopView, ArrivalMonitor, AirportFlow.
AOSNICE KERNEL VS ABI
In addition, ABI is equipped with the following functions that belong to the AOSnice kernel:
Enterprise Desktop: Unique input channel provided with an autoconfigured activation structure based on the privileges of the registered user. Unique Desktop provides easy access, privilege control and a standardized graphical interface for all applications.
User Manager: system to configure user privileges based on the functions that can be activated by them.
Depending on the areas of analysis selected by a customer, Software Design can even offer dedicated operating and business systems to manage the related airport services such as :.
Airport Traffic Manager: CDM-based flight management (collaborative decision making)
ResourceBrain: planning and management of personnel and fixed resources
E-commerce tools: booking and pre-booking services
ShopView: monitoring the cash register for airport shops
AirportFlow: passenger flow control
ArrivalMonitor: arrival flight monitoring (baggage delivery)
ONLINE ANALYSIS
ABI is equipped with a rich set of predefined analyzes (dashboards and reports) that can be modified and extended to map the specific needs of users.
Some of the most relevant analyzes provided at the moment are:
Air traffic
Traffic analysis
Traffic analysis dashboard
Details of the movement
Details on the Pax
Upload the Factor details
Scheduled flights
Key performance indicators: general traffic indicators
Traffic details: traffic details and load factors
Maximum time intervals of maximum traffic traffic
Peak Month DayWeek Traffic: daily passenger traffic per week during the month of maximum traffic
Peak peak traffic: passenger traffic per slot in the month of maximum traffic and on average peak day
Traffic by class. Six classes of aircraft aggregate aircraft according to their tonnage.
Top Ten Airline: list of the top ten airlines for annual passenger traffic.
Pax frequency: graph comparison of the number of passengers per week over the years.
Flights diverted / canceled
Flight delays
Traffic development
Passengers by destination and flight
Passengers by destination and month
Passengers by destination and class
Final destinations and intermediate airports
Compare periods
Top 20 destinations
Not aeronautical Business
Parking analysis
Parking Dashboard analysis
Revenue and transactions
On arrival and transactions per day / week / month
Incoming ytd / last month / week compared to last year
Transactions based on the duration of the parking lot
Transactions by type of rate
Average parking duration based on daily / day / week / month hours
Number of input transactions per hour / day / week / month
Number of outgoing transactions per day / day / week / month
Occupation of the parking lot
Average daily occupation
Average monthly employment
Average occupation of time slots
Retail
Retail Analysis Dashboard
Inbound trend by product category grouped by day / week / month
Incoming values by product category
Income activity by destination airport
Top 20 entries by product category
The 20 largest expenses per destination airport
Average costs per destination airport
Airside Terminal Monthly Waiting time for time intervals
Quality of airport service
General
Complaint analysis
Baggage management
Punctuality in the delivery of baggage
Security checks
Monthly waiting time for time intervals
Monthly waiting time per day and per day
Security performance: Pax expected from actual pax, personal under / over scheduled staff, throughput vs security personnel
The list of available reports continuously increases to meet the specific needs of the customer.
DATAWAREHOUSE
The data warehouse is made up of a number of specialized Datamarts. Each stakeholder can exploit only the datamarts associated with the activities in charge.
The most relevant Datamarts are identified and equipped with the most interesting dimensions: Baggage, Staff allocation, Personnel presence, Parking, Retail, Pax Routing, Traffic.
