🏨 Hotel Sales Performance Dashboard (Power BI)
📌 Overview
This project is a Power BI dashboard designed to analyze hotel sales performance, key accounts, and customer sustainability.
It provides actionable insights into:
Room & F&B revenue
Key account contribution (Pareto 80/20)
Market segment performance
Customer retention and sustainability
Core hotel KPIs (ADR, RevPAR, Room Nights)
Note: All company names and branding are fictional and used for portfolio purposes only.
🎯 Objectives
Identify top revenue-generating companies
Analyze key accounts using Pareto logic
Track room productivity and operational KPIs
Measure customer retention duration
Support sales and revenue management decisions
📊 Key KPIs
Room Sales
F&B Sales
Total Sales
Room Nights
ADR (Average Daily Rate)
RevPAR (Revenue per Available Room)
Top 80% Key Accounts
Avg. Company Retention (Months)
Avg. New Companies per Month
📈 Dashboard Pages
Total Companies Performance – overall revenue & room nights trends
Key Accounts (Pareto Analysis) – dynamic Top 80% revenue contributors
Market Segment Analysis – segment-based performance insights
Companies Sustainability – retention and engagement analysis
🧠 Data Model
Star schema design
Fact tables: Room Revenue, F&B Revenue
Dimension tables: Date, Company, Market Segment
Clean relationships using Company_ID
Optimized DAX measures for performance
🛠 Tools & Technologies
Power BI
DAX
Power Query
🔍 Key Features
Dynamic Pareto analysis with threshold slicer
Conditional formatting for key accounts
Accurate RevPAR calculation using room-night logic
Separation of Room vs F&B analysis
Portfolio-safe anonymized data
This dashboard is created for portfolio and demonstration purposes only. All data and company names are fictional.
👤 Author
[Amr youssef] Hospitality Analytics | Power BI