Saltar al contenido principal

Blog

Practical guides on hotel revenue management and restaurant analytics with Power BI, written by the Keymets team.

Free guide: the 10 KPIs every hotel manager should check every morning.

Hotels

Power BI for hotels: where to start and what you need

How to start with Power BI in a hotel: the PMS data you need, how to build the model, the first five reports and who uses each one.

What pickup is in a hotel and how to analyse it to set prices

What hotel pickup is, how to read it over 3, 7, 14 and 30 days, common mistakes and a practical example for pricing decisions.

Booking pace: how to know if your hotel is ahead of or behind last year

What booking pace is, the three references to compare it with (SDLY, last year’s close and budget) and how to read it in room nights and revenue.

Occupancy, ADR and RevPAR: the three hotel KPIs explained with examples

What occupancy, ADR and RevPAR are, how they are calculated, why they must be read together and what to look at next: TRevPAR and GOPPAR.

The hotel manager’s dashboard: which indicators to show

Which indicators a hotel general manager’s dashboard should show, how to design it to be read in a minute and what to leave out.

Hotel forecasting: how to predict occupancy for the coming months

How to build a hotel forecast from what is on the books plus expected pickup, the references you need and the most common mistakes.

Restaurants

Free guide: the 8 indicators every restaurant group should check every day.

Power BI for restaurants: what it is and what it can do for your business

What Power BI for restaurants is, which POS data it uses and which decisions it improves: sales, average check, time slots, menu and cash.

Average check in a restaurant: how to calculate it and how to improve it

How to calculate a restaurant’s average check, why it must be read together with the number of checks, and practical levers to raise it.

Sales by time slot: how to plan shifts and staffing in your restaurant

How to analyse restaurant sales by hour and day of the week to plan shifts, kitchen production and opening hours with data.

Menu engineering with data: ABC and Pareto analysis of your menu

How to review your restaurant menu with data: ABC classification, Pareto principle and popularity versus price for each dish.

Cash discrepancies in restaurants: how to spot them in time

Why cash overs and shorts happen in restaurants and how to track them by outlet, shift, staff member and trend to act in time.

How to compare outlets in a restaurant group

Which indicators and benchmarks to use to compare outlets fairly in a restaurant group: group average, average check, time slots and product mix.

Beyond POS reports: when to move to Power BI in your restaurant

What POS reports do well, where they fall short and the signs that it is time to move your restaurant’s analysis to Power BI.