11 Oracle Airlines Data Model Sample Reports
Provides Oracle Airlines Data Model sample reports.
Note:
The reports and dashboards shown in the examples in this chapter and delivered with Oracle Airlines Data Model are provided only for demonstration purposes. These sample reports and dashboards are not supported by Oracle.
- Agent Performance Analysis
- Booking Analysis
- Channel Performance Analysis
- Revenue Analysis
- Route Analysis Reports
- Call Center Performance Analysis
- Customer Loyalty Analysis
- Customer Interaction Analysis
- Flight Operations Reports
- Maintenance and Operations Control Reports
- Special Location Gate Reports
- Special Location Passenger Reports
- TAT Analysis Reports
Parent topic: Intra-ETL, OLAP, Data Mining, and Utility Scripts
Agent Performance Analysis
The Agent Performance Analysis reports include the following areas:
- Agent Performance Analysis Confirmed
- Agent Performance Analysis PCT CANCEL
- Agent Performance Analysis Total Revenue
Parent topic: Oracle Airlines Data Model Sample Reports
Agent Performance Analysis Confirmed
This report, as shown in Figure 11-1 provides the current year month-level agent performance analysis confirmed for each agent along with their rank. The report also shows the metrics such as Confirmed LP, Confirmed % Change LP of sales revenue.
Report dimensions are:
-
Time
Figure 11-1 Agent Performance Analysis Confirmed
Description of "Figure 11-1 Agent Performance Analysis Confirmed"
Parent topic: Agent Performance Analysis
Agent Performance Analysis PCT CANCEL
This report, as shown in Figure 11-2 provides the cancelation rate out of total bookings at month level for agents, along with their ranks. The report includes metrics such as LP for the cancelation rate.
Report dimensions are:
-
Time
Figure 11-2 Agent Performance Analysis PCT CANCEL
Description of "Figure 11-2 Agent Performance Analysis PCT CANCEL"
Parent topic: Agent Performance Analysis
Agent Performance Analysis Total Revenue
This report, as shown in Figure 11-3, provides the current year month-level total revenue basing on agent performance for each agent. The report shows the ranks of agents according to their revenue. The report also shows the metrics such as LP and % Change LP of sales revenue.
Report dimensions are:
-
Time
Figure 11-3 Agent Performance Analysis Total Revenue
Description of "Figure 11-3 Agent Performance Analysis Total Revenue"
Parent topic: Agent Performance Analysis
Booking Analysis
The Booking Analysis reports include the following areas:
- Agent Booking Analysis
- Booking Segment Analysis
- Daily Booking Analysis
- Flight booking Analysis
- Group Booking Analysis
- Monthly Booking Analysis
- Quarterly Booking Analysis
- Service Class Analysis
- Weekly Booking Analysis
Parent topic: Oracle Airlines Data Model Sample Reports
Agent Booking Analysis
This report, as shown in Figure 11-4 provides the year wise month level agent booking analysis. The report provides information on the number of booked tickets, confirmed tickets, and canceled tickets out of the booked and what is the materialization rate, along with the metrics LP, % Change LP for booked, canceled, confirmed, and the materialization rate and cancellation rate.
Report dimensions are:
-
Time
-
Agent Name
-
Booking Class
Parent topic: Booking Analysis
Booking Segment Analysis
This report, as shown in Figure 11-5 provides the statistics for booking segment along with the booked tickets count, confirmed count and canceled count out of the booked at month level. The report also shows metrics such as LP, % Change LP for the booked, confirmed and canceled bookings.
Report dimensions are:
-
Time
-
Segment
Parent topic: Booking Analysis
Daily Booking Analysis
This report, as shown in Figure 11-6 provides the current year day level booking analysis of tickets. The statistics are also for how many are canceled, ticketed, net booked and materialization rate for the booked tickets.
Report dimensions are:
-
Time
Parent topic: Booking Analysis
Flight booking Analysis
This report, as shown in Figure 11-7 provides the current year month-level flight bookings for the operating flights. The report also shows how many tickets are booked and how many are confirmed and canceled out of the booked. The report includes the metrics LP, % Change LP on Booked, Confirmed and Canceled.
Report dimensions are:
-
Time
-
Operating Flight
Parent topic: Booking Analysis
Group Booking Analysis
This report, as shown in Figure 11-8 provides the booking of tickets in groups at month level for different service classes. The report also includes information on individual booked tickets. The report shows metrics, including LP and % Change LP for group booked and individual booked.
Report dimensions are:
-
Time
-
Service Class
Parent topic: Booking Analysis
Monthly Booking Analysis
This report, as shown in Figure 11-9 provides the monthly booking analysis of the tickets. The statistics for booked, confirmed, and canceled are shown. The report also shows metrics such as LP, % Change LP for booked, and confirmed and canceled tickets.
Parent topic: Booking Analysis
Quarterly Booking Analysis
This report, as shown in Figure 11-10 provides the current year quarter level booking analysis so that you can understand which quarter has the most bookings and least bookings. The statistics on booked tickets, confirmed, and canceled tickets out of the booked tickets are shown. The metrics such as LP, % Change LP or shown for the booked, confirmed and canceled tickets.
Report dimensions are:
-
Time
Parent topic: Booking Analysis
Service Class Analysis
This report, as shown in Figure 11-11 provides the analysis on service class at the month level so that you can see which class is most popular. This understanding can be obtained from the information provided in booked, confirmed, canceled, canceled from conformed, net confirmed for the service class. You can also obtain information on metrics such as LP, % Change LP.
Report dimensions are:
-
Time
-
Operating Flight
Parent topic: Booking Analysis
Weekly Booking Analysis
This report, as shown in Figure 11-12 provides the weekly booking analysis of tickets. The report includes information on how many tickets are booked, confirmed and canceled out of the booked at the week level. The metrics LP, % Change LP are also provided.
Report dimensions are:
-
Time
Parent topic: Booking Analysis
Channel Performance Analysis
The Channel Performance Analysis reports include the following areas:
Parent topic: Oracle Airlines Data Model Sample Reports
Agent Booking Analysis
This report, as shown in Figure 11-13 provides the booking analysis for agents. The report shows information on which service class is booked by an agent, and how many bookings are confirmed and canceled, and what is the materialization rate.
Report dimensions are:
-
Time
-
Agent
Parent topic: Channel Performance Analysis
Sales Channel Performance Analysis
This report, as shown in Figure 11-14 provides the sales channel performance analysis.
Report dimensions are:
-
Time
-
Agent
Figure 11-14 Sales Channel Performance Analysis
Description of "Figure 11-14 Sales Channel Performance Analysis"
Parent topic: Channel Performance Analysis
Revenue Analysis
The Revenue Analysis reports include the following areas:
- Agent Revenue Analysis in USD
- Booking Class Revenue Analysis in USD
- Channel Revenue Analysis in USD
- Flight Revenue Analysis in USD
- Flown Revenue Per Sales Region
- Flown Revenue per Sales Region and Service Class
- Sales: Net Revenue Flown Channel Bottom 10
- Sales - Net Revenue Flown Channel Top 10
- Sales - Net Revenue Flown Bottom 10 Countries (Flop 10)
- Sales - Net Revenue Flown Top 10 Countries
- Sales - Net Revenue Per Agency - Top 10 Revenue
- Segment Revenue Analysis in USD
- Service Class Revenue Analysis in USD
Parent topic: Oracle Airlines Data Model Sample Reports
Agent Revenue Analysis in USD
This report, as shown in Figure 11-15 provides the revenue analysis in terms of USD among the agents at the month level. This report provides information that enables you to determine agents that are performing well. The report also provides information on sales revenue, net revenue, and the LP, and % Change LP metrics.
Report dimensions are:
-
Time
Figure 11-15 Agent Revenue Analysis in USD
Description of "Figure 11-15 Agent Revenue Analysis in USD"
Parent topic: Revenue Analysis
Booking Class Revenue Analysis in USD
This report, as shown in Figure 11-16 provides the revenue analysis for booking class in USD. This provides information so that you can determine which booking class is well used under which service class. The report also provides metrics for net revenue, sales revenue, LP, and % Change LP metrics.
Report dimensions are:
-
Time
Figure 11-16 Booking Class Revenue Analysis in USD
Description of "Figure 11-16 Booking Class Revenue Analysis in USD"
Parent topic: Revenue Analysis
Channel Revenue Analysis in USD
Report dimensions are:
-
Time
Figure 11-17 Channel Revenue Analysis in USD
Description of "Figure 11-17 Channel Revenue Analysis in USD"
Parent topic: Revenue Analysis
Flight Revenue Analysis in USD
This report, as shown in Figure 11-18 provides the revenue analysis in USD for flights at month level. The report shows which revenue per operating flight. The report also includes information on net revenue, sales revenue, and the metrics LP, and % Change LP.
Report dimensions are:
-
Time
Figure 11-18 Flight Revenue Analysis in USD
Description of "Figure 11-18 Flight Revenue Analysis in USD"
Parent topic: Revenue Analysis
Flown Revenue Per Sales Region
This report, as shown in Figure 11-19 provides the current year month level flown revenue for sales regions. The information is obtained for flown revenue, flown passenger count, and average fare for the sales regions along with LP, % Change LP. This report information help you determine which region has the most revenue.
Report dimensions are:
-
Time
-
Agent Region
Figure 11-19 Flown Revenue per Sales Region
Description of "Figure 11-19 Flown Revenue per Sales Region"
Parent topic: Revenue Analysis
Flown Revenue per Sales Region and Service Class
This report, as shown in Figure 11-20 provides the flown revenue per sales region and service class. The report information is on the flight revenue, flight passenger count, and average fare along with the metrics of LP, % Change LP for the flight revenue and flight passenger count. The information in this report help you determine which sales region and which service class has higher revenue.
Report dimensions are:
-
Time
-
Agent Region
-
Service Class
Figure 11-20 Flown Revenue Per Sales Region and Service Class
Description of "Figure 11-20 Flown Revenue Per Sales Region and Service Class"
Parent topic: Revenue Analysis
Sales: Net Revenue Flown Channel Bottom 10
This report provides the Sales, Net Revenue Flown Channel Bottom 10 report (Flop 10).
Report dimensions are:
-
Time
Figure 11-21 Sales - Net Revenue Flown Channel Bottom 10
Description of "Figure 11-21 Sales - Net Revenue Flown Channel Bottom 10"
Parent topic: Revenue Analysis
Sales - Net Revenue Flown Channel Top 10
This report provides the sales net revenue flown channel by channel type.
Report dimensions are:
-
Time
Figure 11-22 Net Revenue Flown Channel Top 10
Description of "Figure 11-22 Net Revenue Flown Channel Top 10"
Parent topic: Revenue Analysis
Sales - Net Revenue Flown Bottom 10 Countries (Flop 10)
This report provides information on flown passenger counts by country.
Report dimensions are:
-
Time
Figure 11-23 Net Revenue Flown by Passenger Count Bottom 10 Countries
Description of "Figure 11-23 Net Revenue Flown by Passenger Count Bottom 10 Countries"
Parent topic: Revenue Analysis
Sales - Net Revenue Flown Top 10 Countries
This report provides the net revenue flown for the top ten countries.
Report dimensions are:
-
Time
Figure 11-24 Net Revenue Per Agency - Top 10 Revenue
Description of "Figure 11-24 Net Revenue Per Agency - Top 10 Revenue"
Parent topic: Revenue Analysis
Sales - Net Revenue Per Agency - Top 10 Revenue
This report provides the sales net revenue per top ten agency.
Report dimensions are:
-
Time
Figure 11-25 Sales - Net Revenue Per Agency - Top 10 Revenue
Description of "Figure 11-25 Sales - Net Revenue Per Agency - Top 10 Revenue"
Parent topic: Revenue Analysis
Segment Revenue Analysis in USD
This report, as shown in Figure 11-26 provides the information on revenue analysis segment wise in month level. The statistics on sales revenue, net revenue, net revenue per pax, net revenue per booking is available along with LP metrics. This report can help you determine which segment is well used based on revenue.
Report dimensions are:
-
Time
Figure 11-26 Segment Revenue Analysis in USD
Description of "Figure 11-26 Segment Revenue Analysis in USD"
Parent topic: Revenue Analysis
Service Class Revenue Analysis in USD
This report, as shown in Figure 11-27 provides the month level revenue analysis on service class in USD. The report shows that out of all the service classes available, class usage and revenue per service class. The report also shows metrics such as LP for sales revenue, net revenue, net revenue per pax, and net revenue for booking.
Report dimensions are:
-
Time
Figure 11-27 Service Class Revenue Analysis in USD
Description of "Figure 11-27 Service Class Revenue Analysis in USD"
Parent topic: Revenue Analysis
Route Analysis Reports
The Route Analysis Reports are includes one report:
- Route Ranking on Bookings
- ASK Analysis
Shows the ASK Analysis report. - Route Passenger Count Forecast
Shows the Route Passenger Count Forecast report.
Parent topic: Oracle Airlines Data Model Sample Reports
Route Ranking on Bookings
This report provides the information on rankings of routes based on bookings at month level. The report shows the statistics for booked, confirmed, and canceled, along with the metrics LP, % Change LP for booked, confirmed, and canceled. Based on the booking statistics, the report provides ranks for the routes. The report also shows the cancellation rate for the particular route.
Report dimensions are:
-
Time
Figure 11-29 Route Ranking on Bookings Right Side
Description of "Figure 11-29 Route Ranking on Bookings Right Side"
Parent topic: Route Analysis Reports
ASK Analysis
Shows the ASK Analysis report.
Report dimensions are:
-
Time
Figure 11-30 Route Analysis Reports ASK Analysis
Description of "Figure 11-30 Route Analysis Reports ASK Analysis"
Parent topic: Route Analysis Reports
Route Passenger Count Forecast
Shows the Route Passenger Count Forecast report.
Report dimensions are:
-
Time
Figure 11-31 Route Analysis Reports Route Passenger Count Forecast
Description of "Figure 11-31 Route Analysis Reports Route Passenger Count Forecast"
Parent topic: Route Analysis Reports
Call Center Performance Analysis
The Call Center Performance Analysis reports include the following areas:
Parent topic: Oracle Airlines Data Model Sample Reports
Call Center Performance
This report, as shown in Figure 11-32 provides the year wise month level call center performance agents wise. The report includes the total number of calls and how many are accessible calls out of the total calls. The metrics like LP, % Change LP for the total number of calls and accessible calls can be obtained from this report.
Report dimensions are:
-
Time
-
Agent
Parent topic: Call Center Performance Analysis
Call Center Sales Performance
This report, as shown in Figure 11-33 provides the current year month level sales performance for the call centers for all the agents. The report includes information on the sold revenue and the count of coupons. This report also shows metrics LP and % Change LP for the Sold revenue and Coupons count.
Report dimensions are:
-
Time
-
Agent
Figure 11-33 Call Center Sales Performance
Description of "Figure 11-33 Call Center Sales Performance"
Parent topic: Call Center Performance Analysis
Customer Loyalty Analysis
The Customer Loyalty Analysis reports include the following areas:
- Airline Contribution
- Earn / Redemption
- Membership Development
- Frequent Flyer Customer Mining
- Non-Frequent Flyer Customer Mining
The Non-Frequent Flyer Customer Mining area includes two reports.
Parent topic: Oracle Airlines Data Model Sample Reports
Airline Contribution
This report, as shown in Figure 11-34 provides the year wise month level information on airline contribution, that is, how many members are there, how many are active out the total members, what is their growth rate, what is the passengers count and the rate of active members, Active members/Pax, and so on. The metrics like LP, % Change LP for members, active members are also obtained.
Report dimensions are:
-
Time
-
Loyalty Level
Parent topic: Customer Loyalty Analysis
Earn / Redemption
This report, as shown in Figure 11-35 provides the current year month level earnings and redemption. The report includes the total miles amount in accounts, total miles amount earned, and redeemed in the accounts. This report also provides the metrics LP, % Change LP for the total mils amount in accounts, total miles amount earned in accounts and total miles amount redeemed in account.
Report dimensions are:
-
Time
-
Loyalty Level
Parent topic: Customer Loyalty Analysis
Membership Development
This report, as shown in Figure 11-36 provides the membership development for the current year month level basing on loyalty level in different countries. This report provides information on the number of members, how many members are upgraded and degraded. The report also shows the metrics LP and % Change LP for the members' growth rate, upgrade count, and downgrade count.
Report dimensions are:
-
Time
-
Country
-
Loyalty Level
Parent topic: Customer Loyalty Analysis
Frequent Flyer Customer Mining
The Frequent Flyer Customer Mining reports includes four reports.
Customer Segments
This report, provides the frequent flyer customer mining report for segments.
Figure 11-37 Frequent Flyer Customer Mining Customer Segments
Description of "Figure 11-37 Frequent Flyer Customer Mining Customer Segments"
Customer Loyalty
This report, provides the frequent flyer customer mining for customer loyalty.
Report dimensions are:
-
Target Value
Figure 11-38 Frequent Flyer Customer Mining Customer Loyalty
Description of "Figure 11-38 Frequent Flyer Customer Mining Customer Loyalty"
Customer Life Time Analysis
This report, provides the frequent flyer customer mining report for expected customer life time.
Customer Segmentation Details
This report, provides the frequent flyer customer mining report for customer segmentation.
Report dimensions are:
-
Customer Segment Code
Figure 11-40 Frequent Flyer Customer Mining: Customer Segmentation Details
Description of "Figure 11-40 Frequent Flyer Customer Mining: Customer Segmentation Details"
Parent topic: Customer Loyalty Analysis
Non-Frequent Flyer Customer Mining
The Non-Frequent Flyer Customer Mining area includes two reports.
FFP Prediction In Non-FFP Customers
This report provides the Non-Frequent Flyer Customer Mining FFP Prediction Sample Report.
Figure 11-41 Non-Frequent Flyer Customer Mining FFP Prediction In Non-FFP Customers
Description of "Figure 11-41 Non-Frequent Flyer Customer Mining FFP Prediction In Non-FFP Customers"
Non-FFP Customer Mining Overall
This report, provides the Non-FFP Customer Mining Overall Sample Report.
Figure 11-42 Non-FFP Customer Mining Overall
Description of "Figure 11-42 Non-FFP Customer Mining Overall"
Parent topic: Customer Loyalty Analysis
Customer Interaction Analysis
The Customer Interaction Analysis reports include the following areas:
- Customer Satisfaction Survey Summary
- Customer Satisfaction Onboard Survey Detail
- Customer Satisfaction Ground Survey Detail
- Customer Relations Customer Comments
Parent topic: Oracle Airlines Data Model Sample Reports
Customer Satisfaction Survey Summary
This report, as shown in Figure 11-43 provides the yearly month wise customer satisfaction survey summary based on service type, that is, count of surveys made, satisfaction rate of customers known through the survey is known in this report. The report shows metrics such as LP, % Change LP for the total survey count and satisfaction rate of the customers.
Report dimensions are:
-
Time
-
Service Type
Figure 11-43 Customer Satisfaction Survey Summary
Description of "Figure 11-43 Customer Satisfaction Survey Summary"
Parent topic: Customer Interaction Analysis
Customer Satisfaction Onboard Survey Detail
This report, as shown in Figure 11-44 provides the current year month level customer satisfaction onboard based on service type. The report includes information on the total surveys and the satisfaction rate of the customers onboard. The report shows metrics such as LP, % Change LP for total survey count and satisfaction rate.
Report dimensions are:
-
Time
-
Service Type
Figure 11-44 Customer Satisfaction Onboard Survey Detail
Description of "Figure 11-44 Customer Satisfaction Onboard Survey Detail"
Parent topic: Customer Interaction Analysis
Customer Satisfaction Ground Survey Detail
This report, as shown in Figure 11-45 provides the customer satisfaction ground survey details for current year month wise. Statistics on Total surveys made, what is the satisfaction rate of the customers will be provided along with LP and % Change LP in this report.
Report dimensions are:
-
Time
-
Service Type
Figure 11-45 Customer Satisfaction Ground Survey Detail
Description of "Figure 11-45 Customer Satisfaction Ground Survey Detail"
Parent topic: Customer Interaction Analysis
Customer Relations Customer Comments
This report, as shown in Figure 11-46 provides the month level customer relations. The report includes statistics on count of surveys made in the current month for the service type and service. The metrics like LP and % Change LP will also be there for this.
Report dimensions are:
-
Time
-
Service Type
Figure 11-46 Customer Relations Customer Comments
Description of "Figure 11-46 Customer Relations Customer Comments"
Parent topic: Customer Interaction Analysis
Flight Operations Reports
The flight operations reports include the following areas:
Parent topic: Oracle Airlines Data Model Sample Reports
In Flight Aircraft Details
This report provides the flight operations report in flight aircraft details.
Report dimensions are:
-
Aircraft Type
Parent topic: Flight Operations Reports
Historical Resolution Time
This report provides an analysis of the historical resolution time for a ATA chapters.
Report dimensions are:
-
Time
-
Defect Type
Parent topic: Flight Operations Reports
Outstanding Defects
This report provides the defect count details.
Report dimensions are:
Parent topic: Flight Operations Reports
Flight Tracking
This report provides an analysis of the historical resolution time for a ATA chpters.
Report dimensions are:
-
Time
-
Defect Type
Parent topic: Flight Operations Reports
Maintenance and Operations Control Reports
The maintenance and operations control reports include the following areas:
- Passenger Load
- Number of Defects
- Average MEL Clearance Time
Provides information on average MEL Clearance Time. - Non Routine Resolution Analysis
- Non Routine Analysis
- Slot Discrepancy
- Defect Aging
Parent topic: Oracle Airlines Data Model Sample Reports
Passenger Load
This report provides an assessment of current load.
Report dimensions are:
-
Flight
Parent topic: Maintenance and Operations Control Reports
Number of Defects
This report provides information on number of defects and the resolution time for defects.
Report dimensions are:
-
Aircraft Type
Parent topic: Maintenance and Operations Control Reports
Average MEL Clearance Time
Provides information on average MEL Clearance Time.
Report dimensions are:
-
Aircraft Type
Parent topic: Maintenance and Operations Control Reports
Non Routine Resolution Analysis
This report provides information
Report dimensions are:
Parent topic: Maintenance and Operations Control Reports
Non Routine Analysis
This report provides a break down of work analysis by ATA chapter.
Report dimensions are:
-
ATA Chapter
Parent topic: Maintenance and Operations Control Reports
Slot Discrepancy
This report provides a report on whether flight estimates are consistent.
Report dimensions are:
Parent topic: Maintenance and Operations Control Reports
Defect Aging
This report provides a report on defect aging.
Report dimensions are:
-
ATA Chapter
-
Time
Parent topic: Maintenance and Operations Control Reports
Special Location Gate Reports
The eports include the following areas:
Parent topic: Oracle Airlines Data Model Sample Reports
Delay Hot Spots
This report provides a heat map display of the selected airport indicating on time departure efficiency.
Report dimensions are:
-
Airport Code
Parent topic: Special Location Gate Reports
Departures and Delays
This report provides a description of the delays and departures.
Report dimensions are:
-
Time
Parent topic: Special Location Gate Reports
Ground Time Control
This report provides a count down initiated from when the ground time indicator is set.
Report dimensions are:
-
Aircraft Registration
Parent topic: Special Location Gate Reports
Special Location Passenger Reports
The reports include the following areas:
Passenger Connections
This report provides a report of the at risk passenger connections.
Report dimensions are:
-
Flight Number
Parent topic: Special Location Passenger Reports
Passenger Trip Delay
This report provides information on passenger trip delays.
Report dimensions are:
Parent topic: Special Location Passenger Reports
TAT Analysis Reports
The reports include the following areas:
Aircraft Dispatch Reliability
This report provides a report on the probability that the aircraft will take off on scheduled time.
Report dimensions are:
-
Flight Number
-
Time
Figure 11-62 Aircraft Dispatch Reliability
Description of "Figure 11-62 Aircraft Dispatch Reliability"
Parent topic: TAT Analysis Reports