DGCA Skyline

Directorate General for Civil Aviation

Gets insight into flights from and to Kuwait International Airport using Power BI and Sharper Software Business Intelligence Services.


Public Sector Administration

Country of Origin


In Business Since




Directorate General for Civil Aviation


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


DGCA teamed-up with Sharper Software to deliver a dashboard for Civil Aviation. This dashboard uses Power BI as the Business Intelligence engine. Power BI provides the following capabilities:

  • Collect data from multiple sources without having to learn any new technology.
  • Model data using business-friendly terms.
  • Rich Data Visualizations, providing insight into your data and helping you convert data into knowledge.
  • Publishing to Power BI Online, which allows sharing the reports and dashboards with others easily.
  • Available on multiple devices.
  • Based on Office 365 Cloud Subscription model, which is very cost effective.


Shorter Wait Times

Your customers, patients and/or employees will spend less time waiting for you to process their data.

Data Accuracy

Information is guaranteed to be correct and authoritative, as it's provided by the Public Authority for Civil Information.

Data Consistency

Data is consistent across your systems. If a centralized Master Data is used, it is possible to feed it via this solution.