Airbnb Melbourne Analytics
Executive Summary
This analysis explores the Airbnb market in Melbourne, providing insights into pricing trends, property availability, and host performance. It serves as a guide for potential hosts to understand market dynamics and optimize their listings.
The Challenge
Hosts in Melbourne face high competition and fluctuating demand. Identifying the optimal price point and understanding which amenities drive bookings is essential for maximizing revenue.
The Solution
I developed a dashboard that analyzes listing data to reveal pricing hotspots, popular neighborhoods, and the correlation between review scores and price.
Key Insights & Features
- Bookings by Suburb: Bar chart ranking Melbourne suburbs by total bookings (Melbourne, Port Phillip, Yarra, Stonnington, etc.).
- Listing Types: Pie chart showing distribution of room types (Entire home/apt, Private room, Hotel room, Shared room).
- Price Analysis: Table showing the average nightly price by suburb and room type.
- Core Metrics: Displays average number of reviews, total reviews (441), number of suburbs (30), and filters for suburb/room type.
Tools & Technologies
Power BI: For creating the interactive dashboard and map visualizations.
Data Analysis: Analyzed CSV data to extract meaningful patterns.
Conclusion
The Airbnb Melbourne Analytics dashboard demonstrates the ability to turn complex real estate data into clear, visual insights. It highlights the importance of location and property type in determining rental value.