Analyzing Airbnb Listings in Chicago: A Power BI Dashboard Project

“In God we trust, all others bring data.”

-W. Edward Deming

Introduction

As the sharing economy continues to grow, Airbnb has become a major player in the short-term rental market, with thousands of listings worldwide. Analyzing this data can provide insights into trends, customer preferences, pricing strategies, and more. In this article, I’ll walk you through my journey of exploring and visualizing the Airbnb Chicago dataset using Power BI.

The project was undertaken to deepen my understanding of data visualization while also analyzing real-world data for business insights. The dataset I used contains key details about Airbnb listings in Chicago—including pricing, location, availability, and host information.

Dataset Overview

The Airbnb Chicago dataset includes essential features like:

1.Host Information: Name, ID, and whether they are a superhost.
2.Property Details: Type of property (apartment, house, etc.), room type (entire home, private room, etc.), number of guests accommodated.
3.Pricing: Nightly rate, cleaning fees, extra guest charges.
4.Location: Neighborhoods and ZIP codes.
5.Availability and Reviews: Number of available days in a year, customer reviews, and review scores.

Objectives of the Analysis

The main objectives of my analysis were:

1.Price Distribution: Understanding the price distribution across different neighborhoods and property types in Chicago.
2.Host Insights: Identifying how superhosts impact the pricing and reviews.
3.Location Insights: Exploring the most popular neighborhoods in terms of availability and reviews.
4.Seasonality: Analyzing how availability varies over time and how it affects pricing.

Steps Involved

1.Data Cleaning & Preparation
The first step was cleaning the dataset. Some rows had missing or incorrect values, which needed to be addressed. I removed irrelevant columns and filled missing values where applicable. I have used pandas and Numpy libraries for the data cleaning part.

2.Data Modeling in Power BI
In Power BI, I imported the cleaned dataset and built the necessary relationships between different variables like property type, price, and availability. Using DAX (Data Analysis Expressions), I calculated the average prices, availability percentages, and review counts.

3.Building Visualizations
Power BI offers a range of visualizations, and I used several to present my findings clearly:

Chart:Sum of reviews_per_month by room_type
Insight: The chart provides a clear visual representation of the relative popularity or review frequency of different accommodation types, with entire homes/apartments dominating the reviews.

Chart:Count of apartment by room_type in percentage
Insight: The chart provides a clear visual representation of the proportion of each room type. Entire homes or apartments dominate the market, followed by private rooms, while shared rooms are a very small minority. This distribution likely reflects the preferences of travelers or the availability of different accommodation types on a platform like Airbnb.

Chart:No of days Availability of apartment by room_types
Insight:The chart illustrates that hotel rooms tend to be available for the most days on average, while shared rooms are available for the fewest days. There's a relatively small difference in availability between entire homes/apartments and private rooms, with entire homes/apartments being slightly more available on average

Chart:Top 10 host by Reviews
Insight:This chart provides insight into the most active or popular hosts on the platform based on the number of reviews they've received.

Chart:Sum of latitude by longitude and neighbourhood
Insight:This map likely represents the distribution of some kind of data points, possibly related to neighborhoods or specific locations, across North America. The concentrations suggest a focus on major urban areas or popular tourist destinations.

Chart:Average of price by neighbourhood
Insight:This chart provides a clear comparison of rental prices across different areas, which could be useful for travelers or for understanding the local real estate market.

Conclusion

Based on the charts and data presented, here's a concise conclusion for this project:
This analysis appears to focus on short-term rental market dynamics, likely in Chicago. Key findings include:

Entire homes/apartments dominate both listings (68.74%) and reviews, indicating high popularity.
Hotel rooms have the highest availability (211 days/year), while shared rooms are least available (160 days/year).
Top hosts receive thousands of reviews, with "Zencity" leading at 3,748 reviews.
Pricing varies significantly by neighborhood, with West Englewood unexpectedly showing the highest average price ($537.67).
Geographically, listings are concentrated in major urban areas, particularly on the East and West coasts of North America.

This data provides insights into rental preferences, pricing strategies, and market distribution, which could be valuable for hosts, travelers, and platform operators in optimizing their approaches to the short-term rental market.

Next Steps

In the future, I plan to extend this analysis by incorporating machine learning models to predict pricing and availability trends based on factors such as location, host characteristics, and time of year. This would further enhance the practical value of the insights derived from the dataset.

Visuals and Code

The complete Power BI dashboard and associated visuals can be accessed on my GitHub repository,https://github.com/1111raj/Data_visualisation_powerBI_project Feel free to explore the code, data, and insights.

Connect with Me

If you'd like to discuss this project or explore collaboration opportunities, feel free to reach out!

LinkedIn: https://www.linkedin.com/in/raj-tiwari-113b16b1/
Email: [e-mail]
Mobile: [phone]