How to Analyze Airbnb Performance Data in the Right Way

Understand Airbnb Performance Using Tableau Data Analysis

Founded in August of 2008 and based in San Francisco, California, Airbnb is a trusted community marketplace for people to list, discover, and book unique accommodations around the world — online or from a mobile phone or tablet. Whether a spare bedroom, an apartment, a villa or a private island, Airbnb connects travelers to a more diverse and authentic range of experiences in over 34,000 cities and 190 countries.

The dataset includes three main tables:

Based on the neighbourhood locations, the chart shows that 44.3% of Airbnb housings are located in Manhattan, and 41.12% of Airbnb housings are located in Brooklyn. Almost 90% of Airbnb housings are located near by the most famous city hotspots, such as Times Square, Empire State, Wall Street, Central Park, and DUMBO, and tend to have convenient transportation(subway station).

Airbnb users rate their stay on the basis of location, price, cleanliness, living experience and a host of other parameters. Here I used the data to get the chart about variation of average price and numbers of reviews by locations. It is really interesting because average price and numbers of reviews didn’t have a large positive correlation. Highly expensive neighbourhoods will not tend to have more numbers of reviews because travelers will decide more cheaper Airbnb to live in and take the transportation to famous city hotspots.

According to the map showing the variation of average price by location, the average price is largely in line with the locations. It is obvious that the highly rated locations would also tend to be costly this is because in the case of constant supply, the higher the demand, and the higher the price is. Also, Manhattan receives highest average price $196.9 because of its highly demand. And then, it is interesting to observe that the highly average price areas correspond with the transportation. The same is true for Brooklyn and Staten Island.

Based on the map showing the variation of numbers of review by location, Manhattan receives the highest numbers of reviews because it closes to the most famous city hotspots (Times Square, Empire State, Wall Street, and Central Park) and has the more convenient transportation. In Brooklyn, the locations close to the Highland Park have the highest numbers of review. Brooklyn neighbourhoods close to Manhattan tend to have higher location ratings.

Taking a look for the last review by year, it shows that the number of reviews per year has been constantly increasing because the total visitors have been increased from 2011(50.9 millions) to 2018 (65.2 millions). Also, more users want to write down the reviews based on their experience so that they can give potential users a chance to choose the best place to live in. As a result, New York City have already become one of the most famous city to visit!

Now let’s explore the types of rooms that are there in New York City. Below is a chart that shows distribution of types of rooms by different locations (Bronx, Brooklyn, Manhattan, Queens, and Staten Island).

According to the chart, it shows that Brooklyn and Manhattan provide the most houses and rooms, representing a high demand there. Also, because of the high housing prices, New York City in Airbnb gives users more choices for private rooms to reduce the burden on life.

Based on the charts we have above. Let’s explore the busyness of the host that are there in NYC. In line with different charts about numbers of Airbnb by locations in NYC, variation of average price by location, and variation of numbers of review by location, we understand Brooklyn and Manhattan provide the most houses and rooms. Therefore, we can imagine that top 10 busy host are from the area of Brooklyn and Manhattan.

In 2020, I think Airbnb will definitely increase in New York City. Let’s take a look between demand and pricing.

As mentioned earlier, I take number of total visitors from 2011 to 2018 and last review by year for realizing the demand for Airbnb rentals in 2020. Moreover, I assume that the number of reviews correspond to the demand for the Airbnb rentals that 60% of guests should review their stay based on their experience. For number of total visitors from 2011 to 2018, we can know that the total visitors have been increased from 2011(50.9 millions) to 2018 (65.2 millions). Also, chart of last review by year shows that the number of reviews per year has been constantly increasing. Therefore, the more visitors come, the higher the demand for housings, and the higher the price for Airbnb.

To sum up, Airbnb has seen a significant increase in New York City. The above analysis represents that Airbnb still has a strong market in New York City.

Thank you so much for reading my article! Hi, I’m Shirley, currently studying for a Master Degree in MS-Business Analytics at ASU. Special thanks to my teammates Divya, Raghu, and Andrew for their contribution. If you have questions, please don’t hesitate to contact me!

Related posts:

Object Oriented Programming is a programming style, which is associated with the concept like Class, Object, Inheritance, Encapsulation, Abstraction, Polymorphism. CLASS: A class is a collection of…

How often do you re-align your goals and visions with that of your product and how do you do it? All you need is a Roadmap which you can refer to from time to time and make the necessary changes…

We all have an innate sense of fairness — of what’s right and wrong. When that line gets crossed, I feel incensed. I get angry, at least inside. I remember it like it was yesterday. My best friend /…