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:
