Project: Global Hotels and Resorts Revenue Strategy

Scenario

Global Hotels and Resorts (GHR) acquired two properties — one city hotel and one resort — and needed data-driven insights to understand booking patterns, customer segmentation, and strategies for maximizing revenue post-acquisition.

The goal: Deliver insights through Tableau visualizations and business analytics to help the executive team integrate these properties into their portfolio more effectively.

📊 Data

• hotel.csv – guest bookings at the city hotel
• resort.csv – guest bookings at the resort property

Each dataset includes features such as stay durations, lead time, customer demographics, and booking behaviors.

Capstone Presentation

Summary & Outcomes

For this challenge, we developed a Tableau dashboard and performed analysis to:

• Understand guest behavior trends (stay patterns, repeat visits, room upgrades)
• Segment customers by booking channel, deposit type, and lead time
• Identify high-revenue segments and pricing opportunities
• Recommend tailored strategies for each hotel type:
• City Hotel: Optimize short-stay business bookings
• Resort: Focus on long-stay leisure travelers and upselling

This project demonstrated our ability to transform operational data into executive-level recommendations using storytelling and visual insights.