View Live Dashboard

Stage 1: Process & Methodology

• Sourced dataset from Kaggle

• Cleaned and transformed data using Power BI Power Query

• Modeled relationships and created DAX measures for pricing, availability, and retention

• Conducted exploratory analysis across neighborhoods and property types

• Built interactive dashboards to visualize trends and performance

• Applied ETL, KPI modeling, and retention segmentation to guide strategic insights

Stage 2: Business Questions

• How are properties and hosts distributed across London?

• Which property types and neighborhoods yield the highest prices?

• What is the impact of availability on pricing?

• How can inactive listings be leveraged for growth?

Stage 3: Objectives

Analyze property distribution, pricing trends, and host dynamics to identify revenue opportunities and improve listing performance.

Stage 4: Key Insights

• 68K listings managed by 45K hosts; entire home/apt dominates

• High-value areas like Kensington & Chelsea average £303 per night

• High availability correlates with higher pricing

• 39K inactive listings represent untapped supply

• Longer stays yield better revenue; retention rate exceeds 83%

Stage 5: Recommendations

• Target high-performing neighborhoods for host acquisition

• Reactivate dormant listings to expand supply

• Promote longer stays with incentives

• Support both single and multi-property hosts

• Launch loyalty programs to boost retention