Airbnb Listings & Review Intelligence Dashboard
📊 Project Summary
This project presents a 4-page interactive Power BI dashboard analyzing Airbnb listings and guest reviews across three major Belgian cities: Brussels, Ghent, and Antwerp. The analysis combines descriptive, diagnostic, and prescriptive techniques to explore pricing patterns, review sentiment, host performance, and property-type performance.
🧱 Data Preparation & Modeling
The dataset consisted of separate Excel files for each city, with worksheets like listings, reviews, and neighbourhoods. Using Power Query, I loaded each worksheet individually, selected relevant columns, and appended them into consolidated tables — forming a unified star schema around fact_Listing. I then built DAX measures to analyze 5-star ratios, listing volumes, host behavior, and property combinations.
🐍 Python-Driven Insights
Python was embedded within Power BI for advanced sentiment analysis, classifying guest reviews by tone. Additionally, a custom visual ranks the best-performing property + room type combos by their price-to-rating ratio — providing actionable insights for hosts and investors.
📂 Explore the Code
The dashboard is supported by detailed data transformation steps, sentiment scripts, and schema documentation — all available on GitHub. Whether you're interested in how the data was modeled, how review sentiment was analyzed, or how insights were derived, you can explore the full source here:
🔗 View on GitHub