Case study · Hospitality
Occupancy, rate and pace for every hotel
Hotel groups price rooms daily, but often see performance across properties only in weekly spreadsheets. This is how we built Power BI revenue analytics from property management and booking data, showing occupancy, rate, RevPAR and booking pace for each hotel.
Project overview
Revenue analytics on Power BI.
- Industry
- Hospitality
- Client
- Confidential
- Solution
- Revenue analytics
- Platform
- Power BI + Fabric
- Timeline
- 8–12 weeks
- Team
- 3 people
- Sources
- PMS, channel manager, budget
- Refresh
- Daily
- Users
- Revenue managers, GMs, owners
Expected business outcomes
What the client set out to gain
Earlier sight of pace and channel mix supports pricing decisions.
-
Daily
Pace versus last year and budget
Bookings on the books compared with the same point last year.
From daily PMS snapshots
-
2–5%
RevPAR improvement targeted
Pricing decisions made with better data.
Target range; achieved by revenue managers, not the dashboard
-
Visible
Channel costs
Commission cost by channel per hotel.
Where commission rates are recorded
Business challenges
How revenue reporting worked before
Each hotel exports its own figures.
Hotels
Each property's PMS exported to spreadsheets.
Pace
Booking pace tracked manually, if at all.
Channels
Commission costs known only in total.
Budget
Budget comparisons done at month-end.
Owners
Owners receive reports late and in different formats.
Proposed solution
What the Power BI build covers
A hospitality data model with daily snapshots for pace.
-
PMS pipelines
Reservations and revenue from each property loaded daily.
-
Pace snapshots
Daily on-the-books snapshots for pace analysis.
-
Core KPIs
Occupancy, ADR and RevPAR by hotel, segment and period.
-
Channel mix
Bookings, revenue and commission by channel.
-
Budget and forecast
Performance against budget and forecast.
-
Owner reports
Consistent monthly reports for owners.
Project requirements
What the client asked us for
The request was one view across hotels. Pace needs history, so daily snapshots start immediately.
Definitions are aligned across properties, because hotels often count complimentary rooms and packages differently.
What the project had to deliver
- 01One view across hotels
- 02Daily pace analysis
- 03Channel cost visibility
- 04Consistent owner reporting
Key challenges & considerations
What made it harder, and what we did
-
Different PMS systems across hotels
What we did
Each property system was mapped to shared definitions of rooms, rate and revenue.
-
Package revenue splits
What we did
Package revenue was split by an agreed rule, applied the same way in every hotel.
-
Group and contracted business
What we did
Group and contracted business was segmented separately from transient demand.
-
Hotels joining mid-year
What we did
Hotels that joined mid-year were loaded with their history.
What we watched for
- Start pace snapshots immediately
- Align definitions across hotels
- Split package revenue consistently
- Automate owner reports
Development process
Snapshots, KPIs, owners
Pace history accumulates from the first day.
-
Definitions
KPI and segment definitions aligned across hotels.
-
Pipelines and snapshots
PMS data loaded with daily snapshots.
-
KPI dashboards
Occupancy, ADR and RevPAR views built.
-
Pace and channels
Pace and channel analysis added.
-
Owner reports
Standard owner reports delivered monthly.
Technology stack
Power BI for hospitality
Fabric for snapshots, Power BI for every hotel.
Reporting
- Power BI
- Power BI mobile
- Paginated reports
Data platform
- Microsoft Fabric
- Azure SQL
- Dataflows
Governance
- Row-level security
- Deployment pipelines
- Measure documentation
Delivery
- Git integration
- Automated refresh monitoring
Quality assurance & deployment
Every figure reconciled before anyone relied on it
A dashboard is only useful if its numbers are believed. Each measure was reconciled to its source, and to finance where money was involved, before the report was released.
- Each measure reconciled to its source system
- Financial figures signed off by finance
- Data quality checks on every refresh: completeness and freshness
- Row-level security tested with real user accounts
- Report performance tested at full data volume
Deployment
- 01Pace and channelsPace and channel analysis added.
- 02Owner reportsStandard owner reports delivered monthly.
- 03Deployment pipelinesReports moved from development to test to production through controlled pipelines.
- 04Adoption and warrantyTraining for report users and builders, usage reviewed, and six months of free bug fixing.
Final deliverables
Pricing decisions with the full picture
Revenue managers see pace, rate and channel mix for every hotel every morning, and owners receive consistent reports on time.
The group compares properties on the same definitions.
- Daily KPIs per hotel
- Pace versus last year
- Channel mix and cost
- Consistent owner reports
Handed over to the client
- 01Data model and pipelinesDocumented and scheduled
- 02Reports and dashboardsPublished with security roles
- 03Measure definitionsEvery figure documented
- 04TrainingFor report users and report builders
- 05Six-month warrantyFree bug fixing after delivery
Success metrics
How success is measured
| Measure | Outcome | How it is measured |
|---|---|---|
| Pace versus last year and budget | Daily | From daily PMS snapshots |
| RevPAR improvement targeted | 2–5% | Target range; achieved by revenue managers, not the dashboard |
| Channel costs | Visible | Where commission rates are recorded |
Verified reviews
What clients say about our custom software work
Verified reviews from our clients on the same kind of work, published on Clutch.
-
Custom Software Development
Web-Based Coupon App Development
The work produced by the team was of exceptional quality.
Jon Thies
CTO, Model Rocket Feb 2022 – Mar 2023
-
Custom Software Development
Mobile & Web Platform Development & Design
Silver Scintilla was responsive, respectful, and enjoyable to work with, quickly addressing any questions or requests.
DeShawn Brown
CEO & Founder, Lithios Jun 2021 – Nov 2022
-
Custom Software Development
Web-Based HRM System Development
Silver Scintilla provided the best solution with scalable functionality, personalized features, and robust security.
Suheb Khan
Director, Collaborative Insight Technologies Jul 2020 – Jun 2022
Free discovery call
Have an idea? Let's turn it into AI-powered software.
Book a free discovery call with our experts. Share your idea and we will help you shape the scope, timeline and budget, under NDA.
- Free consultation
- NDA before we talk
- Transparent estimate