Power BI
Hotel finance planning and analysis on Microsoft Fabric
Consolidated budget and actuals for multiple hotels and years into a Microsoft Fabric and Power BI model for P&L, balance sheet and budget-versus-actual analysis.
- Client
- Hospitality group
- Industry
- Hospitality
- Status
- Delivered
The problem
Budgets and actuals sat in inconsistent Excel files per hotel and year.
What we built
- OneLake data layer with GL-code mapping
- Consolidated semantic model
- P&L, balance sheet, revenue, payroll and expense dashboards
Challenges we solved
- Missing GL codes
- Inconsistent category names across properties
Results
- Actual vs budget and vs prior-year analysis across all properties
Technology stack
- Microsoft Fabric
- OneLake
- Power BI
- Excel
Need something similar?
Free 30-minute scoping call. We reply within 24 hours.
Talk to us about Power BI