More Accurate Forecasts

We introduced a new forecasting approach that allowed revenue and occupancy forecasts to account for special events alongside normal demand patterns.

The situation

The client needed a more accurate way of carrying out their revenue and occupancy forecasting. They were relying on a statistical technique called ARIMA (Autoregressive Integrated Moving Average), which wasn’t able to consider special events such as property closures.

The opportunity

To include special events and other, non-seasonal factors for more accurate revenue and occupancy forecasts.

How we made it happen

We worked closely with the client to introduce a new forecasting method using Prophet, an open-source machine learning tool. Prophet allowed revenue and occupancy forecasts to account for special events such as property closures, alongside normal patterns of demand.

What changed

  • Revenue and occupancy forecasts became more accurate and more useful
  • Special events were factored into forecasts rather than treated as anomalies
  • Planning and decision-making improved across the business
  • The impact of events and closures on client bottom line became clearer

Why it matters

Planning improved because the business could see the financial impact of special events and closures in advance, not after the fact.

Tech Stack

Other projects we’ve worked on

Better Analytics for the CRMAirflowDBTGoogle Big QueryPowerBI

Better Analytics for the CRM

We built a consolidated analytics layer around the CRM bringing together booking and engagement data, giving teams a joined-up view of guest behaviour.
Develop a Business Intelligence SolutionExcelSQL ServerSSAS Tabular

Develop a Business Intelligence Solution

We built a self-service business intelligence layer that enabled revenue and sales teams to create their own reports using familiar tools.
Solving Data Quality IssuesAirbyteDBTMeltanoPowerBISnowflake

Solving Data Quality Issues

We implemented automated data validation within the finance data pipeline to resolve quality issues and prevent them from recurring in new systems.

Ready to elevate your business?

Booking a free 30-minute consultation today is your first move towards unlocking your business’s full potential. We’re here to listen, answer your questions, and explore how our expertise can drive your success.