KPI Formulas

Hospitality KPI Formulas

Hospitality KPIs track occupancy, rates, revenue per available room, cancellations, and guest satisfaction. Browse copy-paste Excel formulas with practical examples and Power BI DAX notes.

💡 Ideas for You

Resources related to this KPI and spreadsheet reporting.

4 useful links

📚 Step-by-step booksStart with beginner-friendly step-by-step books and learning resources from Create & Learn.📊 KPI dashboard resourcesBooks and templates for building hospitality KPI dashboards in spreadsheets.📈 Business metrics booksReferences for understanding hospitality metrics, definitions, and reporting habits.📘 Excel reporting guidesGuides for turning spreadsheet calculations into clear reports and dashboards.

Start here: what these KPIs are for

Hospitality KPIs track occupancy, rates, revenue per available room, cancellations, and guest satisfaction.

Use these pages when you need to explain a KPI to a beginner, build it in Excel, validate the inputs, or recreate the same logic in Power BI. Each page includes a plain-English definition, real-life example, Excel formula, DAX measure, interpretation notes, and common mistakes.

Best fora hotel performance dashboard

Main questionWhether pricing, occupancy, and guest experience are working together

Recommended viewTrend + target + segment

Hospitality KPI list

Average Daily Rate

Room Revenue / Rooms Sold

Cancellation Rate

Cancelled Bookings / Total Bookings

Guest Satisfaction Score

Total Score / Number of Responses

Occupancy Rate

Rooms Sold / Rooms Available

RevPAR

Room Revenue / Rooms Available

How to use these KPI formulas

Pick one KPI and confirm the business definition.
Add the inputs to a clean Excel table, one row per period or segment.
Paste the formula from the KPI page and format the result correctly.
Add a target or benchmark column so the number has context.
Link related KPIs together instead of judging one metric alone.

Popular Hospitality KPIs