Recent Question/Assignment
Please help me to do my parts of my assignment below.
• If the REM bubble going to burst vs further growth is anticipated;
• Do Conclusion.
BI Report – Part B Word Count Max 1000 Words
Assignment tasks/description
BI Report - Part B (Group)
Property Wealth Advisory (PWA)
Property Wealth Advisory (PWA) is a boutique client-focused property investment advisory. PWA provides advice and market research on property investments specializing joint owned property investments for clients looking to diversify their portfolio. The company also cater for individuals who are seeking to be a home-owner in the right locations.
The service offered by PWA is considered a premium in Australia. The recommendations made by PWA is based on real estate data carefully curated through various means, including data from Consumer Affairs Victoria, Domain.com.au, PropertyData.com.au, and PropertyValue.com.au. The company often advertised its ability to select properties in areas that deliver strong yields with minimum risk (i.e., capital growth in a high-growth area), and/or have the potential for added value to increase future returns (i.e., sizeable land for future development).
PWA operates in three states: Queensland, Victoria, and New South Wales. The backbone of the operations is a small team of young and talented analysts located in PWA’s main office in Hawthorn, Victoria. The analysts’ role is to go through the real estate data and write a report on the trends, key indicators, market forecasting, and other valuable insights emerging from the data.
An Urgent Task
After your report (BI Report - Part A), your manager was sufficiently confident you would make a great BI professional one day. The manager was impressed enough that you have been inducted into the -A- Team of PWA. The A-Team at PWA is responsible for providing critical analysis to PWAs most valuable and high-profile clients.
PWA CEO just had a series of meetings with several groups of investors who have indicated a strong interest in real estate investing in Melbourne. These investors have been accumulating funds during the pandemic and now ready to put it to good use. However, they are concerned about the housing market volatility. The news in mainstream media seem to oscillate between the prediction of Melbourne heading into an unprecedented property glut and the worst property-bubble burst against the forecast of another stellar growth in 2022-2023.
2020-2021 have been a challenging year for everyone and for a lot of sectors. The real estate is no exception. It was evident that the Melbourne real estate has ‘cooled off’ in 2020. On the other hand, the recent 2021 property auction results indicates a strong performance and a strong (but somewhat unreasonable) growth on property prices in a number of suburbs. However, this could just be a temporary bounce from a depressed market.
These investors have asked for PWA’s insights on the property market. They specifically want to know:
• If the REM bubble going to burst vs further growth is anticipated;
• If it’s worth considering investing in properties in, closer, or further away from Melbourne CBD;
• An estimate of the impact to the value of their investments if the property market in certain suburb/postcodes if the overall property market fluctuates within a threshold of +/- 10%;
• Other interesting insights and foresights that can add value to their decision making and investment.
Note: Do Only The “Red Point”, Don’t Have To Do “Yellow Points” &
Do Conclusion.
A special request from the investors:
One page (A4 size) infographic showcasing the key findings from the report
These are sophisticated and very critical investor groups. They will not be satisfied being given statements and/or recommendations. They will scrutinize the information PWA give them. Hence, the CEO specifically requested the analyst team to also provide strong justification on every insights, information, trends, recommendations and conclusion.
Melbourne Real Estate Market Data
Your team will use the same Melbourne REM data you have used to produce the previous report (i.e., Part A - You will negotiate with the rest of the team as to which version should be used). Our Data Technician has scraped 3 years data on Melbourne Real Estate Market. The 2020-2022 data should be adequate to allow the analyst team to conduct a thorough analysis of the data and write a report. The data technician acknowledges there may be missing values and/or inconsistent values in the dataset, but given the urgency of the request, he left it to the analyst team to contact him (he can be reached through our discussion channel: BI Report (Part A - Individual & Part B - Group)) with specific queries on major anomalies the team encounter in the dataset or when adjudication is required due to the differences of opinions amongst the A-team.
As per usual, the original/initial Melbourne REM 2020-2022 dataset Download Melbourne REM 2020-2022 datasethas been uploaded in PWA central repository (a.k.a., INF30004 Canvas site) ready to be accessed by the analyst team.
In order to help your team making sense of the data, the following data dictionary is provided.
Suburb Suburb
Address Address
Rooms Number of rooms
Price Price in Australian dollars
Method S - property sold
SP - property sold prior
PI - property passed in
PN - sold prior not disclosed
SN - sold not disclosed
NB - no bid
VB - vendor bid
W - withdrawn prior to auction
SA - sold after auction
SS - sold after auction price not disclosed
N/A - price or highest bid not available
Type br - bedroom(s)
h - house,cottage,villa, semi,terrace
u - unit, duplex
t - townhouse
dev site - development site
o res - other residential
SellerG Real Estate Agent
Date Date sold
Distance Distance from CBD in Kilometres
Regionname General Region (West, North West, North, North east …etc)
Propertycount Number of properties that exist in the suburb
Bedroom # of Bedrooms
Bathroom # of Bathrooms
Car Carport size/capacity
Landsize Land Size in Metres
BuildingArea Building Size in Metres
YearBuilt Year the house was built
CouncilArea Governing council for the area
Latitude Latitude
Longitude Longitude