Hotel Profit Discovery

Become a data-driven forecasting expert with this hands-on course.

How to Forecast Anything 

with Excel 

Who has registered for this course:

Financial Analysts | Finance & Accounting Managers | Asset Managers
General Managers | Bookkeepers | Consultants | Operations Managers | Tax Pros

16+ 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

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

What You Will Learn

The Best Predictive Techniques

Statistical Concepts for Forecasting

Excel Forecasting functions

Simple Moving Average

Weighted Moving Average

Exponential and Double Smoothing

Exponential Smoothing with Trend Adjustments

Seasonality Smoothing

Excel Array functions

Bayesian Forecasting

Measuring Forecast Accuracy

Improving Forecast Accuracy

Regression Techniques

Applied to Real Hotel Data

Forecasting Year-over-Year Growth

Forecasting Techniques for Group Sales

Forecast Group Pickup and Attrition

Forecast No Shows and Cancellations

Forecast Negotiated Rate Sales

Dynamic Forecasting for Transient Sales

Forecast Ancillary Sales and Covers

Forecast Variable Costs

Forecast the 21 Dimensions of Hotel Revenue Discovery

Building a P&L Forecasting Model

Build Rolling Forecasts

Connecting to Transaction Systems for Streaming Forecasts

arrow-blue-7

Leap to the Top .1% of global hotel talent.

This course consists of 160 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 Certificate

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.

No-nonsense, Immediate-Impact Training

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.