Prague Subletting Market Dashboard

High Level Design

Overview

When offering an apartment for rent, a market understanding is highly valuable in order to maximize your profit. Insights about your approximated income, popular locations, appearance and weekdays can drive your decision.

Goals

Maximize profit by understanding the market’s trends and offering an apartment in the most popular location, days and best price.

Objectives

  • Maximize income by understanding the market’s rental preferences.
  • Maximize booking by understanding the current market trends, price and what is considered as an appealing apartment

KPIs Architecture

Objectives

KPIs

Measures

Data Source

Maximize income by understanding the market’s rental preferences

Median Price

Median (Price)

Listings Detailed.csv

Growth (median price)

Median Income

Median (# Bookings * Price for each listing)

Growth (# Bookings * Price for each listing)

Neighborhoods by Number of Bookings and Income

Top 5 Neighborhoods by Median Price. Break by number of bookings for each Room Type (Entire Room, Private Room, Shared Room)

# of Bookings by Income and Weekdays

Max (number of bookings) for each weekday

Median (# Bookings * Price for each listing)

Maximize booking by understanding the current market trends, price and what is considered as an appealing apartment

# Monthly Availability (Nights)

 

AVG (availability of 30 days)

Growth (availability of 30 days)

# of Listings

Current available listings

Count (listings)

Growth (# number of listings)

# Listings Over Years

# of listings by Years

# Bookings

# of Bookings by Months

10 Most Booked Properties

# of Bookings

Please note that this KPI is linked to Airbnb apartments as an example only. The dashboard’s KPIs are not related to Airbnb.

Plugins & Scripts used

 

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation