Rakesh_Portfolio - Airbnb Performance Dashboard

Airbnb Performance Dashboard

Project Overview

This project is an end-to-end data analysis of Airbnb’s global footprint from its inception (2008) through the 2020 pandemic. By analyzing 279,712 listings and 5.3 million reviews across 10 iconic global cities, I developed an interactive dashboard to evaluate market maturity, competitive pricing against the hotel industry, and guest satisfaction trends. The goal was to transform raw listing data into a roadmap for market expansion and quality control.

Problem Statement

As Airbnb transitioned from a disruptive startup to a profitable global entity in 2016, it faced three primary challenges:

Regulatory Hurdles: How did tightening local regulations in 2016-2017 impact listing growth?
Competitive Value: In high-density markets like Paris, does Airbnb maintain a significant price advantage over traditional hotels to justify its market share?
Global Quality Gaps: Which regions are underperforming in critical metrics like "Cleanliness" and "Value," and how does this threaten brand reputation?

Data Description

The analysis is based on a multi-dimensional dataset containing:

Listing Dimensions: Property type (Entire place, Hotel room, Private/Shared room), City, and Host status (Superhost vs. Regular).
Temporal Data: Growth stages from 2008 to 2020 (Introduction, Growth, Maturity, Decline, Reinvention, Covid-19).
Review & Rating Metrics: 5.3M+ reviews categorized by Accuracy, Cleanliness, Communication, Location, and Value.
Trust Signals: Host verification status (Identity Verified, Profile Picture present).
Competitor Data: Average hotel room pricing per city for benchmarking.

Overview Page

Section 1: The Historical Context of Growth

We begin by mapping the platform's journey. Understanding historical context is essential for predicting future regulatory challenges and market saturation. This analysis defines the corporate lifecycle: Introduction, Growth, Maturity, Decline, and Reinvention.

Insight 1: Reaching the Peak and Regulation

Airbnb’s core value—the "Take-off point"—was established by 2011. However, the data reveals a fascinating story of maturity. 2015 was the peak year for listing volume. The subsequent "growth restriction" of 2016 and 2017 was not a decline in demand, but rather a direct result of Airbnb becoming profitable, which triggered tightening local city regulations. This visualization establishes that regulation, not a lack of interest, is the single greatest brake on Airbnb’s expansion.

Rating Page 1

Section 2: Strategic Market Prioritization (The Paris vs. Hotels Case Study)

To develop a future-facing strategy, we must understand where the revenue is generated and why guests choose Airbnb over established competitors. This dashboard shifts focus to the current dominant markets.

Insight 2: Competitive Pricing Drivers

Our analysis of the "Big Three" (Paris, NYC, Sydney) reveals a strong correlation between high listing volume and hotel prices. Paris is the city with the most listings. Why? Because the price of a hotel room ($800) is almost twice that of an Entire Airbnb ($673). This analysis confirms that "Price Advantage" remains the critical driver of adoption, especially in high-density European markets.

Figure 2: Strategic City Dashboard. Highlights include the price comparison vs. hotels in Paris and the cumulative market share chart, where the top 3 cities manage nearly 50% of the market.

Rating Page 2

Actionable Recommendation: Target High-Value Cities
Airbnb should prioritize acquisition marketing in regions where hotel rates have a >20% premium.

Section 3: Quality Control & Operational Health

A platform’s future depends on consistent quality. Analyzing rating data reveals critical operational issues and opportunities for market expansion.

Insight 3: The Guest Satisfaction Gap

While Paris drives volume, it does not drive the best quality. The dashboard reveals a performance gap: Mexico City and Rio are the overall best-rated cities. This indicates a major opportunity for expansion into LATAM markets, where guest satisfaction is highest. Conversely, we identified a persistent global weakness in "Cleanliness" and "Value", which were consistently the lowest-scoring metrics across almost all markets

Figure 4: Detailed Ratings Analysis. Shows the rating heatmap where LATAM outperforms Europe/Asia, and cleanliness is flagged as a systemic area for improvement.

Reviews Page

Section 4: Trust Metrics & The COVID-19 Era

This dashboard analyzes platform security and resilience, which are critical for maintaining a "high-trust" environment during market volatility.

Insight 4: High-Trust Adoption & Customer Lifetime Value

Is Airbnb a secure platform? The data confirms that over two-thirds (66.9%) of all hosts are fully verified. Furthermore, nearly all hosts provide at least one trust signal. This suggests an extremely resilient ecosystem where security risks are low. This is reinforced by guest behavior: 98.8% of customers use the platform occasionally (3 times or less), meaning Airbnb relies on a constant influx of occasional users rather than high-frequency "power users." This model requires continued, high-trust user acquisition.

Solution

I designed a four-part interactive intelligence suite that transforms raw CSV data into a strategic decision-making tool. The solution features:

Market Lifecycle Tracker: A time-series analysis categorizing growth into six distinct business phases (Introduction to Covid-19).
Competitive Pricing Engine: A benchmarking tool comparing Airbnb listing types against traditional hotel rates to identify "Value Gaps."
Global Quality Heatmap: A granular matrix of five performance metrics (Accuracy, Cleanliness, etc.) across 10 global cities to identify operational weaknesses.
Trust & Security Matrix: A verification-tracking shield that audits host profiles for identity and profile-picture compliance.

Key Insights

The "Paris Paradox": Paris is the platform’s strongest market not just because of tourism, but because it offers the highest savings—hotels are nearly 2x more expensive than an entire Airbnb.
Regional Quality Leaders: While Europe and the US have the most listings, Mexico City and Rio de Janeiro consistently deliver the highest guest satisfaction (94.8% and 94.6% respectively).
Systemic Weakness: Regardless of the city, Cleanliness and Value for Money are the two metrics that consistently score the lowest, representing a global brand-consistency challenge.
The "Occasional User" Reality: 98.8% of guests write 3 reviews or fewer. This proves Airbnb is a "Discovery" platform rather than a "Loyalty" platform, requiring constant fresh user acquisition.
The 2015 Peak: Data shows that listing growth peaked in 2015. The subsequent slowdown in 2016-17 was a direct result of regulatory maturity and Airbnb’s shift toward profitability.

Business Impact

Regulatory Risk Mitigation: By identifying the "Peak Points" in mature markets (like NYC and Paris), leadership can pivot resources to emerging, high-satisfaction regions (LATAM) before local regulations saturate the market.
Revenue Optimization: Highlighted a $127 per-night price advantage in Paris, which can be used in targeted marketing campaigns to steal market share from the hotel industry.
Quality Standardization: Identified specific cities (Istanbul/Hong Kong) that require immediate "Host Quality" intervention to protect the global brand reputation.
Enhanced Platform Trust: Verified that 66.9% of the host ecosystem is fully identity-verified, providing a "Trust Score" that can be used to lower insurance premiums and increase guest booking confidence.

Tools & Technologies

Data Visualization: Power BI ,Excel
Data Cleaning: Power Query

Access the Full Project

The complete data model, raw datasets, and technical documentation (including the DAX measures and data cleaning steps) are available on my GitHub.

View the Global Airbnb Performance Repository on GitHub

Page updated

Google Sites

Report abuse