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: