Reporting and Analysis

Reporting and Analysis

Reporting and Analysis

Avianco’s integrated reporting and analytic capabilities make it easy for organizations to identify business drivers and performance indicators that most impact your organization’s operational efficiency. You can use these to establish best practices for improved productivity and service levels. Avianco’s system leverages the standardized method for time and attendance, demand forecasting, advanced scheduling and employee self-service across a multi-organizational system to support strategic planning at corporate headquarters and the individual needs of each location. Our Web-based workforce management solution uses sophisticated reporting and analysis to enable decision makers in your organization to improve operational efficiencies and reduce costs by simplifying resource management and deployment.

The Avianco system already comes equipped with its own internal set of reports and data retrieval, we continue to develop many reports that will provide and meet additional business intelligence requirements. We develop the functionality within Avianco database using existing database reporting and application tools.

Business Intelligence will be categorized into three main types and developed as such: (a) operational, (b) tactical and (c) strategic. Each of the three categories will leverage different sources of information, will encompass different reporting requirements and will have different report users. The goal is to categorize all report requirements and develop the reporting infrastructure to meet the needs of the organization in a prioritized and timely manner.

In addition to reports, other forms of strategic measures are Dashboards, Metrics and Key Performance Indicators, a comprehensive solution will satisfy customer needs.


Every area of the organization scheduling, assignment, fulfillment, financial settlement/accounting, and long term planning - all can have a direct impact on organization’s overall performance. Unfortunately, it is extremely difficult to capture and report data points from every level of the organization to know exactly how well business is running. Those reports that do exist are typically not available until it's too late to take corrective action.

We are extending the business intelligence needs with the current development of an executive dashboard to provide a management tool for setting expectations for every department at every level, with easy-to-understand metrics, performance indicators, and reporting of the status of progress throughout the year. The executive software measures are set at each level, with ability to roll up to higher indicators, creating a means for gauging the status of organizational progress.


Metrics refer to direct numerical measures that represent a piece of business data in the relationship to one or more dimensions. An example would be: "total requests by week." In this case, the measure would be the “request" and the “dimension" would be time (week). For a given measure, management may also want to see the values across different hierarchies within a dimension. For instance, seeing total claims by month, quarter, or year would show the measure "claims" by different hierarchies (week, month, quarter, and year) within the time dimension. Making the association of a measure with a specific hierarchal level within a dimension refers to the overall grain of the metric.

Looking at a measure across more than one dimension such as organization or type of service requested and time is called multi-dimensional analysis. The Executive Dashboard will leverage some of the more dynamic "slice-and- dice” tools that exist in the database analysis tools. This is important to note, because if in the requirements gathering process we may uncover a significant need for this type of analysis, which may consider supplementing the dashboards with some type of multi-dimensional analysis tool or OLAP tool.

Key Performance Indicators (KPI)

A KPI is simply a metric that is tied to a target. Most often a KPI represents how far a metric is above or below a pre-determined target. KPI's usually are shown as a ratio of actual to target and are designed to instantly let a business user know if they are on or off their plan without the end user having to consciously focus on the metrics being represented. When selecting targets for your KPI's you need to remember that a target will have to exist for every grain you want to view within a metric. Having a dashboard that displays a KPI for gross sales by day, week, and month will require that you have identified targets for each of these associated grains.


Probably the most prevalent BI tool seen in business today is the traditional report. Reports can be very simple and static in nature, such as a list of sales transaction for a given time period, to more sophisticated cross-tab reports with nested grouping, rolling summaries, and dynamic drill-through or linking. Reports are best used when the user needs to look at raw data in an easy to read format. When combined with scorecards and dashboards, reports offer a tremendous way to allow users to analyze the specific data underlying their metrics and key performance indicators.