Connecting people with the world’s greatest travel possibilities.

Confidential

Sabre HotelVision Introduction & Training

2 Confidential

The Future of Hotel Reporting – HotelVision

• Sabre® HotelVisionSM, is a suite of reporting tools to meet your reporting needs across Sabre’s businesses.

• On-demand, Sabre-wide booking and sales information in a single location, with a single log-in.

• Comprehensive view of your activity through Sabre’s distinct booking channels, giving you visibility on key metrics at greater levels of detail than previously available.

• Combines the breadth and depth of Sabre information and your familiarity with the Cognos® Business Intelligence tool

3 Confidential

Topics

• Overview

• Reports

• Cubes• Dimensions• Measures• Predefined date range comparisons• Measure breakdown• Manipulating information

– Filtering– Drilling down– Nesting

• Charting and Graphing Information

• Saving, Exporting, Finding, and Highlighting Information

4 Confidential

HotelVision - Features

• The right information… • 360-degree view

– Historical: 3 years (37 rolling months) – Forward-looking: 11 months (insight into future demand)

• Drill down capability to detailed, organized information

• To the right people…• Multiple reports in the Cognos environment

– Reports – prompts allow for some customization– Cubes – full ad hoc flexibility

• At the right time…• Information updated daily

– Report latency – up to 1 day– Production cube latency – 2 days– Compset cube latency – up to 1 week (cubes published weekly)

• Reports and cubes accessible on demand

5 Confidential

HotelVision – Prompted Reports

Report Description

Report Stats – By Company & Chain with Property

Information for a specific hotel company, its chain and properties. Prompts include start/end date, hotel company and hotel chain. Includes reports based on either Booking Date or Check-in Date.

Report Stats – By Company with Chains

Information for a specific hotel company and its chains (no property detail). Prompts include start/end date and hotel company. Includes reports based on either Booking Date or Check-in Date.

Report Stats – By Distribution Channel

Company-level information broken out by distribution channel (Travel Network, Travelocity, Corporate Solutions). Prompt is start/end date. Includes reports based on either Booking Date or Check-in Date.

Report Stats – By Agency Location Geography

Company-level information broken out in a geographic hierarchy by agency location. Prompts include start/end date, region, country and state/province. Includes reports based on either Booking Date or Check-in Date.

Report Stats – By Destination Geography

Company-level information broken out in a geographical hierarchy by property location (destination). Prompts include start/end date, region, country and state/province. Includes reports based on either Booking Date or Check-in Date.

6 Confidential

Introducing HotelVision - Cubes

Cube Description

Hotel Booking Performance (HBP) by Supplier

Cube containing information on own company production, organized by either booking date or check-in date.

Company Compset - [Company Name] Cube containing information on own company production and aggregated company-level compset production, organized by either booking date or check-in date.

Chain(n) Compset Cube containing information on own chain production and aggregated chain-level compset production, organized by either booking date or check-in date.

Passive Cube containing passive booking information allowing the user to drill down to the agency level by either booking date or check-in date.

Travelocity Property Compset Cube containing information on own property production and aggregated property-level compset production, organized by either booking date or check-in date.

7 Confidential

Rules for the Day

Let’s Go!

• Stay with us

• Be creative

• Ask questions

• Have fun!

• To access HotelVision:• https://hotelvision.sabre.com/c8/ (note: secure access - https://...)• Password protected

• User ID and password will be provided by your Account Manager

8 Confidential

Enter your assigned User ID and Password

9 Confidential

…and you’re in!!!

10 Confidential

Go to the HotelVision Data Analysis Reports and Cubes

11 Confidential

Let’s start with Reports

12 Confidential

Select the Company & Chain with Property report

13 Confidential

Choose Report Preference: Booking Date or Check-in Date

Select the option and then select Next to progress to the date parameter screen

14 Confidential

Choose Start and End Dates and Hotel Company

15 Confidential

Select Chain(s) and Click on Finish to run the report

16 Confidential

A sign that data is being collected

17 Confidential

Success! View the details of the report

Input Parameters

Measures

18 Confidential

Return to the list of reports/cubes, click on return arrow icon

19 Confidential

Now, run a report with options

20 Confidential

Run with options

21 Confidential

Run with options, Save the Report

22 Confidential

Choose Report Preference: Booking Date or Check-in Date

Select the option and then select Next to progress to the date parameter screen

23 Confidential

Select input parameters, click on Finish

24 Confidential

Validate your input, Click OK

25 Confidential

Find your saved reports under My Folders

26 Confidential

View the output version of your report

27 Confidential

View the output versions of your report

28 Confidential

Save the file

29 Confidential

Save the file

30 Confidential

Open the File in Excel to review

31 Confidential

Close the report and return to the main screen

32 Confidential

Now, on to Cubes

33 Confidential

Select the Hotel Booking Performance (HBP) by Supplier Folder

34 Confidential

Select the Hotel Booking Performance (HBP) by Supplier Folder

35 Confidential

Default Screen

Display, Charting and Graphing Functionality

Other Navigational

Tools

Measures

Dimensions

36 Confidential

Dimensions

• Dimensions are categories under which you can organize metrics to better evaluate performance.

How do you want to analyze your data?

37 Confidential

Available dimensions

• Nine primary dimensions form the basis upon which you can analyze your information

Dimension Description Lowest Drill Down Level

Hotel Supplier The hotel company/chain/property hierarchy. Chain

Checkin Date The date of hotel check-in (intended for future check-in dates) for a specific booking, grouped by year, quarter, month, week, and day.

Day

Booking Date The date a booking was made, grouped by year, quarter, month, week, and day.

Day

Agency Location Geographical area of the agency that created the booking. Airport Code

Destination Geographical area of the hotel property that was booked. Property

Distribution Channel Sabre distribution channel hierarchy, aggregated by Travelocity, TN, and Corporate Solutions, with corresponding sub-channels.

Channel Type

Inventory Type Categorization of hotel rate types (published vs. net-rate)

Booking State Categorization of current status of hotel booking (net vs. cancel)

Top Secret Indicator Categorization of booking in Top Secret program

38 Confidential

Dimensions: Booking Date/Check-in Date

Year

Month

Quarter

Week

Day

39 Confidential

Dimensions: Hotel Supplier

Company

Chain Property will appear here after chain

40 Confidential

Dimensions: Agency Location

Region

CityCountry

Airport Code

41 Confidential

Dimensions: Destination

Region

City

Country

Airport Code

State

42 Confidential

Dimensions: Distribution Channel

TN and Joint Ventures Travelocity and

the Partner Network

GetThere and TBiz

Sub Channels

43 Confidential

Dimensions: Inventory

44 Confidential

Dimensions: Booking State

45 Confidential

Dimensions: Top Secret Indicator

46 Confidential

Measures

A measure is a quantifiable evaluation of your transaction activity

What information do you want to analyze?

47 Confidential

Measures

Measures dictate the type of data that is to be analyzed according to the

dimensions you select

48 Confidential

Base Measures

Booking: Number of Net bookings (excluding cancelled

and passive)

Room Nights: Consumed room night quantity

Sales: Net Sales Amount (USD) RoomRate * RoomNights

49 Confidential

Calculated Measures

Average Daily Rate (USD):Sum(NetSales) divided by

Sum(RoomNightCount)

Average Length of Stay: Sum(LOS) divided by Net

bookings

Sales Per Booking: Sales divided by NetBookings

50 Confidential

Layout

When you are manipulating dimensions DISPLAYED in rows or columns, dimensions dictate the

layout

When you are manipulating dimensions DISPLAYED in rows or columns, dimensions dictate the

layout

51 Confidential

Layout Alteration

To change basic layout, simply select a dimension from the left

hand side of the screen……

52 Confidential

Layout Alteration

….and drag it across the dimension you wish to replace

53 Confidential

Layout Alteration

54 Confidential

Layout Alteration

Same is true for columns

55 Confidential

Layout Alteration

56 Confidential

Quick Tip: Swapping

Using the “swap” function is equivalent to

replacing two dimensions in rows or

columns with each other

57 Confidential

Quick Tip: Swapping

58 Confidential

Filtering

When you are altering dimensions NOT DISPLAYED

in rows or columns, dimensions act as filters that

determine what data is appearing on the display

Excluding everything but….

59 Confidential

Filtering

In this example,I am filtering out all booking counts with the exception of

bookings driven through Travelocity

60 Confidential

Filtering

The display has changed to only show

Travelocity

61 Confidential

• You are concerned about the impact of your business in Toronto after the World Health Organization’s announcement to avoid the city due to Flu outbreak.

• As a first step in your analysis, you want to find out how much revenue has flowed into your Toronto properties during the past several years from travelers who booked through Sabre Travel Network’s agencies located within the US

Problem

62 Confidential

Solution

Agency Location = US

Destination = Toronto

Distribution Channel = TN

63 Confidential

Problem

• You are working on a project and realize that you need sales totals for all of your chains by month for 4th quarter 2008. What does your report look like?

64 Confidential

Solution

65 Confidential

Quick Tip: Sorting

Click the arrow above ANY of the dimensions to enable sorting

in ascending or descending order

66 Confidential

The Drill Down Principle

Look at the arrows!!

An arrow indicates you can drill down. Click here to show

ALL of the next lowest level components that appear on

screen

If you are at lowest level, click here to show element in

isolation

67 Confidential

Quick Tip: Scrolling

Scroll bar allows for more drill down options

68 Confidential

The Drill Down Principle

Click on the link to display all

properties within the chain

69 Confidential

The Drill Down Principle

70 Confidential

Quick Tip: Next/Last Page

Move to the next page or the end of the list by

clicking here

A ‘Quick Tip’ is displayedwhen the mouse

is moved over an item

71 Confidential

Nesting

I need to see bookings for each of my chains

broken down by distribution channel over

time.

What was the revenue for each brand by

channel for each quarter of 2009?

How does my room night consumption

differ by agency location within each

region that Sabre has agencies?

• Nesting allows you to solve multiple problems within a single report

72 Confidential

Nesting – one method

Add Measures as nested categories in the rows

beside the Years categories Right mouse click on Measures

Click on Nest Rows

73 Confidential

Nesting – a different method

Highlight MeasuresClick and Drag to the column

beside the Year categories

74 Confidential

Nesting

The summary for each year and each measure

for each Hotel Supplier

Primary Element Secondary

Element

75 Confidential

Quick Tip: To remove a nest

Click on the X to remove the

dimension from its nested position

76 Confidential

Cognos Predefined date range comparisons

77 Confidential

Current data

Current Data = Aggregated data

for this time period

78 Confidential

Current data

79 Confidential

Prior data

“Prior” Data = Aggregated data for the same period of

time during the previous period

80 Confidential

Prior data

81 Confidential

Grouped data

“Grouped” = Comparative data

82 Confidential

Grouped data

YTD Growth= (YTD/Prior YTD) - 1 in percentage

format

YTD Change = Change in the value of the measure that

is selected

No comparisons of past grouped data

83 Confidential

Problem

• You are curious to see revenue growth by property for a specific chain code. Specifically, you want to compare YTD data for 2010 versus 2009. Sort your findings by growth percentage from highest to lowest.

84 Confidential

Solution

85 Confidential

Problem

• You are charged with executing a marketing campaign on behalf of all U.S. based properties affiliated with a specific chain code. The campaign is directed to Sabre Travel Network agencies. In the first phase of your analysis, you have decided to examine bookings for each property throughout each quarter of 2009. Sort your report in descending order by total bookings for the year.

86 Confidential

Solution

87 Confidential

Measure Breakdown

“As values”: Default -- actual raw number of units being

measured

Display Options Button

88 Confidential

Measure Breakdown

“% of row total”: Calculates

percentages based on total values

summed to the right of the row

“% of column total”: Calculates percentages

based on total value summed at the bottom of

the column

“% of grand total”:

Calculates percentages

based on overall total in

lower right corner of table

89 Confidential

Measure Breakdown - Nesting

Row and column subtotals become

relevant when nesting is utilized

90 Confidential

Measure Breakdown - Nesting

Every data point is based to subtotal

91 Confidential

Problem

• Create a report that shows bookings broken down by channel during the 1st quarter of 2009. These bookings were produced by European agencies for a specific chain only. In addition, only show bookings generated for US properties only. Show the percentage of bookings by channel that occurred within each of the months within the quarter.

92 Confidential

Solution 1

93 Confidential

Solution 2

Notice the change in the selection

94 Confidential

Down a Level

95 Confidential

Down a Level

96 Confidential

Up a Level

97 Confidential

Problem

• At the beginning of the year, you decided to promote a contest among all of your chains. You want to know the property which has produced the greatest QTD revenue growth across all agencies and channels. As of this date, which property is winning the contest?

98 Confidential

Solution - Step 1

99 Confidential

Solution - Step 2

100 Confidential

QuickTip: Hide/Show…

Use “Hide/Show…” to

conceal/reveal rows or columns

of data

101 Confidential

QuickTip: Hide/Show…

Remove or add dimensions to

conceal or hide rows.

Determine whether or not

you want to show summaries.

102 Confidential

QuickTip: Hide/Show…

Note that sums are not altered

103 Confidential

QuickTip: Hide Selection

Use Hide Selection to

conceal 1 row or column of data

Right mouse click on row to be

hidden – menu will be displayed

104 Confidential

QuickTip: Hide Selection

105 Confidential

QuickTip: Zero Suppression

Use Zero Suppression to remove rows or

columns that contain all Zeros

106 Confidential

QuickTip: Zero Suppression

Data is not deleted, it’s just not displayed

107 Confidential

Problem

• You have been asked to produce a report analyzing revenue within Sabre by quarter. Specifically, you would like to see how these bookings break down by agency location and distribution channel. Produce the report, using the agency location as your primary element and nesting distribution channel within it.

108 Confidential

Solution

109 Confidential

Problem

• Your boss has changed his mind and wants to see the same information, but with distribution channel as the primary element.

110 Confidential

Solution

“Swap left” reverses order of

primary and secondary

dimensions

111 Confidential

Solution

“Swap right” performs similar

functions

112 Confidential

Grouping

I would really like to have each of my properties

sorted within each of my chains

Can I list and present agency location or

destination countries within each of the

regions?

• To group data, simply nest an element within itself

Chain

Property 1

Property 2

Property 3

Country 1

Country 2

Region

State/Prov. 1

State/Prov. 2

State/Prov. 1

State/Prov. 2City 1

City 2

City 1

City 2

City 1

City 2

City 1

City 2

113 Confidential

Problem

• You have been tasked with providing a report that shows YTD room night growth for each airport in which you have a property affixed. Produce the report, grouping destination airport within country and grouping country within region.

114 Confidential

Solution: Step 1

115 Confidential

Solution: Step 2

116 Confidential

Solution: Step 3

117 Confidential

Solution: Step 4

118 Confidential

Problem

• You have been tasked with generating a marketing campaign to help your business rebound after ‘problems’ in January 2009. The first step requires that you analyze travel patterns for your customers by tying booking location to property location for each of your chains. Create a single report analyzing this type of booking activity for each of your chains for each month of 1st quarter of 2009.

119 Confidential

Solution: Step 1

Selected primary dimensions for row and column

display

Specify date

Select measure

Specify Primary Dimension

120 Confidential

Solution: Step 2

Go down THREE

levels to city level

121 Confidential

Solution: Step 3

Nest Destination

within Agency Location

122 Confidential

Solution: Step 4

Go down THREE

levels to city level

123 Confidential

Solution: Step 5

Nest Hotel Supplier

within Date

124 Confidential

Solution: Step 6

125 Confidential

Beyond Tables – Graphing, Saving and Display Options

• Charting and Graphing Information

• My Folders

• Saving reports

• Display Options

• Exporting Information

• Finding Information

• Exceptions

126 Confidential

Charts and Graphs

Stacked bar chart

Pie chart

Simple bar

chart

3D bar chart

Clustered bar chart

Line graph

Chart Options Scatter and

Correlation

127 Confidential

Single Dimensional Charts

Elements: HOW IS DATA ANALYZED?

Measures: WHICH DATA IS

ANALYZED?

128 Confidential

Multidimensional Charts

Elements: HOW IS DATA ANALYZED?

Measures: WHICH DATA IS

ANALYZED? Second element appears in

certain charts when there are more than two dimensions.

129 Confidential

Problem

• Represent average daily rate in a graph or chart for each quarter of 2009 for each of your chains

130 Confidential

Solution 1: Clustered Bar Chart

131 Confidential

Solution 2: Line Graph

132 Confidential

Solution 3: Stacked Bar Chart

133 Confidential

Solution 4: 3D Bar Chart

134 Confidential

Split View

Click here to see data and chart in same

view.

135 Confidential

Saving reports to My Folders

Once your desired report has been created

click here

136 Confidential

Saving reports to My Folders

Name your report

A description can be added for your reportto eliminate confusion

Click on Select another location or

“My Folders”

137 Confidential

Saving reports to My Folders

Click on My FoldersPress OK to

continue

138 Confidential

Saving reports to My Folders

Default now is My

Folders

Press OK to save your

report

139 Confidential

Review saved reports

Saved Reports

140 Confidential

Display Options

Cross tab display allows you to view elements in table

format

141 Confidential

Display Options

Indented cross tab is designed to decrease

display space by indenting nested row subgroups

under their group

142 Confidential

Exporting Data

Exports to PDF file format

Exports to CSV file format

Exports to XLS file format

143 Confidential

Exporting Data

When Exporting to a XLS file after selecting the “Export to XLS” there

will be an option for saving or opening directing into Excel.

144 Confidential

Exporting to PDF File

Select orientation and paper size before

exporting

145 Confidential

Exporting to PDF File

PDF format is viewable and printable when launched in Adobe Acrobat application

146 Confidential

Exporting to CSV File Type

Press button to initiate export

process

Opens directly into Excel for

saving as CSV or XLS file

147 Confidential

Finding Data

Methods to finding data within a report

148 Confidential

Finding Data

Find specific data

Specify what data to find

Select where to look:

cube/report

149 Confidential

Finding Data

6 rows found w/ Name of Pine Buff

150 Confidential

Exceptions

Access Custom

Exceptions

Add exceptions

151 Confidential

Exceptions

Name the Exception (find properties w/

“low” Values)

Specify Ranges: ‘low’ =

$0 - $500

152 Confidential

Exceptions

Click on Apply

Select Column/Row to apply exception

Exceptions appear

153 Confidential

QuickTip: Return to Source

Click here to return to “Source” page.

154 Confidential

Competitive Set Data Cubes

155 Confidential

Competitive Set

• A competitive set contains at least 4 other companies

• Contact your account manager if:• You have not submitted your competitive set data• Your competitive set needs to be altered

156 Confidential

Application of Competitive Set Data

• Extremely powerful applications that keep you in the know with regards to key performance indicators

Am I gaining or losing bookings market share

to my competitors in my top markets?

Do Sabre agents contribute to my

room night utilization more or less than my

competitors?

Have I been able to grow price through the Travelocity channel at a

rate faster than my competitors?

157 Confidential

Questions?