This Power BI project provides a comprehensive dashboard to analyze the financial performance, occupancy trends, room category insights, and cancellations for ITC Hotels. The dashboard aims to answer critical business questions and offers actionable insights for decision-makers to improve hotel performance and maximize revenue.
- What is the total revenue generated by ITC Hotels, and how does it vary across different hotels and room categories?
- What is the cumulative revenue growth over time?
- How has the revenue grown month-over-month (MoM) and week-over-week (WoW)?
- What are the Average Daily Rate (ADR) and Revenue per Available Room (RevPAR)?
- Total Revenue
- Cumulative Revenue
- MoM and WoW Growth
- Moving Average of Revenue
- Average Daily Rate (ADR)
- Revenue per Available Room (RevPAR)
- What is the occupancy rate for each hotel and room category?
- How does occupancy fluctuate seasonally (e.g., weekends, holidays)?
- What is the cumulative occupancy trend and occupancy growth (MoM/WoW)?
- How does occupancy correlate with revenue and RevPAR?
- Occupancy Rate
- Which room categories generate the most revenue?
- How do booking patterns (lead time, check-in dates) affect revenue and occupancy?
- What is the average length of stay (ALOS) for each hotel and room type?
- What are the room revenue trends (including MoM/WoW growth)?
- Average Length of Stay (ALOS)
- Booking Lead Time
- Room Revenue Trends
- What is the cancellation rate for each hotel and room category?
- How have cancellation trends changed over time (MoM/WoW)?
- What is the lost revenue due to cancellations?
- Are there patterns in cancellations (e.g., specific room types, time of year)?
- Cancellation Rate
- Cumulative Cancellations
- Lost Revenue due to Cancellations
- Cancellation Growth (WoW)
- Power BI for dashboard development
- DAX Query for data preprocessing and KPI calculations