Airbnb Rental Properties Report

Current condition

• Airbnb, Inc. is an American company that operates an online marketplace for lodging, primarily homestays for vacation rentals, and tourism activities. Based in San F-ransisco, California, the platform is accessible via website and mobile app. Currently the stakeholders want to know the report of company and have some business quest-tion they have to know.

Business Questions

• How many total of revenues by room types in Airbnb?
• How many total of properties that Airbnb have?
• How many rented of properties by room type?
• What is the average price of rented properties by room type?
• what is percentage properties by room categories?

Data preparation

• To solve this problem that can answered the business question the most important things is collect dataset that required. Dataset obtained from google sheet with seven column consist of listing_id, description, room_type, price, neighborhood, host_name, and last review. To check the dataset, you can click the data preparation link and go directly to the google dataset sheet. But the dataset from this google sheet needs to be cleaned because we don’t need all the data.

Data Visualization

• Dashboard Report This dashboard is an insight into the data owned by Airbnb company.

• Number of Rented Properties by Room Type in Borough based on the graph, the most rented entire home/apt and shared room types are in manhattan and the most rented private room types are in brooklyn

• Number of Average Price Rented by Room Type based on the graph, the average price per room type in manhattan is the highest compared to other borough followed by Brookyln, Queens, Bronx, and Staten Island.

• Total Room Type and Percentage of Properties by Category The most type of room owned by the company is the entire home/apt room type with 13,173 properties.

• Total of Revenues by Room Type in Borough the highest income from each property is the entire home/apt type in manhattan with a total income of 1,459,564 dollars from grand total of 3,547,146 dollars

Conclusion

• The most rented entire home/apt and shared room types are in manhattan and the most rented private room types are in brooklyn.
• The average price per room type in manhattan is the highest compared to other borough.
• Entire home/apt room type is the most type of room owned by the company.
• The highest income from each property is the entire/apt type in manhattan.