Hotel Analytics with SQL
Using SQL to Analyse Hotel KPIs
5 min readJul 23, 2023
The hotel industry relies on several unique KPIs to gauge performance. One of the most important of these is RevPAR — which stands for revenue per available room.
- RevPAR = Occupancy (%) * Average Daily Rate (ADR)
In addition, hoteliers can also use GOPPAR (or Gross Operating Profit per Available Room) to calculate…