Hotel Profit Discovery

Learn to go from Raw Data to Revenue Discovery
with this hands-on, self-paced course.

Advanced Hotel Revenue Analysis
with Excel

  • Learn the process of understanding any hotel’s demand patterns using PMS data and Excel.
  • Understand how to create any revenue analysis and how to find hidden opportunities.
  • Learn how to dig deeper into booking data to reveal the real drivers of performance.
  • Be able to explain results with clarity and confidence.
  • Master the Excel techniques and tricks that will make you a reporting and analysis guru.
  • Topics based on the needs of real hotel revenue analysts.
  • This course is ideal for the beginner as well as the seasoned hotelier.

20 Hours of Short, One-topic, On-demand, Pre-recorded videos
Self-Paced with No Time Limit and ‘Forever’ Course Access

Real Hotel Data | Downloadable Excel Templates  | Certificate of Completion | No Exams

You get Lifetime access to the course.
Allowing you to come back to review the material at any time.  

Who should take this course:

Revenue Managers | Finance & Accounting Managers | Asset Managers
General Managers | Owners | Hotel Consultants

What You Will Learn

Pattern Analysis

Mastering raw PMS data

  • What data do you need for RM analysis?
  • Understanding PMS databases
  • Getting PMS data
  • Transforming PMS download files

Summarizing Performance

  • By Year, Month, and Day
  • Identifying Seasons
  • By Channel and Rate Code
  • By Discount and Promotion
  • By Analysis Period

The “Core” Revenue Metrics

  • Summarizing Occupancy
  • Average Daily Rate and its variations
  • RevPAR, TrevPAR
  • Peaks and Valleys Analysis

Segment Analysis

  • Market Performance Analysis
  • Room Type Analysis
  • Rate Code Analysis
  • Booking Window Analysis
  • Length of Stay Analysis
  • Discounts and Promotions Analysis

Group Business Analysis

  • Group Spend Analysis
  • Displacement Analysis
  • Group Size Analysis
  • Market Mix Analysis

Demographic Analysis

  • By Country and Region
  • By City and State
  • By Postal Code and Address

Comp Set Analysis

  • Price Positioning Mapping
  • Correlation Analysis
  • Comp Set Variance Analysis

Pickup Analysis

Revenue Pace Reporting

  • Building Pace Report Templates
  • Creating Pace from any point in time
  • Micro-Pace Analysis
  • Variance of Pace Analysis

Pickup Evaluation

  • Identifying Pickup windows
  • Windowing Pickup data
  • Statistical Significance of Pickup
  • Micro-Pickup Analysis

Total Revenue Analysis

Guest Spend Data

  • What data do you need for TRM analysis?
  • Linking Profiles with Purchases
  • Counting Unique Stays

Capture Rate Analysis

  • By Year, Month, and Day
  • By Booking Window
  • By Channel and Rate Code
  • By Discount and Promotions
  • By Analysis Period
  • By Length of Stay

Revenue Math

  • Grossing and Netting
  • Markups and Markdowns
  • Variance Components Analysis
  • Percentages and Variances
  • Conversions and Comparisons
  • Ratios and Proportions
  • Fractions, Decimals, Percents
  • Break-Even Analysis

Statistics Concepts

  • The Problem with Averages
  • Counting Random Events
  • Frequency Distribution
  • Cumulative Distribution
  • Variance
  • Standard Deviation
  • The Normal Distribution
  • Inverse Distribution Function
  • Outliers Identification
  • Correlation Analysis

Excel Techniques

Raw Data Transformation

  • Excel Tables
  • Error Functions
  • Text Functions
  • Join and Logic Functions
  • Date Functions
  • Rounding Functions

Creating Analytical Dimensions

  • Nested Functions
  • Lookup Functions
  • The IF function
  • Statistical Functions

Browsing Data 

  • Pivot Tables
  • Pivot Table Calculations
  • Pivot Charts

Advanced Reporting

  • Criteria Functions
  • Array Formulas
  • Automating data retrieval

Graphing for Analysis

  • Bar Graphs
  • Line Graphs
  • Data Points Graphs
  • Pie Charts
  • Dual Axis Graphs
  • High-Low graphs
  • Bubble graphs

arrow-blue-7Be one of the top hotel analysts in the world.

This course consists of 20 hours of short, on-demand videos, downloadable templates, and a verifiable electronic certificate upon completion.

$895.00 Add to cart

best_leftAdvanced Hotel Revenue Analytics Mastery Package

This bundle consists of 3 Courses and a verifiable electronic certificate for each course upon completion.  That’s more than 50 hours of Advanced RM training.

$2,485.00 Add to cart

 

Advanced Hotel Revenue Analysis,

Data Science of Hotel Revenue Optimization ,

How to Forecast with Excel

.

No programming or mathematics background required.

Most hotel analysis courses focus an a specific software or platform, thereby limiting your ability
to transfer your knowledge to other systems. Not this one.

THIS COURSE IS VENDOR AGNOSTIC. WE DO NOT PROMOTE OR LIMIT THE COURSE TO ANY SPECIFIC RMS, PMS, STATISTICS PACKAGE OR ANY OTHER SOFTWARE.  WE ALSO DO NOT PROMOTE ANY THIRD PARTY COMPANIES OR CONSULTING SERVICES INCLUDING OWL.  THIS COURSE IS NOT AFFILIATED WITH ANY HOTEL ASSOCIATION OR HOSPITALITY COMPANY.

The Instructor

Robert Hernandez is an expert in the field of mathematical Hotel Optimization and Analytics. He has spent the last 17 years building data-driven forecasting and optimization models for companies in over 20 different industries, from tech to tourism. Robert possesses a very unique skill set including cross-disciplinary experience, advanced mathematical and analytics skills, data transformation, industry-specific knowledge and business-process improvement expertise. Robert began his career at the Walt Disney Company in Revenue Planning. Read More+

 

Don't Miss The Next
Hotel Revenue Discovery Idea.

Sorry to interrupt your reading, but if you give us your email address, whenever we write something useful about Revenue Management, Pricing, Marketing, or Hotel Analytics, you'll receive a notice in your inbox.

This information will never be shared.