Hotel Revenue Management PowerBI Dashboard

Hi,

I am looking for an expert in Excel and data visualization, with a background in hotel revenue management, to help create a revenue management dashboard in Power BI for a cluster of two hotels. The raw data will be sourced from Excel and CSV files.

1. Hotel Benchmarking Dashboard
Data Source: STR reports
Metrics: Occupancy, ADR (Average Daily Rate), RevPAR (Revenue Per Available Room)
Visuals: Line charts, bar graphs, and comparison tables
2. Business Mix Dashboard
Data Source: Monthly and year-to-date data from Excel/CSV
Metrics: Business mix by segment (e.g., corporate, leisure)
Visuals: Pie charts, stacked bar charts
3. Events Calendar
Integration: Link with the business mix dashboard
Visuals: Calendar view, event markers
4. Groups on Books
Data Source: Booking data for the next 180 days
Metrics: Group bookings, room nights
Visuals: Gantt charts, line graphs
5. Production Dashboard
Data Source: Online and offline channel performance data
Metrics: Monthly performance, channel comparison
Visuals: Bar charts, line graphs
6. Sponsor Ads and Marketing Campaigns
Data Source: Marketing performance metrics
Metrics: Click-through rates, conversion rates
Visuals: Funnel charts, bar graphs
7. Food & Beverage Revenue Dashboard
Data Source: Ancillary revenue data
Metrics: Revenue from food & beverage
Visuals: Pie charts, bar graphs
8. Guest Review Score Dashboard
Data Source: Guest review scores from various platforms
Metrics: Average scores, sentiment analysis
Visuals: Star ratings, word clouds