Club Mahindra Revenue Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Revenue Analyst in travel, hospitality and food service tracks booking pace, room rates, occupancy, and channel performance to recommend pricing and inventory actions that maximise revenue. Day to day you work with reservation data, build reports in Excel or a BI tool, compare actuals against forecasts, and flag risks or opportunities to sales, marketing, and operations teams. At resorts and hotel chains such as Club Mahindra, you may also analyse membership usage, seasonal demand, and package profitability.

Role and Technical Knowledge

1. 1

   What is RevPAR and how is it different from ADR?

   Define RevPAR as revenue per available room, equal to ADR multiplied by occupancy. Explain that ADR ignores unsold rooms while RevPAR captures both rate and occupancy performance.

2. 2

   How would you calculate the revenue impact of a 5 percent increase in room rates if occupancy drops by 2 percentage points?

   Set up a simple example with rooms available, current ADR, and occupancy. Show the new ADR and new occupancy, then compare total room revenue before and after to state the net effect.

3. 3

   What is booking pace and why does it matter for a resort or hotel?

   Explain that booking pace compares current on-the-books reservations for a future date against the same time last year or against a forecast. It helps decide when to open or close discounts and when to hold inventory for higher-paying guests.

4. 4

   Which distribution channels would you compare for a leisure resort, and what metrics matter?

   Mention direct website, OTAs, travel agents, corporate tie-ups, and membership or loyalty channels. Compare net revenue after commission, cancellation rates, length of stay, and guest lifetime value, not just gross bookings.

Practical Scenarios and Case Questions

1. 5

   A resort sees high occupancy but falling RevPAR during a festive week. What could be happening and what would you check?

   Consider heavy discounting, OTA commission costs, room upgrades, or a shift to lower-rate segments. Suggest checking ADR by segment, discount codes, channel mix, and length-of-stay patterns before recommending action.

2. 6

   You need to forecast room revenue for the next quarter. What data would you pull and what assumptions would you make?

   List historical occupancy, ADR, booking pace, seasonality, local events, holidays, and macro travel trends. State assumptions clearly, build a base, optimistic, and pessimistic case, and mention validating with sales or operations.

3. 7

   Your manager asks you to explain a sudden drop in food and beverage revenue attached to room stays. How would you investigate?

   Break F and B revenue into covers, average check, and capture rate per occupied room. Check if occupancy changed, if package inclusions changed, if outlet hours or menus changed, and if guest mix shifted to lower-spending segments.

4. 8

   A sales team wants to offer a large corporate discount during peak season. How would you evaluate it?

   Compare the discounted rate against expected transient or member demand for those dates. Calculate net revenue after commission and F and B attach, and consider displacement of higher-paying guests before recommending accept, reject, or counter.

Tools, Data and Analysis

1. 9

   Walk me through how you would use Excel to build a simple revenue dashboard for a hotel.

   Describe importing or pasting daily data, using pivot tables for ADR, occupancy, and RevPAR by month or segment, adding charts, and using slicers or filters. Mention keeping the file refreshable and checking for missing dates or duplicate rows.

2. 10

   What is the difference between a left join and an inner join in SQL, and when would you use each?

   Explain that an inner join returns only matching rows while a left join keeps all rows from the left table. Give a hospitality example such as joining bookings to guest profiles, where a left join keeps bookings even if the guest record is missing.

3. 11

   How would you check if a revenue report has data quality issues?

   Look for missing dates, negative rates, duplicate reservation IDs, occupancy above 100 percent, and mismatched totals between source systems. Suggest reconciling against the property management system or finance reports.

4. 12

   What is a KPI you would track for a membership-based resort business, and why?

   Mention metrics such as member activation rate, average nights redeemed per member, upgrade revenue, or renewal rate. Explain that membership businesses earn upfront fees but also carry future service obligations, so usage and satisfaction affect long-term revenue.

Behavioural and HR Questions

1. 13

   Why do you want to work as a Revenue Analyst in the travel and hospitality sector?

   Connect your interest in data and pricing to the dynamic nature of travel demand. Mention seasonality, perishable inventory, and the visible impact of good decisions on a property's performance.

2. 14

   Tell me about a time you worked with a large dataset or a complex spreadsheet under a deadline.

   Use a specific project or internship example. Describe the data size, the tools used, how you checked accuracy, and what the final output helped someone decide or do.

3. 15

   Describe a situation where you had to explain a number or analysis to someone who was not comfortable with data.

   Show that you simplified without losing accuracy. Mention using charts, plain language, and focusing on the so-what for the business rather than the formulas.

4. 16

   How would you handle a week when bookings are far below forecast and multiple teams are asking you for answers?

   Prioritise the most time-sensitive decisions, such as same-week promotions or inventory releases. Communicate what you know, what you are still checking, and when you will update stakeholders, rather than waiting for perfect information.