Directorate General for Civil Aviation
Background
Managing Civil Air Traffic to and from Kuwait International Airport, the Directorate General for Civil Aviation (DGCA) schedules,
tracks and manages every civilian flight in the State of Kuwait. Flights could be classified as Scheduled or Non-Scheduled depending
on the scheduling of the flight. Flights could also be passenger and/or freight flights. There are hundreds of airlines what carry
passengers and freight to and from Kuwait. Keeping track of these flights and turning raw flight data into meaningful information
has been the challenge of DGCA for years. Identifying periods of high vs. low traffic, the seasonality of passenger transport and
many more metrics are difficult to obtain from the current systems.
Business Needs & Challenges
DGCA captures details of every flight. The nature of the flight: Scheduled or non-scheduled, Number of Passengers arriving and/or
departing, freight arriving or departing, the 3 sectors prior to reaching Kuwait International Airport as well as the next 3 sectors
and many more details.
Although DGCA uses a single application to manage all aspects of Civil Aviation, the possibility to analyze this data and draw
correlations between other sources of data available at DGCA is not possible at the moment. It is also difficult to report on
the metrics of interest based on different dimensions, including but not limited to a date range, nature of the flight, number
of passengers, total freight, estimated time of arrival, estimated time of departure and many more important dimensions. It is
clear that DGCA needs a tool that would allow its staff to perform intelligent analysis on the data and help improve DGCA's
services as well as make informed decisions.
Characteristics of a viable solution
A viable solution should provide the following capabilities:
- Import data from multiple sources.
- Allow DGCA resources to model the data using business-friendly terms.
- Provide rich visualizations that would allow DGCA to perform both Explanatory and Exploratory analysis.
- Allow publishing and sharing reports among DGCA team members.
- Be available on multiple devices.
- Be cost-effective
