01 / The brief

The question

Build a clear Power BI dashboard that helps users explore hotel booking performance and understand the main reasons behind cancellations, occupancy changes, and booking trends.

This project analyzes hotel booking data using Power BI. It helps users understand booking behavior, cancellation patterns, occupancy rate, average daily rate, repeat guest rate, lead time, and market segment performance. The dashboard includes two report pages. The first page focuses on monthly booking trends, cancellation behavior, lead time, booking changes, and key hotel KPIs. The second page focuses on market segment distribution, cancellation rate by hotel type, repeat guest rate, and relationships between lead time, average daily rate, booking cancellation, and occupancy rate.

Results & observations

  • The final dashboard gives a clear view of booking trends, cancellation patterns, market segment performance, occupancy rate, lead time, and average daily rate.
  • Users can quickly identify high-cancellation periods, compare market segments, understand guest behavior, and monitor key hotel booking KPIs.

Challenges

  • Combining booking, cancellation, hotel type, and market segment data into one dashboard
  • Making cancellation behavior easy to understand
  • Showing monthly and daily booking trends clearly
  • Comparing market segments with different booking patterns
  • Designing simple visuals for hotel performance metrics

Approach

  1. I cleaned and prepared the hotel bookings data.
  2. I created Power BI measures for occupancy rate, cancellation rate, lead time, average daily rate, repeat guest rate, and booking totals.
  3. I designed dashboard pages for booking performance and market segment analysis.
  4. I added visual comparisons by month, day, hotel type, and market segment.
Implementation details

Data Preparation

Cleaned and prepared the hotel bookings dataset for analysis.

Data Modeling

Created the Power BI data model for bookings, hotel type, market segments, dates, and guest behavior.

DAX Development

Built measures for occupancy rate, cancellation rate, average daily rate, lead time, repeat guest rate, booking totals, and booking changes.

Dashboard Design

Designed booking performance and market segment analysis pages.

Trend Analysis

Created monthly and daily visuals to show booking, cancellation, and rate patterns.

Final Formatting

Formatted the dashboard with clear KPI cards, line charts, bar charts, pie charts, donut charts, and scatter plots.

Explore the report

Select a screenshot for a larger view.