Portfolio Project · Kaggle Dataset Analysis
Hotel Operations KPI Dashboard
Bookings · Revenue · Cancellations · Market Segments · 2015–2017
Source: Kaggle.com — jessemostipak/hotel-booking-demand
Samuel Then · Data Analyst · SQL · Power BI
View on GitHub → SQL Queries · Power BI Preview
Filter by Hotel:
All Hotels
City Hotel
Resort Hotel
Total Bookings
—
All reservations
Total Revenue
—
Confirmed stays only
Cancellation Rate
—
% of total bookings
Avg Daily Rate
—
Per occupied room
Avg Length of Stay
—
Nights per booking
Monthly Revenue Trend
All Hotels
City Hotel
Resort Hotel
Key Insight
—
Revenue by Market Segment
Key Insight
—
Cancellation Rate by Lead Time
Booking Window Analysis
Key Insight
—
Top 8 Countries by Bookings
All Hotels
Booking Status Breakdown
—
Total
ADR by Month — City vs Resort
City Hotel
Resort Hotel
Bookings by Customer Type
All Hotels
Key Insight
—