AirBnB Case Study Using Tableau

Finding Price per Zipcode

The first visualization I wanted to create was a comparison of the Price per Zipcode for the AirBnBs. 

Here we get a nice visualization with each column color coded by zipcode. Based off this graph, my suggestion to the stakeholder would be to purchase property to turn into an AirBnB in the 98134 zipcode, since the Average Price per night for an AirBnB in this zipcode is considerably higher.

Map of Each Zipcode

This is my favorite visualization for this project. Since we are working with zipcodes for these AirBnBs, I wanted to create a map that will go hand in hand with the previous visualization that also shows the average price under the zipcode. 

Using this map, you can see the where the most expensive zipcode is, and also see some of the clusters and the pattern of where the top zipcodes are on the map. 

Finding the best weeks to list the AirBnB

This visualization shows what the average price of AirBnBs are throughout a year. 

This information is useful if the stakeholder is planning on living in this house some of the time, and posting it when it would be most profitable. 

This information might seem pretty obvious, but it is still good to know that the data backs up the fact that AirBnBs are more profittable during the holidays and summer time. 

How will the number of bedrooms affect the average price?

You can see the average price steadily increases as the number of bedrooms increase, which is another piece of information that may sound obvious, but once again is something that is beneficial to have confirmed by the actual data. 

You can also see that 5 and 6 bedroom AirBnBs seem pretty lucrative, as the average price starts to increase more for these places. 

My recommendation for the stakeholders would be to try and focus on getting place with more bedrooms if they are interested in making as much money as they can. 

Finding the count of listings for different number of bedrooms

This visualization goes with the previous one, since the next natural question would be to know how many of each listing there would be. 

You can see here that there are much fewer AirBnBs in Seattle, Washington with 5 or 6 bedrooms. This also contributes to my recommendation of buying a 5 or 6 bedroom listing, since you won't have as much competition with these AirBnBs. 

There is also an abundance of one bedroom AirBnBs in Seattle, Washington, so shying away from these would also be a good idea.