Bali Hotel Revenue
Analysis

The Situation

Role: Data Analyst
Scope: 3 Hotels (Resort, City Hotel, Boutique)

I needed to check how three different hotels were doing. The goal was to see which one was doing well and which one needed help. By analyzing the booking data, we could identify opportunities to optimize revenue.

Getting the Data

I wrote a script to get booking data from the Amadeus API. This allowed me to look at over 26,000 bookings. I cleaned the data using Python to make sure all the prices and room names matched, and I also anonymized the hotel names to protect privacy.

# Reading the data
def analyze_cluster_performance():
    # Loading the file
    df = pd.read_csv("Data/hotel_data_cleaned.csv")
    
    # Selecting only Bali hotels
    bali_cluster = df[df['flg_region'] == 'Bali']
    
    # Calculating average price
    cluster_adr = bali_cluster.groupby(['month', 'property_id'])['price_cleaned'].mean()
    
    return cluster_adr

1. Comparing Prices

By looking at the average prices, we saw that Property_002 (Teal line) was charging less than the others during the busy season. This was a missed opportunity for revenue maximization.

Fig 1: Price comparison of the 3 Bali hotels.

2. Interactive Dashboard

I made a dashboard so the managers could easily see this information without looking at the raw data.

Fig 2: Dashboard View

3. When do guests book?

Knowing when guests book helps us decide when to change prices. The lead time distribution shows us the sweet spot for marketing campaigns.

Fig 3: How many days before arrival guests book.

4. Room Types & Revenue

Seeing which room types bring in the most money helps us know what to sell. It turns out Suites are the real money makers.

Fig 4: Revenue by room type.

My Suggestions

• Stop Last-Minute Discounts: Data shows prices dropping 12% in the near-term (0-30 days). Since this is peak booking window, we should hold rates firm.
• Focus on Suites: Suites are the high-value drivers (generating 67% of revenue), while Deluxe rooms are volume drivers.
• Create Packages: Since we keep a 1-night minimum stay, we should offer special packages to encourage longer stays.