Business Intelligence Solution: Analysis of Rental Market Data

This report provides a comprehensive business intelligence solution for analyzing the Australian rental market. The study begins with an introduction and problem statement, focusing on the changing dynamics of homeownership and rental affordability in Australia. It identifies key issues such as rising housing costs and their impact on rental prices and family finances. The report then outlines a business intelligence solution, detailing key performance indicators (KPIs) like rental types, area-based rent variations, and periodic rent changes based on factors such as amenities. A dashboard is designed for data visualization, examining rental situations in 2011, including dwelling structures and occupancy rates. The analysis considers factors like tenure type and landlord type to avoid data duplication. The findings reveal that owned dwellings are highly occupied compared to rental dwellings. The conclusion summarizes the analysis, emphasizing the importance of understanding the rental market dynamics through the use of business intelligence, and includes references to support the findings.

Business Intelligence
Systems
1

Table of Contents
1. Introduction.......................................................................................................................................2
2. Problem Study...................................................................................................................................2
3. Business Intelligence Solution...........................................................................................................3
4. Conclusion..........................................................................................................................................7
References..................................................................................................................................................7
2

1. Introduction
The main objective is to understand the problems of given case study and to provide a
business intelligence solution. To accomplish this objective, the given case will be studied and
analyzed what the problem is going on. Then the business requirements will be analyzed by
understanding the key performance indicators of the solution. The analysis will be carried out by
designing dashboard and the investigating the obtained result.
2. Problem Study
Residency designs have changed altogether, with less more youthful and moderately aged
individuals owning their own particular home and, over all age gatherings, less owning out and
out. The rate of home possession in Australia is being managed at around 70 for each penny of
families in private abodes by the high rate of responsibility for show age of more seasoned
individuals. As time advances, it now appears to be sure that the total rate of home proprietorship
will drop and the extent leasing will increment altogether ("Melbourne Property Market, House
Prices & Suburb Profile", 2018).
Issues of moderateness have contributed essentially to this. House value development
impacts affect the private rental part as far as request and supply and hence as far as genuine
rents. Reasonableness worries for potential homebuyers keep family units in the private rental
segment longer than would somehow be the situation, compelling up rents through expanded
request and restricted elective choices ("Real Estate & Property For Rent in Townsville - Greater
Region, QLD (Page 1) - realestate.com.au", 2018). Furthermore, moderateness issues in the
home buy section of the market can push a few family units into private rental through home
loan default—in spite of the fact that rates of this are low in Australia by universal gauges — or
as family units choose to discharge themselves from contract obligation before achieving
emergency point ("'Tenants could be lulled into thrill of the chase': More rent bid apps to launch
in Australia", 2018).
Supported house value development in respect to livelihoods has dissolved lodging
moderateness for some families, with most intense effect being felt by those on lower or settled
wages and with poor connection to the work advertise (Guide, 2018).
3

Figure 1 Rental Situation in Australia
3. Business Intelligence Solution
Overview of Solution
Assuming an ever increasing number of new families are being constrained into lodging
pressure since they have no different choices accessible to them, and this is especially applicable
in the private rental area, they are being pushed into a place of monetary pressure ("Record
number of Perth rental vacancies", 2018). Unless a family unit is in a position where their wage
is probably going to become quicker than their lodging costs after some time, it would be
extremely troublesome for such a family unit to ever avoid lodging stretch. Families might be
compelled to go up against improper lodging as far as quality or area to keep their cost loads low
and such a choice may have prosperity suggestions ("Housing and property | australia.gov.au",
2018).
Business Requirements
The key performance indicators are listed below.
4

 Type of Rental: What are the types of rental houses? How it differs by rent?
 Area: How the rent will be changed over the location of House?
 Change over: How the total rent will be changed over periodically in accordance the
facilities provided by the landlord and so on.
 Time: Time is an important key dimension to know periodically change on rent based on
its situation.
Dashboard:
The data visualization tool ‘Dashboard’ is used to view the data analysis result of given
case study.
Total
Owned outright
Owned with a mortgage(b)
Rented Total
Real estate agent
State or territory housing authority
Person not in same household(c)
Housing co-operative/community/church group
Other landlord type(d)
Landlord type not stated
Other tenure type(e)
Tenure type not stated
0
1000000
2000000
3000000
4000000
5000000
6000000
7000000
8000000
9000000
Dashboard
Rental situati on inAustralia
Total occupied private dwellings
Separate house
Semi-detached, row or terrace house, townhouse etc. total
Flat, unit or apartment total
Other dwelling total
Dwelling structure not stated
5

The Dashboard is outlined below.
In the year of 2011, the rental situation in Australia is analyzed. Annual retail dwelling
structure is analyzed. Total number of occupied private dwellings, how many separate house,
how many number of semi-detached, row or terrace house, flat and other types of dwelling are
analyzed. Even the not mentioned Swelling structure is also stated.
Refreshed information inaccessible amid report drafting. Diagram as announced in
'Rental Assistance in Australia 2011'.
 Renting costs are contract reimbursements, lease and rate installments (general and
water).
 Percentile measures are inside the equivalised pay appropriation.
 Low wage family units incorporate the most reduced and second equivalised
dispensable family unit pay quintiles, barring the first and second percentiles (i.e. the
third to 40th percentiles comprehensive). The first and second percentiles are avoided
because of the high riches and consumption attributes those families show, and the
predominance of wage writes other than worker pay and government annuities and
remittances.
6

In another dimension, based on the type of tenture and type of landlord, the data will be
analyzed. Because, same person has many houses and properties with different dwelling
structure. So aggregating them without duplicate is important thing in data analytics. From the
analysis, the owned dwelling is highly occupied rather than rental dwellings. Totally, 2488149
members has their own houses. These are not occupied under Government. Because the
landlords privately owned.
0
2000000
4000000
6000000
8000000
Comparing swelling structures
Total occupied private dwellings Separate house
Renting is now and then seen as the residency of final resort for bring down wage family
units and other people who can't get to home-possession. While the social lodging part gives
reasonable rental to long haul inhabitants, it can't fulfill request, with the outcome that the private
rental market is the essential wellspring of rental lodging for most who might meet all
requirements for social lodging. Rents are higher and the span of inhabitance is overseen by the
relatively all-inclusive gadget of here and now rents. It is unavoidable that the rental market
should change so as to suit expanded interest for longer term rental convenience, and that the
arrangement settings that represent lease help for bring down pay family units and the
arrangement of social lodging should be rethought in this light.
Governments crosswise over Australia additionally subsidize a scope of administrations
to help individuals who are destitute or in danger of vagrancy, known as Specialist Homelessness
Services (SHS). These administrations are conveyed by government financed associations that
work in conveying settlement related and individual help administrations to individuals who are
destitute or in danger of vagrancy. Between 2011– 12 and 2015– 16, more than 800,000
7

customers were upheld by SHS organizations. Bolster included social lodging inhabitants
looking for help from SHS suppliers to keep up their social lodging tenure. In 2015– 16, 1 of
every 8 (12%) SHS customers were openly or group lodging on introduction. The kind of help
offered to those in social lodging is for the most part through case administration and bolster
administrations contrasted with money related help for those in private rental.
4. Conclusion
To accomplish this objective, the given case is studied and analyzed what the problem is
going on. Then the business requirements is analyzed by understanding the key performance
indicators of the solution. The analysis is carried out by designing dashboard and the
investigating the obtained result.
References
Guide, G. (2018). Australia house price rises accelerating. Retrieved from
https://www.globalpropertyguide.com/Pacific/Australia/Price-History
Housing and property | australia.gov.au. (2018). Retrieved from
https://www.australia.gov.au/information-and-services/family-and-community/housing-and-
property
Melbourne Property Market, House Prices & Suburb Profile. (2018). Retrieved from
https://www.realestate.com.au/neighbourhoods/melbourne-3000-vic
Real Estate & Property For Rent in Townsville - Greater Region, QLD (Page 1) -
realestate.com.au. (2018)
Record number of Perth rental vacancies. (2018). Retrieved from
http://www.abc.net.au/news/2016-08-23/record-number-of-perth-rental-vacancies/7778524
'Tenants could be lulled into thrill of the chase': More rent bid apps to launch in Australia.
(2018). Retrieved from https://www.domain.com.au/news/more-rent-bidding-apps-to-
launch-in-australia-as-rental-revolution-looms-20170427-gvslpc/
8