AirBnb vs Real Estate in NYC

Business Processes:

  • Does the price per square feet affects the price per night in NYC? In the most expensive neighborhood in terms of price per square feet? In the least expensive neighborhood?
  • Does the number of reviews affect the price per night?
  • Which are the most popular neighborhoods to stay?
  • What type of property is predominant on AirBnb? By neighborhood?

Grain:

  • AirBnb and Real Estate datasets consist of daily data for the past 5 years. Both datasets have neighborhood level of detail.

KPI:

  • Average price per night
  • Average price per square feet
  • Average number of reviews
  • Average number of nights available during the year

 

Dimensional model:

 

Image