Sabre HotelVision Introduction & Training

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

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

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

HotelVision – Prompted Reports

Introducing HotelVision - Cubes

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

Enter your assigned User ID and Password

…and you’re in!!!

Go to the HotelVision Data Analysis Reports and Cubes

Let’s start with Reports

Select the Company & Chain with Property report

Choose Report Preference: Booking Date or Check-in Date Select the option and then select Next to progress to the date parameter screen

Choose Start and End Dates and Hotel Company

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

A sign that data is being collected

Input Parameters Measures Success! View the details of the report

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

Now, run a report with options

Run with options

Run with options, Save the Report

Choose Report Preference: Booking Date or Check-in Date Select the option and then select Next to progress to the date parameter screen

Select input parameters, click on Finish

Validate your input, Click OK

Find your saved reports under My Folders

View the output version of your report

View the output versions of your report

Save the file

Open the File in Excel to review

Close the report and return to the main screen

Now, on to Cubes

Select the Hotel Booking Performance (HBP) by Supplier Folder

Measures Display, Charting and Graphing Functionality Other Navigational Tools Default Screen Dimensions

Dimensions Dimensions are categories under which you can organize metrics to better evaluate performance. How do you want to analyze your data?

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

Month Week Day Year Quarter Dimensions: Booking Date/Check-in Date

Chain Company Property will appear here after chain Dimensions: Hotel Supplier

Country Region City Airport Code Dimensions: Agency Location

Region Country State City Airport Code Dimensions: Destination

Sub Channels GetThere and TBiz TN and Joint Ventures Travelocity and the Partner Network Dimensions: Distribution Channel

Dimensions: Inventory

Dimensions: Booking State

Dimensions: Top Secret Indicator

Measures A measure is a quantifiable evaluation of your transaction activity What information do you want to analyze?

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

Base Measures Booking: Number of Net bookings (excluding cancelled and passive) Room Nights: Consumed room night quantity Sales: Net Sales Amount (USD) RoomRate * RoomNights

Calculated Measures Average Daily Rate (USD): Sum(NetSales) divided by Sum(RoomNightCount) Sales Per Booking: Sales divided by NetBookings Average Length of Stay: Sum(LOS) divided by Net bookings

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

Layout Alteration To change basic layout, simply select a dimension from the left hand side of the screen……

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

Layout Alteration

Layout Alteration Same is true for columns

Layout Alteration

Quick Tip: Swapping Using the “swap” function is equivalent to replacing two dimensions in rows or columns with each other

Quick Tip: Swapping

Filtering Excluding everything but…. When you are altering dimensions NOT DISPLAYED in rows or columns, dimensions act as filters that determine what data is appearing on the display

Filtering In this example, I am filtering out all booking counts with the exception of bookings driven through Travelocity

Filtering The display has changed to only show Travelocity

Problem 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

Distribution Channel = TN Destination = Toronto Agency Location = US Solution

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?

Solution

Quick Tip: Sorting Click the arrow above ANY of the dimensions to enable sorting in ascending or descending order

Look at the arrows!! If you are at lowest level, click here to show element in isolation An arrow indicates you can drill down. Click here to show ALL of the next lowest level components that appear on screen The Drill Down Principle

Scroll bar allows for more drill down options Quick Tip: Scrolling

The Drill Down Principle Click on the link to display all properties within the chain

The Drill Down Principle

Move to the next page or the end of the list by clicking here A ‘Quick Tip’ is displayed when the mouse is moved over an item Quick Tip: Next/Last Page

Nesting I need to see bookings for each of my chains broken down by distribution channel over time. Nesting allows you to solve multiple problems within a single report How does my room night consumption differ by agency location within each region that Sabre has agencies? What was the revenue for each brand by channel for each quarter of 2009?

Right mouse click on Measures Click on Nest Rows Nesting – one method Add Measures as nested categories in the rows beside the Years categories

Highlight Measures Click and Drag to the column beside the Year categories Nesting – a different method

Nesting The summary for each year and each measure for each Hotel Supplier Primary Element Secondary Element

Quick Tip: To remove a nest Click on the X to remove the dimension from its nested position

Cognos Predefined date range comparisons

Current Data = Aggregated data for this time period Current data

Current data

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

Prior data

“Grouped” = Comparative data Grouped data

YTD Growth= (YTD/Prior YTD) - 1 in percentage format YTD Change = Change in the value of the measure that is selected Grouped data No comparisons of past grouped data

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.

Solution

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.

Solution

“As values”: Default -- actual raw number of units being measured Display Options Button Measure Breakdown

“% of row total”: Calculates percentages based on total values summed to the right of the row “% of grand total”: Calculates percentages based on overall total in lower right corner of table “% of column total”: Calculates percentages based on total value summed at the bottom of the column Measure Breakdown

Row and column subtotals become relevant when nesting is utilized Measure Breakdown - Nesting

Every data point is based to subtotal Measure Breakdown - Nesting

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.

Solution 1

Solution 2 Notice the change in the selection

Down a Level

Up a Level

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?

Solution - Step 1

Solution - Step 2

QuickTip: Hide/Show… Use “Hide/Show…” to conceal/reveal rows or columns of data

QuickTip: Hide/Show… Remove or add dimensions to conceal or hide rows. Determine whether or not you want to show summaries.

QuickTip: Hide/Show… Note that sums are not altered

Use Hide Selection to conceal 1 row or column of data Right mouse click on row to be hidden – menu will be displayed QuickTip: Hide Selection

QuickTip: Hide Selection

QuickTip: Zero Suppression Use Zero Suppression to remove rows or columns that contain all Zeros

QuickTip: Zero Suppression Data is not deleted, it’s just not displayed

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.

Solution

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

Solution “Swap left” reverses order of primary and secondary dimensions

Solution “Swap right” performs similar functions

City 1 Property 1 State/Prov. 1 State/Prov. 2 State/Prov. 1 State/Prov. 2 City 2 Country 1 Property 2 City 1 City 2 Region Property 3 City 1 City 2 Country 2 City 1 City 2 Grouping Can I list and present agency location or destination countries within each of the regions? To group data, simply nest an element within itself I would really like to have each of my properties sorted within each of my chains Chain

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.

Solution: Step 1

Solution: Step 2

Solution: Step 3

Solution: Step 4

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.

Select measure Specify date Specify Primary Dimension Selected primary dimensions for row and column display Solution: Step 1

Go down THREE levels to city level Solution: Step 2

Solution: Step 3 Nest Destination within Agency Location

Solution: Step 4 Go down THREE levels to city level

Solution: Step 5 Nest Hotel Supplier within Date

Solution: Step 6

Beyond Tables – Graphing, Saving and Display Options Charting and Graphing Information My Folders Saving reports Display Options Exporting Information Finding Information Exceptions

Simple bar chart Pie chart Stacked bar chart Clustered bar chart Line graph Scatter and Correlation 3D bar chart Chart Options Charts and Graphs

Measures: WHICH DATA IS ANALYZED? Elements: HOW IS DATA ANALYZED? Single Dimensional Charts

Measures: WHICH DATA IS ANALYZED? Second element appears in certain charts when there are more than two dimensions. Elements: HOW IS DATA ANALYZED? Multidimensional Charts

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

Solution 1: Clustered Bar Chart

Solution 2: Line Graph

Solution 3: Stacked Bar Chart

Solution 4: 3D Bar Chart

Split View Click here to see data and chart in same view.

Once your desired report has been created click here Saving reports to My Folders

Name your report Click on Select another location or “My Folders” A description can be added for your report to eliminate confusion Saving reports to My Folders

Press OK to continue Click on My Folders Saving reports to My Folders

Press OK to save your report Saving reports to My Folders Default now is My Folders

Saved Reports Review saved reports

Display Options Cross tab display allows you to view elements in table format

Display Options Indented cross tab is designed to decrease display space by indenting nested row subgroups under their group

Exports to PDF file format Exports to XLS file format Exports to CSV file format Exporting Data

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.

Exporting to PDF File Select orientation and paper size before exporting

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

Opens directly into Excel for saving as CSV or XLS file Press button to initiate export process Exporting to CSV File Type

Finding Data Methods to finding data within a report

Select where to look: cube/report Specify what data to find Find specific data Finding Data

Finding Data 6rows found w/ Name of Pine Buff

Add exceptions Exceptions Access Custom Exceptions

Name the Exception (find properties w/ “low” Values) Specify Ranges: ‘low’ = $0 - $500 Exceptions

Select Column/Row to apply exception Exceptions appear Click on Apply Exceptions

QuickTip: Return to Source Click here to return to “Source” page.

Competitive Set Data Cubes

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

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? Have I been able to grow price through the Travelocity channel at a rate faster than my competitors? Do Sabre agents contribute to my room night utilization more or less than my competitors?

Questions?

Sabre HotelVision Introduction & Training