This is an analysis of Air BnB’s in Seattle. Here is the Dataset used. Seattle Air BnB’s Analysis.
This data analysis is geared towards helping an investor understand the Air BnB market in Seattle with a view to make an investment.
The Seattle Air BnB’s Data Analysis Dashboard can be viewed here. Tableau Dashboard
Seattle Air BnB’s Data Analysis – Project KPI’s
The investor wanted to know. These questions formed the data analysis KPI’s.
- What are the most profitable neighborhoods?
- What are the peak months of the year?
- How many bedrooms attract the most bookings?
- What is the competition like?
- What factors affect revenue?
Seattle Air BnB’s Data Analysis – Charts
- The first chart in the dashboard gives the number of Air BnB’s listed according to the number of bedrooms. This essentially shows the competition our client is up against.
- The second chart show the revenue for the year 2016. This chart shows not only shows the revenue, it also outlines peak seasons.
- The third chart shows the price by the number of bedrooms. Clearly, the more bedrooms available the more the asking price and the less the competition.
- The fourth chart shows the verifications status of the host. The simple act of getting host verification has a huge impact on the revenue.
- The fifth chart shows the revenue by the number of bedrooms. While 1 bedroom homes have the highest competition, they are also the most in demand and the most profitable.
- The sixth charts shows the revenue by the neighborhoods and can easily help our client identify the most profitable neighborhoods.
- The last chart is closely related to the sixth chart, showing the revenue in terms of zip codes.
Seattle Air BnB’s Data Analysis – Conclusion
This simple analysis is a good guide for the client to use as they consider their investment. Further analysis can be done to zero in certain aspects to guide the investment decisions of the client.
Skills used:
Data Analytics, Tableau, Data Visualization, Data Storytelling, Business Intelligence
